eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SOURCING_GRP dependencies on PO_SOURCING_GRP

Line 1: PACKAGE BODY PO_SOURCING_GRP AS

1: PACKAGE BODY PO_SOURCING_GRP AS
2: /* $Header: POXGCPAB.pls 120.0 2005/06/02 00:57:38 appldev noship $*/
3:
4:
5: ---

Line 29: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SOURCING_GRP';

25: ---
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:

Line 32: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SOURCING_GRP.';

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
36: --Name: create_cpa

Line 113: l_progress := 'PO_SOURCING_GRP: 001';

109: l_progress VARCHAR2(2000) := '000';
110: l_return_status VARCHAR2(1);
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');

Line 117: p_message => 'PO_SOURCING_GRP: Entered');

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,
120: p_name => 'p_api_version',
121: p_value => p_api_version);

Line 182: l_progress := 'PO_SOURCING_GRP: 002';

178:
179: -- Initialize API return status to success
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');

Line 203: l_progress := 'PO_SOURCING_GRP: 003';

199: x_document_id => x_document_id,
200: x_document_number => x_document_number
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');

Line 210: l_progress := 'PO_SOURCING_GRP: 004';

206: p_token => l_progress,
207: p_message => 'After calling po_sourcing_pvt.create_cpa');
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');

Line 214: p_message => 'PO_SOURCING_GRP: After calling PO_SOURCING_PVT.create_cpa');

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,
217: p_name => 'x_document_id',
218: p_value => x_document_id);

Line 244: l_progress := 'PO_SOURCING_GRP: 004';

240: COMMIT;
241: END IF;
242: EXCEPTION
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,

Line 256: l_progress := 'PO_SOURCING_GRP: 005';

252: (p_count => x_msg_count,
253: p_data => x_msg_data );
254: ROLLBACK TO CREATE_CPA_GRP;
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,

Line 267: l_progress := 'PO_SOURCING_GRP: 006';

263: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
264: ,p_data => x_msg_data);
265: ROLLBACK TO CREATE_CPA_GRP;
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,

Line 275: p_pkg_name => 'PO_SOURCING_GRP',

271: p_token => l_progress,
272: p_message => SQLERRM);
273: END IF;
274: FND_MSG_PUB.add_exc_msg(
275: p_pkg_name => 'PO_SOURCING_GRP',
276: p_procedure_name => l_api_name,
277: p_error_text => NULL);
278:
279: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

Line 339: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 001';

335: l_api_version CONSTANT NUMBER := 1.0;
336: l_progress VARCHAR2(2000) := '000';
337:
338: BEGIN
339: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 001';
340: -- Standard call to check for call compatibility.
341: IF NOT FND_API.compatible_api_call (
342: p_current_version_number => l_api_version,
343: p_caller_version_number => p_api_version,

Line 359: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 002';

355:
356: -- Initialize API return status to success
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');

Line 371: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 003';

367: x_return_status => x_return_status,
368: p_interface_header_id => p_interface_header_id
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');

Line 386: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 004';

382: END IF;
383:
384: EXCEPTION
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,

Line 396: l_progress := 'PO_SOURCING_GRP.DELETE_INTERFACE_HEADER: 005';

392: END IF;
393: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
394: ,p_data => x_msg_data);
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,

Line 404: p_pkg_name => 'PO_SOURCING_GRP',

400: p_token => l_progress,
401: p_message => SQLERRM);
402: END IF;
403: FND_MSG_PUB.add_exc_msg(
404: p_pkg_name => 'PO_SOURCING_GRP',
405: p_procedure_name => l_api_name,
406: p_error_text => NULL);
407:
408: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count

Line 412: END PO_SOURCING_GRP;

408: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
409: ,p_data => x_msg_data);
410: END DELETE_INTERFACE_HEADER;
411:
412: END PO_SOURCING_GRP;