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.ZPB_DC_WF dependencies on FND_API

Line 458: l_init_msg_list := FND_API.G_FALSE;

454: l_resultout VARCHAR2(30);
455: BEGIN
456:
457: l_api_version := 1.0;
458: l_init_msg_list := FND_API.G_FALSE;
459: l_commit := FND_API.G_FALSE;
460: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
461: l_owner := fnd_global.user_name;
462:

Line 459: l_commit := FND_API.G_FALSE;

455: BEGIN
456:
457: l_api_version := 1.0;
458: l_init_msg_list := FND_API.G_FALSE;
459: l_commit := FND_API.G_FALSE;
460: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
461: l_owner := fnd_global.user_name;
462:
463: IF (funcmode = 'RUN') THEN

Line 460: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

456:
457: l_api_version := 1.0;
458: l_init_msg_list := FND_API.G_FALSE;
459: l_commit := FND_API.G_FALSE;
460: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
461: l_owner := fnd_global.user_name;
462:
463: IF (funcmode = 'RUN') THEN
464: resultout :='COMPLETE:N';

Line 653: IF NOT FND_API.Compatible_API_Call ( l_api_version,

649: BEGIN
650:
651: SAVEPOINT Raise_Distribution_Event ;
652:
653: IF NOT FND_API.Compatible_API_Call ( l_api_version,
654: p_api_version,
655: l_api_name,
656: G_PKG_NAME )
657: THEN

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

654: p_api_version,
655: l_api_name,
656: G_PKG_NAME )
657: THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
659: END IF;
660:
661:
662: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 662: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
659: END IF;
660:
661:
662: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
663: FND_MSG_PUB.initialize ;
664: END IF;
665:
666: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 666: x_return_status := FND_API.G_RET_STS_SUCCESS ;

662: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
663: FND_MSG_PUB.initialize ;
664: END IF;
665:
666: x_return_status := FND_API.G_RET_STS_SUCCESS ;
667: -- Initialize the parameters
668: l_item_type := 'ZPBDC' ;
669:
670:

Line 764: when FND_API.G_EXC_ERROR then

760: p_data => x_msg_data ) ;
761: --
762: EXCEPTION
763: --
764: when FND_API.G_EXC_ERROR then
765: --
766: rollback to Raise_Distribution_Event ;
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: --
764: when FND_API.G_EXC_ERROR then
765: --
766: rollback to Raise_Distribution_Event ;
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
769: p_data => x_msg_data);
770: --
771: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 771: when FND_API.G_EXC_UNEXPECTED_ERROR then

767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
769: p_data => x_msg_data);
770: --
771: when FND_API.G_EXC_UNEXPECTED_ERROR then
772: --
773: rollback to Raise_Distribution_Event ;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

770: --
771: when FND_API.G_EXC_UNEXPECTED_ERROR then
772: --
773: rollback to Raise_Distribution_Event ;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
776: p_data => x_msg_data);
777: --
778: when OTHERS then

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

777: --
778: when OTHERS then
779: --
780: rollback to Raise_Distribution_Event ;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
783: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
784: l_api_name);
785: END if;

Line 1213: l_init_msg_list := FND_API.G_FALSE;

1209: l_msg_count NUMBER;
1210: l_msg_data VARCHAR2(4000);
1211: BEGIN
1212:
1213: l_init_msg_list := FND_API.G_FALSE;
1214: l_commit := FND_API.G_FALSE;
1215: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1216:
1217: IF (funcmode = 'RUN') THEN

Line 1214: l_commit := FND_API.G_FALSE;

1210: l_msg_data VARCHAR2(4000);
1211: BEGIN
1212:
1213: l_init_msg_list := FND_API.G_FALSE;
1214: l_commit := FND_API.G_FALSE;
1215: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1216:
1217: IF (funcmode = 'RUN') THEN
1218: l_template_id := wf_engine.GetItemAttrNumber(

Line 1215: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

1211: BEGIN
1212:
1213: l_init_msg_list := FND_API.G_FALSE;
1214: l_commit := FND_API.G_FALSE;
1215: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1216:
1217: IF (funcmode = 'RUN') THEN
1218: l_template_id := wf_engine.GetItemAttrNumber(
1219: Itemtype => ItemType,

Line 1412: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1408: BEGIN
1409:
1410: SAVEPOINT Raise_Submission_Event ;
1411:
1412: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1413: p_api_version,
1414: l_api_name,
1415: G_PKG_NAME )
1416: THEN

Line 1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1413: p_api_version,
1414: l_api_name,
1415: G_PKG_NAME )
1416: THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1418: END IF;
1419:
1420: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1421: FND_MSG_PUB.initialize ;

Line 1420: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1416: THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1418: END IF;
1419:
1420: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1421: FND_MSG_PUB.initialize ;
1422: END IF;
1423:
1424: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1424: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1420: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1421: FND_MSG_PUB.initialize ;
1422: END IF;
1423:
1424: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1425:
1426: -- Initialize the parameters
1427: l_item_type := 'ZPBDC' ;
1428:

Line 1583: when FND_API.G_EXC_ERROR then

1579: p_data => x_msg_data ) ;
1580: --
1581: EXCEPTION
1582: --
1583: when FND_API.G_EXC_ERROR then
1584: --
1585: rollback to Raise_Submission_Event ;
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 1586: x_return_status := FND_API.G_RET_STS_ERROR;

1582: --
1583: when FND_API.G_EXC_ERROR then
1584: --
1585: rollback to Raise_Submission_Event ;
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1588: p_data => x_msg_data);
1589: --
1590: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1590: when FND_API.G_EXC_UNEXPECTED_ERROR then

1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1588: p_data => x_msg_data);
1589: --
1590: when FND_API.G_EXC_UNEXPECTED_ERROR then
1591: --
1592: rollback to Raise_Submission_Event ;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1594: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1589: --
1590: when FND_API.G_EXC_UNEXPECTED_ERROR then
1591: --
1592: rollback to Raise_Submission_Event ;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1594: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1595: p_data => x_msg_data);
1596: --
1597: when OTHERS then

Line 1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1596: --
1597: when OTHERS then
1598: --
1599: rollback to Raise_Submission_Event ;
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1602: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1603: l_api_name);
1604: END if;

Line 1897: l_init_msg_list := FND_API.G_FALSE;

1893:
1894: BEGIN
1895:
1896: l_api_version := 1.0;
1897: l_init_msg_list := FND_API.G_FALSE;
1898: l_commit := FND_API.G_FALSE;
1899: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1900:
1901: IF (funcmode = 'RUN') THEN

Line 1898: l_commit := FND_API.G_FALSE;

1894: BEGIN
1895:
1896: l_api_version := 1.0;
1897: l_init_msg_list := FND_API.G_FALSE;
1898: l_commit := FND_API.G_FALSE;
1899: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1900:
1901: IF (funcmode = 'RUN') THEN
1902:

Line 1899: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

1895:
1896: l_api_version := 1.0;
1897: l_init_msg_list := FND_API.G_FALSE;
1898: l_commit := FND_API.G_FALSE;
1899: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
1900:
1901: IF (funcmode = 'RUN') THEN
1902:
1903: l_object_id := wf_engine.GetItemAttrNumber(

Line 2468: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2464: BEGIN
2465:
2466: SAVEPOINT Raise_Approval_Event ;
2467:
2468: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2469: p_api_version,
2470: l_api_name,
2471: G_PKG_NAME )
2472: THEN

Line 2473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2469: p_api_version,
2470: l_api_name,
2471: G_PKG_NAME )
2472: THEN
2473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2474: END IF;
2475:
2476:
2477: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 2477: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

2473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2474: END IF;
2475:
2476:
2477: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2478: FND_MSG_PUB.initialize ;
2479: END IF;
2480:
2481: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2481: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2477: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2478: FND_MSG_PUB.initialize ;
2479: END IF;
2480:
2481: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2482:
2483: -- Initialize the parameters
2484: l_item_type := 'ZPBDC' ;
2485: l_init_msg_list := FND_API.G_FALSE;

Line 2485: l_init_msg_list := FND_API.G_FALSE;

2481: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2482:
2483: -- Initialize the parameters
2484: l_item_type := 'ZPBDC' ;
2485: l_init_msg_list := FND_API.G_FALSE;
2486: l_commit := FND_API.G_FALSE;
2487: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
2488:
2489: SELECT nvl(description,user_name)

Line 2486: l_commit := FND_API.G_FALSE;

2482:
2483: -- Initialize the parameters
2484: l_item_type := 'ZPBDC' ;
2485: l_init_msg_list := FND_API.G_FALSE;
2486: l_commit := FND_API.G_FALSE;
2487: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
2488:
2489: SELECT nvl(description,user_name)
2490: INTO l_approver_for_msg

Line 2487: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

2483: -- Initialize the parameters
2484: l_item_type := 'ZPBDC' ;
2485: l_init_msg_list := FND_API.G_FALSE;
2486: l_commit := FND_API.G_FALSE;
2487: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
2488:
2489: SELECT nvl(description,user_name)
2490: INTO l_approver_for_msg
2491: FROM fnd_user

Line 2598: when FND_API.G_EXC_ERROR then

2594: p_data => x_msg_data ) ;
2595: --
2596: EXCEPTION
2597: --
2598: when FND_API.G_EXC_ERROR then
2599: --
2600: rollback to Raise_Approval_Event ;
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 2601: x_return_status := FND_API.G_RET_STS_ERROR;

2597: --
2598: when FND_API.G_EXC_ERROR then
2599: --
2600: rollback to Raise_Approval_Event ;
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2603: p_data => x_msg_data);
2604: --
2605: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2605: when FND_API.G_EXC_UNEXPECTED_ERROR then

2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2603: p_data => x_msg_data);
2604: --
2605: when FND_API.G_EXC_UNEXPECTED_ERROR then
2606: --
2607: rollback to Raise_Approval_Event ;
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2604: --
2605: when FND_API.G_EXC_UNEXPECTED_ERROR then
2606: --
2607: rollback to Raise_Approval_Event ;
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2610: p_data => x_msg_data);
2611: --
2612: when OTHERS then

Line 2615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2611: --
2612: when OTHERS then
2613: --
2614: rollback to Raise_Approval_Event ;
2615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2616: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2617: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2618: l_api_name);
2619: END if;

Line 2674: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2670: BEGIN
2671:
2672: SAVEPOINT Raise_Rejection_Event ;
2673:
2674: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2675: p_api_version,
2676: l_api_name,
2677: G_PKG_NAME )
2678: THEN

Line 2679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2675: p_api_version,
2676: l_api_name,
2677: G_PKG_NAME )
2678: THEN
2679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2680: END IF;
2681:
2682:
2683: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 2683: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

2679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2680: END IF;
2681:
2682:
2683: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2684: FND_MSG_PUB.initialize ;
2685: END IF;
2686:
2687: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2687: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2683: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
2684: FND_MSG_PUB.initialize ;
2685: END IF;
2686:
2687: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2688:
2689: -- Initialize the parameters
2690: l_init_msg_list := FND_API.G_FALSE;
2691: l_commit := FND_API.G_FALSE;

Line 2690: l_init_msg_list := FND_API.G_FALSE;

2686:
2687: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2688:
2689: -- Initialize the parameters
2690: l_init_msg_list := FND_API.G_FALSE;
2691: l_commit := FND_API.G_FALSE;
2692: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
2693:
2694:

Line 2691: l_commit := FND_API.G_FALSE;

2687: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2688:
2689: -- Initialize the parameters
2690: l_init_msg_list := FND_API.G_FALSE;
2691: l_commit := FND_API.G_FALSE;
2692: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
2693:
2694:
2695: SELECT ZPB_DC_WF_PROCESSES_S.nextval

Line 2692: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

2688:
2689: -- Initialize the parameters
2690: l_init_msg_list := FND_API.G_FALSE;
2691: l_commit := FND_API.G_FALSE;
2692: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
2693:
2694:
2695: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2696: INTO l_item_key

Line 2809: when FND_API.G_EXC_ERROR then

2805: p_data => x_msg_data ) ;
2806: --
2807: EXCEPTION
2808: --
2809: when FND_API.G_EXC_ERROR then
2810: --
2811: rollback to Raise_Rejection_Event ;
2812: x_return_status := FND_API.G_RET_STS_ERROR;
2813: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 2812: x_return_status := FND_API.G_RET_STS_ERROR;

2808: --
2809: when FND_API.G_EXC_ERROR then
2810: --
2811: rollback to Raise_Rejection_Event ;
2812: x_return_status := FND_API.G_RET_STS_ERROR;
2813: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2814: p_data => x_msg_data);
2815: --
2816: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2816: when FND_API.G_EXC_UNEXPECTED_ERROR then

2812: x_return_status := FND_API.G_RET_STS_ERROR;
2813: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2814: p_data => x_msg_data);
2815: --
2816: when FND_API.G_EXC_UNEXPECTED_ERROR then
2817: --
2818: rollback to Raise_Rejection_Event ;
2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2820: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2815: --
2816: when FND_API.G_EXC_UNEXPECTED_ERROR then
2817: --
2818: rollback to Raise_Rejection_Event ;
2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2820: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2821: p_data => x_msg_data);
2822: --
2823: when OTHERS then

Line 2826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2822: --
2823: when OTHERS then
2824: --
2825: rollback to Raise_Rejection_Event ;
2826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2828: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2829: l_api_name);
2830: END if;