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 174: /* STANDARD PARAMETERS */

170: /* Function name: DEBUG */
171: /* Description : Logs the debug message */
172: /* Called from : Called from Update API */
173: /* */
174: /* STANDARD PARAMETERS */
175: /* In Parameters : */
176: /* p_message Required Debug message that needs to be logged */
177: /* p_mod_name Required Module name */
178: /* p_severity_level Required Severity level */

Line 180: /* NON-STANDARD PARAMETERS */

176: /* p_message Required Debug message that needs to be logged */
177: /* p_mod_name Required Module name */
178: /* p_severity_level Required Severity level */
179: /* Output Parameters: */
180: /* NON-STANDARD PARAMETERS */
181: /* In Parameters */
182: /* Out parameters */
183: /* Change Hist : */
184: /* 09/20/03 vlakaman Initial Creation. */

Line 236: /* STANDARD PARAMETERS */

232: /* Function name: INIT_ACTIVITY_REC */
233: /* Description : Initialize the activity record */
234: /* Called from : Called from Update API */
235: /* */
236: /* STANDARD PARAMETERS */
237: /* In Parameters : */
238: /* Output Parameters: */
239: /* NON-STANDARD PARAMETERS */
240: /* In Parameters */

Line 239: /* NON-STANDARD PARAMETERS */

235: /* */
236: /* STANDARD PARAMETERS */
237: /* In Parameters : */
238: /* Output Parameters: */
239: /* NON-STANDARD PARAMETERS */
240: /* In Parameters */
241: /* Out parameters */
242: /* Change Hist : */
243: /* 09/20/03 vlakaman Initial Creation. */

Line 319: /* STANDARD PARAMETERS */

315: /* Logistics lines could be created with different UOM than the one on */
316: /* repair order */
317: /* Called from : Called from Update API (SO_RCV_UPDATE,SO_SHIP_UPDATE) */
318: /* */
319: /* STANDARD PARAMETERS */
320: /* In Parameters : */
321: /* */
322: /* Output Parameters: */
323: /* x_return_status VARCHAR2 Return status of the API */

Line 325: /* NON-STANDARD PARAMETERS */

321: /* */
322: /* Output Parameters: */
323: /* x_return_status VARCHAR2 Return status of the API */
324: /* */
325: /* NON-STANDARD PARAMETERS */
326: /* In Parameters */
327: /* p_to_uom VARCHAR2 Required RO Unit of measure */
328: /* p_item_id NUMBER Required Inventory Item Id */
329: /* p_from_uom VARCHAR2 Conditionaly Required Needed for receiving lines */

Line 349: -- Standard variables

345: p_from_quantity IN number,
346: x_result_quantity OUT NOCOPY number
347: ) IS
348:
349: -- Standard variables
350: l_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_RO_UOM';
351: l_api_version CONSTANT NUMBER := 1.0;
352:
353: -- Variables used in the API

Line 361: -- Standard Start of API savepoint

357: l_error_level number := FND_LOG.LEVEL_ERROR;
358: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.convert_to_ro_uom';
359:
360: BEGIN
361: -- Standard Start of API savepoint
362: SAVEPOINT CONV_TO_RO_UOM;
363:
364: -- Initialize API return status to success
365: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 455: /* STANDARD PARAMETERS */

451: /* Procedure name: LOG_ACTIVITY */
452: /* Description : Procedure called for logging activity */
453: /* */
454: /* Called from : Called from all the api */
455: /* STANDARD PARAMETERS */
456: /* In Parameters : */
457: /* p_api_version NUMBER Required Api Version number */
458: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
459: /* p_commit VARCHAR2 Optional Commits in API */

Line 467: /* NON-STANDARD PARAMETERS */

463: /* x_return_status VARCHAR2 Return status of the API */
464: /* x_msg_count NUMBER Number of messages in stack */
465: /* x_msg_data VARCHAR2 Error Message from message stack */
466: /* */
467: /* NON-STANDARD PARAMETERS */
468: /* In Parameters */
469: /* p_activity_rec RECORD TYPE Activity record type */
470: /* Output Parameter : */
471: /* Change Hist : */

Line 486: -- Standard Variables

482: x_msg_data OUT NOCOPY VARCHAR2,
483: p_activity_rec IN activity_rec_type
484: ) IS
485:
486: -- Standard Variables
487: l_api_name CONSTANT VARCHAR2(30) := 'LOG_ACTIVITY';
488: l_api_version CONSTANT NUMBER := 1.0;
489:
490: -- Variables used in API

Line 498: -- Standard Start of API savepoint

494: l_error_level number := FND_LOG.LEVEL_ERROR;
495: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.log_activity';
496:
497: BEGIN
498: -- Standard Start of API savepoint
499: SAVEPOINT LOG_ACTIVITY;
500:
501: -- Initialize API return status to success
502: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

503:
504: -- Debug messages
505: Debug('At the beginning of log_activity api',l_mod_name,1);
506:
507: -- Standard call to check for call compatibility.
508: IF NOT FND_API.Compatible_API_Call (l_api_version,
509: p_api_version,
510: l_api_name ,
511: G_PKG_NAME )

Line 620: -- Standard check of p_commit.

616: Debug('Validate_And_Write api failed ',l_mod_name,4);
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: -- Standard check of p_commit.
621: IF FND_API.To_Boolean( p_commit ) THEN
622: COMMIT WORK;
623: END IF;
624:

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

621: IF FND_API.To_Boolean( p_commit ) THEN
622: COMMIT WORK;
623: END IF;
624:
625: -- Standard call to get message count and IF count is get message info.
626: FND_MSG_PUB.Count_And_Get
627: (p_count => x_msg_count,
628: p_data => x_msg_data );
629: EXCEPTION

Line 665: /* STANDARD PARAMETERS */

661: /* Procedure name: JOB_COMPLETION_UPDATE */
662: /* Description : Procedure called from wip_update API to update the completed qty */
663: /* It also logs activity for the job completion */
664: /* Called from : Called from WIP_Update API */
665: /* STANDARD PARAMETERS */
666: /* In Parameters : */
667: /* p_api_version NUMBER Required Api Version number */
668: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
669: /* p_commit VARCHAR2 Optional Commits in API */

Line 677: /* NON-STANDARD PARAMETERS */

673: /* x_return_status VARCHAR2 Return status of the API */
674: /* x_msg_count NUMBER Number of messages in stack */
675: /* x_msg_data VARCHAR2 Error Message from message stack */
676: /* */
677: /* NON-STANDARD PARAMETERS */
678: /* In Parameters */
679: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
680: /* Output Parm : */
681: /* Change Hist : */

Line 696: -- Standard Variables

692: x_msg_data OUT NOCOPY VARCHAR2,
693: p_repair_line_id IN NUMBER
694: ) IS
695:
696: -- Standard Variables
697: l_api_name CONSTANT VARCHAR2(30) := 'WIP_UPDATE';
698: l_api_version CONSTANT NUMBER := 1.0;
699:
700: -- Variables used in the program

Line 819: -- Standard Start of API savepoint

815: and mtl.transaction_action_id = 31;-- Wip Assembly Completion
816:
817:
818: BEGIN
819: -- Standard Start of API savepoint
820: SAVEPOINT JOB_COMPLETION_UPDATE;
821:
822: -- Initialize API return status to success
823: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

824:
825: -- Debug messages
826: Debug('At the Beginning of JOB_COMPLETION_UPDATE',l_mod_name,1);
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call (l_api_version,
830: p_api_version,
831: l_api_name ,
832: G_PKG_NAME )

Line 1461: -- Standard check of p_commit.

1457:
1458: -- Debug message
1459: Debug(l_msg_text,l_mod_name,1 );
1460:
1461: -- Standard check of p_commit.
1462: IF FND_API.To_Boolean( p_commit ) THEN
1463: COMMIT WORK;
1464: END IF;
1465:

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

1462: IF FND_API.To_Boolean( p_commit ) THEN
1463: COMMIT WORK;
1464: END IF;
1465:
1466: -- Standard call to get message count and IF count is get message info.
1467: FND_MSG_PUB.Count_And_Get
1468: (p_count => x_msg_count,
1469: p_data => x_msg_data );
1470: EXCEPTION

Line 1506: /* STANDARD PARAMETERS */

1502: /* Procedure name: JOB_CREATION_UPDATE */
1503: /* Description : Procedure called from wip_update API to update the wip entity Id */
1504: /* for the new jobs created by the WIP Mass Load concurrent program */
1505: /* Called from : Called from WIP_Update API */
1506: /* STANDARD PARAMETERS */
1507: /* In Parameters : */
1508: /* p_api_version NUMBER Required Api Version number */
1509: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
1510: /* p_commit VARCHAR2 Optional Commits in API */

Line 1518: /* NON-STANDARD PARAMETERS */

1514: /* x_return_status VARCHAR2 Return status of the API */
1515: /* x_msg_count NUMBER Number of messages in stack */
1516: /* x_msg_data VARCHAR2 Error Message from message stack */
1517: /* */
1518: /* NON-STANDARD PARAMETERS */
1519: /* In Parameters */
1520: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
1521: /* Output Parameter : */
1522: /* Change Hist : */

Line 1538: --Standard variables

1534: x_msg_data OUT NOCOPY VARCHAR2,
1535: p_repair_line_id IN NUMBER
1536: ) IS
1537:
1538: --Standard variables
1539: l_api_name CONSTANT VARCHAR2(30) := 'JOB_CREATION_UPDATE';
1540: l_api_version CONSTANT NUMBER := 1.0;
1541:
1542: -- Variables used in the program

Line 1601: -- Standard Start of API savepoint

1597: and crj.wip_entity_id is null;
1598: --Vijay 11/9/04
1599: K JOB_CREATION_Rec_Type;
1600: BEGIN
1601: -- Standard Start of API savepoint
1602: SAVEPOINT JOB_CREATION_UPDATE;
1603:
1604: -- Initialize API return status to success
1605: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1606:
1607: -- Debug messages
1608: Debug('At the Beginning of JOB_CREATION_UPDATE',l_mod_name,1);
1609:
1610: -- Standard call to check for call compatibility.
1611: IF NOT FND_API.Compatible_API_Call (l_api_version,
1612: p_api_version,
1613: l_api_name ,
1614: G_PKG_NAME )

Line 1786: -- Standard check of p_commit.

1782: CLOSE Job_Creation;
1783: END IF;
1784:
1785:
1786: -- Standard check of p_commit.
1787: IF FND_API.To_Boolean( p_commit ) THEN
1788: COMMIT WORK;
1789: END IF;
1790:

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

1787: IF FND_API.To_Boolean( p_commit ) THEN
1788: COMMIT WORK;
1789: END IF;
1790:
1791: -- Standard call to get message count and IF count is get message info.
1792: FND_MSG_PUB.Count_And_Get
1793: (p_count => x_msg_count,
1794: p_data => x_msg_data );
1795: EXCEPTION

Line 1832: /* STANDARD PARAMETERS */

1828: /* Description : Procedure called from the UI to update the depot tables */
1829: /* for the receipts against RMA/Internal Requisitions. It calls */
1830: /* RMA_RCV_UPDATE and IO_RCV_UPDATE to process RMA and IO respectively */
1831: /* Called from : Called from Depot Repair UI */
1832: /* STANDARD PARAMETERS */
1833: /* In Parameters : */
1834: /* p_api_version NUMBER Required Api Version number */
1835: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
1836: /* p_commit VARCHAR2 Optional Commits in API */

Line 1844: /* NON-STANDARD PARAMETERS */

1840: /* x_return_status VARCHAR2 Return status of the API */
1841: /* x_msg_count NUMBER Number of messages in stack */
1842: /* x_msg_data VARCHAR2 Error Message from message stack */
1843: /* */
1844: /* NON-STANDARD PARAMETERS */
1845: /* In Parameters */
1846: /* p_order_header_id NUMBER Optional Interal sales order Id */
1847: /* p_internal_order_flag VARCHAR2 Required Order Type; Possible values -'Y','N' */
1848: /* p_repair_line_id NUMBER Optional Repair Order Line Id */

Line 1868: --Standard variables

1864: p_repair_line_id IN NUMBER,
1865: p_past_num_of_days IN NUMBER DEFAULT NULL ----bug#6753684, 6742512
1866: ) IS
1867:
1868: --Standard variables
1869: l_api_name CONSTANT VARCHAR2(30) := 'RECEIPTS_UPDATE';
1870: l_api_version CONSTANT NUMBER := 1.0;
1871:
1872: -- Variable used in FND log

Line 1881: -- Standard Start of API savepoint

1877: l_return_status varchar2(1);
1878: l_msg_data_warning VARCHAR2(30000);
1879:
1880: BEGIN
1881: -- Standard Start of API savepoint
1882: SAVEPOINT RECEIPTS_UPDATE;
1883:
1884: -- Initialize API return status to success
1885: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1889: Debug('p_internal_order_flag ='||p_internal_order_flag,l_mod_name,1);
1890: Debug('p_order_header_id ='||p_order_header_id,l_mod_name,1);
1891: Debug('p_repair_line_id ='||p_repair_line_id,l_mod_name,1);
1892:
1893: -- Standard call to check for call compatibility.
1894: IF NOT FND_API.Compatible_API_Call (l_api_version,
1895: p_api_version,
1896: l_api_name ,
1897: G_PKG_NAME )

Line 2014: -- Standard check of p_commit.

2010: p_event => 'RECEIVE',
2011: p_validation_level => fnd_api.g_valid_level_none);
2012: -- end bug#7497790, 12.1 FP, subhat.
2013:
2014: -- Standard check of p_commit.
2015: IF FND_API.To_Boolean( p_commit ) THEN
2016: COMMIT WORK;
2017: END IF;
2018:

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

2015: IF FND_API.To_Boolean( p_commit ) THEN
2016: COMMIT WORK;
2017: END IF;
2018:
2019: -- Standard call to get message count and IF count is get message info.
2020: FND_MSG_PUB.Count_And_Get
2021: (p_count => x_msg_count,
2022: p_data => x_msg_data );
2023:

Line 2093: /* STANDARD PARAMETERS */

2089: /* Description : Procedure called from the update API to update the depot tables */
2090: /* for the receipts against RMA. It also logs activities for accept */
2091: /* reject txn lines */
2092: /* Called from : Called from RECEIPTS_UPDATE API */
2093: /* STANDARD PARAMETERS */
2094: /* In Parameters : */
2095: /* p_api_version NUMBER Required Api Version number */
2096: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
2097: /* p_commit VARCHAR2 Optional Commits in API */

Line 2105: /* NON-STANDARD PARAMETERS */

2101: /* x_return_status VARCHAR2 Return status of the API */
2102: /* x_msg_count NUMBER Number of messages in stack */
2103: /* x_msg_data VARCHAR2 Error Message from message stack */
2104: /* */
2105: /* NON-STANDARD PARAMETERS */
2106: /* In Parameters */
2107: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
2108: /* Output Parameter : */
2109: /* Change Hist : */

Line 2126: -- Standard Variables

2122: p_past_num_of_days IN NUMBER DEFAULT NULL) ----bug#6753684, 6742512
2123: IS
2124:
2125:
2126: -- Standard Variables
2127: l_api_name CONSTANT VARCHAR2(30) := 'RMA_RCV_UPDATE';
2128: l_api_version CONSTANT NUMBER := 1.0;
2129:
2130: -- Variables used in the program

Line 2427: -- Standard Start of API savepoint

2423: and rst.transaction_id = rt.transaction_id;
2424:
2425:
2426: BEGIN
2427: -- Standard Start of API savepoint
2428: SAVEPOINT RMA_RCV_UPDATE;
2429:
2430: -- Initialize API return status to success
2431: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2433: -- Debug messages
2434: Debug('At the Beginning of RMA_RCV_UPDATE',l_mod_name,1);
2435: Debug('Repair Line Id ='||to_char(p_repair_line_id),l_mod_name,1);
2436:
2437: -- Standard call to check for call compatibility.
2438: IF NOT FND_API.Compatible_API_Call (l_api_version,
2439: p_api_version,
2440: l_api_name ,
2441: G_PKG_NAME )

Line 3163: -- Standard check of p_commit.

3159: -- program output and log file
3160: fnd_file.put_line(fnd_file.log,fnd_message.get);
3161: fnd_file.put_line(fnd_file.output,fnd_message.get);
3162:
3163: -- Standard check of p_commit.
3164: IF FND_API.To_Boolean( p_commit ) THEN
3165: COMMIT WORK;
3166: END IF;
3167:

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

3169: If (l_warning_return) THEN
3170: x_return_status := G_CSD_RET_STS_WARNING;
3171: End if;
3172:
3173: -- Standard call to get message count and IF count is get message info.
3174: FND_MSG_PUB.Count_And_Get
3175: (p_count => x_msg_count,
3176: p_data => x_msg_data );
3177: EXCEPTION

Line 3214: /* STANDARD PARAMETERS */

3210: /* Description : Procedure called from the Update api to update the depot tables */
3211: /* for the receipts against Internal Requisitions */
3212: /* It also logs activities for accept reject txn lines */
3213: /* Called from : Called from RECEIPTS_UPDATE API */
3214: /* STANDARD PARAMETERS */
3215: /* In Parameters : */
3216: /* p_api_version NUMBER Required Api Version number */
3217: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
3218: /* p_commit VARCHAR2 Optional Commits in API */

Line 3226: /* NON-STANDARD PARAMETERS */

3222: /* x_return_status VARCHAR2 Return status of the API */
3223: /* x_msg_count NUMBER Number of messages in stack */
3224: /* x_msg_data VARCHAR2 Error Message from message stack */
3225: /* */
3226: /* NON-STANDARD PARAMETERS */
3227: /* In Parameters */
3228: /* p_order_header_id NUMBER Optional Internal sales order Id */
3229: /* Output Parm : */
3230: /* Change Hist : */

Line 3245: -- Standard variables

3241: x_msg_data OUT NOCOPY VARCHAR2,
3242: p_order_header_id IN NUMBER
3243: ) IS
3244:
3245: -- Standard variables
3246: l_api_name CONSTANT VARCHAR2(30) := 'IO_RCV_UPDATE';
3247: l_api_version CONSTANT NUMBER := 1.0;
3248:
3249: -- Variables used in API

Line 3420: -- Standard Start of API savepoint

3416: AND action_code = 'DEFECTIVES'
3417: AND prod_txn_status = 'SHIPPED';
3418:
3419: BEGIN
3420: -- Standard Start of API savepoint
3421: SAVEPOINT IO_RCV_UPDATE;
3422:
3423: -- Initialize API return status to success
3424: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3426: -- Debug messages
3427: Debug('Beginning of IO_RCV_UPDATE',l_mod_name,1);
3428: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);
3429:
3430: -- Standard call to check for call compatibility.
3431: IF NOT FND_API.Compatible_API_Call (l_api_version,
3432: p_api_version,
3433: l_api_name ,
3434: G_PKG_NAME )

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

4291: EXIT;
4292: END IF;
4293:
4294: ELSIF RCV.transaction_type = 'DELIVER' THEN
4295: -- Handles the Direct Delivery and standard routing options
4296:
4297: select nvl(sum(quantity),0)
4298: into l_total_qty
4299: from csd_repair_history crh

Line 4581: -- Standard check of p_commit.

4577: CLOSE GET_RO_PROD_TXN_LINES;
4578: END IF;
4579:
4580:
4581: -- Standard check of p_commit.
4582: IF FND_API.To_Boolean( p_commit ) THEN
4583: COMMIT WORK;
4584: END IF;
4585:

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

4582: IF FND_API.To_Boolean( p_commit ) THEN
4583: COMMIT WORK;
4584: END IF;
4585:
4586: -- Standard call to get message count and IF count is get message info.
4587: FND_MSG_PUB.Count_And_Get
4588: (p_count => x_msg_count,
4589: p_data => x_msg_data);
4590: EXCEPTION

Line 4628: /* STANDARD PARAMETERS */

4624: /* Description : Procedure called from the Update api to update the depot tables */
4625: /* for the receipts against Internal Requisitions for move out line */
4626: /* It also logs activities for accept reject txn lines */
4627: /* Called from : Called from SHIP_UPDATE API */
4628: /* STANDARD PARAMETERS */
4629: /* In Parameters : */
4630: /* p_api_version NUMBER Required Api Version number */
4631: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
4632: /* p_commit VARCHAR2 Optional Commits in API */

Line 4640: /* NON-STANDARD PARAMETERS */

4636: /* x_return_status VARCHAR2 Return status of the API */
4637: /* x_msg_count NUMBER Number of messages in stack */
4638: /* x_msg_data VARCHAR2 Error Message from message stack */
4639: /* */
4640: /* NON-STANDARD PARAMETERS */
4641: /* In Parameters */
4642: /* p_order_header_id NUMBER Optional Internal sales order Id */
4643: /* Output Parm : */
4644: /* Change Hist : */

Line 4659: -- Standard variables

4655: x_msg_data OUT NOCOPY VARCHAR2,
4656: p_order_header_id IN NUMBER
4657: ) IS
4658:
4659: -- Standard variables
4660: l_api_name CONSTANT VARCHAR2(30) := 'IO_RCV_UPDATE_MOVE_OUT';
4661: l_api_version CONSTANT NUMBER := 1.0;
4662:
4663: -- Variables used in API

Line 4836: -- Standard Start of API savepoint

4832: AND action_code = 'USABLES'
4833: AND prod_txn_status = 'SHIPPED';
4834:
4835: BEGIN
4836: -- Standard Start of API savepoint
4837: SAVEPOINT IO_RCV_UPDATE_MOVE_OUT;
4838:
4839: -- Initialize API return status to success
4840: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4842: -- Debug messages
4843: Debug('Beginning of IO_RCV_UPDATE_MOVE_OUT',l_mod_name,1);
4844: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);
4845:
4846: -- Standard call to check for call compatibility.
4847: IF NOT FND_API.Compatible_API_Call (l_api_version,
4848: p_api_version,
4849: l_api_name ,
4850: G_PKG_NAME )

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

5717: EXIT;
5718: END IF;
5719:
5720: ELSIF RCV.transaction_type = 'DELIVER' THEN
5721: -- Handles the Direct Delivery and standard routing options
5722:
5723: select nvl(sum(quantity),0)
5724: into l_total_qty
5725: from csd_repair_history crh

Line 6020: -- Standard check of p_commit.

6016: CLOSE GET_RO_PROD_TXN_LINES;
6017: END IF;
6018:
6019:
6020: -- Standard check of p_commit.
6021: IF FND_API.To_Boolean( p_commit ) THEN
6022: COMMIT WORK;
6023: END IF;
6024:

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

6021: IF FND_API.To_Boolean( p_commit ) THEN
6022: COMMIT WORK;
6023: END IF;
6024:
6025: -- Standard call to get message count and IF count is get message info.
6026: FND_MSG_PUB.Count_And_Get
6027: (p_count => x_msg_count,
6028: p_data => x_msg_data);
6029: EXCEPTION

Line 6067: /* STANDARD PARAMETERS */

6063: /* for the shipment against regular sales order/Internal Sales Order */
6064: /* It calls SO_SHIP_UPDATE and IO_SHIP_UPDATE to process sales order */
6065: /* and internal sales order */
6066: /* Called from : Called from Depot Repair UI */
6067: /* STANDARD PARAMETERS */
6068: /* In Parameters : */
6069: /* p_api_version NUMBER Required Api Version number */
6070: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
6071: /* p_commit VARCHAR2 Optional Commits in API */

Line 6079: /* NON-STANDARD PARAMETERS */

6075: /* x_return_status VARCHAR2 Return status of the API */
6076: /* x_msg_count NUMBER Number of messages in stack */
6077: /* x_msg_data VARCHAR2 Error Message from message stack */
6078: /* */
6079: /* NON-STANDARD PARAMETERS */
6080: /* In Parameters */
6081: /* p_order_header_id NUMBER Optional Interal sales order Id */
6082: /* p_internal_order_flag VARCHAR2 Required Order Type; Possible values -'Y','N' */
6083: /* p_repair_line_id NUMBER Optional Repair Order Line Id */

Line 6103: -- Standard Variables

6099: p_repair_line_id IN NUMBER,
6100: p_past_num_of_days IN NUMBER DEFAULT NULL) ----bug#6753684, 6742512
6101: IS
6102:
6103: -- Standard Variables
6104: l_api_name CONSTANT VARCHAR2(30) := 'SHIPMENT_UPDATE';
6105: l_api_version CONSTANT NUMBER := 1.0;
6106:
6107: -- Variables in FND log

Line 6117: -- Standard Start of API savepoint

6113: l_msg_data_warning VARCHAR2(30000);
6114:
6115:
6116: BEGIN
6117: -- Standard Start of API savepoint
6118: SAVEPOINT SHIP_UPDATE;
6119:
6120: -- Initialize API return status to success
6121: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6125: Debug('p_internal_order_flag ='||p_internal_order_flag,l_mod_name,1);
6126: Debug('p_order_header_id ='||p_order_header_id,l_mod_name,1);
6127: Debug('p_repair_line_id ='||p_repair_line_id,l_mod_name,1);
6128:
6129: -- Standard call to check for call compatibility.
6130: IF NOT FND_API.Compatible_API_Call (l_api_version,
6131: p_api_version,
6132: l_api_name ,
6133: G_PKG_NAME )

Line 6234: -- Standard check of p_commit.

6230: END IF;
6231:
6232: End If;
6233:
6234: -- Standard check of p_commit.
6235: IF FND_API.To_Boolean( p_commit ) THEN
6236: COMMIT WORK;
6237: END IF;
6238:

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

6235: IF FND_API.To_Boolean( p_commit ) THEN
6236: COMMIT WORK;
6237: END IF;
6238:
6239: -- Standard call to get message count and IF count is get message info.
6240: FND_MSG_PUB.Count_And_Get
6241: (p_count => x_msg_count,
6242: p_data => x_msg_data );
6243:

Line 6313: /* STANDARD PARAMETERS */

6309: /* Description : Procedure called from the Update api to update the depot tables */
6310: /* for the shipment against sales order */
6311: /* It also logs activities for the deliver txn lines */
6312: /* Called from : Called from SHIP_UPDATE API */
6313: /* STANDARD PARAMETERS */
6314: /* In Parameters : */
6315: /* p_api_version NUMBER Required Api Version number */
6316: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
6317: /* p_commit VARCHAR2 Optional Commits in API */

Line 6325: /* NON-STANDARD PARAMETERS */

6321: /* x_return_status VARCHAR2 Return status of the API */
6322: /* x_msg_count NUMBER Number of messages in stack */
6323: /* x_msg_data VARCHAR2 Error Message from message stack */
6324: /* */
6325: /* NON-STANDARD PARAMETERS */
6326: /* In Parameters */
6327: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
6328: /* Output Parm : */
6329: /* Change Hist : */

Line 6608: -- Standard variables

6604: --Bug#6779806
6605: l_enable_update_instance VARCHAR2(1);
6606:
6607:
6608: -- Standard variables
6609: l_api_name CONSTANT VARCHAR2(30) := 'SO_SHIP_UPDATE';
6610: l_api_version CONSTANT NUMBER := 1.0;
6611:
6612: -- Variables used in the program

Line 6642: -- Standard Start of API savepoint

6638: --bug#7572853
6639: l_flag NUMBER;
6640:
6641: BEGIN
6642: -- Standard Start of API savepoint
6643: SAVEPOINT SO_SHIP_UPDATE;
6644:
6645: -- Initialize API return status to success
6646: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6649: -- Debug messages
6650: Debug('At the Beginning of ship Update ',l_mod_name,1);
6651: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);
6652:
6653: -- Standard call to check for call compatibility.
6654: IF NOT FND_API.Compatible_API_Call (l_api_version,
6655: p_api_version,
6656: l_api_name ,
6657: G_PKG_NAME )

Line 7201: -- Standard check of p_commit.

7197: -- Log messages in the concurrent log and output file
7198: fnd_file.put_line(fnd_file.log,fnd_message.get);
7199: fnd_file.put_line(fnd_file.output,fnd_message.get);
7200:
7201: -- Standard check of p_commit.
7202: IF FND_API.To_Boolean( p_commit ) THEN
7203: COMMIT WORK;
7204: END IF;
7205:

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

7207: If (l_warning_return) THEN
7208: x_return_status := G_CSD_RET_STS_WARNING;
7209: End if;
7210:
7211: -- Standard call to get message count and IF count is get message info.
7212: FND_MSG_PUB.Count_And_Get
7213: (p_count => x_msg_count,
7214: p_data => x_msg_data);
7215:

Line 7254: /* STANDARD PARAMETERS */

7250: /* Description : Procedure called from the Update api to update the depot tables */
7251: /* for the shipment against Internal sales order */
7252: /* It also logs activities for the deliver txn lines */
7253: /* Called from : Called from SHIP_UPDATE API */
7254: /* STANDARD PARAMETERS */
7255: /* In Parameters : */
7256: /* p_api_version NUMBER Required Api Version number */
7257: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
7258: /* p_commit VARCHAR2 Optional Commits in API */

Line 7266: /* NON-STANDARD PARAMETERS */

7262: /* x_return_status VARCHAR2 Return status of the API */
7263: /* x_msg_count NUMBER Number of messages in stack */
7264: /* x_msg_data VARCHAR2 Error Message from message stack */
7265: /* */
7266: /* NON-STANDARD PARAMETERS */
7267: /* In Parameters */
7268: /* p_order_header_id NUMBER Optional Interal sales order Id */
7269: /* Output Parm : */
7270: /* Change Hist : */

Line 7450: -- Standard variables

7446: and mtl.transaction_type_id in ( 50,62,54,34)
7447: and mtl.picking_line_id = p_del_line_id
7448: and mtl.transaction_source_id = p_txn_src_id ;
7449:
7450: -- Standard variables
7451: l_api_name CONSTANT VARCHAR2(30) := 'IO_SHIP_UPDATE';
7452: l_api_version CONSTANT NUMBER := 1.0;
7453:
7454: -- Variables used by the API

Line 7492: -- Standard Start of API savepoint

7488: SKIP_RECORD EXCEPTION;
7489:
7490: BEGIN
7491:
7492: -- Standard Start of API savepoint
7493: SAVEPOINT IO_SHIP_UPDATE;
7494:
7495: -- Initialize API return status to success
7496: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

7497:
7498: Debug('At the Beginning of IO_SHIP_UPDATE',l_mod_name,1 );
7499: Debug('Order Header Id ='||p_order_header_id,l_mod_name,1);
7500:
7501: -- Standard call to check for call compatibility.
7502: IF NOT FND_API.Compatible_API_Call (l_api_version,
7503: p_api_version,
7504: l_api_name ,
7505: G_PKG_NAME )

Line 8740: -- Standard check of p_commit.

8736: CLOSE DELIVERY_LINES;
8737: END IF;
8738:
8739:
8740: -- Standard check of p_commit.
8741: IF FND_API.To_Boolean( p_commit ) THEN
8742: COMMIT WORK;
8743: END IF;
8744:

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

8741: IF FND_API.To_Boolean( p_commit ) THEN
8742: COMMIT WORK;
8743: END IF;
8744:
8745: -- Standard call to get message count and IF count is get message info.
8746: FND_MSG_PUB.Count_And_Get
8747: (p_count => x_msg_count,
8748: p_data => x_msg_data);
8749:

Line 8785: /* STANDARD PARAMETERS */

8781: /* Description : Procedure called from the UI to update the depot tables */
8782: /* for the WIP Job creation/Completion */
8783: /* */
8784: /* Called from : Called from Depot Repair UI */
8785: /* STANDARD PARAMETERS */
8786: /* In Parameters : */
8787: /* p_api_version NUMBER Required Api Version number */
8788: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
8789: /* p_commit VARCHAR2 Optional Commits in API */

Line 8797: /* NON-STANDARD PARAMETERS */

8793: /* x_return_status VARCHAR2 Return status of the API */
8794: /* x_msg_count NUMBER Number of messages in stack */
8795: /* x_msg_data VARCHAR2 Error Message from message stack */
8796: /* */
8797: /* NON-STANDARD PARAMETERS */
8798: /* In Parameters */
8799: /* p_upd_job_completion Required Order Type; Possible values -'Y','N' */
8800: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
8801: /* Output Parm : */

Line 8818: -- Standard Variables

8814: p_upd_job_completion IN VARCHAR2,
8815: p_repair_line_id IN NUMBER
8816: ) IS
8817:
8818: -- Standard Variables
8819: l_api_name CONSTANT VARCHAR2(30) := 'WIP_UPDATE';
8820: l_api_version CONSTANT NUMBER := 1.0;
8821:
8822: -- Variables used in the program

Line 8830: -- Standard Start of API savepoint

8826: l_error_level number := FND_LOG.LEVEL_ERROR;
8827: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.wip_update';
8828:
8829: BEGIN
8830: -- Standard Start of API savepoint
8831: SAVEPOINT WIP_UPDATE;
8832:
8833: -- Initialize API return status to success
8834: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

8836: -- Debug Messages
8837: Debug('At the Beginning of Wip_update ',l_mod_name,1);
8838: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);
8839:
8840: -- Standard call to check for call compatibility.
8841: IF NOT FND_API.Compatible_API_Call (l_api_version,
8842: p_api_version,
8843: l_api_name ,
8844: G_PKG_NAME )

Line 8913: -- Standard check of p_commit.

8909: RAISE FND_API.G_EXC_ERROR;
8910: END IF;
8911: END IF;
8912:
8913: -- Standard check of p_commit.
8914: IF FND_API.To_Boolean( p_commit ) THEN
8915: COMMIT WORK;
8916: END IF;
8917:

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

8914: IF FND_API.To_Boolean( p_commit ) THEN
8915: COMMIT WORK;
8916: END IF;
8917:
8918: -- Standard call to get message count and IF count is get message info.
8919: FND_MSG_PUB.Count_And_Get
8920: (p_count => x_msg_count,
8921: p_data => x_msg_data);
8922: EXCEPTION

Line 8983: /* STANDARD PARAMETERS */

8979: /* Description : Procedure called by concurrent program to update the depot tables */
8980: /* for the receipts against RMA/Internal Requisitions */
8981: /* */
8982: /* Called from : Called from Receipt update concurrent program */
8983: /* STANDARD PARAMETERS */
8984: /* In Parameters : */
8985: /* */
8986: /* Output Parameters: */
8987: /* errbuf VARCHAR2 Error message */

Line 8990: /* NON-STANDARD PARAMETERS */

8986: /* Output Parameters: */
8987: /* errbuf VARCHAR2 Error message */
8988: /* retcode VARCHAR2 Error Code */
8989: /* */
8990: /* NON-STANDARD PARAMETERS */
8991: /* In Parameters */
8992: /* p_order_type VARCHAR2 Required Order Type; Possible values- 'I','E' */
8993: /* p_order_header_id NUMBER Optional Internal sales Order Id */
8994: /* p_repair_line_id NUMBER Optional Repair Order Line Id */

Line 9009: --Standard Variables

9005: p_repair_line_id IN number,
9006: p_past_num_of_days IN NUMBER DEFAULT NULL) ----bug#6753684, 6742512
9007: IS
9008:
9009: --Standard Variables
9010: l_api_name CONSTANT VARCHAR2(30) := 'RECEIPTS_UPDATE_CONC_PROG';
9011: l_api_version CONSTANT NUMBER := 1.0;
9012:
9013: -- Variable used in the API

Line 9125: /* STANDARD PARAMETERS */

9121: /* Description : Procedure called by concurrent program to update the depot tables */
9122: /* for the WIP Job Creation/ Completion */
9123: /* */
9124: /* Called from : Called from Wip Update Concurrent Program */
9125: /* STANDARD PARAMETERS */
9126: /* In Parameters : */
9127: /* */
9128: /* Output Parameters: */
9129: /* errbuf VARCHAR2 Error message */

Line 9132: /* NON-STANDARD PARAMETERS */

9128: /* Output Parameters: */
9129: /* errbuf VARCHAR2 Error message */
9130: /* retcode VARCHAR2 Error Code */
9131: /* */
9132: /* NON-STANDARD PARAMETERS */
9133: /* In Parameters */
9134: /* p_upd_job_completion Required Order Type; Possible values -'Y','N' */
9135: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
9136: /* Output Parm : */

Line 9147: -- Standard variables

9143: retcode OUT NOCOPY varchar2,
9144: p_repair_line_id IN number,
9145: p_upd_job_completion IN varchar2) IS
9146:
9147: -- Standard variables
9148: l_api_name CONSTANT VARCHAR2(30) := 'WIP_UPDATE_CONC_PROG';
9149: l_api_version CONSTANT NUMBER := 1.0;
9150:
9151: -- Variables used in the program

Line 9225: /* STANDARD PARAMETERS */

9221: /* Description: Procedure called by concurrent program to update the depot tables */
9222: /* for the shipment against Sales order/Internal Sales Order */
9223: /* */
9224: /* Called from : Called from Receipt update concurrent program */
9225: /* STANDARD PARAMETERS */
9226: /* In Parameters : */
9227: /* */
9228: /* Output Parameters: */
9229: /* errbuf VARCHAR2 Error message */

Line 9232: /* NON-STANDARD PARAMETERS */

9228: /* Output Parameters: */
9229: /* errbuf VARCHAR2 Error message */
9230: /* retcode VARCHAR2 Eeror Code */
9231: /* */
9232: /* NON-STANDARD PARAMETERS */
9233: /* In Parameters */
9234: /* p_order_type VARCHAR2 Required Order Type; Possible values- 'I','E' */
9235: /* p_order_header_id NUMBER Optional Internal sales Order Id */
9236: /* p_repair_line_id NUMBER Optional Repair Order Line Id */

Line 9251: -- Standard Variables

9247: p_repair_line_id IN NUMBER,
9248: p_past_num_of_days IN NUMBER DEFAULT NULL) ----bug#6753684, 6742512
9249: IS
9250:
9251: -- Standard Variables
9252: l_api_version CONSTANT NUMBER := 1.0;
9253: l_return_status varchar2(1);
9254: l_msg_count number;
9255: l_msg_data varchar2(30000); --bug#8261344

Line 9362: /* STANDARD PARAMETERS */

9358: /* for the task creation and update */
9359: /* */
9360: /* */
9361: /* Called from : Called from Task Update concurrent program */
9362: /* STANDARD PARAMETERS */
9363: /* In Parameters : */
9364: /* */
9365: /* Output Parameters: */
9366: /* errbuf VARCHAR2 Error message */

Line 9369: /* NON-STANDARD PARAMETERS */

9365: /* Output Parameters: */
9366: /* errbuf VARCHAR2 Error message */
9367: /* retcode VARCHAR2 Error Code */
9368: /* */
9369: /* NON-STANDARD PARAMETERS */
9370: /* In Parameters */
9371: /* p_repair_line_id NUMBER Optional Repair Order Line Id */
9372: /* Output Parm : */
9373: /* Change Hist : */

Line 9424: -- Standard Variables

9420: and hist.paramn1 = tsk.task_id
9421: and hist.repair_line_id = tsk.source_object_id
9422: and (tsk.task_status_id <> hist.paramn5 or tsk.owner_id <> hist.paramn3);
9423:
9424: -- Standard Variables
9425: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_AND_WRITE';
9426: l_api_version CONSTANT NUMBER := 1.0;
9427: l_msg_count NUMBER;
9428: l_msg_data VARCHAR2(2000);

Line 9548: -- Standard Start of API savepoint

9544:
9545: -- --------------------------------
9546: -- Begin Update repair task history
9547: -- --------------------------------
9548: -- Standard Start of API savepoint
9549: SAVEPOINT Update_rep_task_hist;
9550:
9551: -- ---------------
9552: -- Api body starts

Line 9644: -- Standard check of p_commit.

9640:
9641: end if; -- End of check for l_rep_hist_id
9642: end loop;
9643:
9644: -- Standard check of p_commit.
9645: IF FND_API.To_Boolean( FND_API.G_FALSE ) THEN
9646: COMMIT WORK;
9647: END IF;
9648:

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

9645: IF FND_API.To_Boolean( FND_API.G_FALSE ) THEN
9646: COMMIT WORK;
9647: END IF;
9648:
9649: -- Standard call to get message count and IF count is get message info.
9650: FND_MSG_PUB.Count_And_Get
9651: (p_count => x_msg_count,
9652: p_data => x_msg_data );
9653:

Line 9690: /* STANDARD PARAMETERS */

9686: /* Description : Procedure called to update all the logistics lines status to booked */
9687: /* */
9688: /* */
9689: /* Called from : csd_process_pvt and CSDREPLN.pld */
9690: /* STANDARD PARAMETERS */
9691: /* In Parameters : */
9692: /* */
9693: /* Output Parameters: */
9694: /* */

Line 9695: /* NON-STANDARD PARAMETERS */

9691: /* In Parameters : */
9692: /* */
9693: /* Output Parameters: */
9694: /* */
9695: /* NON-STANDARD PARAMETERS */
9696: /* In Parameters */
9697: /* p_repair_line_id NUMBER */
9698: /* p_commit VARCHAR2 */
9699: /* Output Parm : */

Line 9755: /* STANDARD PARAMETERS */

9751: /* cancelled if the corresponding order line is cancelled. */
9752: /* */
9753: /* */
9754: /* Called from : RMA_RCV_UPDATE, IO_RCV_UPDATE , SHIP_UPDATE, IO_SHIP_UPDATE */
9755: /* STANDARD PARAMETERS */
9756: /* In Parameters : */
9757: /* */
9758: /* Output Parameters: */
9759: /* */

Line 9760: /* NON-STANDARD PARAMETERS */

9756: /* In Parameters : */
9757: /* */
9758: /* Output Parameters: */
9759: /* */
9760: /* NON-STANDARD PARAMETERS */
9761: /* In Parameters */
9762: /* p_repair_line_id NUMBER */
9763: /* Output Parm : */
9764: /* Change Hist : */