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.AHL_OSP_PO_PVT dependencies on STANDARD

Line 18: G_DOC_TYPE_CODE CONSTANT VARCHAR2(30) := 'STANDARD';

14: G_PDOI_CODE CONSTANT VARCHAR2(30) := 'POXPOPDOI';
15: G_AHL_OSP_PREFIX CONSTANT VARCHAR2(30) := 'AHL OSP Order ';
16: G_PROCESS_CODE CONSTANT VARCHAR2(30) := 'PENDING';
17: G_ACTION_CODE CONSTANT VARCHAR2(30) := 'ORIGINAL';
18: G_DOC_TYPE_CODE CONSTANT VARCHAR2(30) := 'STANDARD';
19: G_INCOMPLETE_STATUS CONSTANT VARCHAR2(30) := 'INCOMPLETE';
20:
21: G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';
22: G_YES_FLAG CONSTANT VARCHAR2(1) := 'Y';

Line 229: -- Standard IN Parameters :

225: -- Updates OSP table with request id batch id and interface header id
226: -- Pre-reqs :
227: -- Parameters :
228: --
229: -- Standard IN Parameters :
230: -- p_api_version IN NUMBER Required
231: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
232: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
233: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 237: -- Standard OUT Parameters :

233: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
234: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
235: -- p_module_type IN VARCHAR2 Default NULL.
236: --
237: -- Standard OUT Parameters :
238: -- x_return_status OUT VARCHAR2 Required
239: -- x_msg_count OUT NUMBER Required
240: -- x_msg_data OUT VARCHAR2 Required
241: --

Line 376: -- Standard start of API savepoint

372: l_curr_status AHL_OSP_ORDERS_B.STATUS_CODE%TYPE;
373:
374: BEGIN
375:
376: -- Standard start of API savepoint
377: SAVEPOINT Create_Purchase_Order_pvt;
378:
379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

Line 383: -- Standard call to check for call compatibility

379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
381: END IF;
382:
383: -- Standard call to check for call compatibility
384: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
385: G_PKG_NAME) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;

Line 574: -- Standard check of p_commit

570: p_src_doc_type_code => G_DOC_TYPE_OSP,
571: p_dest_doc_id => l_batch_id,
572: p_dest_doc_type_code => G_DOC_TYPE_PO);
573:
574: -- Standard check of p_commit
575: IF FND_API.TO_BOOLEAN(p_commit) THEN
576: --dbms_output.put_line('About to commit work ');
577: COMMIT WORK;
578: END IF;

Line 580: -- Standard call to get message count and if count is 1, get message info

576: --dbms_output.put_line('About to commit work ');
577: COMMIT WORK;
578: END IF;
579:
580: -- Standard call to get message count and if count is 1, get message info
581: FND_MSG_PUB.Count_And_Get
582: ( p_count => x_msg_count,
583: p_data => x_msg_data,
584: p_encoded => fnd_api.g_false

Line 637: -- Standard IN Parameters :

633: -- or if there is no corresponding PO yet.
634: -- Pre-reqs :
635: -- Parameters :
636: --
637: -- Standard IN Parameters :
638: -- p_api_version IN NUMBER Required
639: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
640: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
641: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 645: -- Standard OUT Parameters :

641: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
642: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
643: -- p_module_type IN VARCHAR2 Default NULL.
644: --
645: -- Standard OUT Parameters :
646: -- x_return_status OUT VARCHAR2 Required
647: -- x_msg_count OUT NUMBER Required
648: -- x_msg_data OUT VARCHAR2 Required
649: --

Line 693: -- Standard start of API savepoint

689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
691: END IF;
692:
693: -- Standard start of API savepoint
694: SAVEPOINT Associate_OSP_With_PO_pvt;
695:
696: -- Standard call to check for call compatibility
697: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 696: -- Standard call to check for call compatibility

692:
693: -- Standard start of API savepoint
694: SAVEPOINT Associate_OSP_With_PO_pvt;
695:
696: -- Standard call to check for call compatibility
697: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
698: G_PKG_NAME) THEN
699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
700: END IF;

Line 771: -- Standard check of p_commit

767: IF x_msg_count > 0 THEN
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770:
771: -- Standard check of p_commit
772: IF FND_API.TO_BOOLEAN(p_commit) THEN
773: --dbms_output.put_line('About to commit');
774: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
775: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to commit');

Line 780: -- Standard call to get message count and if count is 1, get message info

776: END IF;
777: COMMIT WORK;
778: END IF;
779:
780: -- Standard call to get message count and if count is 1, get message info
781: FND_MSG_PUB.Count_And_Get
782: ( p_count => x_msg_count,
783: p_data => x_msg_data,
784: p_encoded => fnd_api.g_false

Line 831: -- Standard IN Parameters :

827: -- PO_LINE_ID respectively for all submitted OSP Orders.
828: -- Pre-reqs :
829: -- Parameters :
830: --
831: -- Standard IN Parameters :
832: -- p_api_version IN NUMBER Required
833: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
834: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
835: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 839: -- Standard OUT Parameters :

835: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
836: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
837: -- p_module_type IN VARCHAR2 Default NULL.
838: --
839: -- Standard OUT Parameters :
840: -- x_return_status OUT VARCHAR2 Required
841: -- x_msg_count OUT NUMBER Required
842: -- x_msg_data OUT VARCHAR2 Required
843: --

Line 881: -- Standard start of API savepoint

877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
879: END IF;
880:
881: -- Standard start of API savepoint
882: SAVEPOINT Associate_All_OSP_POs_pvt;
883:
884: -- Standard call to check for call compatibility
885: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 884: -- Standard call to check for call compatibility

880:
881: -- Standard start of API savepoint
882: SAVEPOINT Associate_All_OSP_POs_pvt;
883:
884: -- Standard call to check for call compatibility
885: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
886: G_PKG_NAME) THEN
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;

Line 928: -- Standard check of p_commit

924: IF x_msg_count > 0 THEN
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927:
928: -- Standard check of p_commit
929: IF FND_API.TO_BOOLEAN(p_commit) THEN
930: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
931: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to COMMIT work.');
932: END IF;

Line 936: -- Standard call to get message count and if count is 1, get message info

932: END IF;
933: COMMIT WORK;
934: END IF;
935:
936: -- Standard call to get message count and if count is 1, get message info
937: FND_MSG_PUB.Count_And_Get
938: ( p_count => x_msg_count,
939: p_data => x_msg_data,
940: p_encoded => fnd_api.g_false

Line 988: -- Standard IN Parameters :

984: -- 5. Handles Approved POs (Books Shipment, notifies shipper?)
985: -- Pre-reqs :
986: -- Parameters :
987: --
988: -- Standard IN Parameters :
989: -- p_api_version IN NUMBER Required
990: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
991: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
992: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 996: -- Standard OUT Parameters :

992: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
993: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
994: -- p_module_type IN VARCHAR2 Default NULL.
995: --
996: -- Standard OUT Parameters :
997: -- x_return_status OUT VARCHAR2 Required
998: -- x_msg_count OUT NUMBER Required
999: -- x_msg_data OUT VARCHAR2 Required
1000: --

Line 1034: -- Standard start of API savepoint

1030: END IF;
1031:
1032: -- No need of a Savepoint: Individual procedures commit or rollback
1033: -- within themselves.
1034: -- Standard start of API savepoint
1035: --SAVEPOINT PO_Synch_All_OSPs_pvt;
1036:
1037: -- Standard call to check for call compatibility
1038: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

Line 1037: -- Standard call to check for call compatibility

1033: -- within themselves.
1034: -- Standard start of API savepoint
1035: --SAVEPOINT PO_Synch_All_OSPs_pvt;
1036:
1037: -- Standard call to check for call compatibility
1038: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1039: G_PKG_NAME) THEN
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041: END IF;

Line 1181: -- Standard check of p_commit

1177: IF x_msg_count > 0 THEN
1178: RAISE FND_API.G_EXC_ERROR; --Note that commit might already have taken place
1179: END IF;
1180:
1181: -- Standard check of p_commit
1182: -- No need to commit: Individual procedures commit or rollback
1183: -- within themselves.
1184: -- IF FND_API.TO_BOOLEAN(p_commit) THEN
1185: -- COMMIT WORK; --Note that commit might already have taken place

Line 1188: -- Standard call to get message count and if count is 1, get message info

1184: -- IF FND_API.TO_BOOLEAN(p_commit) THEN
1185: -- COMMIT WORK; --Note that commit might already have taken place
1186: -- END IF;
1187:
1188: -- Standard call to get message count and if count is 1, get message info
1189: FND_MSG_PUB.Count_And_Get
1190: ( p_count => x_msg_count,
1191: p_data => x_msg_data,
1192: p_encoded => fnd_api.g_false

Line 1796: G_DOC_TYPE_CODE, -- 'STANDARD'

1792: l_batch_id,
1793: AHL_GLOBAL.AHL_APP_SHORT_NAME, -- INTERFACE_SOURCE_CODE = 'AHL'
1794: G_PROCESS_CODE, -- 'PENDING'
1795: G_ACTION_CODE, -- 'ORIGINAL'
1796: G_DOC_TYPE_CODE, -- 'STANDARD'
1797: l_currency_code,
1798: p_po_header_rec.BUYER_ID,
1799: p_po_header_rec.VENDOR_ID,
1800: p_po_header_rec.VENDOR_SITE_ID,

Line 2260: -- Standard start of API savepoint

2256: BEGIN
2257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2259: END IF;
2260: -- Standard start of API savepoint
2261: SAVEPOINT Handle_Cancelled_PO_Lines_pvt;
2262:
2263: -- Initialize API return status to success
2264: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2410: -- Standard start of API savepoint

2406: BEGIN
2407: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2408: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2409: END IF;
2410: -- Standard start of API savepoint
2411: SAVEPOINT Handle_Deleted_PO_Lines_pvt;
2412:
2413: -- Initialize API return status to success
2414: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2555: -- Standard start of API savepoint

2551: BEGIN
2552: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2554: END IF;
2555: -- Standard start of API savepoint
2556: SAVEPOINT Handle_Approved_POs_pvt;
2557:
2558: -- Initialize API return status to success
2559: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2684: -- Standard start of API savepoint

2680: BEGIN
2681: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2682: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2683: END IF;
2684: -- Standard start of API savepoint
2685: SAVEPOINT Handle_Deleted_PO_Headers_pvt;
2686:
2687: -- Initialize API return status to success
2688: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2821: -- Standard start of API savepoint

2817: BEGIN
2818: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2819: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2820: END IF;
2821: -- Standard start of API savepoint
2822: SAVEPOINT Handle_Deleted_SOs_pvt;
2823:
2824: -- Initialize API return status to success
2825: x_return_status := FND_API.G_RET_STS_SUCCESS;