APPS.XNP_STANDARD dependencies on FND_MESSAGE

Line 375: fnd_message.set_name('XNP','STD_ERROR');

371: WHEN OTHERS THEN
372: -- Grab the error message and error no.
373: x_error_code := SQLCODE;
374:
375: fnd_message.set_name('XNP','STD_ERROR');
376: fnd_message.set_token('ERROR_LOCN'
377: ,'XNP_STANDARD.SMS_CREATE_PORTED_NUMBER');
378: fnd_message.set_token('ERROR_TEXT',SQLERRM);
379: x_error_message := fnd_message.get;

Line 376: fnd_message.set_token('ERROR_LOCN'

372: -- Grab the error message and error no.
373: x_error_code := SQLCODE;
374:
375: fnd_message.set_name('XNP','STD_ERROR');
376: fnd_message.set_token('ERROR_LOCN'
377: ,'XNP_STANDARD.SMS_CREATE_PORTED_NUMBER');
378: fnd_message.set_token('ERROR_TEXT',SQLERRM);
379: x_error_message := fnd_message.get;
380: END SMS_CREATE_PORTED_NUMBER;

Line 378: fnd_message.set_token('ERROR_TEXT',SQLERRM);

374:
375: fnd_message.set_name('XNP','STD_ERROR');
376: fnd_message.set_token('ERROR_LOCN'
377: ,'XNP_STANDARD.SMS_CREATE_PORTED_NUMBER');
378: fnd_message.set_token('ERROR_TEXT',SQLERRM);
379: x_error_message := fnd_message.get;
380: END SMS_CREATE_PORTED_NUMBER;
381:
382:

Line 379: x_error_message := fnd_message.get;

375: fnd_message.set_name('XNP','STD_ERROR');
376: fnd_message.set_token('ERROR_LOCN'
377: ,'XNP_STANDARD.SMS_CREATE_PORTED_NUMBER');
378: fnd_message.set_token('ERROR_TEXT',SQLERRM);
379: x_error_message := fnd_message.get;
380: END SMS_CREATE_PORTED_NUMBER;
381:
382:
383: --------------------------------------------------------------------

Line 555: fnd_message.set_name('XNP','STD_ERROR');

551: WHEN OTHERS THEN
552: -- Grab the error message and error no.
553: x_error_code := SQLCODE;
554:
555: fnd_message.set_name('XNP','STD_ERROR');
556: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE');
557: fnd_message.set_token('ERROR_TEXT',SQLERRM);
558: x_error_message := fnd_message.get;
559:

Line 556: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE');

552: -- Grab the error message and error no.
553: x_error_code := SQLCODE;
554:
555: fnd_message.set_name('XNP','STD_ERROR');
556: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE');
557: fnd_message.set_token('ERROR_TEXT',SQLERRM);
558: x_error_message := fnd_message.get;
559:
560: END SOA_UPDATE_CUTOFF_DATE;

Line 557: fnd_message.set_token('ERROR_TEXT',SQLERRM);

553: x_error_code := SQLCODE;
554:
555: fnd_message.set_name('XNP','STD_ERROR');
556: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE');
557: fnd_message.set_token('ERROR_TEXT',SQLERRM);
558: x_error_message := fnd_message.get;
559:
560: END SOA_UPDATE_CUTOFF_DATE;
561:

Line 558: x_error_message := fnd_message.get;

554:
555: fnd_message.set_name('XNP','STD_ERROR');
556: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE');
557: fnd_message.set_token('ERROR_TEXT',SQLERRM);
558: x_error_message := fnd_message.get;
559:
560: END SOA_UPDATE_CUTOFF_DATE;
561:
562:

Line 1219: fnd_message.set_name('XNP','STD_ERROR');

1215: WHEN OTHERS THEN
1216: -- Grab the error message and error no.
1217: x_error_code := SQLCODE;
1218:
1219: fnd_message.set_name('XNP','STD_ERROR');
1220: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CREATE_PORTING_ORDER');
1221: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1222: x_error_message := fnd_message.get;
1223:

Line 1220: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CREATE_PORTING_ORDER');

1216: -- Grab the error message and error no.
1217: x_error_code := SQLCODE;
1218:
1219: fnd_message.set_name('XNP','STD_ERROR');
1220: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CREATE_PORTING_ORDER');
1221: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1222: x_error_message := fnd_message.get;
1223:
1224: END SOA_CREATE_PORTING_ORDER;

Line 1221: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1217: x_error_code := SQLCODE;
1218:
1219: fnd_message.set_name('XNP','STD_ERROR');
1220: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CREATE_PORTING_ORDER');
1221: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1222: x_error_message := fnd_message.get;
1223:
1224: END SOA_CREATE_PORTING_ORDER;
1225:

Line 1222: x_error_message := fnd_message.get;

1218:
1219: fnd_message.set_name('XNP','STD_ERROR');
1220: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CREATE_PORTING_ORDER');
1221: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1222: x_error_message := fnd_message.get;
1223:
1224: END SOA_CREATE_PORTING_ORDER;
1225:
1226: --------------------------------------------------------------------

Line 1274: fnd_message.set_name('XNP','STD_ERROR');

1270: WHEN OTHERS THEN
1271: -- Grab the error message and error no.
1272: x_error_code := SQLCODE;
1273:
1274: fnd_message.set_name('XNP','STD_ERROR');
1275: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS');
1276: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1277: x_error_message := fnd_message.get;
1278:

Line 1275: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS');

1271: -- Grab the error message and error no.
1272: x_error_code := SQLCODE;
1273:
1274: fnd_message.set_name('XNP','STD_ERROR');
1275: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS');
1276: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1277: x_error_message := fnd_message.get;
1278:
1279: END SOA_CHECK_NOTIFY_DIR_SVS;

Line 1276: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1272: x_error_code := SQLCODE;
1273:
1274: fnd_message.set_name('XNP','STD_ERROR');
1275: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS');
1276: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1277: x_error_message := fnd_message.get;
1278:
1279: END SOA_CHECK_NOTIFY_DIR_SVS;
1280:

Line 1277: x_error_message := fnd_message.get;

1273:
1274: fnd_message.set_name('XNP','STD_ERROR');
1275: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS');
1276: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1277: x_error_message := fnd_message.get;
1278:
1279: END SOA_CHECK_NOTIFY_DIR_SVS;
1280:
1281:

Line 1372: fnd_message.set_name('XNP','STD_ERROR');

1368: WHEN OTHERS THEN
1369: -- Grab the error message and error no.
1370: x_error_code := SQLCODE;
1371:
1372: fnd_message.set_name('XNP','STD_ERROR');
1373: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.DETERMINE_SP_ROLE');
1374: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1375: x_error_message := fnd_message.get;
1376:

Line 1373: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.DETERMINE_SP_ROLE');

1369: -- Grab the error message and error no.
1370: x_error_code := SQLCODE;
1371:
1372: fnd_message.set_name('XNP','STD_ERROR');
1373: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.DETERMINE_SP_ROLE');
1374: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1375: x_error_message := fnd_message.get;
1376:
1377: END DETERMINE_SP_ROLE;

Line 1374: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1370: x_error_code := SQLCODE;
1371:
1372: fnd_message.set_name('XNP','STD_ERROR');
1373: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.DETERMINE_SP_ROLE');
1374: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1375: x_error_message := fnd_message.get;
1376:
1377: END DETERMINE_SP_ROLE;
1378:

Line 1375: x_error_message := fnd_message.get;

1371:
1372: fnd_message.set_name('XNP','STD_ERROR');
1373: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.DETERMINE_SP_ROLE');
1374: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1375: x_error_message := fnd_message.get;
1376:
1377: END DETERMINE_SP_ROLE;
1378:
1379:

Line 1486: fnd_message.set_name('XNP','STD_ERROR');

1482: WHEN OTHERS THEN
1483: -- Grab the error message and error no.
1484: x_error_code := SQLCODE;
1485:
1486: fnd_message.set_name('XNP','STD_ERROR');
1487: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
1488: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1489: x_error_message := fnd_message.get;
1490:

Line 1487: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');

1483: -- Grab the error message and error no.
1484: x_error_code := SQLCODE;
1485:
1486: fnd_message.set_name('XNP','STD_ERROR');
1487: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
1488: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1489: x_error_message := fnd_message.get;
1490:
1491: END SOA_UPDATE_SV_STATUS;

Line 1488: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1484: x_error_code := SQLCODE;
1485:
1486: fnd_message.set_name('XNP','STD_ERROR');
1487: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
1488: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1489: x_error_message := fnd_message.get;
1490:
1491: END SOA_UPDATE_SV_STATUS;
1492:

Line 1489: x_error_message := fnd_message.get;

1485:
1486: fnd_message.set_name('XNP','STD_ERROR');
1487: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
1488: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1489: x_error_message := fnd_message.get;
1490:
1491: END SOA_UPDATE_SV_STATUS;
1492:
1493: --------------------------------------------------------------------

Line 1616: fnd_message.set_name('XNP','STD_ERROR');

1612: WHEN OTHERS THEN
1613: -- Grab the error message and error no.
1614: x_error_code := SQLCODE;
1615:
1616: fnd_message.set_name('XNP','STD_ERROR');
1617: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CHARGING_INFO');
1618: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1619: x_error_message := fnd_message.get;
1620:

Line 1617: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CHARGING_INFO');

1613: -- Grab the error message and error no.
1614: x_error_code := SQLCODE;
1615:
1616: fnd_message.set_name('XNP','STD_ERROR');
1617: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CHARGING_INFO');
1618: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1619: x_error_message := fnd_message.get;
1620:
1621: END SOA_UPDATE_CHARGING_INFO;

Line 1618: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1614: x_error_code := SQLCODE;
1615:
1616: fnd_message.set_name('XNP','STD_ERROR');
1617: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CHARGING_INFO');
1618: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1619: x_error_message := fnd_message.get;
1620:
1621: END SOA_UPDATE_CHARGING_INFO;
1622:

Line 1619: x_error_message := fnd_message.get;

1615:
1616: fnd_message.set_name('XNP','STD_ERROR');
1617: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CHARGING_INFO');
1618: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1619: x_error_message := fnd_message.get;
1620:
1621: END SOA_UPDATE_CHARGING_INFO;
1622:
1623: --------------------------------------------------------------------

Line 1655: fnd_message.set_name('XNP','STD_ERROR');

1651: WHEN OTHERS THEN
1652: -- Grab the error message and error no.
1653: x_error_code := SQLCODE;
1654:
1655: fnd_message.set_name('XNP','STD_ERROR');
1656: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_ORDER_STATUS');
1657: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1658: x_error_message := fnd_message.get;
1659:

Line 1656: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_ORDER_STATUS');

1652: -- Grab the error message and error no.
1653: x_error_code := SQLCODE;
1654:
1655: fnd_message.set_name('XNP','STD_ERROR');
1656: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_ORDER_STATUS');
1657: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1658: x_error_message := fnd_message.get;
1659:
1660: END SOA_CHECK_ORDER_STATUS;

Line 1657: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1653: x_error_code := SQLCODE;
1654:
1655: fnd_message.set_name('XNP','STD_ERROR');
1656: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_ORDER_STATUS');
1657: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1658: x_error_message := fnd_message.get;
1659:
1660: END SOA_CHECK_ORDER_STATUS;
1661:

Line 1658: x_error_message := fnd_message.get;

1654:
1655: fnd_message.set_name('XNP','STD_ERROR');
1656: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_ORDER_STATUS');
1657: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1658: x_error_message := fnd_message.get;
1659:
1660: END SOA_CHECK_ORDER_STATUS;
1661:
1662: --------------------------------------------------------------------

Line 1720: fnd_message.set_name('XNP','STD_ERROR');

1716: WHEN OTHERS THEN
1717: -- Grab the error message and error no.
1718: x_error_code := SQLCODE;
1719:
1720: fnd_message.set_name('XNP','STD_ERROR');
1721: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_SOA_STATUS_EXISTS');
1722: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1723: x_error_message := fnd_message.get;
1724:

Line 1721: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_SOA_STATUS_EXISTS');

1717: -- Grab the error message and error no.
1718: x_error_code := SQLCODE;
1719:
1720: fnd_message.set_name('XNP','STD_ERROR');
1721: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_SOA_STATUS_EXISTS');
1722: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1723: x_error_message := fnd_message.get;
1724:
1725: END CHECK_SOA_STATUS_EXISTS;

Line 1722: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1718: x_error_code := SQLCODE;
1719:
1720: fnd_message.set_name('XNP','STD_ERROR');
1721: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_SOA_STATUS_EXISTS');
1722: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1723: x_error_message := fnd_message.get;
1724:
1725: END CHECK_SOA_STATUS_EXISTS;
1726:

Line 1723: x_error_message := fnd_message.get;

1719:
1720: fnd_message.set_name('XNP','STD_ERROR');
1721: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_SOA_STATUS_EXISTS');
1722: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1723: x_error_message := fnd_message.get;
1724:
1725: END CHECK_SOA_STATUS_EXISTS;
1726:
1727: --------------------------------------------------------------------

Line 1801: fnd_message.set_name('XNP','STD_ERROR');

1797: WHEN OTHERS THEN
1798: -- Grab the error message and error no.
1799: x_error_code := SQLCODE;
1800:
1801: fnd_message.set_name('XNP','STD_ERROR');
1802: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SET_ORDER_RESULT');
1803: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1804: x_error_message := fnd_message.get;
1805:

Line 1802: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SET_ORDER_RESULT');

1798: -- Grab the error message and error no.
1799: x_error_code := SQLCODE;
1800:
1801: fnd_message.set_name('XNP','STD_ERROR');
1802: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SET_ORDER_RESULT');
1803: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1804: x_error_message := fnd_message.get;
1805:
1806: END SET_ORDER_RESULT;

Line 1803: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1799: x_error_code := SQLCODE;
1800:
1801: fnd_message.set_name('XNP','STD_ERROR');
1802: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SET_ORDER_RESULT');
1803: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1804: x_error_message := fnd_message.get;
1805:
1806: END SET_ORDER_RESULT;
1807:

Line 1804: x_error_message := fnd_message.get;

1800:
1801: fnd_message.set_name('XNP','STD_ERROR');
1802: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SET_ORDER_RESULT');
1803: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1804: x_error_message := fnd_message.get;
1805:
1806: END SET_ORDER_RESULT;
1807:
1808: ------------------------------------------------------------------

Line 2017: fnd_message.set_name('XNP','STD_ERROR');

2013: WHEN OTHERS THEN
2014: -- Grab the error message and error no.
2015: x_error_code := SQLCODE;
2016:
2017: fnd_message.set_name('XNP','STD_ERROR');
2018: fnd_message.set_token('ERROR_LOCN'
2019: ,'XNP_STANDARD.PUBLISH_EVENT');
2020: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2021: x_error_message := fnd_message.get;

Line 2018: fnd_message.set_token('ERROR_LOCN'

2014: -- Grab the error message and error no.
2015: x_error_code := SQLCODE;
2016:
2017: fnd_message.set_name('XNP','STD_ERROR');
2018: fnd_message.set_token('ERROR_LOCN'
2019: ,'XNP_STANDARD.PUBLISH_EVENT');
2020: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2021: x_error_message := fnd_message.get;
2022: END;

Line 2020: fnd_message.set_token('ERROR_TEXT',SQLERRM);

2016:
2017: fnd_message.set_name('XNP','STD_ERROR');
2018: fnd_message.set_token('ERROR_LOCN'
2019: ,'XNP_STANDARD.PUBLISH_EVENT');
2020: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2021: x_error_message := fnd_message.get;
2022: END;
2023:
2024: END PUBLISH_EVENT;

Line 2021: x_error_message := fnd_message.get;

2017: fnd_message.set_name('XNP','STD_ERROR');
2018: fnd_message.set_token('ERROR_LOCN'
2019: ,'XNP_STANDARD.PUBLISH_EVENT');
2020: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2021: x_error_message := fnd_message.get;
2022: END;
2023:
2024: END PUBLISH_EVENT;
2025:

Line 2127: fnd_message.set_name('XNP','STD_GET_FAILED');

2123: ,OUT x_error_message;
2124:
2125: IF x_error_code <> 0
2126: THEN
2127: fnd_message.set_name('XNP','STD_GET_FAILED');
2128: fnd_message.set_token
2129: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2130: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2131: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

Line 2128: fnd_message.set_token

2124:
2125: IF x_error_code <> 0
2126: THEN
2127: fnd_message.set_name('XNP','STD_GET_FAILED');
2128: fnd_message.set_token
2129: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2130: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2131: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2132: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

Line 2130: fnd_message.set_token('ATTRNAME',p_CONSUMER);

2126: THEN
2127: fnd_message.set_name('XNP','STD_GET_FAILED');
2128: fnd_message.set_token
2129: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2130: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2131: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2132: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2133: x_error_message := fnd_message.get||':'||x_error_message;
2134: RETURN;

Line 2131: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

2127: fnd_message.set_name('XNP','STD_GET_FAILED');
2128: fnd_message.set_token
2129: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2130: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2131: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2132: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2133: x_error_message := fnd_message.get||':'||x_error_message;
2134: RETURN;
2135: END IF;

Line 2132: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

2128: fnd_message.set_token
2129: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2130: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2131: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2132: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2133: x_error_message := fnd_message.get||':'||x_error_message;
2134: RETURN;
2135: END IF;
2136:

Line 2133: x_error_message := fnd_message.get||':'||x_error_message;

2129: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2130: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2131: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2132: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2133: x_error_message := fnd_message.get||':'||x_error_message;
2134: RETURN;
2135: END IF;
2136:
2137: -- BUG # 1500177

Line 2148: fnd_message.set_name('XNP','NO_ADAPTER_FOR_FE');

2144:
2145: IF l_consumer_name IS NULL
2146: THEN
2147: x_error_code := xnp_errors.g_no_adapter_for_fe;
2148: fnd_message.set_name('XNP','NO_ADAPTER_FOR_FE');
2149: fnd_message.set_token('NAME',l_fe_name );
2150: x_error_message := fnd_message.get;
2151: END IF;
2152:

Line 2149: fnd_message.set_token('NAME',l_fe_name );

2145: IF l_consumer_name IS NULL
2146: THEN
2147: x_error_code := xnp_errors.g_no_adapter_for_fe;
2148: fnd_message.set_name('XNP','NO_ADAPTER_FOR_FE');
2149: fnd_message.set_token('NAME',l_fe_name );
2150: x_error_message := fnd_message.get;
2151: END IF;
2152:
2153: IF x_error_code <> 0

Line 2150: x_error_message := fnd_message.get;

2146: THEN
2147: x_error_code := xnp_errors.g_no_adapter_for_fe;
2148: fnd_message.set_name('XNP','NO_ADAPTER_FOR_FE');
2149: fnd_message.set_token('NAME',l_fe_name );
2150: x_error_message := fnd_message.get;
2151: END IF;
2152:
2153: IF x_error_code <> 0
2154: THEN

Line 2155: fnd_message.set_name('XNP','STD_GET_FAILED');

2151: END IF;
2152:
2153: IF x_error_code <> 0
2154: THEN
2155: fnd_message.set_name('XNP','STD_GET_FAILED');
2156: fnd_message.set_token
2157: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2158: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2159: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

Line 2156: fnd_message.set_token

2152:
2153: IF x_error_code <> 0
2154: THEN
2155: fnd_message.set_name('XNP','STD_GET_FAILED');
2156: fnd_message.set_token
2157: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2158: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2159: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2160: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

Line 2158: fnd_message.set_token('ATTRNAME',p_CONSUMER);

2154: THEN
2155: fnd_message.set_name('XNP','STD_GET_FAILED');
2156: fnd_message.set_token
2157: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2158: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2159: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2160: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2161: x_error_message := fnd_message.get||':'||x_error_message;
2162: RETURN;

Line 2159: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

2155: fnd_message.set_name('XNP','STD_GET_FAILED');
2156: fnd_message.set_token
2157: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2158: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2159: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2160: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2161: x_error_message := fnd_message.get||':'||x_error_message;
2162: RETURN;
2163: END IF;

Line 2160: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

2156: fnd_message.set_token
2157: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2158: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2159: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2160: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2161: x_error_message := fnd_message.get||':'||x_error_message;
2162: RETURN;
2163: END IF;
2164:

Line 2161: x_error_message := fnd_message.get||':'||x_error_message;

2157: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2158: fnd_message.set_token('ATTRNAME',p_CONSUMER);
2159: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2160: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2161: x_error_message := fnd_message.get||':'||x_error_message;
2162: RETURN;
2163: END IF;
2164:
2165:

Line 2170: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');

2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: -- Grab the error message and error no.
2169: x_error_code := SQLCODE;
2170: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2171: fnd_message.set_token
2172: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2173: fnd_message.set_token('DYNA_PROC',p_CONSUMER);
2174: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

Line 2171: fnd_message.set_token

2167: WHEN OTHERS THEN
2168: -- Grab the error message and error no.
2169: x_error_code := SQLCODE;
2170: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2171: fnd_message.set_token
2172: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2173: fnd_message.set_token('DYNA_PROC',p_CONSUMER);
2174: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2175: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

Line 2173: fnd_message.set_token('DYNA_PROC',p_CONSUMER);

2169: x_error_code := SQLCODE;
2170: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2171: fnd_message.set_token
2172: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2173: fnd_message.set_token('DYNA_PROC',p_CONSUMER);
2174: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2175: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2176: x_error_message :=
2177: fnd_message.get;

Line 2174: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

2170: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2171: fnd_message.set_token
2172: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2173: fnd_message.set_token('DYNA_PROC',p_CONSUMER);
2174: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2175: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2176: x_error_message :=
2177: fnd_message.get;
2178: x_error_message := x_error_message ||':'||SQLERRM;

Line 2175: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

2171: fnd_message.set_token
2172: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2173: fnd_message.set_token('DYNA_PROC',p_CONSUMER);
2174: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2175: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2176: x_error_message :=
2177: fnd_message.get;
2178: x_error_message := x_error_message ||':'||SQLERRM;
2179: END;

Line 2177: fnd_message.get;

2173: fnd_message.set_token('DYNA_PROC',p_CONSUMER);
2174: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2175: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2176: x_error_message :=
2177: fnd_message.get;
2178: x_error_message := x_error_message ||':'||SQLERRM;
2179: END;
2180:
2181: -- If error while getting consumer name then return

Line 2215: fnd_message.set_name('XNP','STD_GET_FAILED');

2211: ,OUT x_error_message;
2212:
2213: IF x_error_code <> 0
2214: THEN
2215: fnd_message.set_name('XNP','STD_GET_FAILED');
2216: fnd_message.set_token('ATTRNAME',p_RECEIVER);
2217: fnd_message.set_token
2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

Line 2216: fnd_message.set_token('ATTRNAME',p_RECEIVER);

2212:
2213: IF x_error_code <> 0
2214: THEN
2215: fnd_message.set_name('XNP','STD_GET_FAILED');
2216: fnd_message.set_token('ATTRNAME',p_RECEIVER);
2217: fnd_message.set_token
2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2220: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

Line 2217: fnd_message.set_token

2213: IF x_error_code <> 0
2214: THEN
2215: fnd_message.set_name('XNP','STD_GET_FAILED');
2216: fnd_message.set_token('ATTRNAME',p_RECEIVER);
2217: fnd_message.set_token
2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2220: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2221: x_error_message := fnd_message.get;

Line 2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

2215: fnd_message.set_name('XNP','STD_GET_FAILED');
2216: fnd_message.set_token('ATTRNAME',p_RECEIVER);
2217: fnd_message.set_token
2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2220: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2221: x_error_message := fnd_message.get;
2222: x_error_message := fnd_message.get||':'||x_error_message;
2223: RETURN;

Line 2220: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

2216: fnd_message.set_token('ATTRNAME',p_RECEIVER);
2217: fnd_message.set_token
2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2220: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2221: x_error_message := fnd_message.get;
2222: x_error_message := fnd_message.get||':'||x_error_message;
2223: RETURN;
2224: END IF;

Line 2221: x_error_message := fnd_message.get;

2217: fnd_message.set_token
2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2220: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2221: x_error_message := fnd_message.get;
2222: x_error_message := fnd_message.get||':'||x_error_message;
2223: RETURN;
2224: END IF;
2225:

Line 2222: x_error_message := fnd_message.get||':'||x_error_message;

2218: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2219: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2220: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2221: x_error_message := fnd_message.get;
2222: x_error_message := fnd_message.get||':'||x_error_message;
2223: RETURN;
2224: END IF;
2225:
2226:

Line 2232: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');

2228: WHEN OTHERS THEN
2229: -- Grab the error message and error no.
2230: x_error_code := SQLCODE;
2231:
2232: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2233: fnd_message.set_token('DYNA_PROC',p_RECEIVER);
2234: fnd_message.set_token
2235: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2236: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

Line 2233: fnd_message.set_token('DYNA_PROC',p_RECEIVER);

2229: -- Grab the error message and error no.
2230: x_error_code := SQLCODE;
2231:
2232: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2233: fnd_message.set_token('DYNA_PROC',p_RECEIVER);
2234: fnd_message.set_token
2235: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2236: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2237: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

Line 2234: fnd_message.set_token

2230: x_error_code := SQLCODE;
2231:
2232: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2233: fnd_message.set_token('DYNA_PROC',p_RECEIVER);
2234: fnd_message.set_token
2235: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2236: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2237: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2238: x_error_message := fnd_message.get||':'||x_error_message;

Line 2236: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');

2232: fnd_message.set_name('XNP','XNP_DYNA_EXEC_FAILED');
2233: fnd_message.set_token('DYNA_PROC',p_RECEIVER);
2234: fnd_message.set_token
2235: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2236: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2237: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2238: x_error_message := fnd_message.get||':'||x_error_message;
2239: END;
2240:

Line 2237: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);

2233: fnd_message.set_token('DYNA_PROC',p_RECEIVER);
2234: fnd_message.set_token
2235: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2236: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2237: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2238: x_error_message := fnd_message.get||':'||x_error_message;
2239: END;
2240:
2241: -- If error while getting recipient name then return

Line 2238: x_error_message := fnd_message.get||':'||x_error_message;

2234: fnd_message.set_token
2235: ('FAILED_PROC','XNP_STANDARD.SEND_MESSAGE');
2236: fnd_message.set_token('KEY','WORKITEM_INSTANCE_ID');
2237: fnd_message.set_token('VALUE',p_WORKITEM_INSTANCE_ID);
2238: x_error_message := fnd_message.get||':'||x_error_message;
2239: END;
2240:
2241: -- If error while getting recipient name then return
2242: IF x_error_code <> 0

Line 2406: fnd_message.set_name('XNP','STD_ERROR');

2402:
2403: -- Grab the error message and error no.
2404: x_error_code := SQLCODE;
2405:
2406: fnd_message.set_name('XNP','STD_ERROR');
2407: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SEND_MESSAGE');
2408: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2409: x_error_message := fnd_message.get;
2410: END;

Line 2407: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SEND_MESSAGE');

2403: -- Grab the error message and error no.
2404: x_error_code := SQLCODE;
2405:
2406: fnd_message.set_name('XNP','STD_ERROR');
2407: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SEND_MESSAGE');
2408: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2409: x_error_message := fnd_message.get;
2410: END;
2411:

Line 2408: fnd_message.set_token('ERROR_TEXT',SQLERRM);

2404: x_error_code := SQLCODE;
2405:
2406: fnd_message.set_name('XNP','STD_ERROR');
2407: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SEND_MESSAGE');
2408: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2409: x_error_message := fnd_message.get;
2410: END;
2411:
2412: XNP_STANDARD.FE_NAME := null;

Line 2409: x_error_message := fnd_message.get;

2405:
2406: fnd_message.set_name('XNP','STD_ERROR');
2407: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SEND_MESSAGE');
2408: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2409: x_error_message := fnd_message.get;
2410: END;
2411:
2412: XNP_STANDARD.FE_NAME := null;
2413:

Line 2468: fnd_message.set_name('XNP','STD_ERROR');

2464: WHEN OTHERS THEN
2465: -- Grab the error message and error no.
2466: x_error_code := SQLCODE;
2467:
2468: fnd_message.set_name('XNP','STD_ERROR');
2469: fnd_message.set_token('ERROR_LOCN'
2470: ,'XNP_STANDARD.SMS_DELETE_FE_MAP');
2471: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2472: x_error_message := fnd_message.get;

Line 2469: fnd_message.set_token('ERROR_LOCN'

2465: -- Grab the error message and error no.
2466: x_error_code := SQLCODE;
2467:
2468: fnd_message.set_name('XNP','STD_ERROR');
2469: fnd_message.set_token('ERROR_LOCN'
2470: ,'XNP_STANDARD.SMS_DELETE_FE_MAP');
2471: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2472: x_error_message := fnd_message.get;
2473:

Line 2471: fnd_message.set_token('ERROR_TEXT',SQLERRM);

2467:
2468: fnd_message.set_name('XNP','STD_ERROR');
2469: fnd_message.set_token('ERROR_LOCN'
2470: ,'XNP_STANDARD.SMS_DELETE_FE_MAP');
2471: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2472: x_error_message := fnd_message.get;
2473:
2474: END SMS_DELETE_FE_MAP;
2475:

Line 2472: x_error_message := fnd_message.get;

2468: fnd_message.set_name('XNP','STD_ERROR');
2469: fnd_message.set_token('ERROR_LOCN'
2470: ,'XNP_STANDARD.SMS_DELETE_FE_MAP');
2471: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2472: x_error_message := fnd_message.get;
2473:
2474: END SMS_DELETE_FE_MAP;
2475:
2476: ------------------------------------------------------------------

Line 2570: fnd_message.set_name('XNP','STD_ERROR');

2566: WHEN OTHERS THEN
2567: -- Grab the error message and error no.
2568: x_error_code := SQLCODE;
2569:
2570: fnd_message.set_name('XNP','STD_ERROR');
2571: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_PHASE_FOR_ROLE');
2572: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2573: x_error_message := fnd_message.get;
2574: END CHECK_PHASE_FOR_ROLE;

Line 2571: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_PHASE_FOR_ROLE');

2567: -- Grab the error message and error no.
2568: x_error_code := SQLCODE;
2569:
2570: fnd_message.set_name('XNP','STD_ERROR');
2571: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_PHASE_FOR_ROLE');
2572: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2573: x_error_message := fnd_message.get;
2574: END CHECK_PHASE_FOR_ROLE;
2575:

Line 2572: fnd_message.set_token('ERROR_TEXT',SQLERRM);

2568: x_error_code := SQLCODE;
2569:
2570: fnd_message.set_name('XNP','STD_ERROR');
2571: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_PHASE_FOR_ROLE');
2572: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2573: x_error_message := fnd_message.get;
2574: END CHECK_PHASE_FOR_ROLE;
2575:
2576: ------------------------------------------------------------------

Line 2573: x_error_message := fnd_message.get;

2569:
2570: fnd_message.set_name('XNP','STD_ERROR');
2571: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.CHECK_PHASE_FOR_ROLE');
2572: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2573: x_error_message := fnd_message.get;
2574: END CHECK_PHASE_FOR_ROLE;
2575:
2576: ------------------------------------------------------------------
2577: -- Purpose: Registers a callback for the given event

Line 2623: fnd_message.set_name('XNP','STD_ERROR');

2619: EXCEPTION
2620: WHEN OTHERS THEN
2621: x_error_code := SQLCODE;
2622:
2623: fnd_message.set_name('XNP','STD_ERROR');
2624: fnd_message.set_token('ERROR_LOCN'
2625: ,'XNP_STANDARD.SUBSCRIBE_FOR_EVENT');
2626: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2627: x_error_message := fnd_message.get;

Line 2624: fnd_message.set_token('ERROR_LOCN'

2620: WHEN OTHERS THEN
2621: x_error_code := SQLCODE;
2622:
2623: fnd_message.set_name('XNP','STD_ERROR');
2624: fnd_message.set_token('ERROR_LOCN'
2625: ,'XNP_STANDARD.SUBSCRIBE_FOR_EVENT');
2626: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2627: x_error_message := fnd_message.get;
2628: END SUBSCRIBE_FOR_EVENT;

Line 2626: fnd_message.set_token('ERROR_TEXT',SQLERRM);

2622:
2623: fnd_message.set_name('XNP','STD_ERROR');
2624: fnd_message.set_token('ERROR_LOCN'
2625: ,'XNP_STANDARD.SUBSCRIBE_FOR_EVENT');
2626: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2627: x_error_message := fnd_message.get;
2628: END SUBSCRIBE_FOR_EVENT;
2629:
2630: --------------------------------------------------------------------

Line 2627: x_error_message := fnd_message.get;

2623: fnd_message.set_name('XNP','STD_ERROR');
2624: fnd_message.set_token('ERROR_LOCN'
2625: ,'XNP_STANDARD.SUBSCRIBE_FOR_EVENT');
2626: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2627: x_error_message := fnd_message.get;
2628: END SUBSCRIBE_FOR_EVENT;
2629:
2630: --------------------------------------------------------------------
2631: -- Checks if this is a subsequent porting

Line 2660: fnd_message.set_name('XNP','STD_ERROR');

2656: EXCEPTION
2657: WHEN OTHERS THEN
2658: x_error_code := SQLCODE;
2659:
2660: fnd_message.set_name('XNP','STD_ERROR');
2661: fnd_message.set_token('ERROR_LOCN'
2662: ,'XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT');
2663: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2664: x_error_message := fnd_message.get;

Line 2661: fnd_message.set_token('ERROR_LOCN'

2657: WHEN OTHERS THEN
2658: x_error_code := SQLCODE;
2659:
2660: fnd_message.set_name('XNP','STD_ERROR');
2661: fnd_message.set_token('ERROR_LOCN'
2662: ,'XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT');
2663: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2664: x_error_message := fnd_message.get;
2665: END SOA_IS_SUBSEQUENT_PORT;

Line 2663: fnd_message.set_token('ERROR_TEXT',SQLERRM);

2659:
2660: fnd_message.set_name('XNP','STD_ERROR');
2661: fnd_message.set_token('ERROR_LOCN'
2662: ,'XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT');
2663: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2664: x_error_message := fnd_message.get;
2665: END SOA_IS_SUBSEQUENT_PORT;
2666:
2667: ------------------------------------------------------------------

Line 2664: x_error_message := fnd_message.get;

2660: fnd_message.set_name('XNP','STD_ERROR');
2661: fnd_message.set_token('ERROR_LOCN'
2662: ,'XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT');
2663: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2664: x_error_message := fnd_message.get;
2665: END SOA_IS_SUBSEQUENT_PORT;
2666:
2667: ------------------------------------------------------------------
2668: -- Updates the SMS_FE_MAP status for the

Line 2725: fnd_message.set_name('XNP','STD_ERROR');

2721: WHEN OTHERS THEN
2722: -- Grab the error message and error no.
2723: x_error_code := SQLCODE;
2724:
2725: fnd_message.set_name('XNP','STD_ERROR');
2726: fnd_message.set_token('ERROR_LOCN'
2727: ,'XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS');
2728: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2729: x_error_message := fnd_message.get;

Line 2726: fnd_message.set_token('ERROR_LOCN'

2722: -- Grab the error message and error no.
2723: x_error_code := SQLCODE;
2724:
2725: fnd_message.set_name('XNP','STD_ERROR');
2726: fnd_message.set_token('ERROR_LOCN'
2727: ,'XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS');
2728: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2729: x_error_message := fnd_message.get;
2730:

Line 2728: fnd_message.set_token('ERROR_TEXT',SQLERRM);

2724:
2725: fnd_message.set_name('XNP','STD_ERROR');
2726: fnd_message.set_token('ERROR_LOCN'
2727: ,'XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS');
2728: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2729: x_error_message := fnd_message.get;
2730:
2731: END SMS_UPDATE_FE_MAP_STATUS;
2732:

Line 2729: x_error_message := fnd_message.get;

2725: fnd_message.set_name('XNP','STD_ERROR');
2726: fnd_message.set_token('ERROR_LOCN'
2727: ,'XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS');
2728: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2729: x_error_message := fnd_message.get;
2730:
2731: END SMS_UPDATE_FE_MAP_STATUS;
2732:
2733:

Line 2942: fnd_message.set_name('XNP','STD_ERROR');

2938: WHEN OTHERS THEN
2939: -- Grab the error message and error no.
2940: x_error_code := SQLCODE;
2941:
2942: fnd_message.set_name('XNP','STD_ERROR');
2943: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER');
2944: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2945: x_error_message := fnd_message.get;
2946: END SMS_MODIFY_PORTED_NUMBER;

Line 2943: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER');

2939: -- Grab the error message and error no.
2940: x_error_code := SQLCODE;
2941:
2942: fnd_message.set_name('XNP','STD_ERROR');
2943: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER');
2944: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2945: x_error_message := fnd_message.get;
2946: END SMS_MODIFY_PORTED_NUMBER;
2947:

Line 2944: fnd_message.set_token('ERROR_TEXT',SQLERRM);

2940: x_error_code := SQLCODE;
2941:
2942: fnd_message.set_name('XNP','STD_ERROR');
2943: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER');
2944: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2945: x_error_message := fnd_message.get;
2946: END SMS_MODIFY_PORTED_NUMBER;
2947:
2948: ------------------------------------------------------------------

Line 2945: x_error_message := fnd_message.get;

2941:
2942: fnd_message.set_name('XNP','STD_ERROR');
2943: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER');
2944: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2945: x_error_message := fnd_message.get;
2946: END SMS_MODIFY_PORTED_NUMBER;
2947:
2948: ------------------------------------------------------------------
2949: -- Calls xnp_core.check_donor_status_exists

Line 3017: fnd_message.set_name('XNP','STD_ERROR');

3013: WHEN OTHERS THEN
3014: -- Grab the error message and error no.
3015: x_error_code := SQLCODE;
3016:
3017: fnd_message.set_name('XNP','STD_ERROR');
3018: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS');
3019: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3020: x_error_message := fnd_message.get;
3021: END SOA_CHECK_DON_STATUS_EXISTS;

Line 3018: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS');

3014: -- Grab the error message and error no.
3015: x_error_code := SQLCODE;
3016:
3017: fnd_message.set_name('XNP','STD_ERROR');
3018: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS');
3019: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3020: x_error_message := fnd_message.get;
3021: END SOA_CHECK_DON_STATUS_EXISTS;
3022:

Line 3019: fnd_message.set_token('ERROR_TEXT',SQLERRM);

3015: x_error_code := SQLCODE;
3016:
3017: fnd_message.set_name('XNP','STD_ERROR');
3018: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS');
3019: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3020: x_error_message := fnd_message.get;
3021: END SOA_CHECK_DON_STATUS_EXISTS;
3022:
3023: ------------------------------------------------------------------

Line 3020: x_error_message := fnd_message.get;

3016:
3017: fnd_message.set_name('XNP','STD_ERROR');
3018: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS');
3019: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3020: x_error_message := fnd_message.get;
3021: END SOA_CHECK_DON_STATUS_EXISTS;
3022:
3023: ------------------------------------------------------------------
3024: -- Calls xnp_core.check_recipient_status_exists

Line 3091: fnd_message.set_name('XNP','STD_ERROR');

3087: WHEN OTHERS THEN
3088: -- Grab the error message and error no.
3089: x_error_code := SQLCODE;
3090:
3091: fnd_message.set_name('XNP','STD_ERROR');
3092: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS');
3093: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3094: x_error_message := fnd_message.get;
3095: END SOA_CHECK_REC_STATUS_EXISTS;

Line 3092: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS');

3088: -- Grab the error message and error no.
3089: x_error_code := SQLCODE;
3090:
3091: fnd_message.set_name('XNP','STD_ERROR');
3092: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS');
3093: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3094: x_error_message := fnd_message.get;
3095: END SOA_CHECK_REC_STATUS_EXISTS;
3096:

Line 3093: fnd_message.set_token('ERROR_TEXT',SQLERRM);

3089: x_error_code := SQLCODE;
3090:
3091: fnd_message.set_name('XNP','STD_ERROR');
3092: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS');
3093: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3094: x_error_message := fnd_message.get;
3095: END SOA_CHECK_REC_STATUS_EXISTS;
3096:
3097: ------------------------------------------------------------------

Line 3094: x_error_message := fnd_message.get;

3090:
3091: fnd_message.set_name('XNP','STD_ERROR');
3092: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS');
3093: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3094: x_error_message := fnd_message.get;
3095: END SOA_CHECK_REC_STATUS_EXISTS;
3096:
3097: ------------------------------------------------------------------
3098: -- Called when: need to update the SV status according

Line 3223: fnd_message.set_name('XNP','STD_ERROR');

3219: WHEN OTHERS THEN
3220: -- Grab the error message and error no.
3221: x_error_code := SQLCODE;
3222:
3223: fnd_message.set_name('XNP','STD_ERROR');
3224: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
3225: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3226: x_error_message := fnd_message.get;
3227:

Line 3224: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');

3220: -- Grab the error message and error no.
3221: x_error_code := SQLCODE;
3222:
3223: fnd_message.set_name('XNP','STD_ERROR');
3224: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
3225: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3226: x_error_message := fnd_message.get;
3227:
3228: END SOA_UPDATE_SV_STATUS;

Line 3225: fnd_message.set_token('ERROR_TEXT',SQLERRM);

3221: x_error_code := SQLCODE;
3222:
3223: fnd_message.set_name('XNP','STD_ERROR');
3224: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
3225: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3226: x_error_message := fnd_message.get;
3227:
3228: END SOA_UPDATE_SV_STATUS;
3229:

Line 3226: x_error_message := fnd_message.get;

3222:
3223: fnd_message.set_name('XNP','STD_ERROR');
3224: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');
3225: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3226: x_error_message := fnd_message.get;
3227:
3228: END SOA_UPDATE_SV_STATUS;
3229:
3230: ------------------------------------------------------------------

Line 3309: fnd_message.set_name('XNP','STD_ERROR');

3305: WHEN OTHERS THEN
3306: -- Grab the error message and error no.
3307: x_error_code := SQLCODE;
3308:
3309: fnd_message.set_name('XNP','STD_ERROR');
3310: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NOTES_INFO');
3311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3312: x_error_message := fnd_message.get;
3313:

Line 3310: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NOTES_INFO');

3306: -- Grab the error message and error no.
3307: x_error_code := SQLCODE;
3308:
3309: fnd_message.set_name('XNP','STD_ERROR');
3310: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NOTES_INFO');
3311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3312: x_error_message := fnd_message.get;
3313:
3314: END SOA_UPDATE_NOTES_INFO;

Line 3311: fnd_message.set_token('ERROR_TEXT',SQLERRM);

3307: x_error_code := SQLCODE;
3308:
3309: fnd_message.set_name('XNP','STD_ERROR');
3310: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NOTES_INFO');
3311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3312: x_error_message := fnd_message.get;
3313:
3314: END SOA_UPDATE_NOTES_INFO;
3315:

Line 3312: x_error_message := fnd_message.get;

3308:
3309: fnd_message.set_name('XNP','STD_ERROR');
3310: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NOTES_INFO');
3311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3312: x_error_message := fnd_message.get;
3313:
3314: END SOA_UPDATE_NOTES_INFO;
3315:
3316:

Line 3495: fnd_message.set_name('XNP','STD_ERROR');

3491: EXCEPTION
3492: WHEN OTHERS THEN
3493: -- Grab the error message and error no.
3494: x_error_code := SQLCODE;
3495: fnd_message.set_name('XNP','STD_ERROR');
3496: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NETWORK_INFO');
3497: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3498: x_error_message := fnd_message.get;
3499:

Line 3496: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NETWORK_INFO');

3492: WHEN OTHERS THEN
3493: -- Grab the error message and error no.
3494: x_error_code := SQLCODE;
3495: fnd_message.set_name('XNP','STD_ERROR');
3496: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NETWORK_INFO');
3497: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3498: x_error_message := fnd_message.get;
3499:
3500: END SOA_UPDATE_NETWORK_INFO;

Line 3497: fnd_message.set_token('ERROR_TEXT',SQLERRM);

3493: -- Grab the error message and error no.
3494: x_error_code := SQLCODE;
3495: fnd_message.set_name('XNP','STD_ERROR');
3496: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NETWORK_INFO');
3497: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3498: x_error_message := fnd_message.get;
3499:
3500: END SOA_UPDATE_NETWORK_INFO;
3501:

Line 3498: x_error_message := fnd_message.get;

3494: x_error_code := SQLCODE;
3495: fnd_message.set_name('XNP','STD_ERROR');
3496: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NETWORK_INFO');
3497: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3498: x_error_message := fnd_message.get;
3499:
3500: END SOA_UPDATE_NETWORK_INFO;
3501:
3502: ------------------------------------------------------------------

Line 3688: fnd_message.set_name('XNP','STD_ERROR');

3684: EXCEPTION
3685: WHEN OTHERS THEN
3686: -- Grab the error message and error no.
3687: x_error_code := SQLCODE;
3688: fnd_message.set_name('XNP','STD_ERROR');
3689: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO');
3690: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3691: x_error_message := fnd_message.get;
3692:

Line 3689: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO');

3685: WHEN OTHERS THEN
3686: -- Grab the error message and error no.
3687: x_error_code := SQLCODE;
3688: fnd_message.set_name('XNP','STD_ERROR');
3689: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO');
3690: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3691: x_error_message := fnd_message.get;
3692:
3693: END SOA_UPDATE_CUSTOMER_INFO;

Line 3690: fnd_message.set_token('ERROR_TEXT',SQLERRM);

3686: -- Grab the error message and error no.
3687: x_error_code := SQLCODE;
3688: fnd_message.set_name('XNP','STD_ERROR');
3689: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO');
3690: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3691: x_error_message := fnd_message.get;
3692:
3693: END SOA_UPDATE_CUSTOMER_INFO;
3694:

Line 3691: x_error_message := fnd_message.get;

3687: x_error_code := SQLCODE;
3688: fnd_message.set_name('XNP','STD_ERROR');
3689: fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO');
3690: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3691: x_error_message := fnd_message.get;
3692:
3693: END SOA_UPDATE_CUSTOMER_INFO;
3694:
3695: ----------------------------------------------------------------------

Line 3767: fnd_message.set_name('XNP','STD_ERROR');

3763: WHEN OTHERS THEN
3764: -- Grab the error message and error no.
3765: x_error_code := SQLCODE;
3766:
3767: fnd_message.set_name('XNP','STD_ERROR');
3768: fnd_message.set_token('ERROR_LOCN' ,'XNP_STANDARD.RUNTIME_VALIDATION');
3769: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3770: x_error_message := fnd_message.get;
3771:

Line 3768: fnd_message.set_token('ERROR_LOCN' ,'XNP_STANDARD.RUNTIME_VALIDATION');

3764: -- Grab the error message and error no.
3765: x_error_code := SQLCODE;
3766:
3767: fnd_message.set_name('XNP','STD_ERROR');
3768: fnd_message.set_token('ERROR_LOCN' ,'XNP_STANDARD.RUNTIME_VALIDATION');
3769: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3770: x_error_message := fnd_message.get;
3771:
3772:

Line 3769: fnd_message.set_token('ERROR_TEXT',SQLERRM);

3765: x_error_code := SQLCODE;
3766:
3767: fnd_message.set_name('XNP','STD_ERROR');
3768: fnd_message.set_token('ERROR_LOCN' ,'XNP_STANDARD.RUNTIME_VALIDATION');
3769: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3770: x_error_message := fnd_message.get;
3771:
3772:
3773: END RUNTIME_VALIDATION;

Line 3770: x_error_message := fnd_message.get;

3766:
3767: fnd_message.set_name('XNP','STD_ERROR');
3768: fnd_message.set_token('ERROR_LOCN' ,'XNP_STANDARD.RUNTIME_VALIDATION');
3769: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3770: x_error_message := fnd_message.get;
3771:
3772:
3773: END RUNTIME_VALIDATION;
3774: