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 269: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

265: ) IS
266: l_api_name CONSTANT VARCHAR2(30) := 'Create_RCVXLAEvent';
267: l_api_version CONSTANT NUMBER := 1.0;
268:
269: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
270: l_msg_count NUMBER := 0;
271: l_msg_data VARCHAR2(8000);
272: l_stmt_num NUMBER := 0;
273: l_api_message VARCHAR2(1000);

Line 327: IF NOT FND_API.Compatible_API_Call (

323: ': Accounting Event: '||p_trx_info.ACCT_EVENT_ID );
324: END IF;
325:
326: -- Standard call to check for call compatibility
327: IF NOT FND_API.Compatible_API_Call (
328: l_api_version,
329: p_api_version,
330: l_api_name,
331: G_PKG_NAME ) THEN

Line 332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

328: l_api_version,
329: p_api_version,
330: l_api_name,
331: G_PKG_NAME ) THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END IF;
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE
336: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 336: IF FND_API.to_Boolean(p_init_msg_list) THEN

332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END IF;
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE
336: IF FND_API.to_Boolean(p_init_msg_list) THEN
337: FND_MSG_PUB.initialize;
338: END IF;
339:
340: -- Initialize API return status to success

Line 341: x_return_status := FND_API.G_RET_STS_SUCCESS;

337: FND_MSG_PUB.initialize;
338: END IF;
339:
340: -- Initialize API return status to success
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342: /* Bug 6987381 : Receiving transactions should create accounting for
343: Blue Print Organization too
344: l_stmt_num := 5;
345: BEGIN

Line 440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

436: IF l_unexpLog THEN
437: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Event creation failed for: Transaction ID: '||
438: to_char(p_trx_info.TRANSACTION_ID)||'Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
439: END IF;
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:
443:
444:

Line 487: RAISE FND_API.G_EXC_ERROR;

483: ELSE
484: FND_MESSAGE.set_name('XLA', 'XLA_ONLINE_ACCT_WARNING');
485: FND_MSG_PUB.ADD;
486: END IF;
487: RAISE FND_API.G_EXC_ERROR;
488: ELSE
489: --}
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;

Line 490: RAISE FND_API.g_exc_unexpected_error;

486: END IF;
487: RAISE FND_API.G_EXC_ERROR;
488: ELSE
489: --}
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:
493: END IF;
494:

Line 583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

579: IF l_unexpLog THEN
580: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||
581: to_char(p_trx_info.TRANSACTION_ID)||'Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
582: END IF;
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;
585:
586:
587: l_stmt_num := 55;

Line 608: p_init_msg_list => FND_API.G_FALSE,

604:
605:
606: PSA_BC_XLA_PUB.Budgetary_Control (
607: p_api_version => 1.0,
608: p_init_msg_list => FND_API.G_FALSE,
609: x_return_status => l_return_status,
610: x_msg_count => x_msg_count,
611: x_msg_data => x_msg_data,
612: p_application_id => G_CST_APPLICATION_ID,

Line 621: l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

617: x_status_code => l_bc_status,
618: x_packet_id => l_packet_id );
619:
620: IF ( l_bc_status in ('XLA_ERROR', 'FATAL') OR
621: l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
622: l_api_message := 'Error in Encumbrance Accounting/Budgetory Control';
623: IF G_DEBUG = 'Y' THEN
624: IF l_unexpLog THEN
625: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);

Line 628: RAISE FND_API.g_exc_unexpected_error;

624: IF l_unexpLog THEN
625: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);
626: END IF;
627: END IF;
628: RAISE FND_API.g_exc_unexpected_error;
629: END IF;
630:
631: IF ( l_bc_status = 'XLA_NO_JOURNAL') THEN
632: l_api_message := 'Journal Lines could not be created for the Encumbrance Event. Please inform your Administrator';

Line 649: WHEN FND_API.g_exc_error THEN

645: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
646: END IF;
647:
648: EXCEPTION
649: WHEN FND_API.g_exc_error THEN
650: ROLLBACK TO Create_RCVXLAEvent;
651: x_return_status := FND_API.g_ret_sts_error;
652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
653: FND_MSG_PUB.add_exc_msg

Line 651: x_return_status := FND_API.g_ret_sts_error;

647:
648: EXCEPTION
649: WHEN FND_API.g_exc_error THEN
650: ROLLBACK TO Create_RCVXLAEvent;
651: x_return_status := FND_API.g_ret_sts_error;
652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
653: FND_MSG_PUB.add_exc_msg
654: ( G_PKG_NAME,
655: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||l_api_message

Line 662: WHEN FND_API.g_exc_unexpected_error THEN

658: FND_MSG_PUB.count_and_get
659: ( p_count => x_msg_count,
660: p_data => x_msg_data
661: );
662: WHEN FND_API.g_exc_unexpected_error THEN
663: ROLLBACK TO Create_RCVXLAEvent;
664: x_msg_data := l_api_message || ': SQL Error: '||SQLERRM;
665: x_return_status := FND_API.g_ret_sts_unexp_error ;
666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 665: x_return_status := FND_API.g_ret_sts_unexp_error ;

661: );
662: WHEN FND_API.g_exc_unexpected_error THEN
663: ROLLBACK TO Create_RCVXLAEvent;
664: x_msg_data := l_api_message || ': SQL Error: '||SQLERRM;
665: x_return_status := FND_API.g_ret_sts_unexp_error ;
666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
667: FND_MSG_PUB.add_exc_msg
668: ( G_PKG_NAME,
669: l_api_name || 'Statement -'||to_char(l_stmt_num)||': '||x_msg_data

Line 678: x_return_status := fnd_api.g_ret_sts_unexp_error ;

674: p_data => x_msg_data
675: );
676: WHEN OTHERS THEN
677: ROLLBACK TO Create_RCVXLAEvent;
678: x_return_status := fnd_api.g_ret_sts_unexp_error ;
679: x_msg_data := SQLERRM;
680:
681: IF l_unexpLog THEN
682: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num

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

732: ) IS
733: l_api_name CONSTANT VARCHAR2(30) := 'Create_INVXLAEvent';
734: l_api_version CONSTANT NUMBER := 1.0;
735:
736: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
737: l_msg_count NUMBER := 0;
738: l_msg_data VARCHAR2(8000);
739: l_stmt_num NUMBER := 0;
740: l_api_message VARCHAR2(1000);

Line 792: IF NOT FND_API.Compatible_API_Call (

788: msg_module => 'Create_INVXLAEvent',
789: msg_level => FND_LOG.LEVEL_STATEMENT);
790:
791: -- Standard call to check for call compatibility
792: IF NOT FND_API.Compatible_API_Call (
793: l_api_version,
794: p_api_version,
795: l_api_name,
796: G_PKG_NAME ) THEN

Line 797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

793: l_api_version,
794: p_api_version,
795: l_api_name,
796: G_PKG_NAME ) THEN
797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
798: END IF;
799:
800: l_stmt_num := 10;
801: -- Initialize message list if p_init_msg_list is set to TRUE

Line 802: IF FND_API.to_Boolean(p_init_msg_list) THEN

798: END IF;
799:
800: l_stmt_num := 10;
801: -- Initialize message list if p_init_msg_list is set to TRUE
802: IF FND_API.to_Boolean(p_init_msg_list) THEN
803: FND_MSG_PUB.initialize;
804: END IF;
805:
806: -- Initialize API return status to success

Line 807: x_return_status := FND_API.G_RET_STS_SUCCESS;

803: FND_MSG_PUB.initialize;
804: END IF;
805:
806: -- Initialize API return status to success
807: x_return_status := FND_API.G_RET_STS_SUCCESS;
808:
809: /* Check if any entries exist for this transaction in MTA.
810: No Events would be raised for transactions without any MTA entries
811: This might change later when SLA supports processing an event without

Line 1210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1206: '||p_trx_info.TXN_SRC_TYPE_ID||' : Event Type:
1207: '||l_events(l_index).event_type_code||' :Event ID: '||l_event_id);
1208: END IF;
1209: IF l_event_id is NULL THEN
1210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1211: END IF;
1212:
1213: --
1214: --User Defined transaction type with Encumbrance Accounting

Line 1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1276: IF l_unexpLog THEN
1277: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||
1278: to_char(p_trx_info.TRANSACTION_ID));
1279: END IF;
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282:
1283: l_stmt_num := 140;
1284: INSERT INTO PSA_BC_XLA_EVENTS_GT (

Line 1309: p_init_msg_list => FND_API.G_FALSE,

1305:
1306: l_stmt_num := 150;
1307: PSA_BC_XLA_PUB.Budgetary_Control (
1308: p_api_version => 1.0,
1309: p_init_msg_list => FND_API.G_FALSE,
1310: x_return_status => l_return_status,
1311: x_msg_count => x_msg_count,
1312: x_msg_data => x_msg_data,
1313: p_application_id => G_CST_APPLICATION_ID,

Line 1322: l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1318: x_status_code => l_bc_status,
1319: x_packet_id => l_packet_id );
1320:
1321: IF ( l_bc_status in ('XLA_ERROR', 'FATAL') OR
1322: l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1323: l_api_message := 'Error in Encumbrance Accounting/Budgetory Control';
1324: IF G_DEBUG = 'Y' THEN
1325: IF l_unexpLog THEN
1326: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);

Line 1329: RAISE FND_API.g_exc_unexpected_error;

1325: IF l_unexpLog THEN
1326: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);
1327: END IF;
1328: END IF;
1329: RAISE FND_API.g_exc_unexpected_error;
1330: END IF;
1331:
1332: END IF; /* ENCUMBRANCE_FLAG = 'Y' */
1333:

Line 1338: WHEN FND_API.g_exc_error THEN

1334: IF l_procLog THEN
1335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');
1336: END IF;
1337: EXCEPTION
1338: WHEN FND_API.g_exc_error THEN
1339: ROLLBACK TO Create_INVXLAEvent;
1340: x_return_status := FND_API.g_ret_sts_error;
1341: FND_MSG_PUB.count_and_get
1342: ( p_count => x_msg_count,

Line 1340: x_return_status := FND_API.g_ret_sts_error;

1336: END IF;
1337: EXCEPTION
1338: WHEN FND_API.g_exc_error THEN
1339: ROLLBACK TO Create_INVXLAEvent;
1340: x_return_status := FND_API.g_ret_sts_error;
1341: FND_MSG_PUB.count_and_get
1342: ( p_count => x_msg_count,
1343: p_data => x_msg_data
1344: );

Line 1345: WHEN FND_API.g_exc_unexpected_error THEN

1341: FND_MSG_PUB.count_and_get
1342: ( p_count => x_msg_count,
1343: p_data => x_msg_data
1344: );
1345: WHEN FND_API.g_exc_unexpected_error THEN
1346: ROLLBACK TO Create_INVXLAEvent;
1347: x_return_status := FND_API.g_ret_sts_unexp_error ;
1348: FND_MSG_PUB.count_and_get
1349: ( p_count => x_msg_count,

Line 1347: x_return_status := FND_API.g_ret_sts_unexp_error ;

1343: p_data => x_msg_data
1344: );
1345: WHEN FND_API.g_exc_unexpected_error THEN
1346: ROLLBACK TO Create_INVXLAEvent;
1347: x_return_status := FND_API.g_ret_sts_unexp_error ;
1348: FND_MSG_PUB.count_and_get
1349: ( p_count => x_msg_count,
1350: p_data => x_msg_data
1351: );

Line 1354: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1350: p_data => x_msg_data
1351: );
1352: WHEN OTHERS THEN
1353: ROLLBACK TO Create_INVXLAEvent;
1354: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1355: IF l_unexpLog THEN
1356: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1357: END IF;
1358:

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

1404: ) IS
1405: l_api_name CONSTANT VARCHAR2(30) := 'Create_WIPXLAEvent';
1406: l_api_version CONSTANT NUMBER := 1.0;
1407:
1408: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1409: l_msg_count NUMBER := 0;
1410: l_msg_data VARCHAR2(8000);
1411: l_stmt_num NUMBER := 0;
1412: l_api_message VARCHAR2(1000);

Line 1450: IF NOT FND_API.Compatible_API_Call (

1446: ': Organization ID: '||p_trx_info.INV_ORGANIZATION_ID);
1447: END IF;
1448:
1449: -- Standard call to check for call compatibility
1450: IF NOT FND_API.Compatible_API_Call (
1451: l_api_version,
1452: p_api_version,
1453: l_api_name,
1454: G_PKG_NAME ) THEN

Line 1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1451: l_api_version,
1452: p_api_version,
1453: l_api_name,
1454: G_PKG_NAME ) THEN
1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1456: END IF;
1457:
1458: -- Initialize message list if p_init_msg_list is set to TRUE
1459: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1459: IF FND_API.to_Boolean(p_init_msg_list) THEN

1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1456: END IF;
1457:
1458: -- Initialize message list if p_init_msg_list is set to TRUE
1459: IF FND_API.to_Boolean(p_init_msg_list) THEN
1460: FND_MSG_PUB.initialize;
1461: END IF;
1462:
1463: -- Initialize API return status to success

Line 1464: x_return_status := FND_API.G_RET_STS_SUCCESS;

1460: FND_MSG_PUB.initialize;
1461: END IF;
1462:
1463: -- Initialize API return status to success
1464: x_return_status := FND_API.G_RET_STS_SUCCESS;
1465:
1466: l_stmt_num := 5;
1467: BEGIN
1468: SELECT NVL(PA_POSTING_FLAG, 'N')

Line 1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1555: IF l_event_id is NULL THEN
1556: IF l_unexpLog THEN
1557: 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));
1558: END IF;
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: END IF;
1561: IF l_procLog THEN
1562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');
1563: END IF;

Line 1566: WHEN FND_API.g_exc_error THEN

1562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');
1563: END IF;
1564:
1565: EXCEPTION
1566: WHEN FND_API.g_exc_error THEN
1567: ROLLBACK TO Create_WIPXLAEvent;
1568: x_return_status := FND_API.g_ret_sts_error;
1569: FND_MSG_PUB.count_and_get
1570: ( p_count => x_msg_count,

Line 1568: x_return_status := FND_API.g_ret_sts_error;

1564:
1565: EXCEPTION
1566: WHEN FND_API.g_exc_error THEN
1567: ROLLBACK TO Create_WIPXLAEvent;
1568: x_return_status := FND_API.g_ret_sts_error;
1569: FND_MSG_PUB.count_and_get
1570: ( p_count => x_msg_count,
1571: p_data => x_msg_data
1572: );

Line 1573: WHEN FND_API.g_exc_unexpected_error THEN

1569: FND_MSG_PUB.count_and_get
1570: ( p_count => x_msg_count,
1571: p_data => x_msg_data
1572: );
1573: WHEN FND_API.g_exc_unexpected_error THEN
1574: ROLLBACK TO Create_WIPXLAEvent;
1575: x_return_status := FND_API.g_ret_sts_unexp_error ;
1576: FND_MSG_PUB.count_and_get
1577: ( p_count => x_msg_count,

Line 1575: x_return_status := FND_API.g_ret_sts_unexp_error ;

1571: p_data => x_msg_data
1572: );
1573: WHEN FND_API.g_exc_unexpected_error THEN
1574: ROLLBACK TO Create_WIPXLAEvent;
1575: x_return_status := FND_API.g_ret_sts_unexp_error ;
1576: FND_MSG_PUB.count_and_get
1577: ( p_count => x_msg_count,
1578: p_data => x_msg_data
1579: );

Line 1582: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1578: p_data => x_msg_data
1579: );
1580: WHEN OTHERS THEN
1581: ROLLBACK TO Create_WIPXLAEvent;
1582: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1583: IF l_unexpLog THEN
1584: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
1585: ,'Create_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1586: END IF;

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

1638:
1639: l_api_name CONSTANT VARCHAR2(30) := 'CreateBulk_WIPXLAEvent';
1640: l_api_version CONSTANT NUMBER := 1.0;
1641:
1642: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1643: l_msg_count NUMBER := 0;
1644: l_msg_data VARCHAR2(8000);
1645: l_stmt_num NUMBER := 0;
1646: l_api_message VARCHAR2(1000);

Line 1673: IF NOT FND_API.Compatible_API_Call (

1669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' CreateBulk_WIPXLAEvent <<');
1670: END IF;
1671:
1672: -- Standard call to check for call compatibility
1673: IF NOT FND_API.Compatible_API_Call (
1674: l_api_version,
1675: p_api_version,
1676: l_api_name,
1677: G_PKG_NAME ) THEN

Line 1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1674: l_api_version,
1675: p_api_version,
1676: l_api_name,
1677: G_PKG_NAME ) THEN
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;
1680:
1681: -- Initialize message list if p_init_msg_list is set to TRUE
1682: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1682: IF FND_API.to_Boolean(p_init_msg_list) THEN

1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;
1680:
1681: -- Initialize message list if p_init_msg_list is set to TRUE
1682: IF FND_API.to_Boolean(p_init_msg_list) THEN
1683: FND_MSG_PUB.initialize;
1684: END IF;
1685:
1686: -- Initialize API return status to success

Line 1687: x_return_status := FND_API.G_RET_STS_SUCCESS;

1683: FND_MSG_PUB.initialize;
1684: END IF;
1685:
1686: -- Initialize API return status to success
1687: x_return_status := FND_API.G_RET_STS_SUCCESS;
1688:
1689: l_stmt_num := 5;
1690: BEGIN
1691: SELECT NVL(PA_POSTING_FLAG, 'N')

Line 1811: WHEN FND_API.g_exc_error THEN

1807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end','CreateBulk_WIPXLAEvent >>');
1808: END IF;
1809:
1810: EXCEPTION
1811: WHEN FND_API.g_exc_error THEN
1812: ROLLBACK TO CreateBulk_WIPXLAEvent;
1813: x_return_status := FND_API.g_ret_sts_error;
1814: FND_MSG_PUB.count_and_get
1815: ( p_count => x_msg_count,

Line 1813: x_return_status := FND_API.g_ret_sts_error;

1809:
1810: EXCEPTION
1811: WHEN FND_API.g_exc_error THEN
1812: ROLLBACK TO CreateBulk_WIPXLAEvent;
1813: x_return_status := FND_API.g_ret_sts_error;
1814: FND_MSG_PUB.count_and_get
1815: ( p_count => x_msg_count,
1816: p_data => x_msg_data
1817: );

Line 1818: WHEN FND_API.g_exc_unexpected_error THEN

1814: FND_MSG_PUB.count_and_get
1815: ( p_count => x_msg_count,
1816: p_data => x_msg_data
1817: );
1818: WHEN FND_API.g_exc_unexpected_error THEN
1819: ROLLBACK TO CreateBulk_WIPXLAEvent;
1820: x_return_status := FND_API.g_ret_sts_unexp_error ;
1821: FND_MSG_PUB.count_and_get
1822: ( p_count => x_msg_count,

Line 1820: x_return_status := FND_API.g_ret_sts_unexp_error ;

1816: p_data => x_msg_data
1817: );
1818: WHEN FND_API.g_exc_unexpected_error THEN
1819: ROLLBACK TO CreateBulk_WIPXLAEvent;
1820: x_return_status := FND_API.g_ret_sts_unexp_error ;
1821: FND_MSG_PUB.count_and_get
1822: ( p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );

Line 1827: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1823: p_data => x_msg_data
1824: );
1825: WHEN OTHERS THEN
1826: ROLLBACK TO CreateBulk_WIPXLAEvent;
1827: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1828: IF l_unexpLog THEN
1829: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1830: END IF;
1831:

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

1882:
1883: l_api_name CONSTANT VARCHAR2(30) := 'Create_CostUpdateXLAEvent';
1884: l_api_version CONSTANT NUMBER := 1.0;
1885:
1886: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1887: l_msg_count NUMBER := 0;
1888: l_msg_data VARCHAR2(8000);
1889: l_stmt_num NUMBER := 0;
1890: l_api_message VARCHAR2(1000);

Line 1916: IF NOT FND_API.Compatible_API_Call (

1912: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_CostUpdateXLAEvent <<');
1913: END IF;
1914:
1915: -- Standard call to check for call compatibility
1916: IF NOT FND_API.Compatible_API_Call (
1917: l_api_version,
1918: p_api_version,
1919: l_api_name,
1920: G_PKG_NAME ) THEN

Line 1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1917: l_api_version,
1918: p_api_version,
1919: l_api_name,
1920: G_PKG_NAME ) THEN
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END IF;
1923:
1924: -- Initialize message list if p_init_msg_list is set to TRUE
1925: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1925: IF FND_API.to_Boolean(p_init_msg_list) THEN

1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END IF;
1923:
1924: -- Initialize message list if p_init_msg_list is set to TRUE
1925: IF FND_API.to_Boolean(p_init_msg_list) THEN
1926: FND_MSG_PUB.initialize;
1927: END IF;
1928:
1929: -- Initialize API return status to success

Line 1930: x_return_status := FND_API.G_RET_STS_SUCCESS;

1926: FND_MSG_PUB.initialize;
1927: END IF;
1928:
1929: -- Initialize API return status to success
1930: x_return_status := FND_API.G_RET_STS_SUCCESS;
1931:
1932: l_stmt_num := 5;
1933: BEGIN
1934: SELECT NVL(PA_POSTING_FLAG, 'N')

Line 2036: WHEN FND_API.g_exc_error THEN

2032: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_CostUpdateXLAEvent >>');
2033: END IF;
2034:
2035: EXCEPTION
2036: WHEN FND_API.g_exc_error THEN
2037: ROLLBACK TO Create_CostUpdateXLAEvent;
2038: x_return_status := FND_API.g_ret_sts_error;
2039: FND_MSG_PUB.count_and_get
2040: ( p_count => x_msg_count,

Line 2038: x_return_status := FND_API.g_ret_sts_error;

2034:
2035: EXCEPTION
2036: WHEN FND_API.g_exc_error THEN
2037: ROLLBACK TO Create_CostUpdateXLAEvent;
2038: x_return_status := FND_API.g_ret_sts_error;
2039: FND_MSG_PUB.count_and_get
2040: ( p_count => x_msg_count,
2041: p_data => x_msg_data
2042: );

Line 2043: WHEN FND_API.g_exc_unexpected_error THEN

2039: FND_MSG_PUB.count_and_get
2040: ( p_count => x_msg_count,
2041: p_data => x_msg_data
2042: );
2043: WHEN FND_API.g_exc_unexpected_error THEN
2044: ROLLBACK TO Create_CostUpdateXLAEvent;
2045: x_return_status := FND_API.g_ret_sts_unexp_error ;
2046: FND_MSG_PUB.count_and_get
2047: ( p_count => x_msg_count,

Line 2045: x_return_status := FND_API.g_ret_sts_unexp_error ;

2041: p_data => x_msg_data
2042: );
2043: WHEN FND_API.g_exc_unexpected_error THEN
2044: ROLLBACK TO Create_CostUpdateXLAEvent;
2045: x_return_status := FND_API.g_ret_sts_unexp_error ;
2046: FND_MSG_PUB.count_and_get
2047: ( p_count => x_msg_count,
2048: p_data => x_msg_data
2049: );

Line 2052: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2048: p_data => x_msg_data
2049: );
2050: WHEN OTHERS THEN
2051: ROLLBACK TO Create_CostUpdateXLAEvent;
2052: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2053: IF l_unexpLog THEN
2054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2055: END IF;
2056:

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

2105:
2106: l_api_name CONSTANT VARCHAR2(30) := 'Create_WIPUpdateXLAEvent';
2107: l_api_version CONSTANT NUMBER := 1.0;
2108:
2109: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2110: l_msg_count NUMBER := 0;
2111: l_msg_data VARCHAR2(8000);
2112: l_stmt_num NUMBER := 0;
2113: l_api_message VARCHAR2(1000);

Line 2140: IF NOT FND_API.Compatible_API_Call (

2136: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_WIPUpdateXLAEvent <<');
2137: END IF;
2138:
2139: -- Standard call to check for call compatibility
2140: IF NOT FND_API.Compatible_API_Call (
2141: l_api_version,
2142: p_api_version,
2143: l_api_name,
2144: G_PKG_NAME ) THEN

Line 2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2141: l_api_version,
2142: p_api_version,
2143: l_api_name,
2144: G_PKG_NAME ) THEN
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF;
2147:
2148: -- Initialize message list if p_init_msg_list is set to TRUE
2149: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2149: IF FND_API.to_Boolean(p_init_msg_list) THEN

2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF;
2147:
2148: -- Initialize message list if p_init_msg_list is set to TRUE
2149: IF FND_API.to_Boolean(p_init_msg_list) THEN
2150: FND_MSG_PUB.initialize;
2151: END IF;
2152:
2153: -- Initialize API return status to success

Line 2154: x_return_status := FND_API.G_RET_STS_SUCCESS;

2150: FND_MSG_PUB.initialize;
2151: END IF;
2152:
2153: -- Initialize API return status to success
2154: x_return_status := FND_API.G_RET_STS_SUCCESS;
2155:
2156: l_stmt_num := 5;
2157: BEGIN
2158: SELECT NVL(PA_POSTING_FLAG, 'N')

Line 2243: WHEN FND_API.g_exc_error THEN

2239: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPUpdateXLAEvent >>');
2240: END IF;
2241:
2242: EXCEPTION
2243: WHEN FND_API.g_exc_error THEN
2244: ROLLBACK TO Create_WIPUpdateXLAEvent;
2245: x_return_status := FND_API.g_ret_sts_error;
2246: FND_MSG_PUB.count_and_get
2247: ( p_count => x_msg_count,

Line 2245: x_return_status := FND_API.g_ret_sts_error;

2241:
2242: EXCEPTION
2243: WHEN FND_API.g_exc_error THEN
2244: ROLLBACK TO Create_WIPUpdateXLAEvent;
2245: x_return_status := FND_API.g_ret_sts_error;
2246: FND_MSG_PUB.count_and_get
2247: ( p_count => x_msg_count,
2248: p_data => x_msg_data
2249: );

Line 2250: WHEN FND_API.g_exc_unexpected_error THEN

2246: FND_MSG_PUB.count_and_get
2247: ( p_count => x_msg_count,
2248: p_data => x_msg_data
2249: );
2250: WHEN FND_API.g_exc_unexpected_error THEN
2251: ROLLBACK TO Create_WIPUpdateXLAEvent;
2252: x_return_status := FND_API.g_ret_sts_unexp_error ;
2253: FND_MSG_PUB.count_and_get
2254: ( p_count => x_msg_count,

Line 2252: x_return_status := FND_API.g_ret_sts_unexp_error ;

2248: p_data => x_msg_data
2249: );
2250: WHEN FND_API.g_exc_unexpected_error THEN
2251: ROLLBACK TO Create_WIPUpdateXLAEvent;
2252: x_return_status := FND_API.g_ret_sts_unexp_error ;
2253: FND_MSG_PUB.count_and_get
2254: ( p_count => x_msg_count,
2255: p_data => x_msg_data
2256: );

Line 2259: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2255: p_data => x_msg_data
2256: );
2257: WHEN OTHERS THEN
2258: ROLLBACK TO Create_WIPUpdateXLAEvent;
2259: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2260: IF l_unexpLog THEN
2261: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
2262: ,'Create_WIPUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2263: END IF;