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_DOCUMENT_ACTION_PVT dependencies on PO_DOCUMENT_ACTION_PVT

Line 1: PACKAGE BODY PO_DOCUMENT_ACTION_PVT AS

1: PACKAGE BODY PO_DOCUMENT_ACTION_PVT AS
2: -- $Header: POXVDACB.pls 120.10 2007/02/15 20:36:32 dedelgad ship $
3:
4: -- Private package constants
5:

Line 6: g_pkg_name CONSTANT varchar2(30) := 'PO_DOCUMENT_ACTION_PVT';

2: -- $Header: POXVDACB.pls 120.10 2007/02/15 20:36:32 dedelgad ship $
3:
4: -- Private package constants
5:
6: g_pkg_name CONSTANT varchar2(30) := 'PO_DOCUMENT_ACTION_PVT';
7: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| g_pkg_name || '.';
8:
9: -- Private package variables
10:

Line 28: -- package PO_DOCUMENT_ACTION_PVT. Performs all the common logic

24: -- None, directly.Calls PO_DOCUMENT_LOCK_GRP to lock document
25: -- if action ctl record's lock_document = TRUE
26: --Function:
27: -- This procedure is the switchboard for all document actions in
28: -- package PO_DOCUMENT_ACTION_PVT. Performs all the common logic
29: -- for these actions.
30: -- This includes:
31: -- setting the org context to that of the document
32: -- initializing g_err_message, the shared error string

Line 53: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

49: -- See individual actions and package spec for more info on outputs.
50: --End of Comments
51: -------------------------------------------------------------------------------
52: PROCEDURE do_action(
53: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
54: )
55: IS
56:
57: l_doc_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 66: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_PVT.do_action';

62: l_msg_count NUMBER;
63: l_msg_data VARCHAR2(2000) := NULL;
64:
65: d_progress NUMBER;
66: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_PVT.do_action';
67: d_log_msg VARCHAR2(200);
68:
69: -- variables required for locking
70: -- resource_busy_exc definition copied from PO_DOCUMENT_LOCK_GRP

Line 252: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE)

248:
249:
250: -- Switchboard: run appropriate handler routine based on action
251:
252: IF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE)
253: THEN
254:
255: d_progress := 30.1;
256: PO_DOCUMENT_ACTION_AUTH.approve(p_action_ctl_rec => p_action_ctl_rec);

Line 258: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT)

254:
255: d_progress := 30.1;
256: PO_DOCUMENT_ACTION_AUTH.approve(p_action_ctl_rec => p_action_ctl_rec);
257:
258: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT)
259: THEN
260:
261: d_progress := 30.2;
262: PO_DOCUMENT_ACTION_AUTH.reject(p_action_ctl_rec => p_action_ctl_rec);

Line 264: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FORWARD)

260:
261: d_progress := 30.2;
262: PO_DOCUMENT_ACTION_AUTH.reject(p_action_ctl_rec => p_action_ctl_rec);
263:
264: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FORWARD)
265: THEN
266:
267: d_progress := 30.3;
268: PO_DOCUMENT_ACTION_AUTH.forward(p_action_ctl_rec => p_action_ctl_rec);

Line 270: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RETURN)

266:
267: d_progress := 30.3;
268: PO_DOCUMENT_ACTION_AUTH.forward(p_action_ctl_rec => p_action_ctl_rec);
269:
270: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RETURN)
271: THEN
272:
273: d_progress := 30.4;
274: PO_DOCUMENT_ACTION_AUTH.return_action(p_action_ctl_rec => p_action_ctl_rec);

Line 276: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_APPROVE)

272:
273: d_progress := 30.4;
274: PO_DOCUMENT_ACTION_AUTH.return_action(p_action_ctl_rec => p_action_ctl_rec);
275:
276: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_APPROVE)
277: THEN
278:
279: d_progress := 40.1;
280: PO_DOCUMENT_ACTION_CHECK.approve_status_check(p_action_ctl_rec => p_action_ctl_rec);

Line 282: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_REJECT)

278:
279: d_progress := 40.1;
280: PO_DOCUMENT_ACTION_CHECK.approve_status_check(p_action_ctl_rec => p_action_ctl_rec);
281:
282: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_REJECT)
283: THEN
284:
285: d_progress := 40.2;
286: PO_DOCUMENT_ACTION_CHECK.reject_status_check(p_action_ctl_rec => p_action_ctl_rec);

Line 288: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_AUTHORITY)

284:
285: d_progress := 40.2;
286: PO_DOCUMENT_ACTION_CHECK.reject_status_check(p_action_ctl_rec => p_action_ctl_rec);
287:
288: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CHECK_AUTHORITY)
289: THEN
290:
291: d_progress := 40.3;
292: PO_DOCUMENT_ACTION_CHECK.authority_check(p_action_ctl_rec => p_action_ctl_rec);

Line 294: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE,

290:
291: d_progress := 40.3;
292: PO_DOCUMENT_ACTION_CHECK.authority_check(p_action_ctl_rec => p_action_ctl_rec);
293:
294: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE,
295: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE))
296: THEN
297:
298: d_progress := 50.1;

Line 295: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE))

291: d_progress := 40.3;
292: PO_DOCUMENT_ACTION_CHECK.authority_check(p_action_ctl_rec => p_action_ctl_rec);
293:
294: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE,
295: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE))
296: THEN
297:
298: d_progress := 50.1;
299: PO_DOCUMENT_ACTION_HOLD.freeze_unfreeze(p_action_ctl_rec => p_action_ctl_rec);

Line 301: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,

297:
298: d_progress := 50.1;
299: PO_DOCUMENT_ACTION_HOLD.freeze_unfreeze(p_action_ctl_rec => p_action_ctl_rec);
300:
301: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
302: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD))
303: THEN
304:
305: d_progress := 50.2;

Line 302: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD))

298: d_progress := 50.1;
299: PO_DOCUMENT_ACTION_HOLD.freeze_unfreeze(p_action_ctl_rec => p_action_ctl_rec);
300:
301: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
302: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD))
303: THEN
304:
305: d_progress := 50.2;
306: PO_DOCUMENT_ACTION_HOLD.hold_unhold(p_action_ctl_rec => p_action_ctl_rec);

Line 308: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,

304:
305: d_progress := 50.2;
306: PO_DOCUMENT_ACTION_HOLD.hold_unhold(p_action_ctl_rec => p_action_ctl_rec);
307:
308: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
309: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
310: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
311: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,

Line 309: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,

305: d_progress := 50.2;
306: PO_DOCUMENT_ACTION_HOLD.hold_unhold(p_action_ctl_rec => p_action_ctl_rec);
307:
308: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
309: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
310: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
311: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
313: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,

Line 310: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,

306: PO_DOCUMENT_ACTION_HOLD.hold_unhold(p_action_ctl_rec => p_action_ctl_rec);
307:
308: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
309: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
310: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
311: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
313: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))

Line 311: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,

307:
308: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
309: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
310: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
311: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
313: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
315: THEN

Line 312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,

308: ELSIF (p_action_ctl_rec.action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
309: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
310: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
311: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
313: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
315: THEN
316:

Line 313: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,

309: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
310: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
311: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
313: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
315: THEN
316:
317: d_progress := 60.1;

Line 314: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))

310: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
311: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE,
312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
313: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV,
314: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
315: THEN
316:
317: d_progress := 60.1;
318: PO_DOCUMENT_ACTION_CLOSE.manual_close_po(p_action_ctl_rec => p_action_ctl_rec);

Line 320: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UPDATE_CLOSE_AUTO)

316:
317: d_progress := 60.1;
318: PO_DOCUMENT_ACTION_CLOSE.manual_close_po(p_action_ctl_rec => p_action_ctl_rec);
319:
320: ELSIF (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UPDATE_CLOSE_AUTO)
321: THEN
322:
323: d_progress := 60.2;
324: PO_DOCUMENT_ACTION_CLOSE.auto_close_po(p_action_ctl_rec => p_action_ctl_rec);

Line 1326: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_PVT.find_forward_to_id';

1322: )
1323: IS
1324:
1325: d_progress NUMBER;
1326: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_PVT.find_forward_to_id';
1327: d_msg VARCHAR2(200);
1328:
1329: l_ret_sts VARCHAR2(1) := 'S'; -- Bug 4448215
1330: l_ret_code VARCHAR2(25);

Line 1858: -- Use one of PO_DOCUMENT_ACTION_PVT.g_doc_action<>

1854: -- Uses do_action switchboard
1855: --Parameters:
1856: --IN:
1857: -- p_action
1858: -- Use one of PO_DOCUMENT_ACTION_PVT.g_doc_action<>
1859: -- Where <> could be:
1860: -- OPEN, CLOSE, CLOSE_RCV, OPEN_RCV, CLOSE_INV, OPEN_INV, or FINALLY_CLOSE
1861: -- p_document_id
1862: -- ID of the document's header (e.g. po_release_id, po_header_id, ...)

Line 2092: END PO_DOCUMENT_ACTION_PVT;

2088: CLOSE l_cursor;
2089: END update_secondary_qty_cancelled;
2090: --
2091:
2092: END PO_DOCUMENT_ACTION_PVT;