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

Line 1030: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1026: END IF;
1027:
1028: -- in case of error , the above api puts message in l_msg_data.
1029:
1030: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1031: x_return_status := '-62';
1032: raise ex_exception_found;
1033: END IF;
1034:

Line 1035: IF (l_txn_allowed = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1031: x_return_status := '-62';
1032: raise ex_exception_found;
1033: END IF;
1034:
1035: IF (l_txn_allowed = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1036: l_tran_rec.lot_status := l_rcpt_status;
1037: END IF;
1038: ELSE
1039: BEGIN

Line 1066: p_init_msg_list => FND_API.G_FALSE,

1062: END IF; /* IF l_tran_rec.lot_id is not null */
1063:
1064: gmi_trans_engine_pub.create_completed_transaction(
1065: p_api_version => 1.0,
1066: p_init_msg_list => FND_API.G_FALSE,
1067: p_commit => FND_API.G_FALSE,
1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1069: p_tran_rec => l_tran_rec,
1070: x_tran_row => l_tran_row,

Line 1067: p_commit => FND_API.G_FALSE,

1063:
1064: gmi_trans_engine_pub.create_completed_transaction(
1065: p_api_version => 1.0,
1066: p_init_msg_list => FND_API.G_FALSE,
1067: p_commit => FND_API.G_FALSE,
1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1069: p_tran_rec => l_tran_rec,
1070: x_tran_row => l_tran_row,
1071: x_return_status => l_return_status,

Line 1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1064: gmi_trans_engine_pub.create_completed_transaction(
1065: p_api_version => 1.0,
1066: p_init_msg_list => FND_API.G_FALSE,
1067: p_commit => FND_API.G_FALSE,
1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1069: p_tran_rec => l_tran_rec,
1070: x_tran_row => l_tran_row,
1071: x_return_status => l_return_status,
1072: x_msg_count => l_msg_count,

Line 1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1074: p_table_name => 'IC_TRAN_PND');
1075:
1076:
1077:
1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: x_return_status := '-80';
1080: raise ex_exception_found;
1081: END IF;
1082:

Line 1267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1263: END IF;
1264:
1265: -- in case of error , the above api puts message in l_msg_data.
1266:
1267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1268: x_return_status := '-93';
1269: raise ex_exception_found;
1270: END IF;
1271:

Line 1273: IF (l_txn_allowed = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1269: raise ex_exception_found;
1270: END IF;
1271:
1272:
1273: IF (l_txn_allowed = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1274: l_tran_rec.lot_status := l_rcpt_status;
1275: END IF;
1276: END IF; -- IF l_ship_status IS NOT NULL
1277: END IF; -- IF ( GML_INTORD_LOT_STS.G_retain_ship_lot_sts = 'Y'

Line 1331: p_init_msg_list FND_API.G_FALSE

1327: /*--------------------------------------------------------------------------------------------------
1328: Parameters that need to be passed to the gmi_trans_engine_pub.create_pending_transaction routine are
1329: Parameter Value
1330: p_api_version 1.0
1331: p_init_msg_list FND_API.G_FALSE
1332: p_commit FND_API.G_FALSE
1333: p_validation_level FND_API.G_VALID_LEVEL_FULL
1334: p_tran_rec Record that needs to be processed. GMI_TRANS_ENGINE_PUB.ictran_rec
1335: x_tran_row Processed record with trans id created in the procedure.

Line 1332: p_commit FND_API.G_FALSE

1328: Parameters that need to be passed to the gmi_trans_engine_pub.create_pending_transaction routine are
1329: Parameter Value
1330: p_api_version 1.0
1331: p_init_msg_list FND_API.G_FALSE
1332: p_commit FND_API.G_FALSE
1333: p_validation_level FND_API.G_VALID_LEVEL_FULL
1334: p_tran_rec Record that needs to be processed. GMI_TRANS_ENGINE_PUB.ictran_rec
1335: x_tran_row Processed record with trans id created in the procedure.
1336: x_return_status Success of the procedure.

Line 1333: p_validation_level FND_API.G_VALID_LEVEL_FULL

1329: Parameter Value
1330: p_api_version 1.0
1331: p_init_msg_list FND_API.G_FALSE
1332: p_commit FND_API.G_FALSE
1333: p_validation_level FND_API.G_VALID_LEVEL_FULL
1334: p_tran_rec Record that needs to be processed. GMI_TRANS_ENGINE_PUB.ictran_rec
1335: x_tran_row Processed record with trans id created in the procedure.
1336: x_return_status Success of the procedure.
1337: x_msg_count Error message.

Line 1362: p_init_msg_list => FND_API.G_FALSE,

1358: END IF;
1359: -- PK End Bug 3936459.
1360: gmi_trans_engine_pub.create_completed_transaction(
1361: p_api_version => 1.0,
1362: p_init_msg_list => FND_API.G_FALSE,
1363: p_commit => FND_API.G_FALSE,
1364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1365: p_tran_rec => l_tran_rec,
1366: x_tran_row => l_tran_row,

Line 1363: p_commit => FND_API.G_FALSE,

1359: -- PK End Bug 3936459.
1360: gmi_trans_engine_pub.create_completed_transaction(
1361: p_api_version => 1.0,
1362: p_init_msg_list => FND_API.G_FALSE,
1363: p_commit => FND_API.G_FALSE,
1364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1365: p_tran_rec => l_tran_rec,
1366: x_tran_row => l_tran_row,
1367: x_return_status => l_return_status,

Line 1364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1360: gmi_trans_engine_pub.create_completed_transaction(
1361: p_api_version => 1.0,
1362: p_init_msg_list => FND_API.G_FALSE,
1363: p_commit => FND_API.G_FALSE,
1364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1365: p_tran_rec => l_tran_rec,
1366: x_tran_row => l_tran_row,
1367: x_return_status => l_return_status,
1368: x_msg_count => l_msg_count,

Line 1372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1368: x_msg_count => l_msg_count,
1369: x_msg_data => l_msg_data,
1370: p_table_name => 'IC_TRAN_PND');
1371:
1372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: x_return_status := '-110';
1374: raise ex_exception_found;
1375: END IF;
1376: END LOOP;

Line 1382: p_init_msg_list => FND_API.G_FALSE,

1378: /*If there were no lots for this transactions then do the following insert */
1379: IF l_lot_exists = 0 THEN
1380: gmi_trans_engine_pub.create_completed_transaction(
1381: p_api_version => 1.0,
1382: p_init_msg_list => FND_API.G_FALSE,
1383: p_commit => FND_API.G_FALSE,
1384: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1385: p_tran_rec => l_tran_rec,
1386: x_tran_row => l_tran_row,

Line 1383: p_commit => FND_API.G_FALSE,

1379: IF l_lot_exists = 0 THEN
1380: gmi_trans_engine_pub.create_completed_transaction(
1381: p_api_version => 1.0,
1382: p_init_msg_list => FND_API.G_FALSE,
1383: p_commit => FND_API.G_FALSE,
1384: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1385: p_tran_rec => l_tran_rec,
1386: x_tran_row => l_tran_row,
1387: x_return_status => l_return_status,

Line 1384: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1380: gmi_trans_engine_pub.create_completed_transaction(
1381: p_api_version => 1.0,
1382: p_init_msg_list => FND_API.G_FALSE,
1383: p_commit => FND_API.G_FALSE,
1384: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1385: p_tran_rec => l_tran_rec,
1386: x_tran_row => l_tran_row,
1387: x_return_status => l_return_status,
1388: x_msg_count => l_msg_count,

Line 1395: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1391:
1392:
1393:
1394:
1395: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1396: x_return_status := '-120';
1397: raise ex_exception_found;
1398: END IF;
1399:

Line 1472: p_encoded => FND_API.G_FALSE,

1468:
1469: FND_MSG_PUB.Get (
1470: p_msg_index => l_loop_cnt,
1471: p_data => l_msg_data,
1472: p_encoded => FND_API.G_FALSE,
1473: p_msg_index_out => l_dummy_cnt);
1474:
1475: --gml_po_log('l_msg_data :' ||l_msg_data);
1476:

Line 1515: p_encoded => FND_API.G_FALSE,

1511:
1512: FND_MSG_PUB.Get (
1513: p_msg_index => l_loop_cnt,
1514: p_data => l_msg_data,
1515: p_encoded => FND_API.G_FALSE,
1516: p_msg_index_out => l_dummy_cnt);
1517:
1518: --gml_po_log('l_msg_data :' ||l_msg_data);
1519:

Line 1537: p_encoded => FND_API.G_FALSE,

1533:
1534: FND_MSG_PUB.Get (
1535: p_msg_index => l_loop_cnt,
1536: p_data => l_msg_data,
1537: p_encoded => FND_API.G_FALSE,
1538: p_msg_index_out => l_dummy_cnt);
1539:
1540: --gml_po_log('l_msg_data :' ||l_msg_data);
1541:

Line 1845: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

1841:
1842: l_trans_rec Gmigapi.conv_rec_typ;
1843: l_ic_item_cnv_row IC_ITEM_CNV%ROWTYPE;
1844: l_status VARCHAR2(1);
1845: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
1846: l_count NUMBER;
1847: l_count_msg NUMBER;
1848: l_data VARCHAR2(2000);
1849: l_dummy_cnt NUMBER :=0;

Line 1872: , p_init_msg_list => FND_API.G_TRUE

1868:
1869: -- Call the standard API and check the return status
1870: Gmipapi.Create_Item_Lot_Conv
1871: ( p_api_version => 3.0
1872: , p_init_msg_list => FND_API.G_TRUE
1873: , p_commit => FND_API.G_FALSE
1874: , p_validation_level => FND_API.G_valid_level_full
1875: , p_conv_rec => l_trans_rec
1876: , x_ic_item_cnv_row => l_ic_item_cnv_row

Line 1873: , p_commit => FND_API.G_FALSE

1869: -- Call the standard API and check the return status
1870: Gmipapi.Create_Item_Lot_Conv
1871: ( p_api_version => 3.0
1872: , p_init_msg_list => FND_API.G_TRUE
1873: , p_commit => FND_API.G_FALSE
1874: , p_validation_level => FND_API.G_valid_level_full
1875: , p_conv_rec => l_trans_rec
1876: , x_ic_item_cnv_row => l_ic_item_cnv_row
1877: , x_return_status => l_status

Line 1874: , p_validation_level => FND_API.G_valid_level_full

1870: Gmipapi.Create_Item_Lot_Conv
1871: ( p_api_version => 3.0
1872: , p_init_msg_list => FND_API.G_TRUE
1873: , p_commit => FND_API.G_FALSE
1874: , p_validation_level => FND_API.G_valid_level_full
1875: , p_conv_rec => l_trans_rec
1876: , x_ic_item_cnv_row => l_ic_item_cnv_row
1877: , x_return_status => l_status
1878: , x_msg_count => l_count

Line 1889: p_encoded => FND_API.G_FALSE,

1885: LOOP
1886: FND_MSG_PUB.Get(
1887: p_msg_index => l_loop_cnt,
1888: p_data => l_data,
1889: p_encoded => FND_API.G_FALSE,
1890: p_msg_index_out => l_dummy_cnt);
1891:
1892: x_data := x_data||l_data;
1893:

Line 1905: P_encoded => FND_API.G_FALSE,

1901: FOR l_loop_cnt IN 1..l_count_msg
1902: LOOP
1903: FND_MSG_PUB.GET(P_msg_index => l_loop_cnt,
1904: P_data => l_data,
1905: P_encoded => FND_API.G_FALSE,
1906: P_msg_index_out => l_dummy_cnt);
1907:
1908: x_data := x_data||l_data;
1909: