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

Line 148: l_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;

144:
145: l_api_version_number CONSTANT NUMBER := 1.0;
146: l_api_name CONSTANT VARCHAR2(30) := 'RUN_REPAIR_EXECUTION';
147:
148: l_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
149: l_commit VARCHAR2(1) := FND_API.G_TRUE;
150: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
151:
152: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 149: l_commit VARCHAR2(1) := FND_API.G_TRUE;

145: l_api_version_number CONSTANT NUMBER := 1.0;
146: l_api_name CONSTANT VARCHAR2(30) := 'RUN_REPAIR_EXECUTION';
147:
148: l_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
149: l_commit VARCHAR2(1) := FND_API.G_TRUE;
150: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
151:
152: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
153: x_msg_count NUMBER;

Line 150: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

146: l_api_name CONSTANT VARCHAR2(30) := 'RUN_REPAIR_EXECUTION';
147:
148: l_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
149: l_commit VARCHAR2(1) := FND_API.G_TRUE;
150: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
151:
152: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
153: x_msg_count NUMBER;
154: x_msg_data VARCHAR2(2000);

Line 152: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

148: l_Init_Msg_List VARCHAR2(1) := FND_API.G_TRUE;
149: l_commit VARCHAR2(1) := FND_API.G_TRUE;
150: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
151:
152: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
153: x_msg_count NUMBER;
154: x_msg_data VARCHAR2(2000);
155:
156: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

152: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
153: x_msg_count NUMBER;
154: x_msg_data VARCHAR2(2000);
155:
156: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
157: l_msg_count NUMBER;
158: l_msg_data VARCHAR2(2000);
159:
160: l_sqlcode NUMBER;

Line 213: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

209:
210: SAVEPOINT RUN_REPAIR_EXECUTION_PVT;
211:
212: /** Standard call to check for call compatibility **/
213: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
214: p_api_version_number,
215: l_api_name,
216: G_PKG_NAME)
217: THEN

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

214: p_api_version_number,
215: l_api_name,
216: G_PKG_NAME)
217: THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220:
221: /** Initialize message list **/
222: IF fnd_api.to_boolean(l_Init_Msg_List) THEN

Line 222: IF fnd_api.to_boolean(l_Init_Msg_List) THEN

218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220:
221: /** Initialize message list **/
222: IF fnd_api.to_boolean(l_Init_Msg_List) THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225:
226: /** Initialize return status **/

Line 227: x_return_status := FND_API.G_RET_STS_SUCCESS;

223: FND_MSG_PUB.initialize;
224: END IF;
225:
226: /** Initialize return status **/
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: /** User and login information **/
230: SELECT Sysdate INTO l_today FROM dual;
231: l_user_id := fnd_global.user_id;

Line 406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

402: ,x_msg_data
403: ,x_msg_count
404: );
405:
406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
407: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_RESERVED_LINES_rec.defective_organization_id);
408: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
409: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_ORG_NAME,TRUE);
410: FND_MSG_PUB.ADD;

Line 427: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

423: ,x_return_status => l_return_status
424: ,x_msg_data => l_msg_data );
425: */
426:
427: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
428: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: Add_Err_Msg;
430: g_retcode := 1;
431: errbuf := X_Msg_Data;

Line 428: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

424: ,x_msg_data => l_msg_data );
425: */
426:
427: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
428: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: Add_Err_Msg;
430: g_retcode := 1;
431: errbuf := X_Msg_Data;
432: ROLLBACK TO RUN_REPAIR_EXECUTION_PVT;

Line 434: Elsif (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

430: g_retcode := 1;
431: errbuf := X_Msg_Data;
432: ROLLBACK TO RUN_REPAIR_EXECUTION_PVT;
433:
434: Elsif (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
435: l_line_rec.line_num := I; -- 1;
436: l_line_rec.inventory_item_id := CSP_RESERVED_LINES_rec.inventory_item_id;
437: --l_line_rec.item_description := 'Sentinel Standard Desktop';
438: l_line_rec.sourced_from := 'INVENTORY';

Line 512: ,p_Init_Msg_List => FND_API.G_FALSE

508:
509: csp_parts_order.process_order
510: (
511: p_api_version => 1.0
512: ,p_Init_Msg_List => FND_API.G_FALSE
513: ,p_commit => FND_API.G_FALSE
514: ,px_header_rec => l_header_rec
515: ,px_line_table => l_line_tbl
516: --,p_process_type => 'BOTH'(Default value is 'BOTH')

Line 513: ,p_commit => FND_API.G_FALSE

509: csp_parts_order.process_order
510: (
511: p_api_version => 1.0
512: ,p_Init_Msg_List => FND_API.G_FALSE
513: ,p_commit => FND_API.G_FALSE
514: ,px_header_rec => l_header_rec
515: ,px_line_table => l_line_tbl
516: --,p_process_type => 'BOTH'(Default value is 'BOTH')
517: ,x_return_status => x_return_status

Line 522: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

518: ,x_msg_count => x_msg_count
519: ,x_msg_data => x_msg_data
520: );
521:
522: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
523: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: Add_Err_Msg;
525: g_retcode := 1;
526: errbuf := X_Msg_Data;

Line 523: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: ,x_msg_data => x_msg_data
520: );
521:
522: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
523: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: Add_Err_Msg;
525: g_retcode := 1;
526: errbuf := X_Msg_Data;
527: ROLLBACK TO RUN_REPAIR_EXECUTION_PVT;

Line 528: Elsif (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

524: Add_Err_Msg;
525: g_retcode := 1;
526: errbuf := X_Msg_Data;
527: ROLLBACK TO RUN_REPAIR_EXECUTION_PVT;
528: Elsif (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
529: /* STATUS = 6 => INTERNAL_ORDER CREATED */
530:
531: UPDATE CSP_REPAIR_PO_HEADERS
532: SET INTERNAL_ORDER_HEADER_ID = l_header_rec.order_header_id,

Line 581: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

577: ,x_msg_data
578: ,x_msg_count
579: );
580:
581: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
582: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
583: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
584: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
585: FND_MSG_PUB.ADD;

Line 710: , p_init_msg_list => FND_API.G_FALSE

706: /** Create Wip component issue transaction to the wip job **/
707:
708: csp_transactions_pub.transact_material
709: ( p_api_version => 1.0
710: , p_init_msg_list => FND_API.G_FALSE
711: , p_commit => FND_API.G_FALSE
712: , px_transaction_header_id => px_transaction_header_id
713: , px_transaction_id => t_transaction_id
714: , p_inventory_item_id => IO_QTY_RECEIVED_CHECK_REC.item_id

Line 711: , p_commit => FND_API.G_FALSE

707:
708: csp_transactions_pub.transact_material
709: ( p_api_version => 1.0
710: , p_init_msg_list => FND_API.G_FALSE
711: , p_commit => FND_API.G_FALSE
712: , px_transaction_header_id => px_transaction_header_id
713: , px_transaction_id => t_transaction_id
714: , p_inventory_item_id => IO_QTY_RECEIVED_CHECK_REC.item_id
715: , p_organization_id => IO_QTY_RECEIVED_CHECK_REC.DESTINATION_ORGANIZATION_ID

Line 747: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

743: , x_msg_count => l_msg_count
744: , x_msg_data => l_msg_data
745: );
746:
747: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
748: -- Raise FND_API.G_EXC_UNEXPECTED_ERROR;
749: Add_Err_Msg;
750: g_retcode := 1;
751: errbuf := l_Msg_Data;

Line 748: -- Raise FND_API.G_EXC_UNEXPECTED_ERROR;

744: , x_msg_data => l_msg_data
745: );
746:
747: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
748: -- Raise FND_API.G_EXC_UNEXPECTED_ERROR;
749: Add_Err_Msg;
750: g_retcode := 1;
751: errbuf := l_Msg_Data;
752: ROLLBACK TO RUN_REPAIR_EXECUTION_PVT;

Line 838: , p_init_msg_list => FND_API.G_FALSE

834: If nvl(l_wib_issue_qty,0) > 0 then
835:
836: csp_transactions_pub.transact_material
837: ( p_api_version => 1.0
838: , p_init_msg_list => FND_API.G_FALSE
839: , p_commit => FND_API.G_FALSE
840: , px_transaction_header_id => px_transaction_header_id
841: , px_transaction_id => t_transaction_id
842: , p_inventory_item_id => IO_QTY_RECEIVED_CHECK_REC.item_id

Line 839: , p_commit => FND_API.G_FALSE

835:
836: csp_transactions_pub.transact_material
837: ( p_api_version => 1.0
838: , p_init_msg_list => FND_API.G_FALSE
839: , p_commit => FND_API.G_FALSE
840: , px_transaction_header_id => px_transaction_header_id
841: , px_transaction_id => t_transaction_id
842: , p_inventory_item_id => IO_QTY_RECEIVED_CHECK_REC.item_id
843: , p_organization_id => IO_QTY_RECEIVED_CHECK_REC.DESTINATION_ORGANIZATION_ID

Line 875: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

871: , x_msg_count => l_msg_count
872: , x_msg_data => l_msg_data
873: );
874:
875: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
876: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: Add_Err_Msg;
878: g_retcode := 1;
879: errbuf := l_Msg_Data;

Line 876: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

872: , x_msg_data => l_msg_data
873: );
874:
875: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
876: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: Add_Err_Msg;
878: g_retcode := 1;
879: errbuf := l_Msg_Data;
880: ROLLBACK TO RUN_REPAIR_EXECUTION_PVT;

Line 971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

967: ,x_msg_data
968: ,x_msg_count
969: );
970:
971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
972: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id);
973: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
974: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
975: FND_MSG_PUB.ADD;

Line 982: , p_init_msg_list => FND_API.G_FALSE

978: END IF;
979:
980: csp_transactions_pub.transact_material
981: ( p_api_version => 1.0
982: , p_init_msg_list => FND_API.G_FALSE
983: , p_commit => FND_API.G_FALSE
984: , px_transaction_header_id => px_transaction_header_id
985: , px_transaction_id => t_transaction_id
986: , p_inventory_item_id => CSP_REPAIR_PO_HEADERS_rec.INVENTORY_ITEM_ID

Line 983: , p_commit => FND_API.G_FALSE

979:
980: csp_transactions_pub.transact_material
981: ( p_api_version => 1.0
982: , p_init_msg_list => FND_API.G_FALSE
983: , p_commit => FND_API.G_FALSE
984: , px_transaction_header_id => px_transaction_header_id
985: , px_transaction_id => t_transaction_id
986: , p_inventory_item_id => CSP_REPAIR_PO_HEADERS_rec.INVENTORY_ITEM_ID
987: , p_organization_id => CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id

Line 1020: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1016: , x_msg_count => l_msg_count
1017: , x_msg_data => l_msg_data
1018: );
1019:
1020: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1021: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: Add_Err_Msg;
1023: g_retcode := 1;
1024: errbuf := l_msg_Data;

Line 1021: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1017: , x_msg_data => l_msg_data
1018: );
1019:
1020: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1021: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: Add_Err_Msg;
1023: g_retcode := 1;
1024: errbuf := l_msg_Data;
1025: ROLLBACK TO RUN_REPAIR_EXECUTION_PVT;

Line 1127: , p_init_msg_list => FND_API.G_FALSE

1123: **/
1124:
1125: csp_transactions_pub.transact_material
1126: ( p_api_version => 1.0
1127: , p_init_msg_list => FND_API.G_FALSE
1128: , p_commit => FND_API.G_FALSE
1129: , px_transaction_header_id => px_transaction_header_id
1130: , px_transaction_id => t_transaction_id
1131: , p_inventory_item_id => CSP_REPAIR_PO_HEADERS_rec.INVENTORY_ITEM_ID

Line 1128: , p_commit => FND_API.G_FALSE

1124:
1125: csp_transactions_pub.transact_material
1126: ( p_api_version => 1.0
1127: , p_init_msg_list => FND_API.G_FALSE
1128: , p_commit => FND_API.G_FALSE
1129: , px_transaction_header_id => px_transaction_header_id
1130: , px_transaction_id => t_transaction_id
1131: , p_inventory_item_id => CSP_REPAIR_PO_HEADERS_rec.INVENTORY_ITEM_ID
1132: , p_organization_id => CSP_REPAIR_PO_HEADERS_rec.repair_supplier_org_id

Line 1164: IF l_return_status <> FND_API.G_RET_STS_SUCCESS and nvl(l_msg_count, 0) > 0 THEN

1160: , x_msg_count => l_msg_count
1161: , x_msg_data => l_msg_data
1162: );
1163:
1164: IF l_return_status <> FND_API.G_RET_STS_SUCCESS and nvl(l_msg_count, 0) > 0 THEN
1165: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: Add_Err_Msg;
1167: g_retcode := 1;
1168: errbuf := l_msg_Data;

Line 1165: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1161: , x_msg_data => l_msg_data
1162: );
1163:
1164: IF l_return_status <> FND_API.G_RET_STS_SUCCESS and nvl(l_msg_count, 0) > 0 THEN
1165: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: Add_Err_Msg;
1167: g_retcode := 1;
1168: errbuf := l_msg_Data;
1169: ROLLBACK TO RUN_REPAIR_EXECUTION_PVT;

Line 1205: IF FND_API.to_Boolean(l_commit) THEN

1201:
1202: Call REP_PO_SCRAP_ADJUST_TRANSACT(); ----> SCRAP/ADJUSTMENT transaction
1203: **/
1204:
1205: IF FND_API.to_Boolean(l_commit) THEN
1206: COMMIT WORK;
1207: END IF;
1208:
1209: /** Standard call to get message count and if count is 1, get message info. **/

Line 1221: WHEN FND_API.G_EXC_ERROR THEN

1217: errbuf := X_Msg_Data;
1218: retcode := g_retcode;
1219:
1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
1222: Add_Err_Msg;
1223: retcode := 2;
1224: errbuf := X_Msg_Data;
1225:

Line 1236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1232: ,X_MSG_COUNT => X_MSG_COUNT
1233: ,X_MSG_DATA => X_MSG_DATA
1234: ,X_RETURN_STATUS => X_RETURN_STATUS);
1235:
1236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1237: Add_Err_Msg;
1238: retcode := 2;
1239: errbuf := X_Msg_Data;
1240:

Line 1289: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

1285: /** REPAIR_PO SCRAP/ADJUSTMENT TRANSACTION **/
1286:
1287: PROCEDURE REP_PO_SCRAP_ADJUST_TRANSACT
1288: (p_Api_Version_Number IN NUMBER
1289: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1290: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1291: ,p_REPAIR_PO_HEADER_ID IN NUMBER
1292: ,p_SCRAP_ADJUST_FLAG IN VARCHAR2
1293: ,p_SCRAP_ADJUST_ITEM_ID IN NUMBER

Line 1290: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1286:
1287: PROCEDURE REP_PO_SCRAP_ADJUST_TRANSACT
1288: (p_Api_Version_Number IN NUMBER
1289: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1290: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1291: ,p_REPAIR_PO_HEADER_ID IN NUMBER
1292: ,p_SCRAP_ADJUST_FLAG IN VARCHAR2
1293: ,p_SCRAP_ADJUST_ITEM_ID IN NUMBER
1294: ,p_SCRAP_ADJUST_QTY IN NUMBER

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

1322:
1323: l_api_version_number CONSTANT NUMBER := 1.0;
1324: l_api_name CONSTANT VARCHAR2(20) := 'REPAIR_PO_SCRAP';
1325:
1326: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1327: l_msg_count NUMBER;
1328: l_msg_data VARCHAR2(2000);
1329: l_Rollback VARCHAR2(1) := 'Y';
1330:

Line 1386: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1382:
1383: SAVEPOINT REPAIR_PO_SCRAP_PVT;
1384:
1385: /** Standard call to check for call compatibility **/
1386: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1387: p_api_version_number,
1388: l_api_name,
1389: G_PKG_NAME)
1390: THEN

Line 1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1387: p_api_version_number,
1388: l_api_name,
1389: G_PKG_NAME)
1390: THEN
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END IF;
1393:
1394: /** Initialize message list **/
1395: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

Line 1395: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END IF;
1393:
1394: /** Initialize message list **/
1395: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1396: FND_MSG_PUB.initialize;
1397: END IF;
1398:
1399: /** Initialize return status **/

Line 1400: x_return_status := FND_API.G_RET_STS_SUCCESS;

1396: FND_MSG_PUB.initialize;
1397: END IF;
1398:
1399: /** Initialize return status **/
1400: x_return_status := FND_API.G_RET_STS_SUCCESS;
1401:
1402: /** User and login information **/
1403: SELECT Sysdate INTO l_today FROM dual;
1404: l_user_id := fnd_global.user_id;

Line 1428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1424: ,x_return_status
1425: ,x_msg_data
1426: ,x_msg_count
1427: );
1428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1429: L_ORG_NAME := CSP_REPAIR_PO_GRP.GET_ORGANIZATION_NAME(CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id);
1430: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
1431: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_ORG_NAME,TRUE);
1432: FND_MSG_PUB.ADD;

Line 1463: , p_init_msg_list => FND_API.G_FALSE

1459: **/
1460:
1461: csp_transactions_pub.transact_material
1462: ( p_api_version => 1.0
1463: , p_init_msg_list => FND_API.G_FALSE
1464: , p_commit => FND_API.G_FALSE
1465: , px_transaction_header_id => px_transaction_header_id
1466: , px_transaction_id => t_transaction_id
1467: , p_inventory_item_id => CSP_REPAIR_PO_SCRAP_rec.defect_item_id

Line 1464: , p_commit => FND_API.G_FALSE

1460:
1461: csp_transactions_pub.transact_material
1462: ( p_api_version => 1.0
1463: , p_init_msg_list => FND_API.G_FALSE
1464: , p_commit => FND_API.G_FALSE
1465: , px_transaction_header_id => px_transaction_header_id
1466: , px_transaction_id => t_transaction_id
1467: , p_inventory_item_id => CSP_REPAIR_PO_SCRAP_rec.defect_item_id
1468: , p_organization_id => CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id

Line 1501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS and l_msg_count <> 0 THEN

1497: , x_msg_count => l_msg_count
1498: , x_msg_data => l_msg_data
1499: );
1500:
1501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS and l_msg_count <> 0 THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: End if;
1504:
1505: /**

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: , x_msg_data => l_msg_data
1499: );
1500:
1501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS and l_msg_count <> 0 THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: End if;
1504:
1505: /**
1506: After WIP_JOB qty is returned from WIP JOB to Repair Supplier Org's Defect subinv

Line 1522: , p_init_msg_list => FND_API.G_FALSE

1518: End if;
1519:
1520: csp_transactions_pub.transact_material
1521: ( p_api_version => 1.0
1522: , p_init_msg_list => FND_API.G_FALSE
1523: , p_commit => FND_API.G_FALSE
1524: , px_transaction_header_id => px_transaction_header_id
1525: , px_transaction_id => t_transaction_id
1526: , p_inventory_item_id => CSP_REPAIR_PO_SCRAP_rec.defect_item_id

Line 1523: , p_commit => FND_API.G_FALSE

1519:
1520: csp_transactions_pub.transact_material
1521: ( p_api_version => 1.0
1522: , p_init_msg_list => FND_API.G_FALSE
1523: , p_commit => FND_API.G_FALSE
1524: , px_transaction_header_id => px_transaction_header_id
1525: , px_transaction_id => t_transaction_id
1526: , p_inventory_item_id => CSP_REPAIR_PO_SCRAP_rec.defect_item_id
1527: , p_organization_id => CSP_REPAIR_PO_SCRAP_rec.repair_supplier_org_id

Line 1559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1555: , x_msg_count => l_msg_count
1556: , x_msg_data => l_msg_data
1557: );
1558:
1559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: End if;
1562:
1563: /** FINAL_COMPLETION_FLAG = 'Y' => Repair PO is Closed, WIP_JOB is Complete and ready to close

Line 1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1556: , x_msg_data => l_msg_data
1557: );
1558:
1559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: End if;
1562:
1563: /** FINAL_COMPLETION_FLAG = 'Y' => Repair PO is Closed, WIP_JOB is Complete and ready to close
1564: FINAL_COMPLETION_FLAG = 'N' => Repair PO is not Closed, WIP_JOB is still open in released status_type

Line 1700: IF FND_API.to_Boolean(p_commit) THEN

1696:
1697: End if;
1698: End loop;
1699:
1700: IF FND_API.to_Boolean(p_commit) THEN
1701: COMMIT WORK;
1702: END IF;
1703:
1704: x_return_status := l_return_status;

Line 1727: x_return_status := FND_API.G_RET_STS_ERROR;

1723: WHEN EXCP_USER_DEFINED THEN
1724: Rollback to REPAIR_PO_SCRAP_PVT;
1725:
1726: /** This returns 'E' as status **/
1727: x_return_status := FND_API.G_RET_STS_ERROR;
1728:
1729: fnd_msg_pub.count_and_get
1730: (p_count => x_msg_count
1731: ,p_data => x_msg_data);

Line 1733: WHEN FND_API.G_EXC_ERROR THEN

1729: fnd_msg_pub.count_and_get
1730: (p_count => x_msg_count
1731: ,p_data => x_msg_data);
1732:
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: /** This returns 'E' as status **/
1735:
1736: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1737: P_API_NAME => L_API_NAME

Line 1746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1742: ,X_MSG_COUNT => X_MSG_COUNT
1743: ,X_MSG_DATA => X_MSG_DATA
1744: ,X_RETURN_STATUS => X_RETURN_STATUS);
1745:
1746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1747: /** This returns 'U' as status **/
1748:
1749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1750: P_API_NAME => L_API_NAME

Line 1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1769: (p_count => x_msg_count
1770: ,p_data => x_msg_data);
1771:
1772: /** This returns 'U' as status **/
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774:
1775: END REP_PO_SCRAP_ADJUST_TRANSACT;
1776:
1777: END CSP_REPAIR_PO_PVT;