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.PON_AUCTION_PO_PKG dependencies on PON_AUCTION_PO_PKG

Line 1: PACKAGE BODY PON_AUCTION_PO_PKG as

1: PACKAGE BODY PON_AUCTION_PO_PKG as
2: /* $Header: PONAUPOB.pls 120.6 2006/03/21 23:33:33 ukottama noship $ */
3:
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_PO_PKG';

Line 5: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_PO_PKG';

1: PACKAGE BODY PON_AUCTION_PO_PKG as
2: /* $Header: PONAUPOB.pls 120.6 2006/03/21 23:33:33 ukottama noship $ */
3:
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_PO_PKG';
6: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
7: g_module VARCHAR2(200) := 'PON.PLSQL.PON_AUCTION_PO_PKG';
8:
9: PROCEDURE log_message(p_message IN VARCHAR2)

Line 7: g_module VARCHAR2(200) := 'PON.PLSQL.PON_AUCTION_PO_PKG';

3:
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_PO_PKG';
6: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
7: g_module VARCHAR2(200) := 'PON.PLSQL.PON_AUCTION_PO_PKG';
8:
9: PROCEDURE log_message(p_message IN VARCHAR2)
10:
11: IS

Line 71: PON_AUCTION_PO_PKG.GET_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);

67: error_msg := '';
68:
69:
70: IF (attachmentType = 'PON_BID_ATTRIBUTES') THEN
71: PON_AUCTION_PO_PKG.GET_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
72: ELSIF (attachmentType = 'PON_BID_HEADER_ATTRIBUTES') THEN
73: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
74: ELSIF (attachmentType = 'PON_BID_BUYER_NOTES') THEN
75: PON_AUCTION_PO_PKG.GET_NOTE_TO_BUYER_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);

Line 73: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);

69:
70: IF (attachmentType = 'PON_BID_ATTRIBUTES') THEN
71: PON_AUCTION_PO_PKG.GET_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
72: ELSIF (attachmentType = 'PON_BID_HEADER_ATTRIBUTES') THEN
73: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
74: ELSIF (attachmentType = 'PON_BID_BUYER_NOTES') THEN
75: PON_AUCTION_PO_PKG.GET_NOTE_TO_BUYER_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
76: ELSIF (attachmentType = 'PON_AUCTION_SUPPLIER_NOTES') THEN
77: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'BOTH');

Line 75: PON_AUCTION_PO_PKG.GET_NOTE_TO_BUYER_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);

71: PON_AUCTION_PO_PKG.GET_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
72: ELSIF (attachmentType = 'PON_BID_HEADER_ATTRIBUTES') THEN
73: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
74: ELSIF (attachmentType = 'PON_BID_BUYER_NOTES') THEN
75: PON_AUCTION_PO_PKG.GET_NOTE_TO_BUYER_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
76: ELSIF (attachmentType = 'PON_AUCTION_SUPPLIER_NOTES') THEN
77: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'BOTH');
78: ELSIF (attachmentType = 'PON_AUC_SUPPLIER_LINE_NOTES') THEN
79: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'LINE');

Line 77: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'BOTH');

73: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
74: ELSIF (attachmentType = 'PON_BID_BUYER_NOTES') THEN
75: PON_AUCTION_PO_PKG.GET_NOTE_TO_BUYER_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
76: ELSIF (attachmentType = 'PON_AUCTION_SUPPLIER_NOTES') THEN
77: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'BOTH');
78: ELSIF (attachmentType = 'PON_AUC_SUPPLIER_LINE_NOTES') THEN
79: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'LINE');
80: ELSIF (attachmentType = 'PON_AUC_SUPPLIER_HEADER_NOTES') THEN
81: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'HEADER');

Line 79: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'LINE');

75: PON_AUCTION_PO_PKG.GET_NOTE_TO_BUYER_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
76: ELSIF (attachmentType = 'PON_AUCTION_SUPPLIER_NOTES') THEN
77: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'BOTH');
78: ELSIF (attachmentType = 'PON_AUC_SUPPLIER_LINE_NOTES') THEN
79: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'LINE');
80: ELSIF (attachmentType = 'PON_AUC_SUPPLIER_HEADER_NOTES') THEN
81: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'HEADER');
82: ELSIF (attachmentType = 'PON_BID_TOTAL_COST') THEN
83: PON_AUCTION_PO_PKG.GET_TOTAL_COST_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);

Line 81: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'HEADER');

77: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'BOTH');
78: ELSIF (attachmentType = 'PON_AUC_SUPPLIER_LINE_NOTES') THEN
79: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'LINE');
80: ELSIF (attachmentType = 'PON_AUC_SUPPLIER_HEADER_NOTES') THEN
81: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'HEADER');
82: ELSIF (attachmentType = 'PON_BID_TOTAL_COST') THEN
83: PON_AUCTION_PO_PKG.GET_TOTAL_COST_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
84: ELSIF (attachmentType = 'PON_JOB_DETAILS') THEN
85: PON_AUCTION_PO_PKG.GET_JOB_DETAILS_ATTACHMENT(pk1, pk3,

Line 83: PON_AUCTION_PO_PKG.GET_TOTAL_COST_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);

79: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'LINE');
80: ELSIF (attachmentType = 'PON_AUC_SUPPLIER_HEADER_NOTES') THEN
81: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'HEADER');
82: ELSIF (attachmentType = 'PON_BID_TOTAL_COST') THEN
83: PON_AUCTION_PO_PKG.GET_TOTAL_COST_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
84: ELSIF (attachmentType = 'PON_JOB_DETAILS') THEN
85: PON_AUCTION_PO_PKG.GET_JOB_DETAILS_ATTACHMENT(pk1, pk3,
86: attachmentDesc, attachment,
87: error_code, error_msg);

Line 85: PON_AUCTION_PO_PKG.GET_JOB_DETAILS_ATTACHMENT(pk1, pk3,

81: PON_AUCTION_PO_PKG.GET_NOTE_TO_SUPP_ATTACHMENT(pk1, pk3, attachmentDesc, attachment, error_code, error_msg, 'HEADER');
82: ELSIF (attachmentType = 'PON_BID_TOTAL_COST') THEN
83: PON_AUCTION_PO_PKG.GET_TOTAL_COST_ATTACHMENT(pk1, pk2, pk3, attachmentDesc, attachment, error_code, error_msg);
84: ELSIF (attachmentType = 'PON_JOB_DETAILS') THEN
85: PON_AUCTION_PO_PKG.GET_JOB_DETAILS_ATTACHMENT(pk1, pk3,
86: attachmentDesc, attachment,
87: error_code, error_msg);
88: ELSIF(attachmentType = 'PON_AUC_PYMNT_SHIP_SUPP_NOTES') and (pk1 is not null) THEN
89: GET_PAYMENT_NOTE_TO_SUPP(pk1, attachmentDesc, attachment, error_code, error_msg);

Line 95: x_progress := 'PON_AUCTION_PO_PKG: GET_ATTACHMENT: EXCEPTION handling pk1:' || pk1 || ' pk2: ' || pk2 || ' pk3: ' || pk3 || ' attachmentType: ' || attachmentType;

91:
92: END IF;
93:
94: IF (error_code = 'FAILURE') THEN
95: x_progress := 'PON_AUCTION_PO_PKG: GET_ATTACHMENT: EXCEPTION handling pk1:' || pk1 || ' pk2: ' || pk2 || ' pk3: ' || pk3 || ' attachmentType: ' || attachmentType;
96: log_message(x_progress);
97: END IF;
98:
99: EXCEPTION

Line 104: x_progress := 'PON_AUCTION_PO_PKG: GET_ATTACHMENT: EXCEPTION handling pk1: ' || pk1 || ' pk2: ' || pk2 || ' pk3: ' || pk3 || ' attachmentType: ' || attachmentType;

100:
101: when others then
102: error_code := 'FAILURE';
103: error_msg := SQLERRM;
104: x_progress := 'PON_AUCTION_PO_PKG: GET_ATTACHMENT: EXCEPTION handling pk1: ' || pk1 || ' pk2: ' || pk2 || ' pk3: ' || pk3 || ' attachmentType: ' || attachmentType;
105: log_message(x_progress);
106:
107: END GET_ATTACHMENT;
108:

Line 647: END PON_AUCTION_PO_PKG;

643: END GET_PAYMENT_NOTE_TO_SUPP;
644:
645:
646:
647: END PON_AUCTION_PO_PKG;