DBA Data[Home] [Help]

APPS.FEM_FEMAPPR_ITEM_TYPE dependencies on FND_MSG_PUB

Line 289: FND_MSG_PUB.Initialize;

285:
286: if (p_func_mode = 'RUN') then
287:
288: -- Initialize API message list
289: FND_MSG_PUB.Initialize;
290:
291: -- Set all the Approval Type information on the Item Attributes
292: InitApprovalRequestInternal(
293: p_item_type => p_item_type,

Line 340: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

336: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
337: raise;
338:
339: when others then
340: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
341: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
342: raise;
343:
344: END InitApprovalRequest;

Line 388: FND_MSG_PUB.Initialize;

384:
385: if (p_func_mode = 'RUN') then
386:
387: -- Initialize API message list
388: FND_MSG_PUB.Initialize;
389:
390: l_item_plsql_pkg_name := WF_ENGINE.GetItemAttrText(
391: p_item_type, p_item_key, G_ITEM_PLSQL_PKG_NAME);
392:

Line 413: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

409:
410: l_request_item_code := WF_ENGINE.GetItemAttrText(
411: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
412:
413: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
414: 'Invalid Approval Request Item: '||l_request_item_code);
415: raise FND_API.G_EXC_UNEXPECTED_ERROR;
416:
417: end if;

Line 432: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

428: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
429: raise;
430:
431: when others then
432: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
433: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
434: raise;
435:
436: END CheckApprovalItems;

Line 480: FND_MSG_PUB.Initialize;

476:
477: if (p_func_mode = 'RUN') then
478:
479: -- Initialize API message list
480: FND_MSG_PUB.Initialize;
481:
482: l_item_plsql_pkg_name := WF_ENGINE.GetItemAttrText(
483: p_item_type, p_item_key, G_ITEM_PLSQL_PKG_NAME);
484:

Line 504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

500:
501: l_request_item_code := WF_ENGINE.GetItemAttrText(
502: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
503:
504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
505: 'Invalid Approval Request Item: '||l_request_item_code);
506: raise FND_API.G_EXC_UNEXPECTED_ERROR;
507:
508: end if;

Line 523: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

519: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
520: raise;
521:
522: when others then
523: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
524: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
525: raise;
526:
527: END InitApprovalItems;

Line 581: FND_MSG_PUB.Initialize;

577:
578: if (p_func_mode = 'RUN') then
579:
580: -- Initialize API message list
581: FND_MSG_PUB.Initialize;
582:
583: l_application_id := WF_ENGINE.GetItemAttrNumber(
584: p_item_type, p_item_key, G_APPLICATION_ID);
585:

Line 600: FND_MSG_PUB.Add;

596:
597: if (l_next_approver_rec.approval_status = AME_UTIL.exceptionStatus) then
598:
599: FND_MESSAGE.set_name('FEM', 'FEM_WF_APPR_NEXT_APPR_ERR');
600: FND_MSG_PUB.Add;
601: raise FND_API.G_EXC_ERROR;
602:
603: end if;
604:

Line 688: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

684: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
685: raise;
686:
687: when others then
688: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
689: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
690: raise;
691:
692: END GetNextApprover;

Line 733: FND_MSG_PUB.Initialize;

729:
730: if (p_func_mode = 'RUN') then
731:
732: -- Initialize API message list
733: FND_MSG_PUB.Initialize;
734:
735: UpdateApproval(
736: p_item_type => p_item_type
737: ,p_item_key => p_item_key

Line 753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

749: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
750: raise;
751:
752: when others then
753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
754: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
755: raise;
756:
757: END UpdateApprovalApproved;

Line 798: FND_MSG_PUB.Initialize;

794:
795: if (p_func_mode = 'RUN') then
796:
797: -- Initialize API message list
798: FND_MSG_PUB.Initialize;
799:
800: UpdateApproval(
801: p_item_type => p_item_type
802: ,p_item_key => p_item_key

Line 818: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

814: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
815: raise;
816:
817: when others then
818: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
819: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
820: raise;
821:
822: END UpdateApprovalRejected;

Line 863: FND_MSG_PUB.Initialize;

859:
860: if (p_func_mode = 'RUN') then
861:
862: -- Initialize API message list
863: FND_MSG_PUB.Initialize;
864:
865: UpdateApproval(
866: p_item_type => p_item_type
867: ,p_item_key => p_item_key

Line 883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

879: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
880: raise;
881:
882: when others then
883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
884: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
885: raise;
886:
887: END UpdateApprovalNoResponse;

Line 944: FND_MSG_PUB.Initialize;

940:
941: if (p_func_mode in ('FORWARD','TRANSFER')) then
942:
943: -- Initialize API message list
944: FND_MSG_PUB.Initialize;
945:
946: -- Get necessary attribute values for call to AME_API
947: l_application_id := WF_ENGINE.GetItemAttrNumber(
948: p_item_type, p_item_key, G_APPLICATION_ID);

Line 995: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

991:
992: else
993:
994: -- Invalid Original System for Old Approver
995: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
996: 'Invalid Original System for Old Approver: '||l_old_approver_orig_system);
997: raise FND_API.G_EXC_UNEXPECTED_ERROR;
998:
999: end if;

Line 1028: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1024: l_new_approver_record.user_id := l_new_approver_id;
1025:
1026: else
1027:
1028: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1029: 'Invalid Original System for New Approver: '||l_new_approver_orig_system);
1030: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1031:
1032: end if;

Line 1104: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1100: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1101: raise;
1102:
1103: when others then
1104: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1105: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1106: raise;
1107:
1108: END ApprovalRequestHandler;

Line 1152: FND_MSG_PUB.Initialize;

1148:
1149: if (p_func_mode = 'RUN') then
1150:
1151: -- Initialize API message list
1152: FND_MSG_PUB.Initialize;
1153:
1154: l_item_plsql_pkg_name := WF_ENGINE.GetItemAttrText(
1155: p_item_type, p_item_key, G_ITEM_PLSQL_PKG_NAME);
1156:

Line 1176: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1172:
1173: l_request_item_code := WF_ENGINE.GetItemAttrText(
1174: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
1175:
1176: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1177: 'Invalid Approval Request Item: '||l_request_item_code);
1178: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1179:
1180: end if;

Line 1195: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1191: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1192: raise;
1193:
1194: when others then
1195: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1196: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1197: raise;
1198:
1199: END SetSubmittedState;

Line 1243: FND_MSG_PUB.Initialize;

1239:
1240: if (p_func_mode = 'RUN') then
1241:
1242: -- Initialize API message list
1243: FND_MSG_PUB.Initialize;
1244:
1245: l_item_plsql_pkg_name := WF_ENGINE.GetItemAttrText(
1246: p_item_type, p_item_key, G_ITEM_PLSQL_PKG_NAME);
1247:

Line 1275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1271:
1272: l_request_item_code := WF_ENGINE.GetItemAttrText(
1273: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
1274:
1275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1276: 'Invalid Approval Request Item: '||l_request_item_code);
1277: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1278:
1279: end if;

Line 1294: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1290: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1291: raise;
1292:
1293: when others then
1294: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1295: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1296: raise;
1297:
1298: END SetApprovedState;

Line 1342: FND_MSG_PUB.Initialize;

1338:
1339: if (p_func_mode = 'RUN') then
1340:
1341: -- Initialize API message list
1342: FND_MSG_PUB.Initialize;
1343:
1344: l_item_plsql_pkg_name := WF_ENGINE.GetItemAttrText(
1345: p_item_type, p_item_key, G_ITEM_PLSQL_PKG_NAME);
1346:

Line 1366: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1362:
1363: l_request_item_code := WF_ENGINE.GetItemAttrText(
1364: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
1365:
1366: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1367: 'Invalid Approval Request Item: '||l_request_item_code);
1368: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1369:
1370: end if;

Line 1385: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1381: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1382: raise;
1383:
1384: when others then
1385: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1386: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1387: raise;
1388:
1389: END SetRejectedState;

Line 1431: FND_MSG_PUB.Initialize;

1427:
1428: if (p_func_mode = 'RUN') then
1429:
1430: -- Initialize API message list
1431: FND_MSG_PUB.Initialize;
1432:
1433: l_justification :=
1434: FND_MESSAGE.get_string('FEM', 'FEM_WF_APPROVED_STATE_ERR');
1435:

Line 1451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1447: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1448: raise;
1449:
1450: when others then
1451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1452: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1453: raise;
1454:
1455: END ApprovedStateFailure;

Line 1495: FND_MSG_PUB.Initialize;

1491:
1492: if (p_func_mode = 'RUN') then
1493:
1494: -- Initialize API message list
1495: FND_MSG_PUB.Initialize;
1496:
1497: PurgeApprovalRequest (
1498: p_item_type => p_item_type
1499: ,p_item_key => p_item_key

Line 1516: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1512: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1513: raise;
1514:
1515: when others then
1516: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1517: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1518: raise;
1519:
1520: END FinalizeApprovalRequest;

Line 1594: FND_MSG_PUB.Initialize;

1590:
1591: elsif (p_command = 'SET_CTX') then
1592:
1593: -- Initialize API message list
1594: FND_MSG_PUB.Initialize;
1595:
1596: l_org_id := WF_ENGINE.GetItemAttrNumber(
1597: p_item_type, p_item_key, G_ORG_ID);
1598:

Line 1629: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1625: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1626: raise;
1627:
1628: when others then
1629: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1630: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1631: raise;
1632:
1633: END CallbackFunction;

Line 1724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1720: );
1721:
1722: else
1723:
1724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1725: 'Invalid Approver Original System: '||l_approver_orig_system);
1726: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1727:
1728: end if;

Line 1783: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1779:
1780: l_request_item_code := WF_ENGINE.GetItemAttrText(
1781: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
1782:
1783: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1784: 'Invalid Approval Request Item: '||l_request_item_code);
1785: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1786:
1787: end if;

Line 1866: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1862: p_item_type, p_item_key, G_REQUEST_ITEM, l_request_item);
1863:
1864: else
1865:
1866: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1867: 'Approval Request ID cannot be NULL');
1868: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1869:
1870: end if;

Line 1888: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1884: p_item_type, p_item_key, G_REQUEST_TYPE, l_request_type);
1885:
1886: else
1887:
1888: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1889: 'Approval Request Type cannot be NULL');
1890: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1891:
1892: end if;

Line 1896: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,

1892: end if;
1893:
1894: else
1895:
1896: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1897: 'Invalid Event Name: '||l_event_name);
1898: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1899:
1900: end if;

Line 1946: -- in the FND_MSG_PUB message stack.

1942: -- BuildErrorMsg
1943: --
1944: -- DESCRIPTION
1945: -- Builds the Workflow Error Message by checking if there are any errors
1946: -- in the FND_MSG_PUB message stack.
1947: --
1948: -- IN
1949: -- p_api_name - The PL/SQL Procedure or Function name.
1950: -- p_item_type - The workflow item type (FEMAPPR)

Line 1969: FND_MSG_PUB.Count_And_Get(

1965: l_msg_data t_msg_data%TYPE;
1966:
1967: BEGIN
1968:
1969: FND_MSG_PUB.Count_And_Get(
1970: p_count => l_msg_count
1971: ,p_data => l_msg_data
1972: );
1973:

Line 1976: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_FIRST);

1972: );
1973:
1974: if (l_msg_count > 1) then
1975:
1976: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_FIRST);
1977:
1978: end if;
1979:
1980: WF_CORE.Context(