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_CHANGE_API1_S dependencies on PO_CHANGE_API1_S

Line 1: PACKAGE BODY PO_CHANGE_API1_S AS

1: PACKAGE BODY PO_CHANGE_API1_S AS
2: /* $Header: POXCHN1B.pls 120.3.12000000.5 2007/04/30 06:55:25 ankugarg ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(50) := 'PO_CHANGE_API1_S';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(50) := 'PO_CHANGE_API1_S';

1: PACKAGE BODY PO_CHANGE_API1_S AS
2: /* $Header: POXCHN1B.pls 120.3.12000000.5 2007/04/30 06:55:25 ankugarg ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(50) := 'PO_CHANGE_API1_S';
5:
6: g_sysdate DATE := SYSDATE;
7: g_user_id NUMBER := fnd_global.user_id;
8: g_login_id NUMBER := fnd_global.login_id;

Line 75: l_result := PO_CHANGE_API1_S.check_mandatory_params(

71: PO_MOAC_UTILS_PVT.validate_orgid_pub_api(x_org_id => l_org_id);
72: PO_MOAC_UTILS_PVT.set_policy_context('S',l_org_id);
73: --
74:
75: l_result := PO_CHANGE_API1_S.check_mandatory_params(
76: X_PO_NUMBER,
77: X_REVISION_NUMBER,
78: VERSION,
79: l_INTERFACE_TYPE,

Line 87: PO_CHANGE_API1_S.insert_error(l_interface_type,

83: end if;
84:
85: if (X_ACCEPTED_FLAG not in ('Y','N') or
86: X_ACCEPTED_FLAG is null) then
87: PO_CHANGE_API1_S.insert_error(l_interface_type,
88: l_transaction_id,
89: 'X_ACCEPTED_FLAG',
90: NULL,
91: 'PO_CHNG_INVALID_ACCEPTED_FLAG',

Line 98: PO_CHANGE_API1_S.insert_error(l_interface_type,

94: return 0;
95: end if;
96:
97: if (X_ACCEPTANCE_LOOKUP_CODE is null) then
98: PO_CHANGE_API1_S.insert_error(l_interface_type,
99: l_transaction_id,
100: 'X_ACCEPTANCE_LOOKUP_CODE',
101: NULL,
102: 'PO_ALL_CNL_PARAM_NULL',

Line 114: PO_CHANGE_API1_S.insert_error(l_interface_type,

110: where lookup_type = 'ACCEPTANCE TYPE'
111: and lookup_code = X_ACCEPTANCE_LOOKUP_CODE;
112:
113: if (l_count = 0) then
114: PO_CHANGE_API1_S.insert_error(l_interface_type,
115: l_transaction_id,
116: 'X_ACCEPTANCE_LOOKUP_CODE',
117: NULL,
118: 'PO_CHNG_INVALID_ACC_LK_CODE',

Line 129: PO_CHANGE_API1_S.insert_error(l_interface_type,

125: OPEN c_po_header;
126: FETCH c_po_header INTO l_po_header_id;
127:
128: if (c_po_header%NOTFOUND or l_po_header_id is null) then
129: PO_CHANGE_API1_S.insert_error(l_interface_type,
130: l_transaction_id,
131: 'PO_HEADER_ID',
132: 'PO_HEADERS',
133: 'PO_NOPOFOUND',

Line 146: PO_CHANGE_API1_S.insert_error(l_interface_type,

142: FETCH c_po_release INTO l_po_release_id;
143:
144: if (c_po_release%NOTFOUND or
145: l_po_release_id is null) then
146: PO_CHANGE_API1_S.insert_error(l_interface_type,
147: l_transaction_id,
148: 'PO_RELEASE_ID',
149: 'PO_RELEASES',
150: 'PO_CHNG_INVALID_RELEASE_NUM',

Line 159: l_result := PO_CHANGE_API1_S.validate_acceptance(

155: CLOSE c_po_release;
156:
157: l_employee_id := X_employee_id;
158:
159: l_result := PO_CHANGE_API1_S.validate_acceptance(
160: null,
161: l_po_release_id,
162: l_employee_id,
163: X_REVISION_NUMBER,

Line 169: l_result := PO_CHANGE_API1_S.validate_acceptance(

165: l_interface_type,
166: l_transaction_id);
167:
168: ELSE
169: l_result := PO_CHANGE_API1_S.validate_acceptance(
170: l_po_header_id,
171: null,
172: l_employee_id,
173: X_REVISION_NUMBER,

Line 295: PO_CHANGE_API1_S.insert_error(X_interface_type,

291: END IF;
292:
293: if (l_closed_code = 'FINALLY CLOSED') then
294: l_result := 0;
295: PO_CHANGE_API1_S.insert_error(X_interface_type,
296: X_transaction_id,
297: 'CLOSED_CODE',
298: 'PO_HEADERS',
299: 'PO_ALL_DOC_CANNOT_BE_OPENED',

Line 307: PO_CHANGE_API1_S.insert_error(X_interface_type,

303:
304: -- Bug#4156064: allow changing of PO with incomplete status also
305: if (l_status not in ('APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE')) then
306: l_result := 0;
307: PO_CHANGE_API1_S.insert_error(X_interface_type,
308: X_transaction_id,
309: 'AUTHORIZATION_STATUS',
310: 'PO_HEADERS',
311: 'PO_ALL_DOC_CANNOT_BE_OPENED',

Line 318: PO_CHANGE_API1_S.insert_error(X_interface_type,

314: end if;
315:
316: if (l_cancel_flag = 'Y') then
317: l_result := 0;
318: PO_CHANGE_API1_S.insert_error(X_interface_type,
319: X_transaction_id,
320: 'CANCEL_FLAG',
321: 'PO_HEADERS',
322: 'PO_ALL_DOC_CANNOT_BE_OPENED',

Line 329: PO_CHANGE_API1_S.insert_error(X_interface_type,

325: end if;
326:
327: if (X_revision_num > X_current_revision) then
328: l_result := 0;
329: PO_CHANGE_API1_S.insert_error(X_interface_type,
330: X_transaction_id,
331: 'X_REVISION_NUMBER',
332: NULL,
333: 'PO_CHNG_REVISION_GT_CURRENT',

Line 347: PO_CHANGE_API1_S.insert_error( X_interface_type,

343: and nvl(effective_end_date, g_sysdate+1);
344:
345: if (l_count = 0) then
346: l_result := 0;
347: PO_CHANGE_API1_S.insert_error( X_interface_type,
348: X_transaction_id,
349: 'X_EMPLOYEE_ID',
350: NULL,
351: 'PO_CHNG_NOT_VALID_EMPLOYEE',

Line 375: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,

371:
372: BEGIN
373:
374: if (X_PO_NUMBER is null) then
375: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,
376: X_TRANSACTION_ID,
377: 'PO_NUMBER',
378: NULL,
379: 'PO_ALL_CNL_PARAM_NULL',

Line 386: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,

382: return 0;
383: end if;
384:
385: if (X_REVISION_NUMBER is null) then
386: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,
387: X_TRANSACTION_ID,
388: 'REVISION_NUM',
389: NULL,
390: 'PO_ALL_CNL_PARAM_NULL',

Line 397: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,

393: return 0;
394: end if;
395:
396: if (VERSION is null) then
397: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,
398: X_TRANSACTION_ID,
399: 'VERSION',
400: NULL,
401: 'PO_ALL_CNL_PARAM_NULL',

Line 406: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,

402: NULL,
403: NULL);
404: return 0;
405: elsif (VERSION <> '1.0') then
406: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,
407: X_TRANSACTION_ID,
408: 'VERSION',
409: NULL,
410: 'PO_CHNG_INVALID_VERSION',

Line 588: END PO_CHANGE_API1_S;

584: RETURN 0;
585: --
586: END update_po;
587:
588: END PO_CHANGE_API1_S;