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 216: IF NOT fnd_api.compatible_api_call(

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

Line 221: RAISE fnd_api.g_exc_unexpected_error;

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

Line 226: IF fnd_api.to_boolean(p_init_msg_list) THEN

222: END IF;
223:
224: l_stmt_num := 30;
225: -- Initialize message list if p_init_msg_list is set to TRUE.
226: IF fnd_api.to_boolean(p_init_msg_list) THEN
227: fnd_msg_pub.initialize;
228: END IF;
229:
230: l_stmt_num := 40;

Line 232: x_return_status := fnd_api.g_ret_sts_success;

228: END IF;
229:
230: l_stmt_num := 40;
231: -- Initialize API return status to success
232: x_return_status := fnd_api.g_ret_sts_success;
233:
234: l_stmt_num := 50;
235: -- API body
236:

Line 542: IF fnd_api.to_boolean(p_commit) THEN

538: x_instance_id := l_instance_id;
539:
540: -- End of API body.
541: -- Standard check of p_commit.
542: IF fnd_api.to_boolean(p_commit) THEN
543: COMMIT WORK;
544: END IF;
545:
546: l_stmt_num := 999;

Line 552: WHEN fnd_api.g_exc_error THEN

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

Line 555: x_return_status := fnd_api.g_ret_sts_error;

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

Line 557: -- p_encoded => FND_API.g_false

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

Line 560: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 562: x_return_status := fnd_api.g_ret_sts_unexp_error;

558: p_count => x_msg_count
559: ,p_data => x_msg_data);
560: WHEN fnd_api.g_exc_unexpected_error THEN
561: ROLLBACK TO get_resource_validate_pvt;
562: x_return_status := fnd_api.g_ret_sts_unexp_error;
563:
564: fnd_msg_pub.count_and_get(
565: p_count => x_msg_count
566: ,p_data => x_msg_data);

Line 569: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

584:
585: PROCEDURE insert_into_wcti(
586: p_api_version IN NUMBER
587: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
588: ,p_commit IN VARCHAR2 := fnd_api.g_false
589: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
590: ,p_wip_entity_id IN NUMBER
591: ,p_operation_seq_num IN NUMBER
592: ,p_organization_id IN NUMBER

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

585: PROCEDURE insert_into_wcti(
586: p_api_version IN NUMBER
587: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
588: ,p_commit IN VARCHAR2 := fnd_api.g_false
589: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
590: ,p_wip_entity_id IN NUMBER
591: ,p_operation_seq_num IN NUMBER
592: ,p_organization_id IN NUMBER
593: ,p_transaction_qty IN NUMBER

Line 667: IF NOT fnd_api.compatible_api_call(

663: SAVEPOINT get_insert_into_wcti_pvt;
664:
665: l_stmt_num := 20;
666: -- Standard call to check for call compatibility.
667: IF NOT fnd_api.compatible_api_call(
668: l_api_version
669: ,p_api_version
670: ,l_api_name
671: ,g_pkg_name) THEN

Line 672: RAISE fnd_api.g_exc_unexpected_error;

668: l_api_version
669: ,p_api_version
670: ,l_api_name
671: ,g_pkg_name) THEN
672: RAISE fnd_api.g_exc_unexpected_error;
673: END IF;
674:
675: l_stmt_num := 30;
676: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 677: IF fnd_api.to_boolean(p_init_msg_list) THEN

673: END IF;
674:
675: l_stmt_num := 30;
676: -- Initialize message list if p_init_msg_list is set to TRUE.
677: IF fnd_api.to_boolean(p_init_msg_list) THEN
678: fnd_msg_pub.initialize;
679: END IF;
680:
681: l_stmt_num := 40;

Line 683: x_return_status := fnd_api.g_ret_sts_success;

679: END IF;
680:
681: l_stmt_num := 40;
682: -- Initialize API return status to success
683: x_return_status := fnd_api.g_ret_sts_success;
684:
685: l_stmt_num := 50;
686: -- API body
687: l_wip_entity_id := p_wip_entity_id;

Line 857: raise fnd_api.g_exc_unexpected_error;

853: and resource_seq_num = l_res_seq_num_temp
854: and organization_id = l_organization_id;
855: EXCEPTION
856: WHEN NO_DATA_FOUND THEN
857: raise fnd_api.g_exc_unexpected_error;
858: END;
859:
860: end if;
861: end loop;

Line 1188: ,p_init_msg_list => fnd_api.g_false

1184: if (p_instance_id is not null and p_instance_id <> 0) then
1185:
1186: WIP_EAM_RESOURCE_TRANSACTION.insert_into_wori (
1187: p_api_version => 1.0
1188: ,p_init_msg_list => fnd_api.g_false
1189: ,p_commit => fnd_api.g_false
1190: ,p_validation_level => fnd_api.g_valid_level_full
1191: ,p_wip_entity_id => l_wip_entity_id
1192: ,p_operation_seq_num => l_operation_seq_num

Line 1189: ,p_commit => fnd_api.g_false

1185:
1186: WIP_EAM_RESOURCE_TRANSACTION.insert_into_wori (
1187: p_api_version => 1.0
1188: ,p_init_msg_list => fnd_api.g_false
1189: ,p_commit => fnd_api.g_false
1190: ,p_validation_level => fnd_api.g_valid_level_full
1191: ,p_wip_entity_id => l_wip_entity_id
1192: ,p_operation_seq_num => l_operation_seq_num
1193: ,p_organization_id => l_organization_id

Line 1190: ,p_validation_level => fnd_api.g_valid_level_full

1186: WIP_EAM_RESOURCE_TRANSACTION.insert_into_wori (
1187: p_api_version => 1.0
1188: ,p_init_msg_list => fnd_api.g_false
1189: ,p_commit => fnd_api.g_false
1190: ,p_validation_level => fnd_api.g_valid_level_full
1191: ,p_wip_entity_id => l_wip_entity_id
1192: ,p_operation_seq_num => l_operation_seq_num
1193: ,p_organization_id => l_organization_id
1194: ,p_resource_seq_num => p_resource_seq_num

Line 1210: IF fnd_api.to_boolean(p_commit) THEN

1206:
1207:
1208: -- End of API body.
1209: -- Standard check of p_commit.
1210: IF fnd_api.to_boolean(p_commit) THEN
1211: COMMIT WORK;
1212: END IF;
1213:
1214: l_stmt_num := 999;

Line 1220: WHEN fnd_api.g_exc_error THEN

1216: fnd_msg_pub.count_and_get(
1217: p_count => x_msg_count
1218: ,p_data => x_msg_data);
1219: EXCEPTION
1220: WHEN fnd_api.g_exc_error THEN
1221: ROLLBACK TO get_insert_into_wcti_pvt;
1222: x_return_status := fnd_api.g_ret_sts_error;
1223: fnd_msg_pub.count_and_get(
1224: -- p_encoded => FND_API.g_false

Line 1222: x_return_status := fnd_api.g_ret_sts_error;

1218: ,p_data => x_msg_data);
1219: EXCEPTION
1220: WHEN fnd_api.g_exc_error THEN
1221: ROLLBACK TO get_insert_into_wcti_pvt;
1222: x_return_status := fnd_api.g_ret_sts_error;
1223: fnd_msg_pub.count_and_get(
1224: -- p_encoded => FND_API.g_false
1225: p_count => x_msg_count
1226: ,p_data => x_msg_data);

Line 1224: -- p_encoded => FND_API.g_false

1220: WHEN fnd_api.g_exc_error THEN
1221: ROLLBACK TO get_insert_into_wcti_pvt;
1222: x_return_status := fnd_api.g_ret_sts_error;
1223: fnd_msg_pub.count_and_get(
1224: -- p_encoded => FND_API.g_false
1225: p_count => x_msg_count
1226: ,p_data => x_msg_data);
1227: WHEN fnd_api.g_exc_unexpected_error THEN
1228: ROLLBACK TO get_insert_into_wcti_pvt;

Line 1227: WHEN fnd_api.g_exc_unexpected_error THEN

1223: fnd_msg_pub.count_and_get(
1224: -- p_encoded => FND_API.g_false
1225: p_count => x_msg_count
1226: ,p_data => x_msg_data);
1227: WHEN fnd_api.g_exc_unexpected_error THEN
1228: ROLLBACK TO get_insert_into_wcti_pvt;
1229: x_return_status := fnd_api.g_ret_sts_unexp_error;
1230:
1231: fnd_msg_pub.count_and_get(

Line 1229: x_return_status := fnd_api.g_ret_sts_unexp_error;

1225: p_count => x_msg_count
1226: ,p_data => x_msg_data);
1227: WHEN fnd_api.g_exc_unexpected_error THEN
1228: ROLLBACK TO get_insert_into_wcti_pvt;
1229: x_return_status := fnd_api.g_ret_sts_unexp_error;
1230:
1231: fnd_msg_pub.count_and_get(
1232: p_count => x_msg_count
1233: ,p_data => x_msg_data);

Line 1236: x_return_status := fnd_api.g_ret_sts_unexp_error;

1232: p_count => x_msg_count
1233: ,p_data => x_msg_data);
1234: WHEN OTHERS THEN
1235: ROLLBACK TO get_insert_into_wcti_pvt;
1236: x_return_status := fnd_api.g_ret_sts_unexp_error;
1237: IF fnd_msg_pub.check_msg_level(
1238: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1239: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1240: END IF;

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

1249: -- Procedure for inserting the instances into WIP_OP_RESOURCE_INSTANCES
1250:
1251: PROCEDURE insert_into_wori(
1252: p_api_version IN NUMBER
1253: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1254: ,p_commit IN VARCHAR2 := fnd_api.g_false
1255: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1256: ,p_wip_entity_id IN NUMBER
1257: ,p_operation_seq_num IN NUMBER

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

1250:
1251: PROCEDURE insert_into_wori(
1252: p_api_version IN NUMBER
1253: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1254: ,p_commit IN VARCHAR2 := fnd_api.g_false
1255: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1256: ,p_wip_entity_id IN NUMBER
1257: ,p_operation_seq_num IN NUMBER
1258: ,p_organization_id IN NUMBER

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

1251: PROCEDURE insert_into_wori(
1252: p_api_version IN NUMBER
1253: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1254: ,p_commit IN VARCHAR2 := fnd_api.g_false
1255: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1256: ,p_wip_entity_id IN NUMBER
1257: ,p_operation_seq_num IN NUMBER
1258: ,p_organization_id IN NUMBER
1259: ,p_resource_seq_num IN NUMBER

Line 1292: IF NOT fnd_api.compatible_api_call(

1288: SAVEPOINT get_insert_into_wori_pvt;
1289:
1290: l_stmt_num := 20;
1291: -- Standard call to check for call compatibility.
1292: IF NOT fnd_api.compatible_api_call(
1293: l_api_version
1294: ,p_api_version
1295: ,l_api_name
1296: ,g_pkg_name) THEN

Line 1297: RAISE fnd_api.g_exc_unexpected_error;

1293: l_api_version
1294: ,p_api_version
1295: ,l_api_name
1296: ,g_pkg_name) THEN
1297: RAISE fnd_api.g_exc_unexpected_error;
1298: END IF;
1299:
1300: l_stmt_num := 30;
1301: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1302: IF fnd_api.to_boolean(p_init_msg_list) THEN

1298: END IF;
1299:
1300: l_stmt_num := 30;
1301: -- Initialize message list if p_init_msg_list is set to TRUE.
1302: IF fnd_api.to_boolean(p_init_msg_list) THEN
1303: fnd_msg_pub.initialize;
1304: END IF;
1305:
1306: l_stmt_num := 40;

Line 1308: x_return_status := fnd_api.g_ret_sts_success;

1304: END IF;
1305:
1306: l_stmt_num := 40;
1307: -- Initialize API return status to success
1308: x_return_status := fnd_api.g_ret_sts_success;
1309:
1310: l_stmt_num := 50;
1311: -- API body
1312:

Line 1385: IF fnd_api.to_boolean(p_commit) THEN

1381: l_stmt_num := 800;
1382:
1383: -- End of API body.
1384: -- Standard check of p_commit.
1385: IF fnd_api.to_boolean(p_commit) THEN
1386: COMMIT WORK;
1387: END IF;
1388:
1389: l_stmt_num := 999;

Line 1395: WHEN fnd_api.g_exc_error THEN

1391: fnd_msg_pub.count_and_get(
1392: p_count => x_msg_count
1393: ,p_data => x_msg_data);
1394: EXCEPTION
1395: WHEN fnd_api.g_exc_error THEN
1396: ROLLBACK TO get_insert_into_wori_pvt;
1397: x_return_status := fnd_api.g_ret_sts_error;
1398: fnd_msg_pub.count_and_get(
1399: -- p_encoded => FND_API.g_false

Line 1397: x_return_status := fnd_api.g_ret_sts_error;

1393: ,p_data => x_msg_data);
1394: EXCEPTION
1395: WHEN fnd_api.g_exc_error THEN
1396: ROLLBACK TO get_insert_into_wori_pvt;
1397: x_return_status := fnd_api.g_ret_sts_error;
1398: fnd_msg_pub.count_and_get(
1399: -- p_encoded => FND_API.g_false
1400: p_count => x_msg_count
1401: ,p_data => x_msg_data);

Line 1399: -- p_encoded => FND_API.g_false

1395: WHEN fnd_api.g_exc_error THEN
1396: ROLLBACK TO get_insert_into_wori_pvt;
1397: x_return_status := fnd_api.g_ret_sts_error;
1398: fnd_msg_pub.count_and_get(
1399: -- p_encoded => FND_API.g_false
1400: p_count => x_msg_count
1401: ,p_data => x_msg_data);
1402: WHEN fnd_api.g_exc_unexpected_error THEN
1403: ROLLBACK TO get_insert_into_wori_pvt;

Line 1402: WHEN fnd_api.g_exc_unexpected_error THEN

1398: fnd_msg_pub.count_and_get(
1399: -- p_encoded => FND_API.g_false
1400: p_count => x_msg_count
1401: ,p_data => x_msg_data);
1402: WHEN fnd_api.g_exc_unexpected_error THEN
1403: ROLLBACK TO get_insert_into_wori_pvt;
1404: x_return_status := fnd_api.g_ret_sts_unexp_error;
1405:
1406: fnd_msg_pub.count_and_get(

Line 1404: x_return_status := fnd_api.g_ret_sts_unexp_error;

1400: p_count => x_msg_count
1401: ,p_data => x_msg_data);
1402: WHEN fnd_api.g_exc_unexpected_error THEN
1403: ROLLBACK TO get_insert_into_wori_pvt;
1404: x_return_status := fnd_api.g_ret_sts_unexp_error;
1405:
1406: fnd_msg_pub.count_and_get(
1407: p_count => x_msg_count
1408: ,p_data => x_msg_data);

Line 1411: x_return_status := fnd_api.g_ret_sts_unexp_error;

1407: p_count => x_msg_count
1408: ,p_data => x_msg_data);
1409: WHEN OTHERS THEN
1410: ROLLBACK TO get_insert_into_wori_pvt;
1411: x_return_status := fnd_api.g_ret_sts_unexp_error;
1412: IF fnd_msg_pub.check_msg_level(
1413: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1414: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1415: END IF;

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

1423: -- Anju Gupta: Modifed for PO Service Line Types Enhancement
1424:
1425: procedure WIP_EAMRCVDIRECTITEM_HOOK
1426: ( p_api_version IN NUMBER
1427: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1428: ,p_commit IN VARCHAR2 := fnd_api.g_false
1429: ,p_rcv_txn_id IN NUMBER
1430: ,p_primary_qty IN NUMBER
1431: ,p_primary_uom IN VARCHAR2

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

1424:
1425: procedure WIP_EAMRCVDIRECTITEM_HOOK
1426: ( p_api_version IN NUMBER
1427: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1428: ,p_commit IN VARCHAR2 := fnd_api.g_false
1429: ,p_rcv_txn_id IN NUMBER
1430: ,p_primary_qty IN NUMBER
1431: ,p_primary_uom IN VARCHAR2
1432: ,p_unit_price IN NUMBER

Line 1475: IF NOT fnd_api.compatible_api_call(

1471: SAVEPOINT wip_eamrcvdirectitem_pvt;
1472:
1473: l_stmt_num := 20;
1474: -- Standard call to check for call compatibility.
1475: IF NOT fnd_api.compatible_api_call(
1476: l_api_version
1477: ,p_api_version
1478: ,l_api_name
1479: ,g_pkg_name) THEN

Line 1480: RAISE fnd_api.g_exc_unexpected_error;

1476: l_api_version
1477: ,p_api_version
1478: ,l_api_name
1479: ,g_pkg_name) THEN
1480: RAISE fnd_api.g_exc_unexpected_error;
1481: END IF;
1482:
1483: l_stmt_num := 30;
1484: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1485: IF fnd_api.to_boolean(p_init_msg_list) THEN

1481: END IF;
1482:
1483: l_stmt_num := 30;
1484: -- Initialize message list if p_init_msg_list is set to TRUE.
1485: IF fnd_api.to_boolean(p_init_msg_list) THEN
1486: fnd_msg_pub.initialize;
1487: END IF;
1488:
1489: l_stmt_num := 40;

Line 1491: x_return_status := fnd_api.g_ret_sts_success;

1487: END IF;
1488:
1489: l_stmt_num := 40;
1490: -- Initialize API return status to success
1491: x_return_status := fnd_api.g_ret_sts_success;
1492:
1493: l_stmt_num := 50;
1494:
1495: -- API body

Line 1575: RAISE fnd_api.g_exc_unexpected_error;

1571: exception
1572:
1573: WHEN NO_DATA_FOUND then
1574:
1575: RAISE fnd_api.g_exc_unexpected_error;
1576:
1577: end;
1578:
1579:

Line 1710: RAISE fnd_api.g_exc_unexpected_error;

1706: exception
1707:
1708: WHEN NO_DATA_FOUND then
1709:
1710: RAISE fnd_api.g_exc_unexpected_error;
1711:
1712: end;
1713:
1714:

Line 1810: IF fnd_api.to_boolean(p_commit) THEN

1806:
1807:
1808: -- End of API body.
1809: -- Standard check of p_commit.
1810: IF fnd_api.to_boolean(p_commit) THEN
1811: COMMIT WORK;
1812: END IF;
1813:
1814: l_stmt_num := 999;

Line 1817: p_encoded => fnd_api.g_false

1813:
1814: l_stmt_num := 999;
1815: -- Standard call to get message count and if count is 1, get message info.
1816: fnd_msg_pub.count_and_get(
1817: p_encoded => fnd_api.g_false
1818: ,p_count => x_msg_count
1819: ,p_data => x_msg_data);
1820:
1821: EXCEPTION

Line 1822: WHEN fnd_api.g_exc_error THEN

1818: ,p_count => x_msg_count
1819: ,p_data => x_msg_data);
1820:
1821: EXCEPTION
1822: WHEN fnd_api.g_exc_error THEN
1823: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1824: x_return_status := fnd_api.g_ret_sts_error;
1825: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1826: fnd_msg_pub.count_and_get(

Line 1824: x_return_status := fnd_api.g_ret_sts_error;

1820:
1821: EXCEPTION
1822: WHEN fnd_api.g_exc_error THEN
1823: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1824: x_return_status := fnd_api.g_ret_sts_error;
1825: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1826: fnd_msg_pub.count_and_get(
1827: p_encoded => fnd_api.g_false
1828: ,p_count => x_msg_count

Line 1827: p_encoded => fnd_api.g_false

1823: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1824: x_return_status := fnd_api.g_ret_sts_error;
1825: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1826: fnd_msg_pub.count_and_get(
1827: p_encoded => fnd_api.g_false
1828: ,p_count => x_msg_count
1829: ,p_data => x_msg_data);
1830: WHEN fnd_api.g_exc_unexpected_error THEN
1831: ROLLBACK TO wip_eamrcvdirectitem_pvt;

Line 1830: WHEN fnd_api.g_exc_unexpected_error THEN

1826: fnd_msg_pub.count_and_get(
1827: p_encoded => fnd_api.g_false
1828: ,p_count => x_msg_count
1829: ,p_data => x_msg_data);
1830: WHEN fnd_api.g_exc_unexpected_error THEN
1831: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1832: x_return_status := fnd_api.g_ret_sts_unexp_error;
1833: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1834: fnd_msg_pub.count_and_get(

Line 1832: x_return_status := fnd_api.g_ret_sts_unexp_error;

1828: ,p_count => x_msg_count
1829: ,p_data => x_msg_data);
1830: WHEN fnd_api.g_exc_unexpected_error THEN
1831: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1832: x_return_status := fnd_api.g_ret_sts_unexp_error;
1833: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1834: fnd_msg_pub.count_and_get(
1835: p_encoded => fnd_api.g_false
1836: ,p_count => x_msg_count

Line 1835: p_encoded => fnd_api.g_false

1831: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1832: x_return_status := fnd_api.g_ret_sts_unexp_error;
1833: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1834: fnd_msg_pub.count_and_get(
1835: p_encoded => fnd_api.g_false
1836: ,p_count => x_msg_count
1837: ,p_data => x_msg_data);
1838: WHEN OTHERS THEN
1839: ROLLBACK TO wip_eamrcvdirectitem_pvt;

Line 1840: x_return_status := fnd_api.g_ret_sts_unexp_error;

1836: ,p_count => x_msg_count
1837: ,p_data => x_msg_data);
1838: WHEN OTHERS THEN
1839: ROLLBACK TO wip_eamrcvdirectitem_pvt;
1840: x_return_status := fnd_api.g_ret_sts_unexp_error;
1841: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
1842: IF fnd_msg_pub.check_msg_level(
1843: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1844: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1848: p_encoded => fnd_api.g_false

1844: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1845: END IF;
1846:
1847: fnd_msg_pub.count_and_get(
1848: p_encoded => fnd_api.g_false
1849: ,p_count => x_msg_count
1850: ,p_data => x_msg_data);
1851:
1852: END WIP_EAMRCVDIRECTITEM_HOOK;