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 1258: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1254:
1255: l_contracts_call_exception exception;
1256: BEGIN
1257: IF (g_po_wf_debug = 'Y') THEN
1258: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1259: '10: Start function IS_STANDARD_CONTRACT ');
1260: END IF;
1261: -- Do nothing in cancel or timeout mode
1262: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1292: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1288: x_msg_count => l_msg_count);
1289: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1290:
1291: IF (g_po_wf_debug = 'Y') THEN
1292: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1293: '100: returned value from Contracts'||result);
1294: END IF;
1295:
1296: ELSE

Line 1303: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1299:
1300:
1301: ELSE -- if no conterms
1302: IF (g_po_wf_debug = 'Y') THEN
1303: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1304: '140:Not a Procurement contract');
1305: END IF;
1306: END IF; -- if conterms exist
1307:

Line 1309: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1305: END IF;
1306: END IF; -- if conterms exist
1307:
1308: IF (g_po_wf_debug = 'Y') THEN
1309: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1310: '200 End: IS_STANDARD_CONTRACT ');
1311: END IF;
1312:
1313:

Line 1318: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1314: EXCEPTION
1315: -- Handle Exceptions and re raise
1316: WHEN l_contracts_call_exception then
1317: IF (g_po_wf_debug = 'Y') THEN
1318: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1319: '250: End contracts_call_exception: IS_STANDARD_CONTRACT ');
1320: show_error(itemtype => itemtype,
1321: itemkey => itemkey,
1322: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',

Line 1336: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1332: RAISE;
1333:
1334: WHEN OTHERS THEN
1335: IF (g_po_wf_debug = 'Y') THEN
1336: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1337: '300: End IN Exception: IS_STANDARD_CONTRACT ');
1338: END IF;
1339: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1340: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1408: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1404:
1405: l_contracts_call_exception exception;
1406: BEGIN
1407: IF (g_po_wf_debug = 'Y') THEN
1408: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1409: '10: Start function IS_CONTRACT_TEMPLATE_EXPIRED ');
1410: END IF;
1411: -- Do nothing in cancel or timeout mode
1412: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1441: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1437: x_msg_count => l_msg_count);
1438: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1439:
1440: IF (g_po_wf_debug = 'Y') THEN
1441: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1442: '100: returned value from Contracts'||result);
1443: END IF;
1444:
1445: ELSE

Line 1452: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1448:
1449:
1450: ELSE -- if no conterms
1451: IF (g_po_wf_debug = 'Y') THEN
1452: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1453: '140:Not a Procurement contract');
1454: END IF;
1455: END IF; -- if conterms exist
1456:

Line 1458: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1454: END IF;
1455: END IF; -- if conterms exist
1456:
1457: IF (g_po_wf_debug = 'Y') THEN
1458: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1459: '200 End: IS_CONTRACT_TEMPLATE_EXPIRED ');
1460: END IF;
1461:
1462:

Line 1467: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1463: EXCEPTION
1464: -- Handle Exceptions and re raise
1465: WHEN l_contracts_call_exception then
1466: IF (g_po_wf_debug = 'Y') THEN
1467: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1468: '250: End contracts_call_exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1469: show_error(itemtype => itemtype,
1470: itemkey => itemkey,
1471: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',

Line 1485: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1481: RAISE;
1482:
1483: WHEN OTHERS THEN
1484: IF (g_po_wf_debug = 'Y') THEN
1485: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1486: '300: End IN Exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1487: END IF;
1488: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1489: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1559: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1555:
1556: l_contracts_call_exception exception;
1557: BEGIN
1558: IF (g_po_wf_debug = 'Y') THEN
1559: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1560: '10: Start function IS_CONTRACT_ARTICLES_EXIST ');
1561: END IF;
1562: -- Do nothing in cancel or timeout mode
1563: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1592: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1588: x_msg_count => l_msg_count);
1589: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1590:
1591: IF (g_po_wf_debug = 'Y') THEN
1592: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1593: '100: returned value from Contracts'||result);
1594: END IF;
1595:
1596: ELSE

Line 1603: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1599:
1600:
1601: ELSE -- if no conterms
1602: IF (g_po_wf_debug = 'Y') THEN
1603: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1604: '140:Not a Procurement contract');
1605: END IF;
1606: END IF; -- if conterms exist
1607:

Line 1609: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1605: END IF;
1606: END IF; -- if conterms exist
1607:
1608: IF (g_po_wf_debug = 'Y') THEN
1609: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1610: '200 End: IS_CONTRACT_ARTICLES_EXIST ');
1611: END IF;
1612:
1613:

Line 1618: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1614: EXCEPTION
1615: -- Handle Exceptions and re raise
1616: WHEN l_contracts_call_exception then
1617: IF (g_po_wf_debug = 'Y') THEN
1618: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1619: '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_EXIST ');
1620: show_error(itemtype => itemtype,
1621: itemkey => itemkey,
1622: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',

Line 1636: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1632: RAISE;
1633:
1634: WHEN OTHERS THEN
1635: IF (g_po_wf_debug = 'Y') THEN
1636: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1637: '300: End IN Exception: IS_CONTRACT_ARTICLES_EXIST ');
1638: END IF;
1639: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1640: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1711: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1707:
1708: l_contracts_call_exception exception;
1709: BEGIN
1710: IF (g_po_wf_debug = 'Y') THEN
1711: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1712: '10: Start function IS_CONTRACT_ARTICLES_AMENDED');
1713: END IF;
1714: -- Do nothing in cancel or timeout mode
1715: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1744: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1740: x_msg_count => l_msg_count);
1741: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1742:
1743: IF (g_po_wf_debug = 'Y') THEN
1744: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1745: '100: returned value from Contracts'||result);
1746: END IF;
1747:
1748: ELSE

Line 1755: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1751:
1752:
1753: ELSE -- if no conterms
1754: IF (g_po_wf_debug = 'Y') THEN
1755: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1756: '140:Not a Procurement contract');
1757: END IF;
1758: END IF; -- if conterms exist
1759:

Line 1761: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1757: END IF;
1758: END IF; -- if conterms exist
1759:
1760: IF (g_po_wf_debug = 'Y') THEN
1761: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1762: '200 End: IS_CONTRACT_ARTICLES_AMENDED ');
1763: END IF;
1764:
1765:

Line 1770: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1766: EXCEPTION
1767: -- Handle Exceptions and re raise
1768: WHEN l_contracts_call_exception then
1769: IF (g_po_wf_debug = 'Y') THEN
1770: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1771: '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_AMENDED ');
1772: show_error(itemtype => itemtype,
1773: itemkey => itemkey,
1774: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',

Line 1788: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1784: RAISE;
1785:
1786: WHEN OTHERS THEN
1787: IF (g_po_wf_debug = 'Y') THEN
1788: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1789: '300: End IN Exception: IS_CONTRACT_ARTICLES_AMENDED ');
1790: END IF;
1791: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1792: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 1866: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1862:
1863: l_contracts_call_exception exception;
1864: BEGIN
1865: IF (g_po_wf_debug = 'Y') THEN
1866: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1867: '10: Start function IS_CONTRACT_DELIVRABLS_EXIST');
1868: END IF;
1869: -- Do nothing in cancel or timeout mode
1870: IF (funcmode <> WF_ENGINE.eng_run) then

Line 1901: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1897: IF (result = 'CONTRACTUAL_AND_INTERNAL') THEN
1898: result := 'ALL';
1899: END IF;
1900: IF (g_po_wf_debug = 'Y') THEN
1901: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1902: '100: returned value from Contracts'||result);
1903: END IF;
1904:
1905: ELSE

Line 1912: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1908:
1909:
1910: ELSE -- if no conterms
1911: IF (g_po_wf_debug = 'Y') THEN
1912: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1913: '140:Not a Procurement contract');
1914: END IF;
1915: END IF; -- if conterms exist
1916:

Line 1918: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1914: END IF;
1915: END IF; -- if conterms exist
1916:
1917: IF (g_po_wf_debug = 'Y') THEN
1918: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1919: '200 End: IS_CONTRACT_DELIVRABLS_EXIST ');
1920: END IF;
1921:
1922:

Line 1927: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1923: EXCEPTION
1924: -- Handle Exceptions and re raise
1925: WHEN l_contracts_call_exception then
1926: IF (g_po_wf_debug = 'Y') THEN
1927: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1928: '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1929: show_error(itemtype => itemtype,
1930: itemkey => itemkey,
1931: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',

Line 1945: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

1941: RAISE;
1942:
1943: WHEN OTHERS THEN
1944: IF (g_po_wf_debug = 'Y') THEN
1945: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1946: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1947: END IF;
1948: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1949: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

Line 2022: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2018:
2019: l_contracts_call_exception exception;
2020: BEGIN
2021: IF (g_po_wf_debug = 'Y') THEN
2022: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2023: '10: Start function IS_CONTRACT_ARTICLES_AMENDED');
2024: END IF;
2025: -- Do nothing in cancel or timeout mode
2026: IF (funcmode <> WF_ENGINE.eng_run) then

Line 2057: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2053: IF (result = 'CONTRACTUAL_AND_INTERNAL') THEN
2054: result := 'ALL';
2055: END IF;
2056: IF (g_po_wf_debug = 'Y') THEN
2057: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2058: '100: returned value from Contracts'||result);
2059: END IF;
2060:
2061: ELSE

Line 2068: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2064:
2065:
2066: ELSE -- if no conterms
2067: IF (g_po_wf_debug = 'Y') THEN
2068: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2069: '140:Not a Procurement contract');
2070: END IF;
2071: END IF; -- if conterms exist
2072:

Line 2074: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2070: END IF;
2071: END IF; -- if conterms exist
2072:
2073: IF (g_po_wf_debug = 'Y') THEN
2074: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2075: '200 End: IS_CONTRACT_DELIVRABLS_AMENDED ');
2076: END IF;
2077:
2078:

Line 2083: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2079: EXCEPTION
2080: -- Handle Exceptions and re raise
2081: WHEN l_contracts_call_exception then
2082: IF (g_po_wf_debug = 'Y') THEN
2083: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2084: '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2085: show_error(itemtype => itemtype,
2086: itemkey => itemkey,
2087: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',

Line 2101: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

2097: RAISE;
2098:
2099: WHEN OTHERS THEN
2100: IF (g_po_wf_debug = 'Y') THEN
2101: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2102: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2103: END IF;
2104: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2105: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);