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

Line 167: /* STANDARD PARAMETERS */

163: /* Function name: DEBUG */
164: /* Description : Logs the debug message */
165: /* Called from : Called from Update API */
166: /* */
167: /* STANDARD PARAMETERS */
168: /* In Parameters : */
169: /* p_message Required Debug message that needs to be logged */
170: /* p_mod_name Required Module name */
171: /* p_severity_level Required Severity level */

Line 173: /* NON-STANDARD PARAMETERS */

169: /* p_message Required Debug message that needs to be logged */
170: /* p_mod_name Required Module name */
171: /* p_severity_level Required Severity level */
172: /* Output Parameters: */
173: /* NON-STANDARD PARAMETERS */
174: /* In Parameters */
175: /* Out parameters */
176: /* Change Hist : */
177: /* 09/20/03 vlakaman Initial Creation. */

Line 229: /* STANDARD PARAMETERS */

225: /* Function name: INIT_ACTIVITY_REC */
226: /* Description : Initialize the activity record */
227: /* Called from : Called from Update API */
228: /* */
229: /* STANDARD PARAMETERS */
230: /* In Parameters : */
231: /* Output Parameters: */
232: /* NON-STANDARD PARAMETERS */
233: /* In Parameters */

Line 232: /* NON-STANDARD PARAMETERS */

228: /* */
229: /* STANDARD PARAMETERS */
230: /* In Parameters : */
231: /* Output Parameters: */
232: /* NON-STANDARD PARAMETERS */
233: /* In Parameters */
234: /* Out parameters */
235: /* Change Hist : */
236: /* 09/20/03 vlakaman Initial Creation. */

Line 312: /* STANDARD PARAMETERS */

308: /* Logistics lines could be created with different UOM than the one on */
309: /* repair order */
310: /* Called from : Called from Update API (SO_RCV_UPDATE,SO_SHIP_UPDATE) */
311: /* */
312: /* STANDARD PARAMETERS */
313: /* In Parameters : */
314: /* */
315: /* Output Parameters: */
316: /* x_return_status VARCHAR2 Return status of the API */

Line 318: /* NON-STANDARD PARAMETERS */

314: /* */
315: /* Output Parameters: */
316: /* x_return_status VARCHAR2 Return status of the API */
317: /* */
318: /* NON-STANDARD PARAMETERS */
319: /* In Parameters */
320: /* p_to_uom VARCHAR2 Required RO Unit of measure */
321: /* p_item_id NUMBER Required Inventory Item Id */
322: /* p_from_uom VARCHAR2 Conditionaly Required Needed for receiving lines */

Line 342: -- Standard variables

338: p_from_quantity IN number,
339: x_result_quantity OUT NOCOPY number
340: ) IS
341:
342: -- Standard variables
343: l_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_RO_UOM';
344: l_api_version CONSTANT NUMBER := 1.0;
345:
346: -- Variables used in the API

Line 354: -- Standard Start of API savepoint

350: l_error_level number := FND_LOG.LEVEL_ERROR;
351: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.convert_to_ro_uom';
352:
353: BEGIN
354: -- Standard Start of API savepoint
355: SAVEPOINT CONV_TO_RO_UOM;
356:
357: -- Initialize API return status to success
358: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 448: /* STANDARD PARAMETERS */

444: /* Procedure name: LOG_ACTIVITY */
445: /* Description : Procedure called for logging activity */
446: /* */
447: /* Called from : Called from all the api */
448: /* STANDARD PARAMETERS */
449: /* In Parameters : */
450: /* p_api_version NUMBER Required Api Version number */
451: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
452: /* p_commit VARCHAR2 Optional Commits in API */

Line 460: /* NON-STANDARD PARAMETERS */

456: /* x_return_status VARCHAR2 Return status of the API */
457: /* x_msg_count NUMBER Number of messages in stack */
458: /* x_msg_data VARCHAR2 Error Message from message stack */
459: /* */
460: /* NON-STANDARD PARAMETERS */
461: /* In Parameters */
462: /* p_activity_rec RECORD TYPE Activity record type */
463: /* Output Parameter : */
464: /* Change Hist : */

Line 479: -- Standard Variables

475: x_msg_data OUT NOCOPY VARCHAR2,
476: p_activity_rec IN activity_rec_type
477: ) IS
478:
479: -- Standard Variables
480: l_api_name CONSTANT VARCHAR2(30) := 'LOG_ACTIVITY';
481: l_api_version CONSTANT NUMBER := 1.0;
482:
483: -- Variables used in API

Line 491: -- Standard Start of API savepoint

487: l_error_level number := FND_LOG.LEVEL_ERROR;
488: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.log_activity';
489:
490: BEGIN
491: -- Standard Start of API savepoint
492: SAVEPOINT LOG_ACTIVITY;
493:
494: -- Initialize API return status to success
495: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 500: -- Standard call to check for call compatibility.

496:
497: -- Debug messages
498: Debug('At the beginning of log_activity api',l_mod_name,1);
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call (l_api_version,
502: p_api_version,
503: l_api_name ,
504: G_PKG_NAME )

Line 613: -- Standard check of p_commit.

609: Debug('Validate_And_Write api failed ',l_mod_name,4);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:
613: -- Standard check of p_commit.
614: IF FND_API.To_Boolean( p_commit ) THEN
615: COMMIT WORK;
616: END IF;
617:

Line 618: -- Standard call to get message count and IF count is get message info.

614: IF FND_API.To_Boolean( p_commit ) THEN
615: COMMIT WORK;
616: END IF;
617:
618: -- Standard call to get message count and IF count is get message info.
619: FND_MSG_PUB.Count_And_Get
620: (p_count => x_msg_count,
621: p_data => x_msg_data );
622: EXCEPTION

Line 658: /* STANDARD PARAMETERS */

654: /* Procedure name: JOB_COMPLETION_UPDATE */
655: /* Description : Procedure called from wip_update API to update the completed qty */
656: /* It also logs activity for the job completion */
657: /* Called from : Called from WIP_Update API */
658: /* STANDARD PARAMETERS */
659: /* In Parameters : */
660: /* p_api_version NUMBER Required Api Version number */
661: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
662: /* p_commit VARCHAR2 Optional Commits in API */

Line 670: /* NON-STANDARD PARAMETERS */

666: /* x_return_status VARCHAR2 Return status of the API */
667: /* x_msg_count NUMBER Number of messages in stack */
668: /* x_msg_data VARCHAR2 Error Message from message stack */
669: /* */
670: /* NON-STANDARD PARAMETERS */
671: /* In Parameters */
672: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
673: /* Output Parm : */
674: /* Change Hist : */

Line 689: -- Standard Variables

685: x_msg_data OUT NOCOPY VARCHAR2,
686: p_repair_line_id IN NUMBER
687: ) IS
688:
689: -- Standard Variables
690: l_api_name CONSTANT VARCHAR2(30) := 'WIP_UPDATE';
691: l_api_version CONSTANT NUMBER := 1.0;
692:
693: -- Variables used in the program

Line 812: -- Standard Start of API savepoint

808: and mtl.transaction_action_id = 31;-- Wip Assembly Completion
809:
810:
811: BEGIN
812: -- Standard Start of API savepoint
813: SAVEPOINT JOB_COMPLETION_UPDATE;
814:
815: -- Initialize API return status to success
816: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 821: -- Standard call to check for call compatibility.

817:
818: -- Debug messages
819: Debug('At the Beginning of JOB_COMPLETION_UPDATE',l_mod_name,1);
820:
821: -- Standard call to check for call compatibility.
822: IF NOT FND_API.Compatible_API_Call (l_api_version,
823: p_api_version,
824: l_api_name ,
825: G_PKG_NAME )

Line 1454: -- Standard check of p_commit.

1450:
1451: -- Debug message
1452: Debug(l_msg_text,l_mod_name,1 );
1453:
1454: -- Standard check of p_commit.
1455: IF FND_API.To_Boolean( p_commit ) THEN
1456: COMMIT WORK;
1457: END IF;
1458:

Line 1459: -- Standard call to get message count and IF count is get message info.

1455: IF FND_API.To_Boolean( p_commit ) THEN
1456: COMMIT WORK;
1457: END IF;
1458:
1459: -- Standard call to get message count and IF count is get message info.
1460: FND_MSG_PUB.Count_And_Get
1461: (p_count => x_msg_count,
1462: p_data => x_msg_data );
1463: EXCEPTION

Line 1499: /* STANDARD PARAMETERS */

1495: /* Procedure name: JOB_CREATION_UPDATE */
1496: /* Description : Procedure called from wip_update API to update the wip entity Id */
1497: /* for the new jobs created by the WIP Mass Load concurrent program */
1498: /* Called from : Called from WIP_Update API */
1499: /* STANDARD PARAMETERS */
1500: /* In Parameters : */
1501: /* p_api_version NUMBER Required Api Version number */
1502: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
1503: /* p_commit VARCHAR2 Optional Commits in API */

Line 1511: /* NON-STANDARD PARAMETERS */

1507: /* x_return_status VARCHAR2 Return status of the API */
1508: /* x_msg_count NUMBER Number of messages in stack */
1509: /* x_msg_data VARCHAR2 Error Message from message stack */
1510: /* */
1511: /* NON-STANDARD PARAMETERS */
1512: /* In Parameters */
1513: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
1514: /* Output Parameter : */
1515: /* Change Hist : */

Line 1531: --Standard variables

1527: x_msg_data OUT NOCOPY VARCHAR2,
1528: p_repair_line_id IN NUMBER
1529: ) IS
1530:
1531: --Standard variables
1532: l_api_name CONSTANT VARCHAR2(30) := 'JOB_CREATION_UPDATE';
1533: l_api_version CONSTANT NUMBER := 1.0;
1534:
1535: -- Variables used in the program

Line 1594: -- Standard Start of API savepoint

1590: and crj.wip_entity_id is null;
1591: --Vijay 11/9/04
1592: K JOB_CREATION_Rec_Type;
1593: BEGIN
1594: -- Standard Start of API savepoint
1595: SAVEPOINT JOB_CREATION_UPDATE;
1596:
1597: -- Initialize API return status to success
1598: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1603: -- Standard call to check for call compatibility.

1599:
1600: -- Debug messages
1601: Debug('At the Beginning of JOB_CREATION_UPDATE',l_mod_name,1);
1602:
1603: -- Standard call to check for call compatibility.
1604: IF NOT FND_API.Compatible_API_Call (l_api_version,
1605: p_api_version,
1606: l_api_name ,
1607: G_PKG_NAME )

Line 1779: -- Standard check of p_commit.

1775: CLOSE Job_Creation;
1776: END IF;
1777:
1778:
1779: -- Standard check of p_commit.
1780: IF FND_API.To_Boolean( p_commit ) THEN
1781: COMMIT WORK;
1782: END IF;
1783:

Line 1784: -- Standard call to get message count and IF count is get message info.

1780: IF FND_API.To_Boolean( p_commit ) THEN
1781: COMMIT WORK;
1782: END IF;
1783:
1784: -- Standard call to get message count and IF count is get message info.
1785: FND_MSG_PUB.Count_And_Get
1786: (p_count => x_msg_count,
1787: p_data => x_msg_data );
1788: EXCEPTION

Line 1825: /* STANDARD PARAMETERS */

1821: /* Description : Procedure called from the UI to update the depot tables */
1822: /* for the receipts against RMA/Internal Requisitions. It calls */
1823: /* RMA_RCV_UPDATE and IO_RCV_UPDATE to process RMA and IO respectively */
1824: /* Called from : Called from Depot Repair UI */
1825: /* STANDARD PARAMETERS */
1826: /* In Parameters : */
1827: /* p_api_version NUMBER Required Api Version number */
1828: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
1829: /* p_commit VARCHAR2 Optional Commits in API */

Line 1837: /* NON-STANDARD PARAMETERS */

1833: /* x_return_status VARCHAR2 Return status of the API */
1834: /* x_msg_count NUMBER Number of messages in stack */
1835: /* x_msg_data VARCHAR2 Error Message from message stack */
1836: /* */
1837: /* NON-STANDARD PARAMETERS */
1838: /* In Parameters */
1839: /* p_order_header_id NUMBER Optional Interal sales order Id */
1840: /* p_internal_order_flag VARCHAR2 Required Order Type; Possible values -'Y','N' */
1841: /* p_repair_line_id NUMBER Optional Repair Order Line Id */

Line 1861: --Standard variables

1857: p_repair_line_id IN NUMBER,
1858: p_past_num_of_days IN NUMBER DEFAULT NULL ----bug#6753684, 6742512
1859: ) IS
1860:
1861: --Standard variables
1862: l_api_name CONSTANT VARCHAR2(30) := 'RECEIPTS_UPDATE';
1863: l_api_version CONSTANT NUMBER := 1.0;
1864:
1865: -- Variable used in FND log

Line 1870: -- Standard Start of API savepoint

1866: l_error_level number := FND_LOG.LEVEL_ERROR;
1867: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update';
1868:
1869: BEGIN
1870: -- Standard Start of API savepoint
1871: SAVEPOINT RECEIPTS_UPDATE;
1872:
1873: -- Initialize API return status to success
1874: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1882: -- Standard call to check for call compatibility.

1878: Debug('p_internal_order_flag ='||p_internal_order_flag,l_mod_name,1);
1879: Debug('p_order_header_id ='||p_order_header_id,l_mod_name,1);
1880: Debug('p_repair_line_id ='||p_repair_line_id,l_mod_name,1);
1881:
1882: -- Standard call to check for call compatibility.
1883: IF NOT FND_API.Compatible_API_Call (l_api_version,
1884: p_api_version,
1885: l_api_name ,
1886: G_PKG_NAME )

Line 1975: -- Standard check of p_commit.

1971: p_event => 'RECEIVE',
1972: p_validation_level => fnd_api.g_valid_level_none);
1973: -- end bug#7497790, 12.1 FP, subhat.
1974:
1975: -- Standard check of p_commit.
1976: IF FND_API.To_Boolean( p_commit ) THEN
1977: COMMIT WORK;
1978: END IF;
1979:

Line 1980: -- Standard call to get message count and IF count is get message info.

1976: IF FND_API.To_Boolean( p_commit ) THEN
1977: COMMIT WORK;
1978: END IF;
1979:
1980: -- Standard call to get message count and IF count is get message info.
1981: FND_MSG_PUB.Count_And_Get
1982: (p_count => x_msg_count,
1983: p_data => x_msg_data );
1984: EXCEPTION

Line 2045: /* STANDARD PARAMETERS */

2041: /* Description : Procedure called from the update API to update the depot tables */
2042: /* for the receipts against RMA. It also logs activities for accept */
2043: /* reject txn lines */
2044: /* Called from : Called from RECEIPTS_UPDATE API */
2045: /* STANDARD PARAMETERS */
2046: /* In Parameters : */
2047: /* p_api_version NUMBER Required Api Version number */
2048: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
2049: /* p_commit VARCHAR2 Optional Commits in API */

Line 2057: /* NON-STANDARD PARAMETERS */

2053: /* x_return_status VARCHAR2 Return status of the API */
2054: /* x_msg_count NUMBER Number of messages in stack */
2055: /* x_msg_data VARCHAR2 Error Message from message stack */
2056: /* */
2057: /* NON-STANDARD PARAMETERS */
2058: /* In Parameters */
2059: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
2060: /* Output Parameter : */
2061: /* Change Hist : */

Line 2078: -- Standard Variables

2074: p_past_num_of_days IN NUMBER DEFAULT NULL) ----bug#6753684, 6742512
2075: IS
2076:
2077:
2078: -- Standard Variables
2079: l_api_name CONSTANT VARCHAR2(30) := 'RMA_RCV_UPDATE';
2080: l_api_version CONSTANT NUMBER := 1.0;
2081:
2082: -- Variables used in the program

Line 2365: -- Standard Start of API savepoint

2361: and rst.transaction_id = rt.transaction_id;
2362:
2363:
2364: BEGIN
2365: -- Standard Start of API savepoint
2366: SAVEPOINT RMA_RCV_UPDATE;
2367:
2368: -- Initialize API return status to success
2369: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2375: -- Standard call to check for call compatibility.

2371: -- Debug messages
2372: Debug('At the Beginning of RMA_RCV_UPDATE',l_mod_name,1);
2373: Debug('Repair Line Id ='||to_char(p_repair_line_id),l_mod_name,1);
2374:
2375: -- Standard call to check for call compatibility.
2376: IF NOT FND_API.Compatible_API_Call (l_api_version,
2377: p_api_version,
2378: l_api_name ,
2379: G_PKG_NAME )

Line 3007: -- Standard check of p_commit.

3003: -- program output and log file
3004: fnd_file.put_line(fnd_file.log,fnd_message.get);
3005: fnd_file.put_line(fnd_file.output,fnd_message.get);
3006:
3007: -- Standard check of p_commit.
3008: IF FND_API.To_Boolean( p_commit ) THEN
3009: COMMIT WORK;
3010: END IF;
3011:

Line 3012: -- Standard call to get message count and IF count is get message info.

3008: IF FND_API.To_Boolean( p_commit ) THEN
3009: COMMIT WORK;
3010: END IF;
3011:
3012: -- Standard call to get message count and IF count is get message info.
3013: FND_MSG_PUB.Count_And_Get
3014: (p_count => x_msg_count,
3015: p_data => x_msg_data );
3016: EXCEPTION

Line 3053: /* STANDARD PARAMETERS */

3049: /* Description : Procedure called from the Update api to update the depot tables */
3050: /* for the receipts against Internal Requisitions */
3051: /* It also logs activities for accept reject txn lines */
3052: /* Called from : Called from RECEIPTS_UPDATE API */
3053: /* STANDARD PARAMETERS */
3054: /* In Parameters : */
3055: /* p_api_version NUMBER Required Api Version number */
3056: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
3057: /* p_commit VARCHAR2 Optional Commits in API */

Line 3065: /* NON-STANDARD PARAMETERS */

3061: /* x_return_status VARCHAR2 Return status of the API */
3062: /* x_msg_count NUMBER Number of messages in stack */
3063: /* x_msg_data VARCHAR2 Error Message from message stack */
3064: /* */
3065: /* NON-STANDARD PARAMETERS */
3066: /* In Parameters */
3067: /* p_order_header_id NUMBER Optional Internal sales order Id */
3068: /* Output Parm : */
3069: /* Change Hist : */

Line 3084: -- Standard variables

3080: x_msg_data OUT NOCOPY VARCHAR2,
3081: p_order_header_id IN NUMBER
3082: ) IS
3083:
3084: -- Standard variables
3085: l_api_name CONSTANT VARCHAR2(30) := 'IO_RCV_UPDATE';
3086: l_api_version CONSTANT NUMBER := 1.0;
3087:
3088: -- Variables used in API

Line 3259: -- Standard Start of API savepoint

3255: AND action_code = 'DEFECTIVES'
3256: AND prod_txn_status = 'SHIPPED';
3257:
3258: BEGIN
3259: -- Standard Start of API savepoint
3260: SAVEPOINT IO_RCV_UPDATE;
3261:
3262: -- Initialize API return status to success
3263: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3269: -- Standard call to check for call compatibility.

3265: -- Debug messages
3266: Debug('Beginning of IO_RCV_UPDATE',l_mod_name,1);
3267: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);
3268:
3269: -- Standard call to check for call compatibility.
3270: IF NOT FND_API.Compatible_API_Call (l_api_version,
3271: p_api_version,
3272: l_api_name ,
3273: G_PKG_NAME )

Line 4134: -- Handles the Direct Delivery and standard routing options

4130: EXIT;
4131: END IF;
4132:
4133: ELSIF RCV.transaction_type = 'DELIVER' THEN
4134: -- Handles the Direct Delivery and standard routing options
4135:
4136: select nvl(sum(quantity),0)
4137: into l_total_qty
4138: from csd_repair_history crh

Line 4420: -- Standard check of p_commit.

4416: CLOSE GET_RO_PROD_TXN_LINES;
4417: END IF;
4418:
4419:
4420: -- Standard check of p_commit.
4421: IF FND_API.To_Boolean( p_commit ) THEN
4422: COMMIT WORK;
4423: END IF;
4424:

Line 4425: -- Standard call to get message count and IF count is get message info.

4421: IF FND_API.To_Boolean( p_commit ) THEN
4422: COMMIT WORK;
4423: END IF;
4424:
4425: -- Standard call to get message count and IF count is get message info.
4426: FND_MSG_PUB.Count_And_Get
4427: (p_count => x_msg_count,
4428: p_data => x_msg_data);
4429: EXCEPTION

Line 4467: /* STANDARD PARAMETERS */

4463: /* Description : Procedure called from the Update api to update the depot tables */
4464: /* for the receipts against Internal Requisitions for move out line */
4465: /* It also logs activities for accept reject txn lines */
4466: /* Called from : Called from SHIP_UPDATE API */
4467: /* STANDARD PARAMETERS */
4468: /* In Parameters : */
4469: /* p_api_version NUMBER Required Api Version number */
4470: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
4471: /* p_commit VARCHAR2 Optional Commits in API */

Line 4479: /* NON-STANDARD PARAMETERS */

4475: /* x_return_status VARCHAR2 Return status of the API */
4476: /* x_msg_count NUMBER Number of messages in stack */
4477: /* x_msg_data VARCHAR2 Error Message from message stack */
4478: /* */
4479: /* NON-STANDARD PARAMETERS */
4480: /* In Parameters */
4481: /* p_order_header_id NUMBER Optional Internal sales order Id */
4482: /* Output Parm : */
4483: /* Change Hist : */

Line 4498: -- Standard variables

4494: x_msg_data OUT NOCOPY VARCHAR2,
4495: p_order_header_id IN NUMBER
4496: ) IS
4497:
4498: -- Standard variables
4499: l_api_name CONSTANT VARCHAR2(30) := 'IO_RCV_UPDATE_MOVE_OUT';
4500: l_api_version CONSTANT NUMBER := 1.0;
4501:
4502: -- Variables used in API

Line 4675: -- Standard Start of API savepoint

4671: AND action_code = 'USABLES'
4672: AND prod_txn_status = 'SHIPPED';
4673:
4674: BEGIN
4675: -- Standard Start of API savepoint
4676: SAVEPOINT IO_RCV_UPDATE_MOVE_OUT;
4677:
4678: -- Initialize API return status to success
4679: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4685: -- Standard call to check for call compatibility.

4681: -- Debug messages
4682: Debug('Beginning of IO_RCV_UPDATE_MOVE_OUT',l_mod_name,1);
4683: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);
4684:
4685: -- Standard call to check for call compatibility.
4686: IF NOT FND_API.Compatible_API_Call (l_api_version,
4687: p_api_version,
4688: l_api_name ,
4689: G_PKG_NAME )

Line 5560: -- Handles the Direct Delivery and standard routing options

5556: EXIT;
5557: END IF;
5558:
5559: ELSIF RCV.transaction_type = 'DELIVER' THEN
5560: -- Handles the Direct Delivery and standard routing options
5561:
5562: select nvl(sum(quantity),0)
5563: into l_total_qty
5564: from csd_repair_history crh

Line 5859: -- Standard check of p_commit.

5855: CLOSE GET_RO_PROD_TXN_LINES;
5856: END IF;
5857:
5858:
5859: -- Standard check of p_commit.
5860: IF FND_API.To_Boolean( p_commit ) THEN
5861: COMMIT WORK;
5862: END IF;
5863:

Line 5864: -- Standard call to get message count and IF count is get message info.

5860: IF FND_API.To_Boolean( p_commit ) THEN
5861: COMMIT WORK;
5862: END IF;
5863:
5864: -- Standard call to get message count and IF count is get message info.
5865: FND_MSG_PUB.Count_And_Get
5866: (p_count => x_msg_count,
5867: p_data => x_msg_data);
5868: EXCEPTION

Line 5906: /* STANDARD PARAMETERS */

5902: /* for the shipment against regular sales order/Internal Sales Order */
5903: /* It calls SO_SHIP_UPDATE and IO_SHIP_UPDATE to process sales order */
5904: /* and internal sales order */
5905: /* Called from : Called from Depot Repair UI */
5906: /* STANDARD PARAMETERS */
5907: /* In Parameters : */
5908: /* p_api_version NUMBER Required Api Version number */
5909: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
5910: /* p_commit VARCHAR2 Optional Commits in API */

Line 5918: /* NON-STANDARD PARAMETERS */

5914: /* x_return_status VARCHAR2 Return status of the API */
5915: /* x_msg_count NUMBER Number of messages in stack */
5916: /* x_msg_data VARCHAR2 Error Message from message stack */
5917: /* */
5918: /* NON-STANDARD PARAMETERS */
5919: /* In Parameters */
5920: /* p_order_header_id NUMBER Optional Interal sales order Id */
5921: /* p_internal_order_flag VARCHAR2 Required Order Type; Possible values -'Y','N' */
5922: /* p_repair_line_id NUMBER Optional Repair Order Line Id */

Line 5942: -- Standard Variables

5938: p_repair_line_id IN NUMBER,
5939: p_past_num_of_days IN NUMBER DEFAULT NULL) ----bug#6753684, 6742512
5940: IS
5941:
5942: -- Standard Variables
5943: l_api_name CONSTANT VARCHAR2(30) := 'SHIPMENT_UPDATE';
5944: l_api_version CONSTANT NUMBER := 1.0;
5945:
5946: -- Variables in FND log

Line 5951: -- Standard Start of API savepoint

5947: l_error_level number := FND_LOG.LEVEL_ERROR;
5948: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update';
5949:
5950: BEGIN
5951: -- Standard Start of API savepoint
5952: SAVEPOINT SHIP_UPDATE;
5953:
5954: -- Initialize API return status to success
5955: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5963: -- Standard call to check for call compatibility.

5959: Debug('p_internal_order_flag ='||p_internal_order_flag,l_mod_name,1);
5960: Debug('p_order_header_id ='||p_order_header_id,l_mod_name,1);
5961: Debug('p_repair_line_id ='||p_repair_line_id,l_mod_name,1);
5962:
5963: -- Standard call to check for call compatibility.
5964: IF NOT FND_API.Compatible_API_Call (l_api_version,
5965: p_api_version,
5966: l_api_name ,
5967: G_PKG_NAME )

Line 6044: -- Standard check of p_commit.

6040: RAISE FND_API.G_EXC_ERROR;
6041: END IF;
6042: End If;
6043:
6044: -- Standard check of p_commit.
6045: IF FND_API.To_Boolean( p_commit ) THEN
6046: COMMIT WORK;
6047: END IF;
6048:

Line 6049: -- Standard call to get message count and IF count is get message info.

6045: IF FND_API.To_Boolean( p_commit ) THEN
6046: COMMIT WORK;
6047: END IF;
6048:
6049: -- Standard call to get message count and IF count is get message info.
6050: FND_MSG_PUB.Count_And_Get
6051: (p_count => x_msg_count,
6052: p_data => x_msg_data );
6053: EXCEPTION

Line 6114: /* STANDARD PARAMETERS */

6110: /* Description : Procedure called from the Update api to update the depot tables */
6111: /* for the shipment against sales order */
6112: /* It also logs activities for the deliver txn lines */
6113: /* Called from : Called from SHIP_UPDATE API */
6114: /* STANDARD PARAMETERS */
6115: /* In Parameters : */
6116: /* p_api_version NUMBER Required Api Version number */
6117: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
6118: /* p_commit VARCHAR2 Optional Commits in API */

Line 6126: /* NON-STANDARD PARAMETERS */

6122: /* x_return_status VARCHAR2 Return status of the API */
6123: /* x_msg_count NUMBER Number of messages in stack */
6124: /* x_msg_data VARCHAR2 Error Message from message stack */
6125: /* */
6126: /* NON-STANDARD PARAMETERS */
6127: /* In Parameters */
6128: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
6129: /* Output Parm : */
6130: /* Change Hist : */

Line 6406: -- Standard variables

6402: --Bug#6779806
6403: l_enable_update_instance VARCHAR2(1);
6404:
6405:
6406: -- Standard variables
6407: l_api_name CONSTANT VARCHAR2(30) := 'SO_SHIP_UPDATE';
6408: l_api_version CONSTANT NUMBER := 1.0;
6409:
6410: -- Variables used in the program

Line 6433: -- Standard Start of API savepoint

6429: l_error_level number := FND_LOG.LEVEL_ERROR;
6430: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.so_ship_update';
6431:
6432: BEGIN
6433: -- Standard Start of API savepoint
6434: SAVEPOINT SO_SHIP_UPDATE;
6435:
6436: -- Initialize API return status to success
6437: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6443: -- Standard call to check for call compatibility.

6439: -- Debug messages
6440: Debug('At the Beginning of ship Update ',l_mod_name,1);
6441: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);
6442:
6443: -- Standard call to check for call compatibility.
6444: IF NOT FND_API.Compatible_API_Call (l_api_version,
6445: p_api_version,
6446: l_api_name ,
6447: G_PKG_NAME )

Line 6914: -- Standard check of p_commit.

6910: -- Log messages in the concurrent log and output file
6911: fnd_file.put_line(fnd_file.log,fnd_message.get);
6912: fnd_file.put_line(fnd_file.output,fnd_message.get);
6913:
6914: -- Standard check of p_commit.
6915: IF FND_API.To_Boolean( p_commit ) THEN
6916: COMMIT WORK;
6917: END IF;
6918:

Line 6919: -- Standard call to get message count and IF count is get message info.

6915: IF FND_API.To_Boolean( p_commit ) THEN
6916: COMMIT WORK;
6917: END IF;
6918:
6919: -- Standard call to get message count and IF count is get message info.
6920: FND_MSG_PUB.Count_And_Get
6921: (p_count => x_msg_count,
6922: p_data => x_msg_data);
6923:

Line 6962: /* STANDARD PARAMETERS */

6958: /* Description : Procedure called from the Update api to update the depot tables */
6959: /* for the shipment against Internal sales order */
6960: /* It also logs activities for the deliver txn lines */
6961: /* Called from : Called from SHIP_UPDATE API */
6962: /* STANDARD PARAMETERS */
6963: /* In Parameters : */
6964: /* p_api_version NUMBER Required Api Version number */
6965: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
6966: /* p_commit VARCHAR2 Optional Commits in API */

Line 6974: /* NON-STANDARD PARAMETERS */

6970: /* x_return_status VARCHAR2 Return status of the API */
6971: /* x_msg_count NUMBER Number of messages in stack */
6972: /* x_msg_data VARCHAR2 Error Message from message stack */
6973: /* */
6974: /* NON-STANDARD PARAMETERS */
6975: /* In Parameters */
6976: /* p_order_header_id NUMBER Optional Interal sales order Id */
6977: /* Output Parm : */
6978: /* Change Hist : */

Line 7158: -- Standard variables

7154: and mtl.transaction_type_id in ( 50,62,54,34)
7155: and mtl.picking_line_id = p_del_line_id
7156: and mtl.transaction_source_id = p_txn_src_id ;
7157:
7158: -- Standard variables
7159: l_api_name CONSTANT VARCHAR2(30) := 'IO_SHIP_UPDATE';
7160: l_api_version CONSTANT NUMBER := 1.0;
7161:
7162: -- Variables used by the API

Line 7200: -- Standard Start of API savepoint

7196: SKIP_RECORD EXCEPTION;
7197:
7198: BEGIN
7199:
7200: -- Standard Start of API savepoint
7201: SAVEPOINT IO_SHIP_UPDATE;
7202:
7203: -- Initialize API return status to success
7204: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7209: -- Standard call to check for call compatibility.

7205:
7206: Debug('At the Beginning of IO_SHIP_UPDATE',l_mod_name,1 );
7207: Debug('Order Header Id ='||p_order_header_id,l_mod_name,1);
7208:
7209: -- Standard call to check for call compatibility.
7210: IF NOT FND_API.Compatible_API_Call (l_api_version,
7211: p_api_version,
7212: l_api_name ,
7213: G_PKG_NAME )

Line 8448: -- Standard check of p_commit.

8444: CLOSE DELIVERY_LINES;
8445: END IF;
8446:
8447:
8448: -- Standard check of p_commit.
8449: IF FND_API.To_Boolean( p_commit ) THEN
8450: COMMIT WORK;
8451: END IF;
8452:

Line 8453: -- Standard call to get message count and IF count is get message info.

8449: IF FND_API.To_Boolean( p_commit ) THEN
8450: COMMIT WORK;
8451: END IF;
8452:
8453: -- Standard call to get message count and IF count is get message info.
8454: FND_MSG_PUB.Count_And_Get
8455: (p_count => x_msg_count,
8456: p_data => x_msg_data);
8457:

Line 8493: /* STANDARD PARAMETERS */

8489: /* Description : Procedure called from the UI to update the depot tables */
8490: /* for the WIP Job creation/Completion */
8491: /* */
8492: /* Called from : Called from Depot Repair UI */
8493: /* STANDARD PARAMETERS */
8494: /* In Parameters : */
8495: /* p_api_version NUMBER Required Api Version number */
8496: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
8497: /* p_commit VARCHAR2 Optional Commits in API */

Line 8505: /* NON-STANDARD PARAMETERS */

8501: /* x_return_status VARCHAR2 Return status of the API */
8502: /* x_msg_count NUMBER Number of messages in stack */
8503: /* x_msg_data VARCHAR2 Error Message from message stack */
8504: /* */
8505: /* NON-STANDARD PARAMETERS */
8506: /* In Parameters */
8507: /* p_upd_job_completion Required Order Type; Possible values -'Y','N' */
8508: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
8509: /* Output Parm : */

Line 8526: -- Standard Variables

8522: p_upd_job_completion IN VARCHAR2,
8523: p_repair_line_id IN NUMBER
8524: ) IS
8525:
8526: -- Standard Variables
8527: l_api_name CONSTANT VARCHAR2(30) := 'WIP_UPDATE';
8528: l_api_version CONSTANT NUMBER := 1.0;
8529:
8530: -- Variables used in the program

Line 8538: -- Standard Start of API savepoint

8534: l_error_level number := FND_LOG.LEVEL_ERROR;
8535: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.wip_update';
8536:
8537: BEGIN
8538: -- Standard Start of API savepoint
8539: SAVEPOINT WIP_UPDATE;
8540:
8541: -- Initialize API return status to success
8542: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8548: -- Standard call to check for call compatibility.

8544: -- Debug Messages
8545: Debug('At the Beginning of Wip_update ',l_mod_name,1);
8546: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);
8547:
8548: -- Standard call to check for call compatibility.
8549: IF NOT FND_API.Compatible_API_Call (l_api_version,
8550: p_api_version,
8551: l_api_name ,
8552: G_PKG_NAME )

Line 8621: -- Standard check of p_commit.

8617: RAISE FND_API.G_EXC_ERROR;
8618: END IF;
8619: END IF;
8620:
8621: -- Standard check of p_commit.
8622: IF FND_API.To_Boolean( p_commit ) THEN
8623: COMMIT WORK;
8624: END IF;
8625:

Line 8626: -- Standard call to get message count and IF count is get message info.

8622: IF FND_API.To_Boolean( p_commit ) THEN
8623: COMMIT WORK;
8624: END IF;
8625:
8626: -- Standard call to get message count and IF count is get message info.
8627: FND_MSG_PUB.Count_And_Get
8628: (p_count => x_msg_count,
8629: p_data => x_msg_data);
8630: EXCEPTION

Line 8691: /* STANDARD PARAMETERS */

8687: /* Description : Procedure called by concurrent program to update the depot tables */
8688: /* for the receipts against RMA/Internal Requisitions */
8689: /* */
8690: /* Called from : Called from Receipt update concurrent program */
8691: /* STANDARD PARAMETERS */
8692: /* In Parameters : */
8693: /* */
8694: /* Output Parameters: */
8695: /* errbuf VARCHAR2 Error message */

Line 8698: /* NON-STANDARD PARAMETERS */

8694: /* Output Parameters: */
8695: /* errbuf VARCHAR2 Error message */
8696: /* retcode VARCHAR2 Error Code */
8697: /* */
8698: /* NON-STANDARD PARAMETERS */
8699: /* In Parameters */
8700: /* p_order_type VARCHAR2 Required Order Type; Possible values- 'I','E' */
8701: /* p_order_header_id NUMBER Optional Internal sales Order Id */
8702: /* p_repair_line_id NUMBER Optional Repair Order Line Id */

Line 8717: --Standard Variables

8713: p_repair_line_id IN number,
8714: p_past_num_of_days IN NUMBER DEFAULT NULL) ----bug#6753684, 6742512
8715: IS
8716:
8717: --Standard Variables
8718: l_api_name CONSTANT VARCHAR2(30) := 'RECEIPTS_UPDATE_CONC_PROG';
8719: l_api_version CONSTANT NUMBER := 1.0;
8720:
8721: -- Variable used in the API

Line 8801: /* STANDARD PARAMETERS */

8797: /* Description : Procedure called by concurrent program to update the depot tables */
8798: /* for the WIP Job Creation/ Completion */
8799: /* */
8800: /* Called from : Called from Wip Update Concurrent Program */
8801: /* STANDARD PARAMETERS */
8802: /* In Parameters : */
8803: /* */
8804: /* Output Parameters: */
8805: /* errbuf VARCHAR2 Error message */

Line 8808: /* NON-STANDARD PARAMETERS */

8804: /* Output Parameters: */
8805: /* errbuf VARCHAR2 Error message */
8806: /* retcode VARCHAR2 Error Code */
8807: /* */
8808: /* NON-STANDARD PARAMETERS */
8809: /* In Parameters */
8810: /* p_upd_job_completion Required Order Type; Possible values -'Y','N' */
8811: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
8812: /* Output Parm : */

Line 8823: -- Standard variables

8819: retcode OUT NOCOPY varchar2,
8820: p_repair_line_id IN number,
8821: p_upd_job_completion IN varchar2) IS
8822:
8823: -- Standard variables
8824: l_api_name CONSTANT VARCHAR2(30) := 'WIP_UPDATE_CONC_PROG';
8825: l_api_version CONSTANT NUMBER := 1.0;
8826:
8827: -- Variables used in the program

Line 8901: /* STANDARD PARAMETERS */

8897: /* Description : Procedure called by concurrent program to update the depot tables */
8898: /* for the shipment against Sales order/Internal Sales Order */
8899: /* */
8900: /* Called from : Called from Receipt update concurrent program */
8901: /* STANDARD PARAMETERS */
8902: /* In Parameters : */
8903: /* */
8904: /* Output Parameters: */
8905: /* errbuf VARCHAR2 Error message */

Line 8908: /* NON-STANDARD PARAMETERS */

8904: /* Output Parameters: */
8905: /* errbuf VARCHAR2 Error message */
8906: /* retcode VARCHAR2 Eeror Code */
8907: /* */
8908: /* NON-STANDARD PARAMETERS */
8909: /* In Parameters */
8910: /* p_order_type VARCHAR2 Required Order Type; Possible values- 'I','E' */
8911: /* p_order_header_id NUMBER Optional Internal sales Order Id */
8912: /* p_repair_line_id NUMBER Optional Repair Order Line Id */

Line 8927: -- Standard Variables

8923: p_repair_line_id IN NUMBER,
8924: p_past_num_of_days IN NUMBER DEFAULT NULL) ----bug#6753684, 6742512
8925: IS
8926:
8927: -- Standard Variables
8928: l_api_version CONSTANT NUMBER := 1.0;
8929: l_return_status varchar2(1);
8930: l_msg_count number;
8931: l_msg_data varchar2(20000);

Line 9010: /* STANDARD PARAMETERS */

9006: /* for the task creation and update */
9007: /* */
9008: /* */
9009: /* Called from : Called from Task Update concurrent program */
9010: /* STANDARD PARAMETERS */
9011: /* In Parameters : */
9012: /* */
9013: /* Output Parameters: */
9014: /* errbuf VARCHAR2 Error message */

Line 9017: /* NON-STANDARD PARAMETERS */

9013: /* Output Parameters: */
9014: /* errbuf VARCHAR2 Error message */
9015: /* retcode VARCHAR2 Error Code */
9016: /* */
9017: /* NON-STANDARD PARAMETERS */
9018: /* In Parameters */
9019: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
9020: /* Output Parm : */
9021: /* Change Hist : */

Line 9072: -- Standard Variables

9068: and hist.paramn1 = tsk.task_id
9069: and hist.repair_line_id = tsk.source_object_id
9070: and (tsk.task_status_id <> hist.paramn5 or tsk.owner_id <> hist.paramn3);
9071:
9072: -- Standard Variables
9073: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_AND_WRITE';
9074: l_api_version CONSTANT NUMBER := 1.0;
9075: l_msg_count NUMBER;
9076: l_msg_data VARCHAR2(2000);

Line 9196: -- Standard Start of API savepoint

9192:
9193: -- --------------------------------
9194: -- Begin Update repair task history
9195: -- --------------------------------
9196: -- Standard Start of API savepoint
9197: SAVEPOINT Update_rep_task_hist;
9198:
9199: -- ---------------
9200: -- Api body starts

Line 9292: -- Standard check of p_commit.

9288:
9289: end if; -- End of check for l_rep_hist_id
9290: end loop;
9291:
9292: -- Standard check of p_commit.
9293: IF FND_API.To_Boolean( FND_API.G_FALSE ) THEN
9294: COMMIT WORK;
9295: END IF;
9296:

Line 9297: -- Standard call to get message count and IF count is get message info.

9293: IF FND_API.To_Boolean( FND_API.G_FALSE ) THEN
9294: COMMIT WORK;
9295: END IF;
9296:
9297: -- Standard call to get message count and IF count is get message info.
9298: FND_MSG_PUB.Count_And_Get
9299: (p_count => x_msg_count,
9300: p_data => x_msg_data );
9301:

Line 9338: /* STANDARD PARAMETERS */

9334: /* Description : Procedure called to update all the logistics lines status to booked */
9335: /* */
9336: /* */
9337: /* Called from : csd_process_pvt and CSDREPLN.pld */
9338: /* STANDARD PARAMETERS */
9339: /* In Parameters : */
9340: /* */
9341: /* Output Parameters: */
9342: /* */

Line 9343: /* NON-STANDARD PARAMETERS */

9339: /* In Parameters : */
9340: /* */
9341: /* Output Parameters: */
9342: /* */
9343: /* NON-STANDARD PARAMETERS */
9344: /* In Parameters */
9345: /* p_repair_line_id NUMBER */
9346: /* p_commit VARCHAR2 */
9347: /* Output Parm : */

Line 9403: /* STANDARD PARAMETERS */

9399: /* cancelled if the corresponding order line is cancelled. */
9400: /* */
9401: /* */
9402: /* Called from : RMA_RCV_UPDATE, IO_RCV_UPDATE , SHIP_UPDATE, IO_SHIP_UPDATE */
9403: /* STANDARD PARAMETERS */
9404: /* In Parameters : */
9405: /* */
9406: /* Output Parameters: */
9407: /* */

Line 9408: /* NON-STANDARD PARAMETERS */

9404: /* In Parameters : */
9405: /* */
9406: /* Output Parameters: */
9407: /* */
9408: /* NON-STANDARD PARAMETERS */
9409: /* In Parameters */
9410: /* p_repair_line_id NUMBER */
9411: /* Output Parm : */
9412: /* Change Hist : */