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_CONTERMS_WF_PVT dependencies on PO_WF_DEBUG_PKG

Line 48: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

44: p_return_status IN VARCHAR2) IS
45:
46: l_count number:= FND_MSG_PUB.Count_Msg;
47: BEGIN
48: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
49: '10: Start show error');
50: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
51: '20:Return status for '||p_api_name||':'||p_return_status);
52: FOR i IN 1..l_count LOOP

Line 50: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

46: l_count number:= FND_MSG_PUB.Count_Msg;
47: BEGIN
48: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
49: '10: Start show error');
50: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
51: '20:Return status for '||p_api_name||':'||p_return_status);
52: FOR i IN 1..l_count LOOP
53: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
54: (20+i)||':Error-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line 53: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

49: '10: Start show error');
50: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
51: '20:Return status for '||p_api_name||':'||p_return_status);
52: FOR i IN 1..l_count LOOP
53: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
54: (20+i)||':Error-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
55: END LOOP;
56: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
57: '100: End show error');

Line 56: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

52: FOR i IN 1..l_count LOOP
53: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
54: (20+i)||':Error-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
55: END LOOP;
56: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
57: '100: End show error');
58: END show_error;
59:
60: -------------------------------------------------------------------------------

Line 100: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

96:
97: BEGIN
98:
99: IF (g_po_wf_debug = 'Y') THEN
100: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
101: '10:Start get_wf_params ');
102: END IF;
103: x_po_header_id := PO_wf_Util_Pkg.GetItemAttrNumber(
104: itemtype => itemtype,

Line 119: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

115: itemkey => itemkey,
116: aname => 'DOCUMENT_SUBTYPE');
117:
118: IF (g_po_wf_debug = 'Y') THEN
119: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
120: '30:po_header_id = '|| to_char(x_po_header_id));
121: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
122: '40:po doc type= '|| x_po_doc_type);
123: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

Line 121: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

117:
118: IF (g_po_wf_debug = 'Y') THEN
119: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
120: '30:po_header_id = '|| to_char(x_po_header_id));
121: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
122: '40:po doc type= '|| x_po_doc_type);
123: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
124: '50:po sub type= '|| x_po_doc_subtype);
125: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

Line 123: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

119: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
120: '30:po_header_id = '|| to_char(x_po_header_id));
121: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
122: '40:po doc type= '|| x_po_doc_type);
123: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
124: '50:po sub type= '|| x_po_doc_subtype);
125: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
126: '100:End get_wf_params ');
127: END IF;

Line 125: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

121: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
122: '40:po doc type= '|| x_po_doc_type);
123: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
124: '50:po sub type= '|| x_po_doc_subtype);
125: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
126: '100:End get_wf_params ');
127: END IF;
128: END get_wf_params;
129:

Line 322: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

318: l_contracts_call_exception exception;
319: l_api_name VARCHAR2(100);
320: BEGIN
321: IF (g_po_wf_debug = 'Y') THEN
322: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
323: '10: Start function contract_terms_Changed ');
324: END IF;
325:
326:

Line 351: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

347: IF nvl(l_conterms_yn,'N') = 'Y' AND
348: nvl(l_archived_conterms_flag,'N') = 'N' THEN
349:
350: IF (g_po_wf_debug = 'Y') THEN
351: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
352: '120:Previous version does not have terms');
353: END IF;
354: l_changed:='Y';
355:

Line 366: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

362: -- Start bug 4100563
363: l_api_name := 'OKC_TERMS_UTIL_GRP.CONTRACT_TERMS_AMENDED';
364:
365: IF (g_po_wf_debug = 'Y') THEN
366: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
367: '130: Return status before the call'||l_return_status);
368: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
369: '132: Call OKC_TERMS_UTIL_GRP.contract_terms_amended');
370: END IF;

Line 368: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

364:
365: IF (g_po_wf_debug = 'Y') THEN
366: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
367: '130: Return status before the call'||l_return_status);
368: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
369: '132: Call OKC_TERMS_UTIL_GRP.contract_terms_amended');
370: END IF;
371:
372: l_k_terms_changed := OKC_TERMS_UTIL_GRP.CONTRACT_TERMS_AMENDED(

Line 381: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

377: x_msg_data => l_msg_data,
378: x_msg_count => l_msg_count);
379:
380: IF (g_po_wf_debug = 'Y') THEN
381: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
382: '135: Return status after call to CONTRACT_TERMS_AMENDED'||l_return_status);
383:
384: END IF;
385:

Line 392: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

388:
389: -- Check return value from CONTRACT_TERMS_AMENDED
390: IF (l_k_terms_changed = 'NONE') THEN
391: IF (g_po_wf_debug = 'Y') THEN
392: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
393: '138: K contract terms changed: N'||l_k_terms_changed);
394: END IF;
395:
396: --End Bug 4100563

Line 401: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

397:
398: --Call contracts to find out if contract terms changed
399: l_api_name := 'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED';
400: IF (g_po_wf_debug = 'Y') THEN
401: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
402: '140: Return status Before the call'||l_return_status);
403: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
404: '142: Call OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED');
405: END IF;

Line 403: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

399: l_api_name := 'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED';
400: IF (g_po_wf_debug = 'Y') THEN
401: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
402: '140: Return status Before the call'||l_return_status);
403: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
404: '142: Call OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED');
405: END IF;
406:
407: l_k_terms_changed :=OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED(

Line 416: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

412: x_msg_data => l_msg_data,
413: x_msg_count => l_msg_count);
414:
415: IF (g_po_wf_debug = 'Y') THEN
416: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
417: '150: Return status after call to IS_ARTICLE_AMENDED'||l_return_status);
418:
419: END IF;
420:

Line 425: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

421: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
422:
423: IF (l_k_terms_changed = 'NONE') THEN
424: IF (g_po_wf_debug = 'Y') THEN
425: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
426: '155: K Articles changed: N'||l_k_terms_changed);
427: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
428: '160: Call OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended');
429: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

Line 427: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

423: IF (l_k_terms_changed = 'NONE') THEN
424: IF (g_po_wf_debug = 'Y') THEN
425: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
426: '155: K Articles changed: N'||l_k_terms_changed);
427: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
428: '160: Call OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended');
429: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
430: '162: Return status Before the call'||l_return_status);
431: END IF;

Line 429: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

425: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
426: '155: K Articles changed: N'||l_k_terms_changed);
427: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
428: '160: Call OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended');
429: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
430: '162: Return status Before the call'||l_return_status);
431: END IF;
432:
433: l_api_name := 'OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended';

Line 443: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

439: x_msg_data => l_msg_data,
440: x_msg_count => l_msg_count);
441:
442: IF (g_po_wf_debug = 'Y') THEN
443: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
444: '165: Return status after call to Is_Deliverable_Amended'||l_return_status);
445:
446: END IF;
447:

Line 451: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

447:
448: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
449: IF (l_k_terms_changed = 'NONE') THEN
450: IF (g_po_wf_debug = 'Y') THEN
451: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
452: '170: K Deliverables changed: N'||l_k_terms_changed);
453: END IF;
454: l_changed:='N';
455:

Line 458: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

454: l_changed:='N';
455:
456: ELSE -- if deliverables changed
457: IF (g_po_wf_debug = 'Y') THEN
458: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
459: '175:K deliverables Changed: Y'||l_k_terms_changed);
460: END IF;
461: l_changed:='Y';
462:

Line 470: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

466: END IF; -- Return status for is_deliverables_amended
467:
468: ELSE -- if articles changed
469: IF (g_po_wf_debug = 'Y') THEN
470: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
471: '180:K Terms Changed: Y'||l_k_terms_changed);
472: END IF;
473: l_changed:='Y';
474:

Line 486: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

482: -- Start bug 4100563
483: ELSE -- if contract terms changed
484:
485: IF (g_po_wf_debug = 'Y') THEN
486: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
487: '190:K Contract terms Changed: Y'||l_k_terms_changed);
488: END IF;
489: l_changed:='Y';
490:

Line 500: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

496: -- End bug 4100563
497:
498: ELSE -- if no conterms
499: IF (g_po_wf_debug = 'Y') THEN
500: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
501: '120:Not a Procurement contract');
502: END IF;
503: l_changed:='N';
504: END IF; -- if conterms exist

Line 507: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

503: l_changed:='N';
504: END IF; -- if conterms exist
505:
506: IF (g_po_wf_debug = 'Y') THEN
507: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
508: '200 End: contract_terms_Changed ');
509: END IF;
510:
511:

Line 518: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

514: EXCEPTION
515: -- Handle Exceptions and re raise
516: WHEN l_contracts_call_exception then
517: IF (g_po_wf_debug = 'Y') THEN
518: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
519: '250: End contracts_call_exception: contract_terms_Changed ');
520:
521: show_error(itemtype => itemtype,
522: itemkey => itemkey,

Line 530: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

526: wf_core.context('PO_CONTERMS_WF_PVT', 'CONTRACT_TERMS_CHANGED', 'l_contracts_call_Exception');
527: RAISE;
528: WHEN OTHERS THEN
529: IF (g_po_wf_debug = 'Y') THEN
530: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
531: '300: End IN Exception: contract_terms_Changed ');
532: END IF;
533: wf_core.context('PO_CONTERMS_WF_PVT', 'CONTRACT_TERMS_CHANGED', 'Exception');
534: RAISE;

Line 1277: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1273:
1274: l_contracts_call_exception exception;
1275: BEGIN
1276: IF (g_po_wf_debug = 'Y') THEN
1277: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1278: '10: Start function IS_STANDARD_CONTRACT ');
1279: END IF;
1280: -- Do nothing in cancel or timeout mode
1281: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1311: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1307: x_msg_count => l_msg_count);
1308: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1309:
1310: IF (g_po_wf_debug = 'Y') THEN
1311: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1312: '100: returned value from Contracts'||result);
1313: END IF;
1314:
1315: ELSE

Line 1322: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1318:
1319:
1320: ELSE -- if no conterms
1321: IF (g_po_wf_debug = 'Y') THEN
1322: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1323: '140:Not a Procurement contract');
1324: END IF;
1325: END IF; -- if conterms exist
1326:

Line 1328: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1324: END IF;
1325: END IF; -- if conterms exist
1326:
1327: IF (g_po_wf_debug = 'Y') THEN
1328: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1329: '200 End: IS_STANDARD_CONTRACT ');
1330: END IF;
1331:
1332:

Line 1337: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1333: EXCEPTION
1334: -- Handle Exceptions and re raise
1335: WHEN l_contracts_call_exception then
1336: IF (g_po_wf_debug = 'Y') THEN
1337: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1338: '250: End contracts_call_exception: IS_STANDARD_CONTRACT ');
1339: show_error(itemtype => itemtype,
1340: itemkey => itemkey,
1341: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',

Line 1355: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1351: RAISE;
1352:
1353: WHEN OTHERS THEN
1354: IF (g_po_wf_debug = 'Y') THEN
1355: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1356: '300: End IN Exception: IS_STANDARD_CONTRACT ');
1357: END IF;
1358: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1359: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1427: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1423:
1424: l_contracts_call_exception exception;
1425: BEGIN
1426: IF (g_po_wf_debug = 'Y') THEN
1427: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1428: '10: Start function IS_CONTRACT_TEMPLATE_EXPIRED ');
1429: END IF;
1430: -- Do nothing in cancel or timeout mode
1431: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1460: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1456: x_msg_count => l_msg_count);
1457: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1458:
1459: IF (g_po_wf_debug = 'Y') THEN
1460: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1461: '100: returned value from Contracts'||result);
1462: END IF;
1463:
1464: ELSE

Line 1471: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1467:
1468:
1469: ELSE -- if no conterms
1470: IF (g_po_wf_debug = 'Y') THEN
1471: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1472: '140:Not a Procurement contract');
1473: END IF;
1474: END IF; -- if conterms exist
1475:

Line 1477: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1473: END IF;
1474: END IF; -- if conterms exist
1475:
1476: IF (g_po_wf_debug = 'Y') THEN
1477: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1478: '200 End: IS_CONTRACT_TEMPLATE_EXPIRED ');
1479: END IF;
1480:
1481:

Line 1486: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1482: EXCEPTION
1483: -- Handle Exceptions and re raise
1484: WHEN l_contracts_call_exception then
1485: IF (g_po_wf_debug = 'Y') THEN
1486: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1487: '250: End contracts_call_exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1488: show_error(itemtype => itemtype,
1489: itemkey => itemkey,
1490: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',

Line 1504: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1500: RAISE;
1501:
1502: WHEN OTHERS THEN
1503: IF (g_po_wf_debug = 'Y') THEN
1504: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1505: '300: End IN Exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1506: END IF;
1507: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1508: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1578: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1574:
1575: l_contracts_call_exception exception;
1576: BEGIN
1577: IF (g_po_wf_debug = 'Y') THEN
1578: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1579: '10: Start function IS_CONTRACT_ARTICLES_EXIST ');
1580: END IF;
1581: -- Do nothing in cancel or timeout mode
1582: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1611: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1607: x_msg_count => l_msg_count);
1608: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1609:
1610: IF (g_po_wf_debug = 'Y') THEN
1611: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1612: '100: returned value from Contracts'||result);
1613: END IF;
1614:
1615: ELSE

Line 1622: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1618:
1619:
1620: ELSE -- if no conterms
1621: IF (g_po_wf_debug = 'Y') THEN
1622: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1623: '140:Not a Procurement contract');
1624: END IF;
1625: END IF; -- if conterms exist
1626:

Line 1628: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1624: END IF;
1625: END IF; -- if conterms exist
1626:
1627: IF (g_po_wf_debug = 'Y') THEN
1628: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1629: '200 End: IS_CONTRACT_ARTICLES_EXIST ');
1630: END IF;
1631:
1632:

Line 1637: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1633: EXCEPTION
1634: -- Handle Exceptions and re raise
1635: WHEN l_contracts_call_exception then
1636: IF (g_po_wf_debug = 'Y') THEN
1637: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1638: '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_EXIST ');
1639: show_error(itemtype => itemtype,
1640: itemkey => itemkey,
1641: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',

Line 1655: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1651: RAISE;
1652:
1653: WHEN OTHERS THEN
1654: IF (g_po_wf_debug = 'Y') THEN
1655: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1656: '300: End IN Exception: IS_CONTRACT_ARTICLES_EXIST ');
1657: END IF;
1658: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1659: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1730: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1726:
1727: l_contracts_call_exception exception;
1728: BEGIN
1729: IF (g_po_wf_debug = 'Y') THEN
1730: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1731: '10: Start function IS_CONTRACT_ARTICLES_AMENDED');
1732: END IF;
1733: -- Do nothing in cancel or timeout mode
1734: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1763: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1759: x_msg_count => l_msg_count);
1760: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1761:
1762: IF (g_po_wf_debug = 'Y') THEN
1763: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1764: '100: returned value from Contracts'||result);
1765: END IF;
1766:
1767: ELSE

Line 1774: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1770:
1771:
1772: ELSE -- if no conterms
1773: IF (g_po_wf_debug = 'Y') THEN
1774: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1775: '140:Not a Procurement contract');
1776: END IF;
1777: END IF; -- if conterms exist
1778:

Line 1780: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1776: END IF;
1777: END IF; -- if conterms exist
1778:
1779: IF (g_po_wf_debug = 'Y') THEN
1780: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1781: '200 End: IS_CONTRACT_ARTICLES_AMENDED ');
1782: END IF;
1783:
1784:

Line 1789: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1785: EXCEPTION
1786: -- Handle Exceptions and re raise
1787: WHEN l_contracts_call_exception then
1788: IF (g_po_wf_debug = 'Y') THEN
1789: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1790: '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_AMENDED ');
1791: show_error(itemtype => itemtype,
1792: itemkey => itemkey,
1793: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',

Line 1807: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1803: RAISE;
1804:
1805: WHEN OTHERS THEN
1806: IF (g_po_wf_debug = 'Y') THEN
1807: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1808: '300: End IN Exception: IS_CONTRACT_ARTICLES_AMENDED ');
1809: END IF;
1810: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1811: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1885: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1881:
1882: l_contracts_call_exception exception;
1883: BEGIN
1884: IF (g_po_wf_debug = 'Y') THEN
1885: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1886: '10: Start function IS_CONTRACT_DELIVRABLS_EXIST');
1887: END IF;
1888: -- Do nothing in cancel or timeout mode
1889: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1920: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1916: IF (result = 'CONTRACTUAL_AND_INTERNAL') THEN
1917: result := 'ALL';
1918: END IF;
1919: IF (g_po_wf_debug = 'Y') THEN
1920: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1921: '100: returned value from Contracts'||result);
1922: END IF;
1923:
1924: ELSE

Line 1931: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1927:
1928:
1929: ELSE -- if no conterms
1930: IF (g_po_wf_debug = 'Y') THEN
1931: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1932: '140:Not a Procurement contract');
1933: END IF;
1934: END IF; -- if conterms exist
1935:

Line 1937: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1933: END IF;
1934: END IF; -- if conterms exist
1935:
1936: IF (g_po_wf_debug = 'Y') THEN
1937: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1938: '200 End: IS_CONTRACT_DELIVRABLS_EXIST ');
1939: END IF;
1940:
1941:

Line 1946: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1942: EXCEPTION
1943: -- Handle Exceptions and re raise
1944: WHEN l_contracts_call_exception then
1945: IF (g_po_wf_debug = 'Y') THEN
1946: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1947: '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1948: show_error(itemtype => itemtype,
1949: itemkey => itemkey,
1950: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',

Line 1964: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1960: RAISE;
1961:
1962: WHEN OTHERS THEN
1963: IF (g_po_wf_debug = 'Y') THEN
1964: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1965: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1966: END IF;
1967: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1968: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 2041: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2037:
2038: l_contracts_call_exception exception;
2039: BEGIN
2040: IF (g_po_wf_debug = 'Y') THEN
2041: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2042: '10: Start function IS_CONTRACT_ARTICLES_AMENDED');
2043: END IF;
2044: -- Do nothing in cancel or timeout mode
2045: IF (funcmode <> WF_ENGINE.eng_run) then

Line 2076: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2072: IF (result = 'CONTRACTUAL_AND_INTERNAL') THEN
2073: result := 'ALL';
2074: END IF;
2075: IF (g_po_wf_debug = 'Y') THEN
2076: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2077: '100: returned value from Contracts'||result);
2078: END IF;
2079:
2080: ELSE

Line 2087: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2083:
2084:
2085: ELSE -- if no conterms
2086: IF (g_po_wf_debug = 'Y') THEN
2087: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2088: '140:Not a Procurement contract');
2089: END IF;
2090: END IF; -- if conterms exist
2091:

Line 2093: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2089: END IF;
2090: END IF; -- if conterms exist
2091:
2092: IF (g_po_wf_debug = 'Y') THEN
2093: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2094: '200 End: IS_CONTRACT_DELIVRABLS_AMENDED ');
2095: END IF;
2096:
2097:

Line 2102: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2098: EXCEPTION
2099: -- Handle Exceptions and re raise
2100: WHEN l_contracts_call_exception then
2101: IF (g_po_wf_debug = 'Y') THEN
2102: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2103: '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2104: show_error(itemtype => itemtype,
2105: itemkey => itemkey,
2106: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',

Line 2120: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2116: RAISE;
2117:
2118: WHEN OTHERS THEN
2119: IF (g_po_wf_debug = 'Y') THEN
2120: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2121: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2122: END IF;
2123: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2124: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);