DBA Data[Home] [Help]

APPS.PN_PURGE_INTERFACE_PKG dependencies on FND_MESSAGE

Line 20: fnd_message.set_name ('PN','PN_BATCH_NAME');

16: fnd_file.put_names('PNVPURGE.log', 'PNVPURGE.out', '/sqlcom/out');
17:
18: if (l_Debug = 'Y') Then
19:
20: fnd_message.set_name ('PN','PN_BATCH_NAME');
21: fnd_message.set_token ('NAME',p_batch_name);
22: pnp_debug_pkg.put_log_msg(fnd_message.get);
23:
24: fnd_message.set_name ('PN','PN_VPURG_FN_FLAG');

Line 21: fnd_message.set_token ('NAME',p_batch_name);

17:
18: if (l_Debug = 'Y') Then
19:
20: fnd_message.set_name ('PN','PN_BATCH_NAME');
21: fnd_message.set_token ('NAME',p_batch_name);
22: pnp_debug_pkg.put_log_msg(fnd_message.get);
23:
24: fnd_message.set_name ('PN','PN_VPURG_FN_FLAG');
25: fnd_message.set_token ('FLAG',function_flag);

Line 22: pnp_debug_pkg.put_log_msg(fnd_message.get);

18: if (l_Debug = 'Y') Then
19:
20: fnd_message.set_name ('PN','PN_BATCH_NAME');
21: fnd_message.set_token ('NAME',p_batch_name);
22: pnp_debug_pkg.put_log_msg(fnd_message.get);
23:
24: fnd_message.set_name ('PN','PN_VPURG_FN_FLAG');
25: fnd_message.set_token ('FLAG',function_flag);
26: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 24: fnd_message.set_name ('PN','PN_VPURG_FN_FLAG');

20: fnd_message.set_name ('PN','PN_BATCH_NAME');
21: fnd_message.set_token ('NAME',p_batch_name);
22: pnp_debug_pkg.put_log_msg(fnd_message.get);
23:
24: fnd_message.set_name ('PN','PN_VPURG_FN_FLAG');
25: fnd_message.set_token ('FLAG',function_flag);
26: pnp_debug_pkg.put_log_msg(fnd_message.get);
27:
28: End If;

Line 25: fnd_message.set_token ('FLAG',function_flag);

21: fnd_message.set_token ('NAME',p_batch_name);
22: pnp_debug_pkg.put_log_msg(fnd_message.get);
23:
24: fnd_message.set_name ('PN','PN_VPURG_FN_FLAG');
25: fnd_message.set_token ('FLAG',function_flag);
26: pnp_debug_pkg.put_log_msg(fnd_message.get);
27:
28: End If;
29:

Line 26: pnp_debug_pkg.put_log_msg(fnd_message.get);

22: pnp_debug_pkg.put_log_msg(fnd_message.get);
23:
24: fnd_message.set_name ('PN','PN_VPURG_FN_FLAG');
25: fnd_message.set_token ('FLAG',function_flag);
26: pnp_debug_pkg.put_log_msg(fnd_message.get);
27:
28: End If;
29:
30: IF (function_flag = 'L') then

Line 93: fnd_message.set_name ('PN','PN_BATCH_NAME');

89: END IF;
90:
91: pnp_debug_pkg.log('Table: PN_LOCATIONS_ITF');
92:
93: fnd_message.set_name ('PN','PN_BATCH_NAME');
94: fnd_message.set_token ('NAME',p_batch_name);
95: pnp_debug_pkg.put_log_msg(fnd_message.get);
96:
97: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');

Line 94: fnd_message.set_token ('NAME',p_batch_name);

90:
91: pnp_debug_pkg.log('Table: PN_LOCATIONS_ITF');
92:
93: fnd_message.set_name ('PN','PN_BATCH_NAME');
94: fnd_message.set_token ('NAME',p_batch_name);
95: pnp_debug_pkg.put_log_msg(fnd_message.get);
96:
97: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
98: fnd_message.set_token ('NUM',l_Count);

Line 95: pnp_debug_pkg.put_log_msg(fnd_message.get);

91: pnp_debug_pkg.log('Table: PN_LOCATIONS_ITF');
92:
93: fnd_message.set_name ('PN','PN_BATCH_NAME');
94: fnd_message.set_token ('NAME',p_batch_name);
95: pnp_debug_pkg.put_log_msg(fnd_message.get);
96:
97: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
98: fnd_message.set_token ('NUM',l_Count);
99: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 97: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');

93: fnd_message.set_name ('PN','PN_BATCH_NAME');
94: fnd_message.set_token ('NAME',p_batch_name);
95: pnp_debug_pkg.put_log_msg(fnd_message.get);
96:
97: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
98: fnd_message.set_token ('NUM',l_Count);
99: pnp_debug_pkg.put_log_msg(fnd_message.get);
100:
101: EXCEPTION

Line 98: fnd_message.set_token ('NUM',l_Count);

94: fnd_message.set_token ('NAME',p_batch_name);
95: pnp_debug_pkg.put_log_msg(fnd_message.get);
96:
97: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
98: fnd_message.set_token ('NUM',l_Count);
99: pnp_debug_pkg.put_log_msg(fnd_message.get);
100:
101: EXCEPTION
102: When Others Then

Line 99: pnp_debug_pkg.put_log_msg(fnd_message.get);

95: pnp_debug_pkg.put_log_msg(fnd_message.get);
96:
97: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
98: fnd_message.set_token ('NUM',l_Count);
99: pnp_debug_pkg.put_log_msg(fnd_message.get);
100:
101: EXCEPTION
102: When Others Then
103: Raise;

Line 138: fnd_message.set_name ('PN','PN_BATCH_NAME');

134: Delete From PN_EMP_SPACE_ASSIGN_ITF;
135: END IF;
136:
137: pnp_debug_pkg.log('Table: PN_EMP_SPACE_ASSIGN_ITF');
138: fnd_message.set_name ('PN','PN_BATCH_NAME');
139: fnd_message.set_token ('NAME',p_batch_name);
140: pnp_debug_pkg.put_log_msg(fnd_message.get);
141:
142: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');

Line 139: fnd_message.set_token ('NAME',p_batch_name);

135: END IF;
136:
137: pnp_debug_pkg.log('Table: PN_EMP_SPACE_ASSIGN_ITF');
138: fnd_message.set_name ('PN','PN_BATCH_NAME');
139: fnd_message.set_token ('NAME',p_batch_name);
140: pnp_debug_pkg.put_log_msg(fnd_message.get);
141:
142: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
143: fnd_message.set_token ('NUM',l_Count);

Line 140: pnp_debug_pkg.put_log_msg(fnd_message.get);

136:
137: pnp_debug_pkg.log('Table: PN_EMP_SPACE_ASSIGN_ITF');
138: fnd_message.set_name ('PN','PN_BATCH_NAME');
139: fnd_message.set_token ('NAME',p_batch_name);
140: pnp_debug_pkg.put_log_msg(fnd_message.get);
141:
142: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
143: fnd_message.set_token ('NUM',l_Count);
144: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 142: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');

138: fnd_message.set_name ('PN','PN_BATCH_NAME');
139: fnd_message.set_token ('NAME',p_batch_name);
140: pnp_debug_pkg.put_log_msg(fnd_message.get);
141:
142: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
143: fnd_message.set_token ('NUM',l_Count);
144: pnp_debug_pkg.put_log_msg(fnd_message.get);
145:
146: EXCEPTION

Line 143: fnd_message.set_token ('NUM',l_Count);

139: fnd_message.set_token ('NAME',p_batch_name);
140: pnp_debug_pkg.put_log_msg(fnd_message.get);
141:
142: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
143: fnd_message.set_token ('NUM',l_Count);
144: pnp_debug_pkg.put_log_msg(fnd_message.get);
145:
146: EXCEPTION
147: When Others Then

Line 144: pnp_debug_pkg.put_log_msg(fnd_message.get);

140: pnp_debug_pkg.put_log_msg(fnd_message.get);
141:
142: fnd_message.set_name ('PN','PN_VPURG_ROWS_DEL');
143: fnd_message.set_token ('NUM',l_Count);
144: pnp_debug_pkg.put_log_msg(fnd_message.get);
145:
146: EXCEPTION
147: When Others Then
148: Raise;