DBA Data[Home] [Help]

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 237: -- Standard IN Parameters :

233: -- Updates OSP table with request id batch id and interface header id
234: -- Pre-reqs :
235: -- Parameters :
236: --
237: -- Standard IN Parameters :
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
240: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 245: -- Standard OUT Parameters :

241: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
242: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
243: -- p_module_type IN VARCHAR2 Default NULL.
244: --
245: -- Standard OUT Parameters :
246: -- x_return_status OUT VARCHAR2 Required
247: -- x_msg_count OUT NUMBER Required
248: -- x_msg_data OUT VARCHAR2 Required
249: --

Line 384: -- Standard start of API savepoint

380: l_curr_status AHL_OSP_ORDERS_B.STATUS_CODE%TYPE;
381:
382: BEGIN
383:
384: -- Standard start of API savepoint
385: SAVEPOINT Create_Purchase_Order_pvt;
386:
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

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

387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
389: END IF;
390:
391: -- Standard call to check for call compatibility
392: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
393: G_PKG_NAME) THEN
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;

Line 582: -- Standard check of p_commit

578: p_src_doc_type_code => G_DOC_TYPE_OSP,
579: p_dest_doc_id => l_batch_id,
580: p_dest_doc_type_code => G_DOC_TYPE_PO);
581:
582: -- Standard check of p_commit
583: IF FND_API.TO_BOOLEAN(p_commit) THEN
584: --dbms_output.put_line('About to commit work ');
585: COMMIT WORK;
586: END IF;

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

584: --dbms_output.put_line('About to commit work ');
585: COMMIT WORK;
586: END IF;
587:
588: -- Standard call to get message count and if count is 1, get message info
589: FND_MSG_PUB.Count_And_Get
590: ( p_count => x_msg_count,
591: p_data => x_msg_data,
592: p_encoded => fnd_api.g_false

Line 645: -- Standard IN Parameters :

641: -- or if there is no corresponding PO yet.
642: -- Pre-reqs :
643: -- Parameters :
644: --
645: -- Standard IN Parameters :
646: -- p_api_version IN NUMBER Required
647: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
648: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
649: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 653: -- Standard OUT Parameters :

649: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
650: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
651: -- p_module_type IN VARCHAR2 Default NULL.
652: --
653: -- Standard OUT Parameters :
654: -- x_return_status OUT VARCHAR2 Required
655: -- x_msg_count OUT NUMBER Required
656: -- x_msg_data OUT VARCHAR2 Required
657: --

Line 701: -- Standard start of API savepoint

697: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
699: END IF;
700:
701: -- Standard start of API savepoint
702: SAVEPOINT Associate_OSP_With_PO_pvt;
703:
704: -- Standard call to check for call compatibility
705: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

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

700:
701: -- Standard start of API savepoint
702: SAVEPOINT Associate_OSP_With_PO_pvt;
703:
704: -- Standard call to check for call compatibility
705: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
706: G_PKG_NAME) THEN
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END IF;

Line 779: -- Standard check of p_commit

775: IF x_msg_count > 0 THEN
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778:
779: -- Standard check of p_commit
780: IF FND_API.TO_BOOLEAN(p_commit) THEN
781: --dbms_output.put_line('About to commit');
782: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to commit');

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

784: END IF;
785: COMMIT WORK;
786: END IF;
787:
788: -- Standard call to get message count and if count is 1, get message info
789: FND_MSG_PUB.Count_And_Get
790: ( p_count => x_msg_count,
791: p_data => x_msg_data,
792: p_encoded => fnd_api.g_false

Line 839: -- Standard IN Parameters :

835: -- PO_LINE_ID respectively for all submitted OSP Orders.
836: -- Pre-reqs :
837: -- Parameters :
838: --
839: -- Standard IN Parameters :
840: -- p_api_version IN NUMBER Required
841: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
842: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
843: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 847: -- Standard OUT Parameters :

843: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
844: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
845: -- p_module_type IN VARCHAR2 Default NULL.
846: --
847: -- Standard OUT Parameters :
848: -- x_return_status OUT VARCHAR2 Required
849: -- x_msg_count OUT NUMBER Required
850: -- x_msg_data OUT VARCHAR2 Required
851: --

Line 889: -- Standard start of API savepoint

885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
887: END IF;
888:
889: -- Standard start of API savepoint
890: SAVEPOINT Associate_All_OSP_POs_pvt;
891:
892: -- Standard call to check for call compatibility
893: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

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

888:
889: -- Standard start of API savepoint
890: SAVEPOINT Associate_All_OSP_POs_pvt;
891:
892: -- Standard call to check for call compatibility
893: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
894: G_PKG_NAME) THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;

Line 936: -- Standard check of p_commit

932: IF x_msg_count > 0 THEN
933: RAISE FND_API.G_EXC_ERROR;
934: END IF;
935:
936: -- Standard check of p_commit
937: IF FND_API.TO_BOOLEAN(p_commit) THEN
938: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
939: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to COMMIT work.');
940: END IF;

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

940: END IF;
941: COMMIT WORK;
942: END IF;
943:
944: -- Standard call to get message count and if count is 1, get message info
945: FND_MSG_PUB.Count_And_Get
946: ( p_count => x_msg_count,
947: p_data => x_msg_data,
948: p_encoded => fnd_api.g_false

Line 996: -- Standard IN Parameters :

992: -- 5. Handles Approved POs (Books Shipment, notifies shipper?)
993: -- Pre-reqs :
994: -- Parameters :
995: --
996: -- Standard IN Parameters :
997: -- p_api_version IN NUMBER Required
998: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
999: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1000: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1004: -- Standard OUT Parameters :

1000: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1001: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1002: -- p_module_type IN VARCHAR2 Default NULL.
1003: --
1004: -- Standard OUT Parameters :
1005: -- x_return_status OUT VARCHAR2 Required
1006: -- x_msg_count OUT NUMBER Required
1007: -- x_msg_data OUT VARCHAR2 Required
1008: --

Line 1042: -- Standard start of API savepoint

1038: END IF;
1039:
1040: -- No need of a Savepoint: Individual procedures commit or rollback
1041: -- within themselves.
1042: -- Standard start of API savepoint
1043: --SAVEPOINT PO_Synch_All_OSPs_pvt;
1044:
1045: -- Standard call to check for call compatibility
1046: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

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

1041: -- within themselves.
1042: -- Standard start of API savepoint
1043: --SAVEPOINT PO_Synch_All_OSPs_pvt;
1044:
1045: -- Standard call to check for call compatibility
1046: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1047: G_PKG_NAME) THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;

Line 1189: -- Standard check of p_commit

1185: IF x_msg_count > 0 THEN
1186: RAISE FND_API.G_EXC_ERROR; --Note that commit might already have taken place
1187: END IF;
1188:
1189: -- Standard check of p_commit
1190: -- No need to commit: Individual procedures commit or rollback
1191: -- within themselves.
1192: -- IF FND_API.TO_BOOLEAN(p_commit) THEN
1193: -- COMMIT WORK; --Note that commit might already have taken place

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

1192: -- IF FND_API.TO_BOOLEAN(p_commit) THEN
1193: -- COMMIT WORK; --Note that commit might already have taken place
1194: -- END IF;
1195:
1196: -- Standard call to get message count and if count is 1, get message info
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_count => x_msg_count,
1199: p_data => x_msg_data,
1200: p_encoded => fnd_api.g_false

Line 1809: G_DOC_TYPE_CODE, -- 'STANDARD'

1805: l_batch_id,
1806: AHL_GLOBAL.AHL_APP_SHORT_NAME, -- INTERFACE_SOURCE_CODE = 'AHL'
1807: G_PROCESS_CODE, -- 'PENDING'
1808: G_ACTION_CODE, -- 'ORIGINAL'
1809: G_DOC_TYPE_CODE, -- 'STANDARD'
1810: l_currency_code,
1811: p_po_header_rec.BUYER_ID,
1812: p_po_header_rec.VENDOR_ID,
1813: p_po_header_rec.VENDOR_SITE_ID,

Line 2293: -- Standard start of API savepoint

2289: BEGIN
2290: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2291: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2292: END IF;
2293: -- Standard start of API savepoint
2294: SAVEPOINT Handle_Cancelled_PO_Lines_pvt;
2295:
2296: -- Initialize API return status to success
2297: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2443: -- Standard start of API savepoint

2439: BEGIN
2440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2442: END IF;
2443: -- Standard start of API savepoint
2444: SAVEPOINT Handle_Deleted_PO_Lines_pvt;
2445:
2446: -- Initialize API return status to success
2447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2588: -- Standard start of API savepoint

2584: BEGIN
2585: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2587: END IF;
2588: -- Standard start of API savepoint
2589: SAVEPOINT Handle_Approved_POs_pvt;
2590:
2591: -- Initialize API return status to success
2592: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2717: -- Standard start of API savepoint

2713: BEGIN
2714: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2715: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2716: END IF;
2717: -- Standard start of API savepoint
2718: SAVEPOINT Handle_Deleted_PO_Headers_pvt;
2719:
2720: -- Initialize API return status to success
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2854: -- Standard start of API savepoint

2850: BEGIN
2851: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2853: END IF;
2854: -- Standard start of API savepoint
2855: SAVEPOINT Handle_Deleted_SOs_pvt;
2856:
2857: -- Initialize API return status to success
2858: x_return_status := FND_API.G_RET_STS_SUCCESS;