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.10 2011/12/27 09:16:23 pamandav 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.10 2011/12/27 09:16:23 pamandav 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 171: l_result := PO_CHANGE_API1_S.validate_acceptance(

167:
168: ELSE
169: l_employee_id := X_employee_id; --Bug12638303
170:
171: l_result := PO_CHANGE_API1_S.validate_acceptance(
172: l_po_header_id,
173: null,
174: l_employee_id,
175: X_REVISION_NUMBER,

Line 297: PO_CHANGE_API1_S.insert_error(X_interface_type,

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

Line 309: PO_CHANGE_API1_S.insert_error(X_interface_type,

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

Line 320: PO_CHANGE_API1_S.insert_error(X_interface_type,

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

Line 335: PO_CHANGE_API1_S.insert_error(X_interface_type,

331: current_revision, then insert error. */
332:
333: if (X_revision_num <> X_current_revision) then
334: l_result := 0;
335: PO_CHANGE_API1_S.insert_error(X_interface_type,
336: X_transaction_id,
337: 'X_REVISION_NUMBER',
338: NULL,
339: 'PO_CHNG_REVISION_NOT_MATCH',

Line 353: PO_CHANGE_API1_S.insert_error( X_interface_type,

349: and nvl(effective_end_date, g_sysdate+1);
350:
351: if (l_count = 0) then
352: l_result := 0;
353: PO_CHANGE_API1_S.insert_error( X_interface_type,
354: X_transaction_id,
355: 'X_EMPLOYEE_ID',
356: NULL,
357: 'PO_CHNG_NOT_VALID_EMPLOYEE',

Line 381: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,

377:
378: BEGIN
379:
380: if (X_PO_NUMBER is null) then
381: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,
382: X_TRANSACTION_ID,
383: 'PO_NUMBER',
384: NULL,
385: 'PO_ALL_CNL_PARAM_NULL',

Line 392: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,

388: return 0;
389: end if;
390:
391: if (X_REVISION_NUMBER is null) then
392: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,
393: X_TRANSACTION_ID,
394: 'REVISION_NUM',
395: NULL,
396: 'PO_ALL_CNL_PARAM_NULL',

Line 403: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,

399: return 0;
400: end if;
401:
402: if (VERSION is null) then
403: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,
404: X_TRANSACTION_ID,
405: 'VERSION',
406: NULL,
407: 'PO_ALL_CNL_PARAM_NULL',

Line 412: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,

408: NULL,
409: NULL);
410: return 0;
411: elsif (VERSION <> '1.0') then
412: PO_CHANGE_API1_S.insert_error(X_INTERFACE_TYPE,
413: X_TRANSACTION_ID,
414: 'VERSION',
415: NULL,
416: 'PO_CHNG_INVALID_VERSION',

Line 594: END PO_CHANGE_API1_S;

590: RETURN 0;
591: --
592: END update_po;
593:
594: END PO_CHANGE_API1_S;