DBA Data[Home] [Help]

APPS.PO_SOURCING_GRP dependencies on PO_DEBUG

Line 30: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

26:
27: --------------------------------------------------------------------------------
28:
29: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SOURCING_GRP';
30: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
31: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
32: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SOURCING_GRP.';
33:
34: -------------------------------------------------------------------------------

Line 31: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

27: --------------------------------------------------------------------------------
28:
29: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SOURCING_GRP';
30: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
31: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
32: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SOURCING_GRP.';
33:
34: -------------------------------------------------------------------------------
35: --Start of Comments

Line 115: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

111:
112: BEGIN
113: l_progress := 'PO_SOURCING_GRP: 001';
114: IF g_debug_stmt THEN
115: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
116: p_token => l_progress,
117: p_message => 'PO_SOURCING_GRP: Entered');
118: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
119: p_progress => l_progress,

Line 118: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

114: IF g_debug_stmt THEN
115: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
116: p_token => l_progress,
117: p_message => 'PO_SOURCING_GRP: Entered');
118: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
119: p_progress => l_progress,
120: p_name => 'p_api_version',
121: p_value => p_api_version);
122: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 122: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

118: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
119: p_progress => l_progress,
120: p_name => 'p_api_version',
121: p_value => p_api_version);
122: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
123: p_progress => l_progress,
124: p_name => 'p_init_msg_list',
125: p_value => p_init_msg_list);
126: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 126: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

122: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
123: p_progress => l_progress,
124: p_name => 'p_init_msg_list',
125: p_value => p_init_msg_list);
126: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
127: p_progress => l_progress,
128: p_name => 'p_commit',
129: p_value => p_commit);
130: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 130: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

126: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
127: p_progress => l_progress,
128: p_name => 'p_commit',
129: p_value => p_commit);
130: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
131: p_progress => l_progress,
132: p_name => 'p_validation_level',
133: p_value => p_validation_level);
134: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 134: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

130: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
131: p_progress => l_progress,
132: p_name => 'p_validation_level',
133: p_value => p_validation_level);
134: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
135: p_progress => l_progress,
136: p_name => 'p_interface_header_id',
137: p_value => p_interface_header_id);
138: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 138: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

134: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
135: p_progress => l_progress,
136: p_name => 'p_interface_header_id',
137: p_value => p_interface_header_id);
138: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
139: p_progress => l_progress,
140: p_name => 'p_auction_header_id',
141: p_value => p_auction_header_id);
142: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 142: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

138: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
139: p_progress => l_progress,
140: p_name => 'p_auction_header_id',
141: p_value => p_auction_header_id);
142: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
143: p_progress => l_progress,
144: p_name => 'p_bid_number',
145: p_value => p_bid_number);
146: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 146: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

142: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
143: p_progress => l_progress,
144: p_name => 'p_bid_number',
145: p_value => p_bid_number);
146: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
147: p_progress => l_progress,
148: p_name => 'p_sourcing_k_doc_type',
149: p_value => p_sourcing_k_doc_type);
150: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 150: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

146: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
147: p_progress => l_progress,
148: p_name => 'p_sourcing_k_doc_type',
149: p_value => p_sourcing_k_doc_type);
150: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
151: p_progress => l_progress,
152: p_name => 'p_conterms_exist_flag',
153: p_value => p_conterms_exist_flag);
154: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 154: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

150: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
151: p_progress => l_progress,
152: p_name => 'p_conterms_exist_flag',
153: p_value => p_conterms_exist_flag);
154: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
155: p_progress => l_progress,
156: p_name => 'p_document_creation_method',
157: p_value => p_document_creation_method);
158: END IF;

Line 184: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181:
182: l_progress := 'PO_SOURCING_GRP: 002';
183: IF g_debug_stmt THEN
184: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
185: p_token => l_progress,
186: p_message => 'Before calling po_sourcing_pvt.create_cpa');
187: END IF;
188:

Line 205: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

201: );
202:
203: l_progress := 'PO_SOURCING_GRP: 003';
204: IF g_debug_stmt THEN
205: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
206: p_token => l_progress,
207: p_message => 'After calling po_sourcing_pvt.create_cpa');
208: END IF;
209:

Line 212: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

208: END IF;
209:
210: l_progress := 'PO_SOURCING_GRP: 004';
211: IF g_debug_stmt THEN
212: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
213: p_token => l_progress,
214: p_message => 'PO_SOURCING_GRP: After calling PO_SOURCING_PVT.create_cpa');
215: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
216: p_progress => l_progress,

Line 215: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

211: IF g_debug_stmt THEN
212: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
213: p_token => l_progress,
214: p_message => 'PO_SOURCING_GRP: After calling PO_SOURCING_PVT.create_cpa');
215: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
216: p_progress => l_progress,
217: p_name => 'x_document_id',
218: p_value => x_document_id);
219: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 219: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

215: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
216: p_progress => l_progress,
217: p_name => 'x_document_id',
218: p_value => x_document_id);
219: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
220: p_progress => l_progress,
221: p_name => 'x_document_number',
222: p_value => x_document_number);
223: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

Line 223: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,

219: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
220: p_progress => l_progress,
221: p_name => 'x_document_number',
222: p_value => x_document_number);
223: PO_DEBUG.debug_var (p_log_head => g_log_head||l_api_name,
224: p_progress => l_progress,
225: p_name => 'x_return_status',
226: p_value => x_return_status);
227: END IF;

Line 247: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

243: WHEN FND_API.G_EXC_ERROR THEN
244: l_progress := 'PO_SOURCING_GRP: 004';
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: IF g_debug_stmt THEN
247: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
248: p_token => l_progress,
249: p_message => x_msg_data);
250: END IF;
251: FND_MSG_PUB.Count_And_Get

Line 259: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: l_progress := 'PO_SOURCING_GRP: 005';
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: IF g_debug_unexp THEN
259: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
260: p_token => l_progress,
261: p_message => SQLERRM);
262: END IF;
263: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

Line 270: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

266: WHEN OTHERS THEN
267: l_progress := 'PO_SOURCING_GRP: 006';
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: IF g_debug_unexp THEN
270: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
271: p_token => l_progress,
272: p_message => SQLERRM);
273: END IF;
274: FND_MSG_PUB.add_exc_msg(

Line 361: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358:
359: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 002';
360: IF g_debug_stmt THEN
361: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
362: p_token => l_progress,
363: p_message => 'Before calling po_sourcing_pvt.delete_interface_header');
364: END IF;
365:

Line 373: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

369: );
370:
371: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 003';
372: IF g_debug_stmt THEN
373: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
374: p_token => l_progress,
375: p_message => 'After calling po_sourcing_pvt.delete_interface_header');
376: END IF;
377:

Line 389: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 004';
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: IF g_debug_unexp THEN
389: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
390: p_token => l_progress,
391: p_message => x_msg_data);
392: END IF;
393: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

Line 399: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

395: WHEN OTHERS THEN
396: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 005';
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: IF g_debug_unexp THEN
399: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
400: p_token => l_progress,
401: p_message => SQLERRM);
402: END IF;
403: FND_MSG_PUB.add_exc_msg(