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_RECEIVE_PVT dependencies on FND_API

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

30: , x_msg_data OUT NOCOPY VARCHAR2
31: ) IS
32: PRAGMA AUTONOMOUS_TRANSACTION;
33: l_receipt_exists NUMBER;
34: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
35: l_msg_count NUMBER;
36: l_msg_data VARCHAR2(400);
37: l_progress VARCHAR2(10);
38: l_receipt_code VARCHAR2(25);

Line 41: x_return_status := fnd_api.g_ret_sts_success;

37: l_progress VARCHAR2(10);
38: l_receipt_code VARCHAR2(25);
39: l_api_name VARCHAR2(25) := 'gen_receipt_num';
40: BEGIN
41: x_return_status := fnd_api.g_ret_sts_success;
42:
43: UPDATE rcv_parameters
44: SET next_receipt_num = next_receipt_num + 1
45: WHERE organization_id = p_organization_id

Line 67: RAISE FND_API.G_EXC_ERROR;

63: IF (l_receipt_exists = 1) THEN
64: fnd_message.set_name('CSP','CSP_RECEIPT_NUM_EXISTS');
65: fnd_message.set_token('RECEIPT',x_receipt_num,false);
66: fnd_msg_pub.add;
67: RAISE FND_API.G_EXC_ERROR;
68: END IF;
69:
70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN

Line 71: WHEN FND_API.G_EXC_ERROR THEN

67: RAISE FND_API.G_EXC_ERROR;
68: END IF;
69:
70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN
72: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
73: P_API_NAME => L_API_NAME
74: ,P_PKG_NAME => G_PKG_NAME
75: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

76: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
77: ,X_MSG_COUNT => X_MSG_COUNT
78: ,X_MSG_DATA => X_MSG_DATA
79: ,X_RETURN_STATUS => X_RETURN_STATUS);
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
82: P_API_NAME => L_API_NAME
83: ,P_PKG_NAME => G_PKG_NAME
84: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 234: WHEN FND_API.G_EXC_ERROR THEN

230: END IF ;
231:
232: return(TRUE);
233: exception
234: WHEN FND_API.G_EXC_ERROR THEN
235: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
236: P_API_NAME => L_API_NAME
237: ,P_PKG_NAME => G_PKG_NAME
238: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

240: ,X_MSG_COUNT => X_MSG_COUNT
241: ,X_MSG_DATA => X_MSG_DATA
242: ,X_RETURN_STATUS => X_RETURN_STATUS);
243: return FALSE;
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
246: P_API_NAME => L_API_NAME
247: ,P_PKG_NAME => G_PKG_NAME
248: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 331: x_return_status := FND_API.G_RET_STS_SUCCESS;

327:
328: BEGIN
329: SAVEPOINT receive_shipments_pvt;
330: MO_GLOBAL.init('CSF');
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:
333: -- Standard call to check for call compatibility.
334: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
335: p_api_version_number,

Line 334: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

330: MO_GLOBAL.init('CSF');
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:
333: -- Standard call to check for call compatibility.
334: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
335: p_api_version_number,
336: l_api_name,
337: G_PKG_NAME)
338: THEN

Line 339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

335: p_api_version_number,
336: l_api_name,
337: G_PKG_NAME)
338: THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341:
342:
343: -- Initialize message list

Line 344: IF fnd_api.to_boolean(p_init_msg_list) THEN

340: END IF;
341:
342:
343: -- Initialize message list
344: IF fnd_api.to_boolean(p_init_msg_list) THEN
345: fnd_msg_pub.initialize;
346: END IF;
347:
348:

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: END IF;
347:
348:
349: -- Initialize API return status to SUCCESS
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: If NOT get_employee (l_employee_id,
353: l_employee_name,
354: l_location_id ,

Line 360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

356: l_is_buyer ,
357: l_emp_flag
358: ) Then
359: GET_MESSAGES(x_msg_data);
360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: End If;
362:
363: --
364: -- API body

Line 368: ,P_init_Msg_List => FND_API.G_FALSE

364: -- API body
365: --
366: insert_rcv_hdr_interface
367: (P_Api_Version_Number => 1.0
368: ,P_init_Msg_List => FND_API.G_FALSE
369: ,P_Commit => FND_API.G_FALSE
370: ,P_Validation_Level => p_validation_level
371: ,X_Return_Status => X_return_Status
372: ,X_Msg_Count => X_Msg_Count

Line 369: ,P_Commit => FND_API.G_FALSE

365: --
366: insert_rcv_hdr_interface
367: (P_Api_Version_Number => 1.0
368: ,P_init_Msg_List => FND_API.G_FALSE
369: ,P_Commit => FND_API.G_FALSE
370: ,P_Validation_Level => p_validation_level
371: ,X_Return_Status => X_return_Status
372: ,X_Msg_Count => X_Msg_Count
373: ,X_Msg_Data => X_Msg_Data

Line 397: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

393: ,p_customer_id => p_receive_hdr_rec.customer_id
394: ,p_customer_site_id => p_receive_hdr_rec.customer_site_id
395: ,x_header_interface_id => l_header_interface_id
396: ,x_group_id => l_group_id);
397: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
398: Get_Messages(X_MSG_DATA);
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: End If;
401: FOR i in 1..p_receive_rec_tbl.COUNT LOOP

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395: ,x_header_interface_id => l_header_interface_id
396: ,x_group_id => l_group_id);
397: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
398: Get_Messages(X_MSG_DATA);
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: End If;
401: FOR i in 1..p_receive_rec_tbl.COUNT LOOP
402:
403: If p_receive_rec_tbl(i).inv_loc_assignment_id is not null Then

Line 425: ,P_init_Msg_List => FND_API.G_FALSE

421: l_rcv_transaction_rec.item_id,
422: l_rcv_transaction_rec.primary_uom);
423: insert_rcv_txn_interface
424: (P_Api_Version_Number => 1.0
425: ,P_init_Msg_List => FND_API.G_FALSE
426: ,P_Commit => FND_API.G_FALSE
427: ,P_Validation_Level => p_Validation_Level
428: ,X_Return_Status => X_return_Status
429: ,X_Msg_Count => X_Msg_Count

Line 426: ,P_Commit => FND_API.G_FALSE

422: l_rcv_transaction_rec.primary_uom);
423: insert_rcv_txn_interface
424: (P_Api_Version_Number => 1.0
425: ,P_init_Msg_List => FND_API.G_FALSE
426: ,P_Commit => FND_API.G_FALSE
427: ,P_Validation_Level => p_Validation_Level
428: ,X_Return_Status => X_return_Status
429: ,X_Msg_Count => X_Msg_Count
430: ,X_Msg_Data => X_Msg_Data

Line 434: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

430: ,X_Msg_Data => X_Msg_Data
431: ,x_interface_transaction_id => x_interface_transaction_id
432: ,p_receive_rec => l_rcv_transaction_rec);
433:
434: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
435: Get_Messages(X_MSG_DATA);
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: End If;
438: l_serial_interface_inserted := FALSE;

Line 436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

432: ,p_receive_rec => l_rcv_transaction_rec);
433:
434: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
435: Get_Messages(X_MSG_DATA);
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: End If;
438: l_serial_interface_inserted := FALSE;
439: l_serial_interface_id := null;
440: l_lot_interface_id := null;

Line 445: , p_init_msg_list => FND_API.G_FALSE

441: -- Lot/Serial
442: If p_receive_rec_tbl(i).fm_serial_number is not null then
443: insert_serial_interface (
444: p_api_version => 1.0
445: , p_init_msg_list => FND_API.G_FALSE
446: , x_return_status => x_return_status
447: , x_msg_count => x_msg_count
448: , x_msg_data => x_msg_data
449: , px_transaction_interface_id => l_serial_interface_id

Line 454: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

450: , p_product_transaction_id => x_interface_transaction_id
451: , p_product_code => p_receive_rec_tbl(i).product_code
452: , p_fm_serial_number => p_receive_rec_tbl(i).fm_serial_number
453: , p_to_serial_number => p_receive_rec_tbl(i).to_serial_number);
454: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
455: Get_Messages(X_MSG_DATA);
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: End If;
458: end if;

Line 456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

452: , p_fm_serial_number => p_receive_rec_tbl(i).fm_serial_number
453: , p_to_serial_number => p_receive_rec_tbl(i).to_serial_number);
454: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
455: Get_Messages(X_MSG_DATA);
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: End If;
458: end if;
459: If p_receive_rec_tbl(i).lot_number is not null then
460: insert_lots_interface (

Line 462: , p_init_msg_list => FND_API.G_FALSE

458: end if;
459: If p_receive_rec_tbl(i).lot_number is not null then
460: insert_lots_interface (
461: p_api_version => 1.0
462: , p_init_msg_list => FND_API.G_FALSE
463: , x_return_status => x_return_status
464: , x_msg_count => x_msg_count
465: , x_msg_data => x_msg_data
466: , p_transaction_interface_id => l_lot_interface_id

Line 475: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

471: , p_inventory_item_id => p_receive_rec_tbl(i).item_id
472: , p_serial_transaction_temp_id => l_serial_interface_id
473: , p_product_transaction_id => x_interface_transaction_id
474: , p_product_code => p_receive_rec_tbl(i).product_code);
475: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
476: Get_Messages(X_MSG_DATA);
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: End If;
479: End If;

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

473: , p_product_transaction_id => x_interface_transaction_id
474: , p_product_code => p_receive_rec_tbl(i).product_code);
475: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
476: Get_Messages(X_MSG_DATA);
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: End If;
479: End If;
480:
481: END LOOP;

Line 491: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

487: --- Process the interface record
488: rcv_online_request (p_group_id => l_group_id,
489: x_return_status => x_return_status,
490: x_msg_data => x_msg_data);
491: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
492: GET_MESSAGES(x_msg_data);
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: End If;
495: --- Commit;

Line 493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

489: x_return_status => x_return_status,
490: x_msg_data => x_msg_data);
491: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
492: GET_MESSAGES(x_msg_data);
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: End If;
495: --- Commit;
496: COMMIT;
497: EXCEPTION

Line 498: WHEN FND_API.G_EXC_ERROR THEN

494: End If;
495: --- Commit;
496: COMMIT;
497: EXCEPTION
498: WHEN FND_API.G_EXC_ERROR THEN
499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
500: P_API_NAME => L_API_NAME
501: ,P_PKG_NAME => G_PKG_NAME
502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
504: ,X_MSG_COUNT => X_MSG_COUNT
505: ,X_MSG_DATA => X_MESSAGE
506: ,X_RETURN_STATUS => X_RETURN_STATUS);
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 577: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

573: BEGIN
574: SAVEPOINT insert_rcv_hdr_interface_pvt;
575:
576: -- Standard call to check for call compatibility.
577: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
578: p_api_version_number,
579: l_api_name,
580: G_PKG_NAME)
581: THEN

Line 582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

578: p_api_version_number,
579: l_api_name,
580: G_PKG_NAME)
581: THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 586: IF fnd_api.to_boolean(p_init_msg_list) THEN

582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF fnd_api.to_boolean(p_init_msg_list) THEN
587: fnd_msg_pub.initialize;
588: END IF;
589:
590: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 590: x_return_status := FND_API.G_RET_STS_SUCCESS;

586: IF fnd_api.to_boolean(p_init_msg_list) THEN
587: fnd_msg_pub.initialize;
588: END IF;
589:
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591:
592:
593: l_header_interface_id := p_header_interface_id;
594: If (l_header_interface_id IS NULL) THEN

Line 614: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then

610: , p_organization_id => p_ship_to_org_id
611: , x_return_status => x_return_status
612: , x_msg_count => x_msg_count
613: , x_msg_data => x_msg_data);
614: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
615: GET_MESSAGES(x_msg_data);
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: End If;
618: End If;

Line 616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

612: , x_msg_count => x_msg_count
613: , x_msg_data => x_msg_data);
614: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
615: GET_MESSAGES(x_msg_data);
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: End If;
618: End If;
619: IF p_source_type_code = 'INTERNAL' THEN
620: l_receipt_header_id := p_receipt_header_id;

Line 692: WHEN FND_API.G_EXC_ERROR THEN

688: x_header_interface_id := l_header_interface_id;
689: x_group_id := l_group_id;
690:
691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN
693: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
694: P_API_NAME => L_API_NAME
695: ,P_PKG_NAME => G_PKG_NAME
696: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

697: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
698: ,X_MSG_COUNT => X_MSG_COUNT
699: ,X_MSG_DATA => X_MSG_DATA
700: ,X_RETURN_STATUS => X_RETURN_STATUS);
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
703: P_API_NAME => L_API_NAME
704: ,P_PKG_NAME => G_PKG_NAME
705: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 846: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

842: BEGIN
843: SAVEPOINT insert_rcv_txn_interface_pvt;
844:
845: -- Standard call to check for call compatibility.
846: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
847: p_api_version_number,
848: l_api_name,
849: G_PKG_NAME)
850: THEN

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

847: p_api_version_number,
848: l_api_name,
849: G_PKG_NAME)
850: THEN
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853:
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 855: IF fnd_api.to_boolean(p_init_msg_list) THEN

851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853:
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: IF fnd_api.to_boolean(p_init_msg_list) THEN
856: fnd_msg_pub.initialize;
857: END IF;
858:
859: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 859: x_return_status := FND_API.G_RET_STS_SUCCESS;

855: IF fnd_api.to_boolean(p_init_msg_list) THEN
856: fnd_msg_pub.initialize;
857: END IF;
858:
859: x_return_status := FND_API.G_RET_STS_SUCCESS;
860:
861: l_rcv_transaction_rec := p_receive_rec;
862:
863: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;

Line 934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

930: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);
931: fnd_message.set_token('SQLERRM',sqlerrm,false);
932: fnd_msg_pub.add;
933: get_messages(x_msg_data);
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END;
936:
937:
938: IF (NOT x_valid_ship_to_location) THEN

Line 957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

953: fnd_message.set_token('ROUTINE','get receiving flag',false);
954: fnd_message.set_token('SQLERRM',sqlerrm,false);
955: fnd_msg_pub.add;
956: get_messages(x_msg_data);
957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
958: END;
959:
960: IF l_blind_receiving_flag = 'Y' THEN
961: l_rcv_transaction_rec.ordered_qty := 0;

Line 1422: WHEN FND_API.G_EXC_ERROR THEN

1418: );
1419:
1420: x_interface_transaction_id := l_interface_transaction_id;
1421: EXCEPTION
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1424: P_API_NAME => L_API_NAME
1425: ,P_PKG_NAME => G_PKG_NAME
1426: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1427: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1428: ,X_MSG_COUNT => X_MSG_COUNT
1429: ,X_MSG_DATA => X_MESSAGE
1430: ,X_RETURN_STATUS => X_RETURN_STATUS);
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1433: P_API_NAME => L_API_NAME
1434: ,P_PKG_NAME => G_PKG_NAME
1435: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1632: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

1628:
1629: BEGIN
1630:
1631: -- Standard call to check for call compatibility.
1632: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1633: l_api_name, G_PKG_NAME) THEN
1634: RAISE fnd_api.g_exc_unexpected_error;
1635: END IF;
1636:

Line 1634: RAISE fnd_api.g_exc_unexpected_error;

1630:
1631: -- Standard call to check for call compatibility.
1632: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1633: l_api_name, G_PKG_NAME) THEN
1634: RAISE fnd_api.g_exc_unexpected_error;
1635: END IF;
1636:
1637: -- Initialize message list if p_init_msg_list is set to TRUE.
1638: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1638: IF fnd_api.to_boolean(p_init_msg_list) THEN

1634: RAISE fnd_api.g_exc_unexpected_error;
1635: END IF;
1636:
1637: -- Initialize message list if p_init_msg_list is set to TRUE.
1638: IF fnd_api.to_boolean(p_init_msg_list) THEN
1639: fnd_msg_pub.initialize;
1640: END IF;
1641:
1642: --Initialize the return status

Line 1643: x_return_status := FND_API.G_RET_STS_SUCCESS;

1639: fnd_msg_pub.initialize;
1640: END IF;
1641:
1642: --Initialize the return status
1643: x_return_status := FND_API.G_RET_STS_SUCCESS;
1644:
1645: l_transaction_interface_id := p_transaction_interface_id;
1646: If (l_transaction_interface_id IS NULL) THEN
1647: SELECT mtl_material_transactions_s.NEXTVAL

Line 1897: WHEN FND_API.G_EXC_ERROR THEN

1893: , l_territory_code
1894: );
1895:
1896: EXCEPTION
1897: WHEN FND_API.G_EXC_ERROR THEN
1898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1899: P_API_NAME => L_API_NAME
1900: ,P_PKG_NAME => G_PKG_NAME
1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1903: ,X_MSG_COUNT => X_MSG_COUNT
1904: ,X_MSG_DATA => X_MESSAGE
1905: ,X_RETURN_STATUS => X_RETURN_STATUS);
1906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1907: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1997: IF NOT fnd_api.compatible_api_call(l_api_version,

1993: x_message varchar2(4000);
1994: BEGIN
1995:
1996: -- Standard call to check for call compatibility.
1997: IF NOT fnd_api.compatible_api_call(l_api_version,
1998: p_api_version,
1999: l_api_name,
2000: G_PKG_NAME) THEN
2001: RAISE fnd_api.g_exc_unexpected_error;

Line 2001: RAISE fnd_api.g_exc_unexpected_error;

1997: IF NOT fnd_api.compatible_api_call(l_api_version,
1998: p_api_version,
1999: l_api_name,
2000: G_PKG_NAME) THEN
2001: RAISE fnd_api.g_exc_unexpected_error;
2002: END IF;
2003:
2004: -- Initialize message list if p_init_msg_list is set to TRUE.
2005: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2005: IF fnd_api.to_boolean(p_init_msg_list) THEN

2001: RAISE fnd_api.g_exc_unexpected_error;
2002: END IF;
2003:
2004: -- Initialize message list if p_init_msg_list is set to TRUE.
2005: IF fnd_api.to_boolean(p_init_msg_list) THEN
2006: fnd_msg_pub.initialize;
2007: END IF;
2008:
2009: --Initialize the return status

Line 2010: x_return_status := fnd_api.g_ret_sts_success;

2006: fnd_msg_pub.initialize;
2007: END IF;
2008:
2009: --Initialize the return status
2010: x_return_status := fnd_api.g_ret_sts_success;
2011:
2012: --Generate transaction_interface_id if necessary
2013: l_transaction_interface_id := px_transaction_interface_id;
2014: IF (l_transaction_interface_id IS NULL) THEN

Line 2055: WHEN FND_API.G_EXC_ERROR THEN

2051: px_transaction_interface_id := l_transaction_interface_id;
2052:
2053:
2054: EXCEPTION
2055: WHEN FND_API.G_EXC_ERROR THEN
2056: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2057: P_API_NAME => L_API_NAME
2058: ,P_PKG_NAME => G_PKG_NAME
2059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2060: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2061: ,X_MSG_COUNT => X_MSG_COUNT
2062: ,X_MSG_DATA => X_MESSAGE
2063: ,X_RETURN_STATUS => X_RETURN_STATUS);
2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2065: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2066: P_API_NAME => L_API_NAME
2067: ,P_PKG_NAME => G_PKG_NAME
2068: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2097: l_return_status VARCHAR2(5) := fnd_api.g_ret_sts_success;

2093: l_api_name varchar2(20) := 'rcv_online_request';
2094: l_timeout NUMBER := 300;
2095: l_outcome VARCHAR2(200) := NULL;
2096: l_message VARCHAR2(2000) := NULL;
2097: l_return_status VARCHAR2(5) := fnd_api.g_ret_sts_success;
2098: l_msg_count NUMBER;
2099: x_str varchar2(6000) := NULL;
2100: DELETE_ROWS BOOLEAN := FALSE;
2101: r_val1 varchar2(300) := NULL;

Line 2125: x_return_status := fnd_api.g_ret_sts_success;

2121: l_progress VARCHAR2(10) := '10';
2122: x_msg_count number;
2123: po_message varchar2(2000);
2124: BEGIN
2125: x_return_status := fnd_api.g_ret_sts_success;
2126: -- debug_handler := UTL_FILE.FOPEN('/slot06/oracle/SCMC1MQ1db/9.2.0/temp', 'FieldServicePortal.log','a');
2127:
2128:
2129: rc := fnd_transaction.synchronous

Line 2149: x_return_status := fnd_api.g_ret_sts_error;

2145: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2146: fnd_message.set_token('REQUEST', p_group_id);
2147: fnd_message.set_token('REASON', x_str);
2148: fnd_msg_pub.ADD;
2149: x_return_status := fnd_api.g_ret_sts_error;
2150: ELSIF (rc = 2) THEN
2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');

Line 2157: x_return_status := fnd_api.g_ret_sts_error;

2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2154: fnd_message.set_token('REQUEST', p_group_id);
2155: fnd_message.set_token('REASON', x_str);
2156: fnd_msg_pub.ADD;
2157: x_return_status := fnd_api.g_ret_sts_error;
2158: ELSIF (rc = 3 or
2159: (l_outcome IN ('WARNING', 'ERROR'))) THEN
2160: BEGIN
2161: select ERROR_MESSAGE INTO po_message

Line 2171: x_return_status := fnd_api.g_ret_sts_error;

2167: and PROCESSING_STATUS_CODE = 'ERROR' ;
2168: FND_MESSAGE.set_name('CSP','CSP_PO_RECEIVE_ERROR');
2169: fnd_message.set_token('ERROR_MESSAGE', po_message );
2170: fnd_msg_pub.ADD;
2171: x_return_status := fnd_api.g_ret_sts_error;
2172: Exception
2173: when NO_DATA_FOUND THEN
2174:
2175: rc := fnd_transaction.get_values

Line 2265: x_return_status := fnd_api.g_ret_sts_error;

2261: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2262: fnd_message.set_token('REQUEST', p_group_id);
2263: fnd_message.set_token('REASON', x_str);
2264: fnd_msg_pub.ADD;
2265: x_return_status := fnd_api.g_ret_sts_error;
2266: END;
2267: END IF;
2268: EXCEPTION
2269: WHEN OTHERS THEN

Line 2274: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2270: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2271: fnd_message.set_token('ROUTINE',l_api_name,FALSE);
2272: fnd_message.set_token('SQLERRM',sqlerrm,FALSE);
2273: fnd_msg_pub.add;
2274: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2275: END rcv_online_request;
2276:
2277: /*
2278: Function : USER_INPUT_REQUIRED