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

Line 8: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

4: g_pkg_name CONSTANT VARCHAR2(30):= 'WIP_EAM_RESOURCE_TRANSACTION';
5:
6: PROCEDURE resource_validate (
7: p_api_version IN NUMBER
8: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9: ,p_commit IN VARCHAR2 := fnd_api.g_false
10: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
11: ,p_wip_entity_id IN NUMBER
12: ,p_operation_seq_num IN NUMBER

Line 9: ,p_commit IN VARCHAR2 := fnd_api.g_false

5:
6: PROCEDURE resource_validate (
7: p_api_version IN NUMBER
8: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9: ,p_commit IN VARCHAR2 := fnd_api.g_false
10: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
11: ,p_wip_entity_id IN NUMBER
12: ,p_operation_seq_num IN NUMBER
13: ,p_organization_id IN NUMBER

Line 10: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

6: PROCEDURE resource_validate (
7: p_api_version IN NUMBER
8: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9: ,p_commit IN VARCHAR2 := fnd_api.g_false
10: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
11: ,p_wip_entity_id IN NUMBER
12: ,p_operation_seq_num IN NUMBER
13: ,p_organization_id IN NUMBER
14: ,p_resource_seq_num IN NUMBER

Line 212: IF NOT fnd_api.compatible_api_call(

208: SAVEPOINT get_resource_validate_pvt;
209:
210: l_stmt_num := 20;
211: -- Standard call to check for call compatibility.
212: IF NOT fnd_api.compatible_api_call(
213: l_api_version
214: ,p_api_version
215: ,l_api_name
216: ,g_pkg_name) THEN

Line 217: RAISE fnd_api.g_exc_unexpected_error;

213: l_api_version
214: ,p_api_version
215: ,l_api_name
216: ,g_pkg_name) THEN
217: RAISE fnd_api.g_exc_unexpected_error;
218: END IF;
219:
220: l_stmt_num := 30;
221: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 222: IF fnd_api.to_boolean(p_init_msg_list) THEN

218: END IF;
219:
220: l_stmt_num := 30;
221: -- Initialize message list if p_init_msg_list is set to TRUE.
222: IF fnd_api.to_boolean(p_init_msg_list) THEN
223: fnd_msg_pub.initialize;
224: END IF;
225:
226: l_stmt_num := 40;

Line 228: x_return_status := fnd_api.g_ret_sts_success;

224: END IF;
225:
226: l_stmt_num := 40;
227: -- Initialize API return status to success
228: x_return_status := fnd_api.g_ret_sts_success;
229:
230: l_stmt_num := 50;
231: -- API body
232:

Line 538: IF fnd_api.to_boolean(p_commit) THEN

534: x_instance_id := l_instance_id;
535:
536: -- End of API body.
537: -- Standard check of p_commit.
538: IF fnd_api.to_boolean(p_commit) THEN
539: COMMIT WORK;
540: END IF;
541:
542: l_stmt_num := 999;

Line 548: WHEN fnd_api.g_exc_error THEN

544: fnd_msg_pub.count_and_get(
545: p_count => x_msg_count
546: ,p_data => x_msg_data);
547: EXCEPTION
548: WHEN fnd_api.g_exc_error THEN
549: ROLLBACK TO get_resource_validate_pvt
550: ;
551: x_return_status := fnd_api.g_ret_sts_error;
552: fnd_msg_pub.count_and_get(

Line 551: x_return_status := fnd_api.g_ret_sts_error;

547: EXCEPTION
548: WHEN fnd_api.g_exc_error THEN
549: ROLLBACK TO get_resource_validate_pvt
550: ;
551: x_return_status := fnd_api.g_ret_sts_error;
552: fnd_msg_pub.count_and_get(
553: -- p_encoded => FND_API.g_false
554: p_count => x_msg_count
555: ,p_data => x_msg_data);

Line 553: -- p_encoded => FND_API.g_false

549: ROLLBACK TO get_resource_validate_pvt
550: ;
551: x_return_status := fnd_api.g_ret_sts_error;
552: fnd_msg_pub.count_and_get(
553: -- p_encoded => FND_API.g_false
554: p_count => x_msg_count
555: ,p_data => x_msg_data);
556: WHEN fnd_api.g_exc_unexpected_error THEN
557: ROLLBACK TO get_resource_validate_pvt;

Line 556: WHEN fnd_api.g_exc_unexpected_error THEN

552: fnd_msg_pub.count_and_get(
553: -- p_encoded => FND_API.g_false
554: p_count => x_msg_count
555: ,p_data => x_msg_data);
556: WHEN fnd_api.g_exc_unexpected_error THEN
557: ROLLBACK TO get_resource_validate_pvt;
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559:
560: fnd_msg_pub.count_and_get(

Line 558: x_return_status := fnd_api.g_ret_sts_unexp_error;

554: p_count => x_msg_count
555: ,p_data => x_msg_data);
556: WHEN fnd_api.g_exc_unexpected_error THEN
557: ROLLBACK TO get_resource_validate_pvt;
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559:
560: fnd_msg_pub.count_and_get(
561: p_count => x_msg_count
562: ,p_data => x_msg_data);

Line 565: x_return_status := fnd_api.g_ret_sts_unexp_error;

561: p_count => x_msg_count
562: ,p_data => x_msg_data);
563: WHEN OTHERS THEN
564: ROLLBACK TO get_resource_validate_pvt;
565: x_return_status := fnd_api.g_ret_sts_unexp_error;
566: IF fnd_msg_pub.check_msg_level(
567: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;

Line 583: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

579:
580:
581: PROCEDURE insert_into_wcti(
582: p_api_version IN NUMBER
583: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
584: ,p_commit IN VARCHAR2 := fnd_api.g_false
585: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
586: ,p_wip_entity_id IN NUMBER
587: ,p_operation_seq_num IN NUMBER

Line 584: ,p_commit IN VARCHAR2 := fnd_api.g_false

580:
581: PROCEDURE insert_into_wcti(
582: p_api_version IN NUMBER
583: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
584: ,p_commit IN VARCHAR2 := fnd_api.g_false
585: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
586: ,p_wip_entity_id IN NUMBER
587: ,p_operation_seq_num IN NUMBER
588: ,p_organization_id IN NUMBER

Line 585: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

581: PROCEDURE insert_into_wcti(
582: p_api_version IN NUMBER
583: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
584: ,p_commit IN VARCHAR2 := fnd_api.g_false
585: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
586: ,p_wip_entity_id IN NUMBER
587: ,p_operation_seq_num IN NUMBER
588: ,p_organization_id IN NUMBER
589: ,p_transaction_qty IN NUMBER

Line 699: IF NOT fnd_api.compatible_api_call(

695: SAVEPOINT get_insert_into_wcti_pvt;
696:
697: l_stmt_num := 20;
698: -- Standard call to check for call compatibility.
699: IF NOT fnd_api.compatible_api_call(
700: l_api_version
701: ,p_api_version
702: ,l_api_name
703: ,g_pkg_name) THEN

Line 704: RAISE fnd_api.g_exc_unexpected_error;

700: l_api_version
701: ,p_api_version
702: ,l_api_name
703: ,g_pkg_name) THEN
704: RAISE fnd_api.g_exc_unexpected_error;
705: END IF;
706:
707: l_stmt_num := 30;
708: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 709: IF fnd_api.to_boolean(p_init_msg_list) THEN

705: END IF;
706:
707: l_stmt_num := 30;
708: -- Initialize message list if p_init_msg_list is set to TRUE.
709: IF fnd_api.to_boolean(p_init_msg_list) THEN
710: fnd_msg_pub.initialize;
711: END IF;
712:
713: l_stmt_num := 40;

Line 715: x_return_status := fnd_api.g_ret_sts_success;

711: END IF;
712:
713: l_stmt_num := 40;
714: -- Initialize API return status to success
715: x_return_status := fnd_api.g_ret_sts_success;
716:
717: l_stmt_num := 50;
718: -- API body
719: l_wip_entity_id := p_wip_entity_id;

Line 776: RAISE FND_API.G_EXC_ERROR;

772: IF l_project_task_chargeable <> 'Y' THEN
773:
774: FND_MESSAGE.SET_NAME('EAM','EAM_RES_TXN_PJM_TASK_N_CHARGE');
775: FND_MSG_PUB.Add;
776: RAISE FND_API.G_EXC_ERROR;
777:
778: END IF ;
779:
780:

Line 924: raise fnd_api.g_exc_unexpected_error;

920: and resource_seq_num = l_res_seq_num_temp
921: and organization_id = l_organization_id;
922: EXCEPTION
923: WHEN NO_DATA_FOUND THEN
924: raise fnd_api.g_exc_unexpected_error;
925: END;
926:
927: end if;
928: end loop;

Line 1257: ,p_init_msg_list => fnd_api.g_false

1253: if (p_instance_id is not null and p_instance_id <> 0) then
1254:
1255: WIP_EAM_RESOURCE_TRANSACTION.insert_into_wori (
1256: p_api_version => 1.0
1257: ,p_init_msg_list => fnd_api.g_false
1258: ,p_commit => fnd_api.g_false
1259: ,p_validation_level => fnd_api.g_valid_level_full
1260: ,p_wip_entity_id => l_wip_entity_id
1261: ,p_operation_seq_num => l_operation_seq_num

Line 1258: ,p_commit => fnd_api.g_false

1254:
1255: WIP_EAM_RESOURCE_TRANSACTION.insert_into_wori (
1256: p_api_version => 1.0
1257: ,p_init_msg_list => fnd_api.g_false
1258: ,p_commit => fnd_api.g_false
1259: ,p_validation_level => fnd_api.g_valid_level_full
1260: ,p_wip_entity_id => l_wip_entity_id
1261: ,p_operation_seq_num => l_operation_seq_num
1262: ,p_organization_id => l_organization_id

Line 1259: ,p_validation_level => fnd_api.g_valid_level_full

1255: WIP_EAM_RESOURCE_TRANSACTION.insert_into_wori (
1256: p_api_version => 1.0
1257: ,p_init_msg_list => fnd_api.g_false
1258: ,p_commit => fnd_api.g_false
1259: ,p_validation_level => fnd_api.g_valid_level_full
1260: ,p_wip_entity_id => l_wip_entity_id
1261: ,p_operation_seq_num => l_operation_seq_num
1262: ,p_organization_id => l_organization_id
1263: ,p_resource_seq_num => p_resource_seq_num

Line 1279: IF fnd_api.to_boolean(p_commit) THEN

1275:
1276:
1277: -- End of API body.
1278: -- Standard check of p_commit.
1279: IF fnd_api.to_boolean(p_commit) THEN
1280: COMMIT WORK;
1281: END IF;
1282:
1283: l_stmt_num := 999;

Line 1289: WHEN fnd_api.g_exc_error THEN

1285: fnd_msg_pub.count_and_get(
1286: p_count => x_msg_count
1287: ,p_data => x_msg_data);
1288: EXCEPTION
1289: WHEN fnd_api.g_exc_error THEN
1290: ROLLBACK TO get_insert_into_wcti_pvt;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_msg_pub.count_and_get(
1293: -- p_encoded => FND_API.g_false

Line 1291: x_return_status := fnd_api.g_ret_sts_error;

1287: ,p_data => x_msg_data);
1288: EXCEPTION
1289: WHEN fnd_api.g_exc_error THEN
1290: ROLLBACK TO get_insert_into_wcti_pvt;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_msg_pub.count_and_get(
1293: -- p_encoded => FND_API.g_false
1294: p_count => x_msg_count
1295: ,p_data => x_msg_data);

Line 1293: -- p_encoded => FND_API.g_false

1289: WHEN fnd_api.g_exc_error THEN
1290: ROLLBACK TO get_insert_into_wcti_pvt;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_msg_pub.count_and_get(
1293: -- p_encoded => FND_API.g_false
1294: p_count => x_msg_count
1295: ,p_data => x_msg_data);
1296: WHEN fnd_api.g_exc_unexpected_error THEN
1297: ROLLBACK TO get_insert_into_wcti_pvt;

Line 1296: WHEN fnd_api.g_exc_unexpected_error THEN

1292: fnd_msg_pub.count_and_get(
1293: -- p_encoded => FND_API.g_false
1294: p_count => x_msg_count
1295: ,p_data => x_msg_data);
1296: WHEN fnd_api.g_exc_unexpected_error THEN
1297: ROLLBACK TO get_insert_into_wcti_pvt;
1298: x_return_status := fnd_api.g_ret_sts_unexp_error;
1299:
1300: fnd_msg_pub.count_and_get(

Line 1298: x_return_status := fnd_api.g_ret_sts_unexp_error;

1294: p_count => x_msg_count
1295: ,p_data => x_msg_data);
1296: WHEN fnd_api.g_exc_unexpected_error THEN
1297: ROLLBACK TO get_insert_into_wcti_pvt;
1298: x_return_status := fnd_api.g_ret_sts_unexp_error;
1299:
1300: fnd_msg_pub.count_and_get(
1301: p_count => x_msg_count
1302: ,p_data => x_msg_data);

Line 1305: x_return_status := fnd_api.g_ret_sts_unexp_error;

1301: p_count => x_msg_count
1302: ,p_data => x_msg_data);
1303: WHEN OTHERS THEN
1304: ROLLBACK TO get_insert_into_wcti_pvt;
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306: IF fnd_msg_pub.check_msg_level(
1307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1309: END IF;

Line 1322: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1318: -- Procedure for inserting the instances into WIP_OP_RESOURCE_INSTANCES
1319:
1320: PROCEDURE insert_into_wori(
1321: p_api_version IN NUMBER
1322: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1323: ,p_commit IN VARCHAR2 := fnd_api.g_false
1324: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1325: ,p_wip_entity_id IN NUMBER
1326: ,p_operation_seq_num IN NUMBER

Line 1323: ,p_commit IN VARCHAR2 := fnd_api.g_false

1319:
1320: PROCEDURE insert_into_wori(
1321: p_api_version IN NUMBER
1322: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1323: ,p_commit IN VARCHAR2 := fnd_api.g_false
1324: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1325: ,p_wip_entity_id IN NUMBER
1326: ,p_operation_seq_num IN NUMBER
1327: ,p_organization_id IN NUMBER

Line 1324: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

1320: PROCEDURE insert_into_wori(
1321: p_api_version IN NUMBER
1322: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1323: ,p_commit IN VARCHAR2 := fnd_api.g_false
1324: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1325: ,p_wip_entity_id IN NUMBER
1326: ,p_operation_seq_num IN NUMBER
1327: ,p_organization_id IN NUMBER
1328: ,p_resource_seq_num IN NUMBER

Line 1361: IF NOT fnd_api.compatible_api_call(

1357: SAVEPOINT get_insert_into_wori_pvt;
1358:
1359: l_stmt_num := 20;
1360: -- Standard call to check for call compatibility.
1361: IF NOT fnd_api.compatible_api_call(
1362: l_api_version
1363: ,p_api_version
1364: ,l_api_name
1365: ,g_pkg_name) THEN

Line 1366: RAISE fnd_api.g_exc_unexpected_error;

1362: l_api_version
1363: ,p_api_version
1364: ,l_api_name
1365: ,g_pkg_name) THEN
1366: RAISE fnd_api.g_exc_unexpected_error;
1367: END IF;
1368:
1369: l_stmt_num := 30;
1370: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1371: IF fnd_api.to_boolean(p_init_msg_list) THEN

1367: END IF;
1368:
1369: l_stmt_num := 30;
1370: -- Initialize message list if p_init_msg_list is set to TRUE.
1371: IF fnd_api.to_boolean(p_init_msg_list) THEN
1372: fnd_msg_pub.initialize;
1373: END IF;
1374:
1375: l_stmt_num := 40;

Line 1377: x_return_status := fnd_api.g_ret_sts_success;

1373: END IF;
1374:
1375: l_stmt_num := 40;
1376: -- Initialize API return status to success
1377: x_return_status := fnd_api.g_ret_sts_success;
1378:
1379: l_stmt_num := 50;
1380: -- API body
1381:

Line 1454: IF fnd_api.to_boolean(p_commit) THEN

1450: l_stmt_num := 800;
1451:
1452: -- End of API body.
1453: -- Standard check of p_commit.
1454: IF fnd_api.to_boolean(p_commit) THEN
1455: COMMIT WORK;
1456: END IF;
1457:
1458: l_stmt_num := 999;

Line 1464: WHEN fnd_api.g_exc_error THEN

1460: fnd_msg_pub.count_and_get(
1461: p_count => x_msg_count
1462: ,p_data => x_msg_data);
1463: EXCEPTION
1464: WHEN fnd_api.g_exc_error THEN
1465: ROLLBACK TO get_insert_into_wori_pvt;
1466: x_return_status := fnd_api.g_ret_sts_error;
1467: fnd_msg_pub.count_and_get(
1468: -- p_encoded => FND_API.g_false

Line 1466: x_return_status := fnd_api.g_ret_sts_error;

1462: ,p_data => x_msg_data);
1463: EXCEPTION
1464: WHEN fnd_api.g_exc_error THEN
1465: ROLLBACK TO get_insert_into_wori_pvt;
1466: x_return_status := fnd_api.g_ret_sts_error;
1467: fnd_msg_pub.count_and_get(
1468: -- p_encoded => FND_API.g_false
1469: p_count => x_msg_count
1470: ,p_data => x_msg_data);

Line 1468: -- p_encoded => FND_API.g_false

1464: WHEN fnd_api.g_exc_error THEN
1465: ROLLBACK TO get_insert_into_wori_pvt;
1466: x_return_status := fnd_api.g_ret_sts_error;
1467: fnd_msg_pub.count_and_get(
1468: -- p_encoded => FND_API.g_false
1469: p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: WHEN fnd_api.g_exc_unexpected_error THEN
1472: ROLLBACK TO get_insert_into_wori_pvt;

Line 1471: WHEN fnd_api.g_exc_unexpected_error THEN

1467: fnd_msg_pub.count_and_get(
1468: -- p_encoded => FND_API.g_false
1469: p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: WHEN fnd_api.g_exc_unexpected_error THEN
1472: ROLLBACK TO get_insert_into_wori_pvt;
1473: x_return_status := fnd_api.g_ret_sts_unexp_error;
1474:
1475: fnd_msg_pub.count_and_get(

Line 1473: x_return_status := fnd_api.g_ret_sts_unexp_error;

1469: p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: WHEN fnd_api.g_exc_unexpected_error THEN
1472: ROLLBACK TO get_insert_into_wori_pvt;
1473: x_return_status := fnd_api.g_ret_sts_unexp_error;
1474:
1475: fnd_msg_pub.count_and_get(
1476: p_count => x_msg_count
1477: ,p_data => x_msg_data);

Line 1480: x_return_status := fnd_api.g_ret_sts_unexp_error;

1476: p_count => x_msg_count
1477: ,p_data => x_msg_data);
1478: WHEN OTHERS THEN
1479: ROLLBACK TO get_insert_into_wori_pvt;
1480: x_return_status := fnd_api.g_ret_sts_unexp_error;
1481: IF fnd_msg_pub.check_msg_level(
1482: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1483: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1484: END IF;

Line 1496: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1492: -- Anju Gupta: Modifed for PO Service Line Types Enhancement
1493:
1494: procedure WIP_EAMRCVDIRECTITEM_HOOK
1495: ( p_api_version IN NUMBER
1496: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1497: ,p_commit IN VARCHAR2 := fnd_api.g_false
1498: ,p_rcv_txn_id IN NUMBER
1499: ,p_primary_qty IN NUMBER
1500: ,p_primary_uom IN VARCHAR2

Line 1497: ,p_commit IN VARCHAR2 := fnd_api.g_false

1493:
1494: procedure WIP_EAMRCVDIRECTITEM_HOOK
1495: ( p_api_version IN NUMBER
1496: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1497: ,p_commit IN VARCHAR2 := fnd_api.g_false
1498: ,p_rcv_txn_id IN NUMBER
1499: ,p_primary_qty IN NUMBER
1500: ,p_primary_uom IN VARCHAR2
1501: ,p_unit_price IN NUMBER

Line 1544: IF NOT fnd_api.compatible_api_call(

1540: SAVEPOINT wip_eamrcvdirectitem_pvt;
1541:
1542: l_stmt_num := 20;
1543: -- Standard call to check for call compatibility.
1544: IF NOT fnd_api.compatible_api_call(
1545: l_api_version
1546: ,p_api_version
1547: ,l_api_name
1548: ,g_pkg_name) THEN

Line 1549: RAISE fnd_api.g_exc_unexpected_error;

1545: l_api_version
1546: ,p_api_version
1547: ,l_api_name
1548: ,g_pkg_name) THEN
1549: RAISE fnd_api.g_exc_unexpected_error;
1550: END IF;
1551:
1552: l_stmt_num := 30;
1553: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1554: IF fnd_api.to_boolean(p_init_msg_list) THEN

1550: END IF;
1551:
1552: l_stmt_num := 30;
1553: -- Initialize message list if p_init_msg_list is set to TRUE.
1554: IF fnd_api.to_boolean(p_init_msg_list) THEN
1555: fnd_msg_pub.initialize;
1556: END IF;
1557:
1558: l_stmt_num := 40;

Line 1560: x_return_status := fnd_api.g_ret_sts_success;

1556: END IF;
1557:
1558: l_stmt_num := 40;
1559: -- Initialize API return status to success
1560: x_return_status := fnd_api.g_ret_sts_success;
1561:
1562: l_stmt_num := 50;
1563:
1564: -- API body

Line 1648: RAISE fnd_api.g_exc_unexpected_error;

1644: exception
1645:
1646: WHEN NO_DATA_FOUND then
1647:
1648: RAISE fnd_api.g_exc_unexpected_error;
1649:
1650: end;
1651:
1652:

Line 1778: RAISE fnd_api.g_exc_unexpected_error;

1774: exception
1775:
1776: WHEN NO_DATA_FOUND then
1777:
1778: RAISE fnd_api.g_exc_unexpected_error;
1779:
1780: end;
1781:
1782:

Line 1878: IF fnd_api.to_boolean(p_commit) THEN

1874:
1875:
1876: -- End of API body.
1877: -- Standard check of p_commit.
1878: IF fnd_api.to_boolean(p_commit) THEN
1879: COMMIT WORK;
1880: END IF;
1881:
1882: l_stmt_num := 999;

Line 1885: p_encoded => fnd_api.g_false

1881:
1882: l_stmt_num := 999;
1883: -- Standard call to get message count and if count is 1, get message info.
1884: fnd_msg_pub.count_and_get(
1885: p_encoded => fnd_api.g_false
1886: ,p_count => x_msg_count
1887: ,p_data => x_msg_data);
1888:
1889: EXCEPTION

Line 1890: WHEN fnd_api.g_exc_error THEN

1886: ,p_count => x_msg_count
1887: ,p_data => x_msg_data);
1888:
1889: EXCEPTION
1890: WHEN fnd_api.g_exc_error THEN
1891: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1892: x_return_status := fnd_api.g_ret_sts_error;
1893: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1894: fnd_msg_pub.count_and_get(

Line 1892: x_return_status := fnd_api.g_ret_sts_error;

1888:
1889: EXCEPTION
1890: WHEN fnd_api.g_exc_error THEN
1891: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1892: x_return_status := fnd_api.g_ret_sts_error;
1893: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1894: fnd_msg_pub.count_and_get(
1895: p_encoded => fnd_api.g_false
1896: ,p_count => x_msg_count

Line 1895: p_encoded => fnd_api.g_false

1891: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1892: x_return_status := fnd_api.g_ret_sts_error;
1893: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1894: fnd_msg_pub.count_and_get(
1895: p_encoded => fnd_api.g_false
1896: ,p_count => x_msg_count
1897: ,p_data => x_msg_data);
1898: WHEN fnd_api.g_exc_unexpected_error THEN
1899: ROLLBACK TO wip_eamrcvdirectitem_pvt;

Line 1898: WHEN fnd_api.g_exc_unexpected_error THEN

1894: fnd_msg_pub.count_and_get(
1895: p_encoded => fnd_api.g_false
1896: ,p_count => x_msg_count
1897: ,p_data => x_msg_data);
1898: WHEN fnd_api.g_exc_unexpected_error THEN
1899: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1900: x_return_status := fnd_api.g_ret_sts_unexp_error;
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1902: fnd_msg_pub.count_and_get(

Line 1900: x_return_status := fnd_api.g_ret_sts_unexp_error;

1896: ,p_count => x_msg_count
1897: ,p_data => x_msg_data);
1898: WHEN fnd_api.g_exc_unexpected_error THEN
1899: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1900: x_return_status := fnd_api.g_ret_sts_unexp_error;
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1902: fnd_msg_pub.count_and_get(
1903: p_encoded => fnd_api.g_false
1904: ,p_count => x_msg_count

Line 1903: p_encoded => fnd_api.g_false

1899: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1900: x_return_status := fnd_api.g_ret_sts_unexp_error;
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1902: fnd_msg_pub.count_and_get(
1903: p_encoded => fnd_api.g_false
1904: ,p_count => x_msg_count
1905: ,p_data => x_msg_data);
1906: WHEN OTHERS THEN
1907: ROLLBACK TO wip_eamrcvdirectitem_pvt;

Line 1908: x_return_status := fnd_api.g_ret_sts_unexp_error;

1904: ,p_count => x_msg_count
1905: ,p_data => x_msg_data);
1906: WHEN OTHERS THEN
1907: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1908: x_return_status := fnd_api.g_ret_sts_unexp_error;
1909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1910: IF fnd_msg_pub.check_msg_level(
1911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1916: p_encoded => fnd_api.g_false

1912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1913: END IF;
1914:
1915: fnd_msg_pub.count_and_get(
1916: p_encoded => fnd_api.g_false
1917: ,p_count => x_msg_count
1918: ,p_data => x_msg_data);
1919:
1920: END WIP_EAMRCVDIRECTITEM_HOOK;