DBA Data[Home] [Help]

APPS.PN_PURGE_INTERFACE_PKG dependencies on PNP_DEBUG_PKG

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 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 49: pnp_debug_pkg.put_log_msg('=======================================================');

45:
46: ELSIF (function_flag = 'A') then
47: BEGIN
48: delete_locations(p_batch_name);
49: pnp_debug_pkg.put_log_msg('=======================================================');
50: delete_space_allocations(p_batch_name);
51: EXCEPTION
52: when OTHERS then
53: APP_EXCEPTION.raise_exception;

Line 82: pnp_debug_pkg.log('About to Delete from PN_LOCATIONS_ITF ...');

78: END IF;
79:
80:
81: If (l_Debug = 'Y') Then
82: pnp_debug_pkg.log('About to Delete from PN_LOCATIONS_ITF ...');
83: End If;
84: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
85: Delete From PN_LOCATIONS_ITF
86: Where Batch_Name = p_Batch_Name ;

Line 91: pnp_debug_pkg.log('Table: PN_LOCATIONS_ITF');

87: ELSIF P_BATCH_NAME IS NULL then
88: Delete From PN_LOCATIONS_ITF;
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);

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 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 127: pnp_debug_pkg.log('About to Delete from PN_EMP_SPACE_ASSIGN_ITF ...');

123: Into l_Count
124: From PN_EMP_SPACE_ASSIGN_ITF;
125: END IF;
126: If (l_Debug = 'Y') Then
127: pnp_debug_pkg.log('About to Delete from PN_EMP_SPACE_ASSIGN_ITF ...');
128: End If;
129:
130: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
131: Delete From PN_EMP_SPACE_ASSIGN_ITF

Line 137: pnp_debug_pkg.log('Table: PN_EMP_SPACE_ASSIGN_ITF');

133: ELSIF P_BATCH_NAME is null then
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:

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 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;