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

Line 68: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

64: *----------------------------------------------------------------------------*/
65: FUNCTION blueprint_sla_hook_wrap(p_wrap_txn_id NUMBER,
66: p_wrap_tb_source VARCHAR2)
67: RETURN integer IS
68: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
69: l_msg_count NUMBER := 0;
70: l_msg_data VARCHAR2(8000);
71: l_return_val NUMBER := 0;
72: BEGIN

Line 80: RAISE FND_API.g_exc_unexpected_error;

76: x_msg_count => l_msg_count,
77: x_msg_data => l_msg_data),0);
78:
79: IF (l_return_status <> 'S' OR l_return_val = -1) THEN
80: RAISE FND_API.g_exc_unexpected_error;
81: ELSIF (l_return_val = 0) THEN
82: return 0;
83: ELSIF (l_return_val = 1) THEN
84: RETURN 1;

Line 87: -- WHEN FND_API.g_exc_unexpected_error THEN

83: ELSIF (l_return_val = 1) THEN
84: RETURN 1;
85: END IF;
86: EXCEPTION
87: -- WHEN FND_API.g_exc_unexpected_error THEN
88: -- ROLLBACK TO Create_INVXLAEvent;
89: WHEN OTHERS THEN
90: --raise;
91: raise_application_error(-20200, 'Error in: CST_PRJMFG_ACCT_HOOK.blueprint_sla_hook');

Line 360: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

356: ) IS
357: l_api_name CONSTANT VARCHAR2(30) := 'Create_RCVXLAEvent';
358: l_api_version CONSTANT NUMBER := 1.0;
359:
360: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
361: l_msg_count NUMBER := 0;
362: l_msg_data VARCHAR2(8000);
363: l_stmt_num NUMBER := 0;
364: l_api_message VARCHAR2(1000);

Line 418: IF NOT FND_API.Compatible_API_Call (

414: ': Accounting Event: '||p_trx_info.ACCT_EVENT_ID );
415: END IF;
416:
417: -- Standard call to check for call compatibility
418: IF NOT FND_API.Compatible_API_Call (
419: l_api_version,
420: p_api_version,
421: l_api_name,
422: G_PKG_NAME ) THEN

Line 423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

419: l_api_version,
420: p_api_version,
421: l_api_name,
422: G_PKG_NAME ) THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: -- Initialize message list if p_init_msg_list is set to TRUE
427: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 427: IF FND_API.to_Boolean(p_init_msg_list) THEN

423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: -- Initialize message list if p_init_msg_list is set to TRUE
427: IF FND_API.to_Boolean(p_init_msg_list) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Initialize API return status to success

Line 432: x_return_status := FND_API.G_RET_STS_SUCCESS;

428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Initialize API return status to success
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433: /* Bug 6987381 : Receiving transactions should create accounting for
434: Blue Print Organization too
435: l_stmt_num := 5;
436: BEGIN

Line 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

529: IF l_unexpLog THEN
530: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Event creation failed for: Transaction ID: '||
531: to_char(p_trx_info.TRANSACTION_ID)||'Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
532: END IF;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END IF;
535:
536:
537:

Line 599: -- RAISE FND_API.G_EXC_ERROR;

595: -- ELSE
596: -- FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_WARNING');
597: -- FND_MSG_PUB.ADD;
598: -- END IF;
599: -- RAISE FND_API.G_EXC_ERROR;
600: -- ELSE
601: --}
602: -- RAISE FND_API.g_exc_unexpected_error;
603: -- END IF; /*End l_retcode = 2*/

Line 602: -- RAISE FND_API.g_exc_unexpected_error;

598: -- END IF;
599: -- RAISE FND_API.G_EXC_ERROR;
600: -- ELSE
601: --}
602: -- RAISE FND_API.g_exc_unexpected_error;
603: -- END IF; /*End l_retcode = 2*/
604:
605: -- END IF; /*End l_retcode <> 0*/
606:

Line 706: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

702: -- IF l_unexpLog THEN
703: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||
704: -- to_char(p_trx_info.TRANSACTION_ID)||'Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
705: -- END IF;
706: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: -- END IF;
708:
709:
710: -- l_stmt_num := 55;

Line 731: -- p_init_msg_list => FND_API.G_FALSE,

727:
728:
729: -- PSA_BC_XLA_PUB.Budgetary_Control (
730: -- p_api_version => 1.0,
731: -- p_init_msg_list => FND_API.G_FALSE,
732: -- x_return_status => l_return_status,
733: -- x_msg_count => x_msg_count,
734: -- x_msg_data => x_msg_data,
735: -- p_application_id => G_CST_APPLICATION_ID,

Line 744: -- l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

740: -- x_status_code => l_bc_status,
741: -- x_packet_id => l_packet_id );
742:
743: -- IF ( l_bc_status in ('XLA_ERROR', 'FATAL') OR
744: -- l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
745: -- l_api_message := 'Error in Encumbrance Accounting/Budgetory Control';
746: -- IF G_DEBUG = 'Y' THEN
747: -- IF l_unexpLog THEN
748: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);

Line 751: -- RAISE FND_API.g_exc_unexpected_error;

747: -- IF l_unexpLog THEN
748: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);
749: -- END IF;
750: -- END IF;
751: -- RAISE FND_API.g_exc_unexpected_error;
752: -- END IF;
753:
754: -- IF ( l_bc_status = 'XLA_NO_JOURNAL') THEN
755: -- l_api_message := 'Journal Lines could not be created for the Encumbrance Event. Please inform your Administrator';

Line 779: WHEN FND_API.g_exc_error THEN

775: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
776: END IF;
777:
778: EXCEPTION
779: WHEN FND_API.g_exc_error THEN
780: ROLLBACK TO Create_RCVXLAEvent;
781: x_return_status := FND_API.g_ret_sts_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

Line 781: x_return_status := FND_API.g_ret_sts_error;

777:
778: EXCEPTION
779: WHEN FND_API.g_exc_error THEN
780: ROLLBACK TO Create_RCVXLAEvent;
781: x_return_status := FND_API.g_ret_sts_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
784: ( G_PKG_NAME,
785: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||l_api_message

Line 792: WHEN FND_API.g_exc_unexpected_error THEN

788: FND_MSG_PUB.count_and_get
789: ( p_count => x_msg_count,
790: p_data => x_msg_data
791: );
792: WHEN FND_API.g_exc_unexpected_error THEN
793: ROLLBACK TO Create_RCVXLAEvent;
794: x_msg_data := l_api_message || ': SQL Error: '||SQLERRM;
795: x_return_status := FND_API.g_ret_sts_unexp_error ;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 795: x_return_status := FND_API.g_ret_sts_unexp_error ;

791: );
792: WHEN FND_API.g_exc_unexpected_error THEN
793: ROLLBACK TO Create_RCVXLAEvent;
794: x_msg_data := l_api_message || ': SQL Error: '||SQLERRM;
795: x_return_status := FND_API.g_ret_sts_unexp_error ;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
797: FND_MSG_PUB.add_exc_msg
798: ( G_PKG_NAME,
799: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data

Line 808: x_return_status := fnd_api.g_ret_sts_unexp_error ;

804: p_data => x_msg_data
805: );
806: WHEN OTHERS THEN
807: ROLLBACK TO Create_RCVXLAEvent;
808: x_return_status := fnd_api.g_ret_sts_unexp_error ;
809: x_msg_data := SQLERRM;
810:
811: IF l_unexpLog THEN
812: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num

Line 866: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

862: ) IS
863: l_api_name CONSTANT VARCHAR2(30) := 'Create_INVXLAEvent';
864: l_api_version CONSTANT NUMBER := 1.0;
865:
866: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
867: l_msg_count NUMBER := 0;
868: l_msg_data VARCHAR2(8000);
869: l_stmt_num NUMBER := 0;
870: l_api_message VARCHAR2(1000);

Line 924: IF NOT FND_API.Compatible_API_Call (

920: msg_module => 'Create_INVXLAEvent',
921: msg_level => FND_LOG.LEVEL_STATEMENT);
922:
923: -- Standard call to check for call compatibility
924: IF NOT FND_API.Compatible_API_Call (
925: l_api_version,
926: p_api_version,
927: l_api_name,
928: G_PKG_NAME ) THEN

Line 929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

925: l_api_version,
926: p_api_version,
927: l_api_name,
928: G_PKG_NAME ) THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:
932: l_stmt_num := 10;
933: -- Initialize message list if p_init_msg_list is set to TRUE

Line 934: IF FND_API.to_Boolean(p_init_msg_list) THEN

930: END IF;
931:
932: l_stmt_num := 10;
933: -- Initialize message list if p_init_msg_list is set to TRUE
934: IF FND_API.to_Boolean(p_init_msg_list) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: -- Initialize API return status to success

Line 939: x_return_status := FND_API.G_RET_STS_SUCCESS;

935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: -- Initialize API return status to success
939: x_return_status := FND_API.G_RET_STS_SUCCESS;
940:
941: /* Check if any entries exist for this transaction in MTA.
942: No Events would be raised for transactions without any MTA entries
943: This might change later when SLA supports processing an event without

Line 1017: RAISE FND_API.g_exc_unexpected_error;

1013: x_msg_data => l_msg_data),0);
1014: IF (l_return_status <> 'S' OR l_post_option = -1) THEN
1015: x_msg_count := l_msg_count;
1016: x_msg_data := l_msg_data;
1017: RAISE FND_API.g_exc_unexpected_error;
1018: ELSIF (l_post_option = 1) THEN
1019: IF l_stmtLog THEN
1020: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1021: 'Hook was used, events will be created for Inventory Transaction: '||

Line 1384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1380: '||p_trx_info.TXN_SRC_TYPE_ID||' : Event Type:
1381: '||l_events(l_index).event_type_code||' :Event ID: '||l_event_id);
1382: END IF;
1383: IF l_event_id is NULL THEN
1384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1385: END IF;
1386:
1387: --
1388: --User Defined transaction type with Encumbrance Accounting

Line 1460: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1456: -- IF l_unexpLog THEN
1457: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||
1458: -- to_char(p_trx_info.TRANSACTION_ID));
1459: -- END IF;
1460: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: -- END IF;
1462:
1463: -- l_stmt_num := 140;
1464: -- INSERT INTO PSA_BC_XLA_EVENTS_GT (

Line 1495: -- p_init_msg_list => FND_API.G_FALSE,

1491:
1492: -- l_stmt_num := 150;
1493: -- PSA_BC_XLA_PUB.Budgetary_Control (
1494: -- p_api_version => 1.0,
1495: -- p_init_msg_list => FND_API.G_FALSE,
1496: -- x_return_status => l_return_status,
1497: -- x_msg_count => x_msg_count,
1498: -- x_msg_data => x_msg_data,
1499: -- p_application_id => G_CST_APPLICATION_ID,

Line 1508: -- l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1504: -- x_status_code => l_bc_status,
1505: -- x_packet_id => l_packet_id );
1506:
1507: -- IF ( l_bc_status in ('XLA_ERROR', 'FATAL') OR
1508: -- l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1509: -- l_api_message := 'Error in Encumbrance Accounting/Budgetory Control';
1510: -- IF G_DEBUG = 'Y' THEN
1511: -- IF l_unexpLog THEN
1512: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);

Line 1515: -- RAISE FND_API.g_exc_unexpected_error;

1511: -- IF l_unexpLog THEN
1512: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);
1513: -- END IF;
1514: -- END IF;
1515: -- RAISE FND_API.g_exc_unexpected_error;
1516: -- END IF;
1517:
1518: -- END IF; /* ENCUMBRANCE_FLAG = 'Y' */
1519:

Line 1526: WHEN FND_API.g_exc_error THEN

1522: IF l_procLog THEN
1523: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');
1524: END IF;
1525: EXCEPTION
1526: WHEN FND_API.g_exc_error THEN
1527: ROLLBACK TO Create_INVXLAEvent;
1528: x_return_status := FND_API.g_ret_sts_error;
1529: FND_MSG_PUB.count_and_get
1530: ( p_count => x_msg_count,

Line 1528: x_return_status := FND_API.g_ret_sts_error;

1524: END IF;
1525: EXCEPTION
1526: WHEN FND_API.g_exc_error THEN
1527: ROLLBACK TO Create_INVXLAEvent;
1528: x_return_status := FND_API.g_ret_sts_error;
1529: FND_MSG_PUB.count_and_get
1530: ( p_count => x_msg_count,
1531: p_data => x_msg_data
1532: );

Line 1533: WHEN FND_API.g_exc_unexpected_error THEN

1529: FND_MSG_PUB.count_and_get
1530: ( p_count => x_msg_count,
1531: p_data => x_msg_data
1532: );
1533: WHEN FND_API.g_exc_unexpected_error THEN
1534: ROLLBACK TO Create_INVXLAEvent;
1535: x_return_status := FND_API.g_ret_sts_unexp_error ;
1536: FND_MSG_PUB.count_and_get
1537: ( p_count => x_msg_count,

Line 1535: x_return_status := FND_API.g_ret_sts_unexp_error ;

1531: p_data => x_msg_data
1532: );
1533: WHEN FND_API.g_exc_unexpected_error THEN
1534: ROLLBACK TO Create_INVXLAEvent;
1535: x_return_status := FND_API.g_ret_sts_unexp_error ;
1536: FND_MSG_PUB.count_and_get
1537: ( p_count => x_msg_count,
1538: p_data => x_msg_data
1539: );

Line 1542: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1538: p_data => x_msg_data
1539: );
1540: WHEN OTHERS THEN
1541: ROLLBACK TO Create_INVXLAEvent;
1542: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1543: IF l_unexpLog THEN
1544: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1545: END IF;
1546:

Line 1596: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1592: ) IS
1593: l_api_name CONSTANT VARCHAR2(30) := 'Create_WIPXLAEvent';
1594: l_api_version CONSTANT NUMBER := 1.0;
1595:
1596: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1597: l_msg_count NUMBER := 0;
1598: l_msg_data VARCHAR2(8000);
1599: l_stmt_num NUMBER := 0;
1600: l_api_message VARCHAR2(1000);

Line 1641: IF NOT FND_API.Compatible_API_Call (

1637: ': Organization ID: '||p_trx_info.INV_ORGANIZATION_ID);
1638: END IF;
1639:
1640: -- Standard call to check for call compatibility
1641: IF NOT FND_API.Compatible_API_Call (
1642: l_api_version,
1643: p_api_version,
1644: l_api_name,
1645: G_PKG_NAME ) THEN

Line 1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1642: l_api_version,
1643: p_api_version,
1644: l_api_name,
1645: G_PKG_NAME ) THEN
1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1647: END IF;
1648:
1649: -- Initialize message list if p_init_msg_list is set to TRUE
1650: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1650: IF FND_API.to_Boolean(p_init_msg_list) THEN

1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1647: END IF;
1648:
1649: -- Initialize message list if p_init_msg_list is set to TRUE
1650: IF FND_API.to_Boolean(p_init_msg_list) THEN
1651: FND_MSG_PUB.initialize;
1652: END IF;
1653:
1654: -- Initialize API return status to success

Line 1655: x_return_status := FND_API.G_RET_STS_SUCCESS;

1651: FND_MSG_PUB.initialize;
1652: END IF;
1653:
1654: -- Initialize API return status to success
1655: x_return_status := FND_API.G_RET_STS_SUCCESS;
1656:
1657: l_stmt_num := 5;
1658: BEGIN
1659: SELECT NVL(PA_POSTING_FLAG, 'N')

Line 1689: RAISE FND_API.g_exc_unexpected_error;

1685: x_msg_data => l_msg_data) ,0);
1686: IF (l_return_status <> 'S' OR l_post_option = -1) THEN
1687: x_msg_count := l_msg_count;
1688: x_msg_data := l_msg_data;
1689: RAISE FND_API.g_exc_unexpected_error;
1690: ELSIF (l_post_option = 1) THEN
1691: IF l_stmtLog THEN
1692: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1693: 'Hook was used, events will be created for WCTI Transaction: '||

Line 1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1782: IF l_event_id is NULL THEN
1783: IF l_unexpLog THEN
1784: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Event creation failed for: Transaction ID: '||to_char(p_trx_info.TRANSACTION_ID)||': Organization ID: '||to_char(p_trx_info.INV_ORGANIZATION_ID));
1785: END IF;
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788: IF l_procLog THEN
1789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');
1790: END IF;

Line 1793: WHEN FND_API.g_exc_error THEN

1789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');
1790: END IF;
1791:
1792: EXCEPTION
1793: WHEN FND_API.g_exc_error THEN
1794: ROLLBACK TO Create_WIPXLAEvent;
1795: x_return_status := FND_API.g_ret_sts_error;
1796: FND_MSG_PUB.count_and_get
1797: ( p_count => x_msg_count,

Line 1795: x_return_status := FND_API.g_ret_sts_error;

1791:
1792: EXCEPTION
1793: WHEN FND_API.g_exc_error THEN
1794: ROLLBACK TO Create_WIPXLAEvent;
1795: x_return_status := FND_API.g_ret_sts_error;
1796: FND_MSG_PUB.count_and_get
1797: ( p_count => x_msg_count,
1798: p_data => x_msg_data
1799: );

Line 1800: WHEN FND_API.g_exc_unexpected_error THEN

1796: FND_MSG_PUB.count_and_get
1797: ( p_count => x_msg_count,
1798: p_data => x_msg_data
1799: );
1800: WHEN FND_API.g_exc_unexpected_error THEN
1801: ROLLBACK TO Create_WIPXLAEvent;
1802: x_return_status := FND_API.g_ret_sts_unexp_error ;
1803: FND_MSG_PUB.count_and_get
1804: ( p_count => x_msg_count,

Line 1802: x_return_status := FND_API.g_ret_sts_unexp_error ;

1798: p_data => x_msg_data
1799: );
1800: WHEN FND_API.g_exc_unexpected_error THEN
1801: ROLLBACK TO Create_WIPXLAEvent;
1802: x_return_status := FND_API.g_ret_sts_unexp_error ;
1803: FND_MSG_PUB.count_and_get
1804: ( p_count => x_msg_count,
1805: p_data => x_msg_data
1806: );

Line 1809: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1805: p_data => x_msg_data
1806: );
1807: WHEN OTHERS THEN
1808: ROLLBACK TO Create_WIPXLAEvent;
1809: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1810: IF l_unexpLog THEN
1811: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
1812: ,'Create_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1813: END IF;

Line 1869: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1865:
1866: l_api_name CONSTANT VARCHAR2(30) := 'CreateBulk_WIPXLAEvent';
1867: l_api_version CONSTANT NUMBER := 1.0;
1868:
1869: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1870: l_msg_count NUMBER := 0;
1871: l_msg_data VARCHAR2(8000);
1872: l_stmt_num NUMBER := 0;
1873: l_api_message VARCHAR2(1000);

Line 1900: IF NOT FND_API.Compatible_API_Call (

1896: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' CreateBulk_WIPXLAEvent <<');
1897: END IF;
1898:
1899: -- Standard call to check for call compatibility
1900: IF NOT FND_API.Compatible_API_Call (
1901: l_api_version,
1902: p_api_version,
1903: l_api_name,
1904: G_PKG_NAME ) THEN

Line 1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1901: l_api_version,
1902: p_api_version,
1903: l_api_name,
1904: G_PKG_NAME ) THEN
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: END IF;
1907:
1908: -- Initialize message list if p_init_msg_list is set to TRUE
1909: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1909: IF FND_API.to_Boolean(p_init_msg_list) THEN

1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: END IF;
1907:
1908: -- Initialize message list if p_init_msg_list is set to TRUE
1909: IF FND_API.to_Boolean(p_init_msg_list) THEN
1910: FND_MSG_PUB.initialize;
1911: END IF;
1912:
1913: -- Initialize API return status to success

Line 1914: x_return_status := FND_API.G_RET_STS_SUCCESS;

1910: FND_MSG_PUB.initialize;
1911: END IF;
1912:
1913: -- Initialize API return status to success
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: l_stmt_num := 5;
1917: BEGIN
1918: SELECT NVL(PA_POSTING_FLAG, 'N')

Line 2059: WHEN FND_API.g_exc_error THEN

2055: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end','CreateBulk_WIPXLAEvent >>');
2056: END IF;
2057:
2058: EXCEPTION
2059: WHEN FND_API.g_exc_error THEN
2060: ROLLBACK TO CreateBulk_WIPXLAEvent;
2061: x_return_status := FND_API.g_ret_sts_error;
2062: FND_MSG_PUB.count_and_get
2063: ( p_count => x_msg_count,

Line 2061: x_return_status := FND_API.g_ret_sts_error;

2057:
2058: EXCEPTION
2059: WHEN FND_API.g_exc_error THEN
2060: ROLLBACK TO CreateBulk_WIPXLAEvent;
2061: x_return_status := FND_API.g_ret_sts_error;
2062: FND_MSG_PUB.count_and_get
2063: ( p_count => x_msg_count,
2064: p_data => x_msg_data
2065: );

Line 2066: WHEN FND_API.g_exc_unexpected_error THEN

2062: FND_MSG_PUB.count_and_get
2063: ( p_count => x_msg_count,
2064: p_data => x_msg_data
2065: );
2066: WHEN FND_API.g_exc_unexpected_error THEN
2067: ROLLBACK TO CreateBulk_WIPXLAEvent;
2068: x_return_status := FND_API.g_ret_sts_unexp_error ;
2069: FND_MSG_PUB.count_and_get
2070: ( p_count => x_msg_count,

Line 2068: x_return_status := FND_API.g_ret_sts_unexp_error ;

2064: p_data => x_msg_data
2065: );
2066: WHEN FND_API.g_exc_unexpected_error THEN
2067: ROLLBACK TO CreateBulk_WIPXLAEvent;
2068: x_return_status := FND_API.g_ret_sts_unexp_error ;
2069: FND_MSG_PUB.count_and_get
2070: ( p_count => x_msg_count,
2071: p_data => x_msg_data
2072: );

Line 2075: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2071: p_data => x_msg_data
2072: );
2073: WHEN OTHERS THEN
2074: ROLLBACK TO CreateBulk_WIPXLAEvent;
2075: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2076: IF l_unexpLog THEN
2077: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2078: END IF;
2079:

Line 2134: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2130:
2131: l_api_name CONSTANT VARCHAR2(30) := 'Create_CostUpdateXLAEvent';
2132: l_api_version CONSTANT NUMBER := 1.0;
2133:
2134: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2135: l_msg_count NUMBER := 0;
2136: l_msg_data VARCHAR2(8000);
2137: l_stmt_num NUMBER := 0;
2138: l_api_message VARCHAR2(1000);

Line 2164: IF NOT FND_API.Compatible_API_Call (

2160: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_CostUpdateXLAEvent <<');
2161: END IF;
2162:
2163: -- Standard call to check for call compatibility
2164: IF NOT FND_API.Compatible_API_Call (
2165: l_api_version,
2166: p_api_version,
2167: l_api_name,
2168: G_PKG_NAME ) THEN

Line 2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2165: l_api_version,
2166: p_api_version,
2167: l_api_name,
2168: G_PKG_NAME ) THEN
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: END IF;
2171:
2172: -- Initialize message list if p_init_msg_list is set to TRUE
2173: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2173: IF FND_API.to_Boolean(p_init_msg_list) THEN

2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: END IF;
2171:
2172: -- Initialize message list if p_init_msg_list is set to TRUE
2173: IF FND_API.to_Boolean(p_init_msg_list) THEN
2174: FND_MSG_PUB.initialize;
2175: END IF;
2176:
2177: -- Initialize API return status to success

Line 2178: x_return_status := FND_API.G_RET_STS_SUCCESS;

2174: FND_MSG_PUB.initialize;
2175: END IF;
2176:
2177: -- Initialize API return status to success
2178: x_return_status := FND_API.G_RET_STS_SUCCESS;
2179:
2180: l_stmt_num := 5;
2181: BEGIN
2182: SELECT NVL(PA_POSTING_FLAG, 'N')

Line 2291: WHEN FND_API.g_exc_error THEN

2287: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_CostUpdateXLAEvent >>');
2288: END IF;
2289:
2290: EXCEPTION
2291: WHEN FND_API.g_exc_error THEN
2292: ROLLBACK TO Create_CostUpdateXLAEvent;
2293: x_return_status := FND_API.g_ret_sts_error;
2294: FND_MSG_PUB.count_and_get
2295: ( p_count => x_msg_count,

Line 2293: x_return_status := FND_API.g_ret_sts_error;

2289:
2290: EXCEPTION
2291: WHEN FND_API.g_exc_error THEN
2292: ROLLBACK TO Create_CostUpdateXLAEvent;
2293: x_return_status := FND_API.g_ret_sts_error;
2294: FND_MSG_PUB.count_and_get
2295: ( p_count => x_msg_count,
2296: p_data => x_msg_data
2297: );

Line 2298: WHEN FND_API.g_exc_unexpected_error THEN

2294: FND_MSG_PUB.count_and_get
2295: ( p_count => x_msg_count,
2296: p_data => x_msg_data
2297: );
2298: WHEN FND_API.g_exc_unexpected_error THEN
2299: ROLLBACK TO Create_CostUpdateXLAEvent;
2300: x_return_status := FND_API.g_ret_sts_unexp_error ;
2301: FND_MSG_PUB.count_and_get
2302: ( p_count => x_msg_count,

Line 2300: x_return_status := FND_API.g_ret_sts_unexp_error ;

2296: p_data => x_msg_data
2297: );
2298: WHEN FND_API.g_exc_unexpected_error THEN
2299: ROLLBACK TO Create_CostUpdateXLAEvent;
2300: x_return_status := FND_API.g_ret_sts_unexp_error ;
2301: FND_MSG_PUB.count_and_get
2302: ( p_count => x_msg_count,
2303: p_data => x_msg_data
2304: );

Line 2307: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2303: p_data => x_msg_data
2304: );
2305: WHEN OTHERS THEN
2306: ROLLBACK TO Create_CostUpdateXLAEvent;
2307: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2308: IF l_unexpLog THEN
2309: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2310: END IF;
2311:

Line 2364: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2360:
2361: l_api_name CONSTANT VARCHAR2(30) := 'Create_WIPUpdateXLAEvent';
2362: l_api_version CONSTANT NUMBER := 1.0;
2363:
2364: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2365: l_msg_count NUMBER := 0;
2366: l_msg_data VARCHAR2(8000);
2367: l_stmt_num NUMBER := 0;
2368: l_api_message VARCHAR2(1000);

Line 2395: IF NOT FND_API.Compatible_API_Call (

2391: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_WIPUpdateXLAEvent <<');
2392: END IF;
2393:
2394: -- Standard call to check for call compatibility
2395: IF NOT FND_API.Compatible_API_Call (
2396: l_api_version,
2397: p_api_version,
2398: l_api_name,
2399: G_PKG_NAME ) THEN

Line 2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2396: l_api_version,
2397: p_api_version,
2398: l_api_name,
2399: G_PKG_NAME ) THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END IF;
2402:
2403: -- Initialize message list if p_init_msg_list is set to TRUE
2404: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2404: IF FND_API.to_Boolean(p_init_msg_list) THEN

2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END IF;
2402:
2403: -- Initialize message list if p_init_msg_list is set to TRUE
2404: IF FND_API.to_Boolean(p_init_msg_list) THEN
2405: FND_MSG_PUB.initialize;
2406: END IF;
2407:
2408: -- Initialize API return status to success

Line 2409: x_return_status := FND_API.G_RET_STS_SUCCESS;

2405: FND_MSG_PUB.initialize;
2406: END IF;
2407:
2408: -- Initialize API return status to success
2409: x_return_status := FND_API.G_RET_STS_SUCCESS;
2410:
2411: l_stmt_num := 5;
2412: BEGIN
2413: SELECT NVL(PA_POSTING_FLAG, 'N')

Line 2507: WHEN FND_API.g_exc_error THEN

2503: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPUpdateXLAEvent >>');
2504: END IF;
2505:
2506: EXCEPTION
2507: WHEN FND_API.g_exc_error THEN
2508: ROLLBACK TO Create_WIPUpdateXLAEvent;
2509: x_return_status := FND_API.g_ret_sts_error;
2510: FND_MSG_PUB.count_and_get
2511: ( p_count => x_msg_count,

Line 2509: x_return_status := FND_API.g_ret_sts_error;

2505:
2506: EXCEPTION
2507: WHEN FND_API.g_exc_error THEN
2508: ROLLBACK TO Create_WIPUpdateXLAEvent;
2509: x_return_status := FND_API.g_ret_sts_error;
2510: FND_MSG_PUB.count_and_get
2511: ( p_count => x_msg_count,
2512: p_data => x_msg_data
2513: );

Line 2514: WHEN FND_API.g_exc_unexpected_error THEN

2510: FND_MSG_PUB.count_and_get
2511: ( p_count => x_msg_count,
2512: p_data => x_msg_data
2513: );
2514: WHEN FND_API.g_exc_unexpected_error THEN
2515: ROLLBACK TO Create_WIPUpdateXLAEvent;
2516: x_return_status := FND_API.g_ret_sts_unexp_error ;
2517: FND_MSG_PUB.count_and_get
2518: ( p_count => x_msg_count,

Line 2516: x_return_status := FND_API.g_ret_sts_unexp_error ;

2512: p_data => x_msg_data
2513: );
2514: WHEN FND_API.g_exc_unexpected_error THEN
2515: ROLLBACK TO Create_WIPUpdateXLAEvent;
2516: x_return_status := FND_API.g_ret_sts_unexp_error ;
2517: FND_MSG_PUB.count_and_get
2518: ( p_count => x_msg_count,
2519: p_data => x_msg_data
2520: );

Line 2523: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2519: p_data => x_msg_data
2520: );
2521: WHEN OTHERS THEN
2522: ROLLBACK TO Create_WIPUpdateXLAEvent;
2523: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2524: IF l_unexpLog THEN
2525: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
2526: ,'Create_WIPUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2527: END IF;