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 FND_LOG

Line 12: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_UPDATE_PROGRAMS_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(30) := 'csddrclb.pls';
10:
11: -- Global variable for storing the debug level
12: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13:
14: -- Added by Vijay 10/22/04
15: TYPE RCPT_LINES_Rec_Type IS RECORD
16: (

Line 186: -- Variables used in FND Log

182: p_mod_name in varchar2,
183: p_severity_level in number
184: ) IS
185:
186: -- Variables used in FND Log
187: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
188: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
189: l_event_level number := FND_LOG.LEVEL_EVENT;
190: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 187: l_stat_level number := FND_LOG.LEVEL_STATEMENT;

183: p_severity_level in number
184: ) IS
185:
186: -- Variables used in FND Log
187: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
188: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
189: l_event_level number := FND_LOG.LEVEL_EVENT;
190: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
191: l_error_level number := FND_LOG.LEVEL_ERROR;

Line 188: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

184: ) IS
185:
186: -- Variables used in FND Log
187: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
188: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
189: l_event_level number := FND_LOG.LEVEL_EVENT;
190: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
191: l_error_level number := FND_LOG.LEVEL_ERROR;
192: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 189: l_event_level number := FND_LOG.LEVEL_EVENT;

185:
186: -- Variables used in FND Log
187: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
188: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
189: l_event_level number := FND_LOG.LEVEL_EVENT;
190: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
191: l_error_level number := FND_LOG.LEVEL_ERROR;
192: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
193:

Line 190: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

186: -- Variables used in FND Log
187: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
188: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
189: l_event_level number := FND_LOG.LEVEL_EVENT;
190: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
191: l_error_level number := FND_LOG.LEVEL_ERROR;
192: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
193:
194: BEGIN

Line 191: l_error_level number := FND_LOG.LEVEL_ERROR;

187: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
188: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
189: l_event_level number := FND_LOG.LEVEL_EVENT;
190: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
191: l_error_level number := FND_LOG.LEVEL_ERROR;
192: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
193:
194: BEGIN
195:

Line 192: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

188: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
189: l_event_level number := FND_LOG.LEVEL_EVENT;
190: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
191: l_error_level number := FND_LOG.LEVEL_ERROR;
192: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
193:
194: BEGIN
195:
196: IF p_severity_level = 1 THEN

Line 198: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);

194: BEGIN
195:
196: IF p_severity_level = 1 THEN
197: IF ( l_stat_level >= G_debug_level) THEN
198: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);
199: END IF;
200: ELSIF p_severity_level = 2 THEN
201: IF ( l_proc_level >= G_debug_level) THEN
202: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);

Line 202: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);

198: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);
199: END IF;
200: ELSIF p_severity_level = 2 THEN
201: IF ( l_proc_level >= G_debug_level) THEN
202: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);
203: END IF;
204: ELSIF p_severity_level = 3 THEN
205: IF ( l_event_level >= G_debug_level) THEN
206: FND_LOG.STRING(l_event_level,p_mod_name,p_message);

Line 206: FND_LOG.STRING(l_event_level,p_mod_name,p_message);

202: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);
203: END IF;
204: ELSIF p_severity_level = 3 THEN
205: IF ( l_event_level >= G_debug_level) THEN
206: FND_LOG.STRING(l_event_level,p_mod_name,p_message);
207: END IF;
208: ELSIF p_severity_level = 4 THEN
209: IF ( l_excep_level >= G_debug_level) THEN
210: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);

Line 210: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);

206: FND_LOG.STRING(l_event_level,p_mod_name,p_message);
207: END IF;
208: ELSIF p_severity_level = 4 THEN
209: IF ( l_excep_level >= G_debug_level) THEN
210: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);
211: END IF;
212: ELSIF p_severity_level = 5 THEN
213: IF ( l_error_level >= G_debug_level) THEN
214: FND_LOG.STRING(l_error_level,p_mod_name,p_message);

Line 214: FND_LOG.STRING(l_error_level,p_mod_name,p_message);

210: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);
211: END IF;
212: ELSIF p_severity_level = 5 THEN
213: IF ( l_error_level >= G_debug_level) THEN
214: FND_LOG.STRING(l_error_level,p_mod_name,p_message);
215: END IF;
216: ELSIF p_severity_level = 6 THEN
217: IF ( l_unexp_level >= G_debug_level) THEN
218: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);

Line 218: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);

214: FND_LOG.STRING(l_error_level,p_mod_name,p_message);
215: END IF;
216: ELSIF p_severity_level = 6 THEN
217: IF ( l_unexp_level >= G_debug_level) THEN
218: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);
219: END IF;
220: END IF;
221:
222: END DEBUG;

Line 349: -- Variables used in FND Log

345:
346: -- Variables used in the API
347: l_from_uom_code mtl_units_of_measure.uom_code%type;
348:
349: -- Variables used in FND Log
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

Line 350: l_error_level number := FND_LOG.LEVEL_ERROR;

346: -- Variables used in the API
347: l_from_uom_code mtl_units_of_measure.uom_code%type;
348:
349: -- Variables used in FND Log
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

Line 375: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

371: WHEN NO_DATA_FOUND THEN
372: IF ( l_error_level >= G_debug_level) THEN
373: fnd_message.set_name('CSD','CSD_UOM_MISSING');
374: fnd_message.set_token('UOM',p_from_uom);
375: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
376: ELSE
377: fnd_message.set_name('CSD','CSD_UOM_MISSING');
378: fnd_message.set_token('UOM',p_from_uom);
379: fnd_msg_pub.add;

Line 386: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

382: WHEN TOO_MANY_ROWS THEN
383: IF ( l_error_level >= G_debug_level) THEN
384: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
385: fnd_message.set_token('UOM',p_from_uom);
386: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
387: ELSE
388: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
389: fnd_message.set_token('UOM',p_from_uom);
390: fnd_msg_pub.add;

Line 417: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

413: -- if the inv_convert api fails then it returns -99999
414: IF x_result_quantity < 0 then
415: IF ( l_error_level >= G_debug_level) THEN
416: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
417: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
418: ELSE
419: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
420: fnd_msg_pub.add;
421: END IF;

Line 486: -- Variable used in FND log

482:
483: -- Variables used in API
484: l_rep_hist_id NUMBER;
485:
486: -- Variable used in FND log
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

Line 487: l_error_level number := FND_LOG.LEVEL_ERROR;

483: -- Variables used in API
484: l_rep_hist_id NUMBER;
485:
486: -- Variable used in FND log
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

Line 715: -- Variable used in FND log

711:
712: -- Define a record of activity_rec_type
713: l_activity_rec activity_rec_type;
714:
715: -- Variable used in FND log
716: l_error_level number := FND_LOG.LEVEL_ERROR;
717: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.job_completion_update';
718:
719: -- User defined exception

Line 716: l_error_level number := FND_LOG.LEVEL_ERROR;

712: -- Define a record of activity_rec_type
713: l_activity_rec activity_rec_type;
714:
715: -- Variable used in FND log
716: l_error_level number := FND_LOG.LEVEL_ERROR;
717: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.job_completion_update';
718:
719: -- User defined exception
720: SKIP_RECORD EXCEPTION;

Line 967: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

963: IF SQL%NOTFOUND THEN
964: IF ( l_error_level >= G_debug_level) THEN
965: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
966: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
967: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
968: ELSE
969: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
970: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
971: FND_MSG_PUB.ADD;

Line 1090: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1086: IF SQL%NOTFOUND THEN
1087: IF ( l_error_level >= G_debug_level) THEN
1088: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1089: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1090: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1091: ELSE
1092: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1093: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1094: FND_MSG_PUB.ADD;

Line 1222: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1218: IF SQL%NOTFOUND THEN
1219: IF ( l_error_level >= G_debug_level) THEN
1220: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1221: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1222: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1223: ELSE
1224: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1225: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1226: FND_MSG_PUB.ADD;

Line 1275: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1271: WHEN NO_DATA_FOUND THEN
1272: IF ( l_error_level >= G_debug_level) THEN
1273: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1274: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1275: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1276: ELSE
1277: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1278: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1279: FND_MSG_PUB.ADD;

Line 1339: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1335: IF SQL%NOTFOUND THEN
1336: IF ( l_error_level >= G_debug_level) THEN
1337: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1338: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1339: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1340: ELSE
1341: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1342: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1343: FND_MSG_PUB.ADD;

Line 1546: -- Variable used in FND log

1542:
1543: -- activity record
1544: l_activity_rec activity_rec_type;
1545:
1546: -- Variable used in FND log
1547: l_error_level number := FND_LOG.LEVEL_ERROR;
1548: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.job_creation_update';
1549:
1550: -- This cursor gets all the records in csd_repair_job_xref

Line 1547: l_error_level number := FND_LOG.LEVEL_ERROR;

1543: -- activity record
1544: l_activity_rec activity_rec_type;
1545:
1546: -- Variable used in FND log
1547: l_error_level number := FND_LOG.LEVEL_ERROR;
1548: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.job_creation_update';
1549:
1550: -- This cursor gets all the records in csd_repair_job_xref
1551: -- that does not have wip_entity_id.

Line 1714: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1710: IF SQL%NOTFOUND THEN
1711: IF ( l_error_level >= G_debug_level) THEN
1712: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1713: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1714: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1715: ELSE
1716: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1717: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1718: FND_MSG_PUB.ADD;

Line 1735: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1731: IF SQL%NOTFOUND THEN
1732: IF ( l_error_level >= G_debug_level) THEN
1733: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1734: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1735: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1736: ELSE
1737: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1738: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1739: FND_MSG_PUB.ADD;

Line 1865: -- Variable used in FND log

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
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

Line 1866: l_error_level number := FND_LOG.LEVEL_ERROR;

1862: l_api_name CONSTANT VARCHAR2(30) := 'RECEIPTS_UPDATE';
1863: l_api_version CONSTANT NUMBER := 1.0;
1864:
1865: -- Variable used in FND log
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

Line 2002: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1998: IF ( l_error_level >= G_debug_level) THEN
1999: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2000: fnd_message.set_token('SQLERRM',SQLERRM);
2001: fnd_message.set_token('SQLCODE',SQLCODE);
2002: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2003: END If;
2004: -- As we are committing the processed records in the inner APIs
2005: -- so we rollback only if the p_commit='F'
2006: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 2019: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2015: IF ( l_error_level >= G_debug_level) THEN
2016: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2017: fnd_message.set_token('SQLERRM',SQLERRM);
2018: fnd_message.set_token('SQLCODE',SQLCODE);
2019: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2020: END If;
2021: -- As we are committing the processed records in the inner APIs
2022: -- so we rollback only if the p_commit='F'
2023: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 2108: -- Variables for FND Log

2104: --bug#6753684, 6742512
2105: l_From_Date Date;
2106: l_TO_Date Date;
2107:
2108: -- Variables for FND Log
2109: l_error_level number := FND_LOG.LEVEL_ERROR;
2110: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.rma_rcv_update';
2111:
2112: -- User defined exceptions

Line 2109: l_error_level number := FND_LOG.LEVEL_ERROR;

2105: l_From_Date Date;
2106: l_TO_Date Date;
2107:
2108: -- Variables for FND Log
2109: l_error_level number := FND_LOG.LEVEL_ERROR;
2110: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.rma_rcv_update';
2111:
2112: -- User defined exceptions
2113: SKIP_RECORD EXCEPTION;

Line 2606: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

2602: When no_data_found then
2603: IF ( l_error_level >= G_debug_level) THEN
2604: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2605: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2606: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2607: ELSE
2608: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2609: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2610: fnd_msg_pub.add;

Line 2633: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2629: IF (rcv_txn_serial_num%NOTFOUND) THEN
2630: IF ( l_error_level >= G_debug_level) THEN
2631: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2632: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2633: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2634: ELSE
2635: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2636: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2637: FND_MSG_PUB.ADD;

Line 2664: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2660: WHEN NO_DATA_FOUND THEN
2661: IF ( l_error_level >= G_debug_level) THEN
2662: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2663: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2664: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2665: ELSE
2666: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2667: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2668: FND_MSG_PUB.ADD;

Line 2676: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2672: WHEN TOO_MANY_ROWS THEN
2673: IF ( l_error_level >= G_debug_level) THEN
2674: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2675: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2676: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2677: ELSE
2678: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2679: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2680: FND_MSG_PUB.ADD;

Line 2760: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

2756: WHEN NO_DATA_FOUND THEN
2757: IF ( l_error_level >= G_debug_level) THEN
2758: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2759: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2760: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2761: ELSE
2762: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2763: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2764: fnd_msg_pub.add;

Line 2820: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

2816: IF SQL%NOTFOUND THEN
2817: IF ( l_error_level >= G_debug_level) THEN
2818: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2819: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2820: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2821: ELSE
2822: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2823: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2824: fnd_msg_pub.add;

Line 2843: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

2839: IF SQL%NOTFOUND THEN
2840: IF ( l_error_level >= G_debug_level) THEN
2841: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2842: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2843: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2844: ELSE
2845: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2846: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2847: fnd_msg_pub.add;

Line 2879: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

2875: IF SQL%NOTFOUND THEN
2876: IF ( l_error_level >= G_debug_level) THEN
2877: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2878: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2879: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2880: ELSE
2881: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2882: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2883: fnd_msg_pub.add;

Line 3117: -- Variable for the FND log file

3113:
3114: -- activity record
3115: l_activity_rec activity_rec_type;
3116:
3117: -- Variable for the FND log file
3118: l_error_level number := FND_LOG.LEVEL_ERROR;
3119: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_rcv_update';
3120:
3121: -- User defined exception

Line 3118: l_error_level number := FND_LOG.LEVEL_ERROR;

3114: -- activity record
3115: l_activity_rec activity_rec_type;
3116:
3117: -- Variable for the FND log file
3118: l_error_level number := FND_LOG.LEVEL_ERROR;
3119: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_rcv_update';
3120:
3121: -- User defined exception
3122: SKIP_RECORD EXCEPTION;

Line 3306: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3302: WHEN NO_DATA_FOUND THEN
3303: IF ( l_error_level >= G_debug_level) THEN
3304: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3305: fnd_message.set_token('HEADER_ID',p_order_header_id);
3306: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3307: ELSE
3308: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3309: fnd_message.set_token('HEADER_ID',p_order_header_id);
3310: fnd_msg_pub.add;

Line 3535: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3531: WHEN NO_DATA_FOUND THEN
3532: IF ( l_error_level >= G_debug_level) THEN
3533: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3534: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3535: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3536: ELSE
3537: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3538: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3539: fnd_msg_pub.add;

Line 3557: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3553: When NO_DATA_FOUND THEN
3554: IF ( l_error_level >= G_debug_level) THEN
3555: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3556: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3557: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3558: ELSE
3559: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3560: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3561: fnd_msg_pub.add;

Line 3567: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3563: When Others THEN
3564: IF ( l_error_level >= G_debug_level) THEN
3565: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3566: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3567: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3568: ELSE
3569: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3570: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3571: fnd_msg_pub.add;

Line 3598: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3594: WHEN NO_DATA_FOUND THEN
3595: IF ( l_error_level >= G_debug_level) THEN
3596: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3597: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3598: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3599: ELSE
3600: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3601: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3602: fnd_msg_pub.add;

Line 3646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3642: IF SQL%NOTFOUND THEN
3643: IF ( l_error_level >= G_debug_level) THEN
3644: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3645: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3647: ELSE
3648: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3649: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3650: fnd_msg_pub.add;

Line 3675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3671: IF SQL%NOTFOUND THEN
3672: IF ( l_error_level >= G_debug_level) THEN
3673: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3674: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3676: ELSE
3677: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3678: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3679: fnd_msg_pub.add;

Line 3903: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3899: WHEN NO_DATA_FOUND THEN
3900: IF ( l_error_level >= G_debug_level) THEN
3901: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3902: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3903: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3904: ELSE
3905: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3906: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3907: fnd_msg_pub.add;

Line 3925: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3921: When NO_DATA_FOUND THEN
3922: IF ( l_error_level >= G_debug_level) THEN
3923: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3924: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3925: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3926: ELSE
3927: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3928: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3929: fnd_msg_pub.add;

Line 3935: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3931: When Others THEN
3932: IF ( l_error_level >= G_debug_level) THEN
3933: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3934: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3935: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3936: ELSE
3937: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3938: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3939: fnd_msg_pub.add;

Line 3966: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

3962: WHEN NO_DATA_FOUND THEN
3963: IF ( l_error_level >= G_debug_level) THEN
3964: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3965: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3966: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3967: ELSE
3968: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3969: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3970: fnd_msg_pub.add;

Line 4014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4010: IF SQL%NOTFOUND THEN
4011: IF ( l_error_level >= G_debug_level) THEN
4012: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4013: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4015: ELSE
4016: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4017: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4018: fnd_msg_pub.add;

Line 4044: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4040: IF SQL%NOTFOUND THEN
4041: IF ( l_error_level >= G_debug_level) THEN
4042: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4043: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4044: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4045: ELSE
4046: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4047: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4048: fnd_msg_pub.add;

Line 4179: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4175: WHEN NO_DATA_FOUND THEN
4176: IF ( l_error_level >= G_debug_level) THEN
4177: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4178: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4179: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4180: ELSE
4181: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4182: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4183: fnd_msg_pub.add;

Line 4202: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4198: When NO_DATA_FOUND THEN
4199: IF ( l_error_level >= G_debug_level) THEN
4200: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4201: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4202: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4203: ELSE
4204: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4205: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4206: fnd_msg_pub.add;

Line 4212: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4208: When Others THEN
4209: IF ( l_error_level >= G_debug_level) THEN
4210: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4211: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4212: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4213: ELSE
4214: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4215: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4216: fnd_msg_pub.add;

Line 4241: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4237: WHEN NO_DATA_FOUND THEN
4238: IF ( l_error_level >= G_debug_level) THEN
4239: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4240: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4241: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4242: ELSE
4243: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4244: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4245: fnd_msg_pub.add;

Line 4289: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4285: IF SQL%NOTFOUND THEN
4286: IF ( l_error_level >= G_debug_level) THEN
4287: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4288: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4289: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4290: ELSE
4291: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4292: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4293: fnd_msg_pub.add;

Line 4317: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4313: IF SQL%NOTFOUND THEN
4314: IF ( l_error_level >= G_debug_level) THEN
4315: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4316: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4317: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4318: ELSE
4319: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4320: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4321: fnd_msg_pub.add;

Line 4531: -- Variable for the FND log file

4527:
4528: -- activity record
4529: l_activity_rec activity_rec_type;
4530:
4531: -- Variable for the FND log file
4532: l_error_level number := FND_LOG.LEVEL_ERROR;
4533: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_rcv_update_move_out';
4534:
4535: -- User defined exception

Line 4532: l_error_level number := FND_LOG.LEVEL_ERROR;

4528: -- activity record
4529: l_activity_rec activity_rec_type;
4530:
4531: -- Variable for the FND log file
4532: l_error_level number := FND_LOG.LEVEL_ERROR;
4533: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_rcv_update_move_out';
4534:
4535: -- User defined exception
4536: SKIP_RECORD EXCEPTION;

Line 4722: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4718: WHEN NO_DATA_FOUND THEN
4719: IF ( l_error_level >= G_debug_level) THEN
4720: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4721: fnd_message.set_token('HEADER_ID',p_order_header_id);
4722: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4723: ELSE
4724: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4725: fnd_message.set_token('HEADER_ID',p_order_header_id);
4726: fnd_msg_pub.add;

Line 4951: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4947: WHEN NO_DATA_FOUND THEN
4948: IF ( l_error_level >= G_debug_level) THEN
4949: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4950: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4951: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4952: ELSE
4953: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4954: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4955: fnd_msg_pub.add;

Line 4973: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4969: When NO_DATA_FOUND THEN
4970: IF ( l_error_level >= G_debug_level) THEN
4971: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4972: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4973: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4974: ELSE
4975: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4976: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4977: fnd_msg_pub.add;

Line 4983: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

4979: When Others THEN
4980: IF ( l_error_level >= G_debug_level) THEN
4981: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4982: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4983: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4984: ELSE
4985: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4986: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4987: fnd_msg_pub.add;

Line 5014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5010: WHEN NO_DATA_FOUND THEN
5011: IF ( l_error_level >= G_debug_level) THEN
5012: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5013: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5015: ELSE
5016: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5017: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5018: fnd_msg_pub.add;

Line 5067: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5063: IF SQL%NOTFOUND THEN
5064: IF ( l_error_level >= G_debug_level) THEN
5065: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5066: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5067: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5068: ELSE
5069: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5070: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5071: fnd_msg_pub.add;

Line 5096: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5092: IF SQL%NOTFOUND THEN
5093: IF ( l_error_level >= G_debug_level) THEN
5094: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5095: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5096: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5097: ELSE
5098: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5099: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5100: fnd_msg_pub.add;

Line 5324: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5320: WHEN NO_DATA_FOUND THEN
5321: IF ( l_error_level >= G_debug_level) THEN
5322: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5323: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5324: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5325: ELSE
5326: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5327: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5328: fnd_msg_pub.add;

Line 5346: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5342: When NO_DATA_FOUND THEN
5343: IF ( l_error_level >= G_debug_level) THEN
5344: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5345: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5346: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5347: ELSE
5348: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5349: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5350: fnd_msg_pub.add;

Line 5356: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5352: When Others THEN
5353: IF ( l_error_level >= G_debug_level) THEN
5354: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5355: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5356: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5357: ELSE
5358: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5359: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5360: fnd_msg_pub.add;

Line 5387: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5383: WHEN NO_DATA_FOUND THEN
5384: IF ( l_error_level >= G_debug_level) THEN
5385: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5386: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5387: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5388: ELSE
5389: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5390: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5391: fnd_msg_pub.add;

Line 5440: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5436: IF SQL%NOTFOUND THEN
5437: IF ( l_error_level >= G_debug_level) THEN
5438: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5439: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5440: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5441: ELSE
5442: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5443: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5444: fnd_msg_pub.add;

Line 5470: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5466: IF SQL%NOTFOUND THEN
5467: IF ( l_error_level >= G_debug_level) THEN
5468: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5469: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5470: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5471: ELSE
5472: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5473: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5474: fnd_msg_pub.add;

Line 5613: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5609: WHEN NO_DATA_FOUND THEN
5610: IF ( l_error_level >= G_debug_level) THEN
5611: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5612: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5613: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5614: ELSE
5615: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5616: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5617: fnd_msg_pub.add;

Line 5636: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5632: When NO_DATA_FOUND THEN
5633: IF ( l_error_level >= G_debug_level) THEN
5634: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5635: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5636: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5637: ELSE
5638: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5639: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5640: fnd_msg_pub.add;

Line 5646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5642: When Others THEN
5643: IF ( l_error_level >= G_debug_level) THEN
5644: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5645: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5647: ELSE
5648: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5649: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5650: fnd_msg_pub.add;

Line 5675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5671: WHEN NO_DATA_FOUND THEN
5672: IF ( l_error_level >= G_debug_level) THEN
5673: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5674: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5676: ELSE
5677: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5678: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5679: fnd_msg_pub.add;

Line 5728: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5724: IF SQL%NOTFOUND THEN
5725: IF ( l_error_level >= G_debug_level) THEN
5726: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5727: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5728: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5729: ELSE
5730: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5731: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5732: fnd_msg_pub.add;

Line 5756: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

5752: IF SQL%NOTFOUND THEN
5753: IF ( l_error_level >= G_debug_level) THEN
5754: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5755: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5756: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5757: ELSE
5758: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5759: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5760: fnd_msg_pub.add;

Line 5946: -- Variables in FND log

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
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

Line 5947: l_error_level number := FND_LOG.LEVEL_ERROR;

5943: l_api_name CONSTANT VARCHAR2(30) := 'SHIPMENT_UPDATE';
5944: l_api_version CONSTANT NUMBER := 1.0;
5945:
5946: -- Variables in FND log
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

Line 6071: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

6067: IF ( l_error_level >= G_debug_level) THEN
6068: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6069: fnd_message.set_token('SQLERRM',SQLERRM);
6070: fnd_message.set_token('SQLCODE',SQLCODE);
6071: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6072: END If;
6073: -- As we commit the processed records in the inner APIs
6074: -- so we rollback only if the p_commit= 'F'
6075: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 6088: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

6084: IF ( l_error_level >= G_debug_level) THEN
6085: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6086: fnd_message.set_token('SQLERRM',SQLERRM);
6087: fnd_message.set_token('SQLCODE',SQLCODE);
6088: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6089: END If;
6090: -- As we commit the processed records in the inner APIs
6091: -- so we rollback only if the p_commit= 'F'
6092: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 6428: -- Variables used for FND Log

6424: --bug#6753684, 6742512
6425: l_From_Date Date;
6426: l_TO_Date Date;
6427:
6428: -- Variables used for FND Log
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

Line 6429: l_error_level number := FND_LOG.LEVEL_ERROR;

6425: l_From_Date Date;
6426: l_TO_Date Date;
6427:
6428: -- Variables used for FND Log
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

Line 6586: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

6582: Exception
6583: When no_data_found then
6584: IF ( l_error_level >= G_debug_level) THEN
6585: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6586: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6587: ELSE
6588: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6589: fnd_msg_pub.add;
6590: END IF;

Line 6689: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

6685: IF SQL%NOTFOUND THEN
6686: IF ( l_error_level >= G_debug_level) THEN
6687: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6688: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6689: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6690: ELSE
6691: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6692: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6693: fnd_msg_pub.add;

Line 6718: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

6714: IF ( l_error_level >= G_debug_level) THEN
6715: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6716: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6717: fnd_msg_pub.add;
6718: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6719: fnd_file.put_line(fnd_file.log, fnd_message.get);
6720: ELSE
6721: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6722: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);

Line 6736: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

6732: IF ( l_error_level >= G_debug_level) THEN
6733: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6734: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6735: fnd_msg_pub.add;
6736: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6737: fnd_file.put_line(fnd_file.log, fnd_message.get);
6738: ELSE
6739: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6740: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);

Line 6779: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

6775: IF SQL%NOTFOUND THEN
6776: IF ( l_error_level >= G_debug_level) THEN
6777: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
6778: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
6779: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6780: ELSE
6781: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
6782: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
6783: fnd_msg_pub.add;

Line 7190: -- Variables for the FND Log

7186:
7187: -- activity record
7188: l_activity_rec activity_rec_type;
7189:
7190: -- Variables for the FND Log
7191: l_error_level number := FND_LOG.LEVEL_ERROR;
7192: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_ship_update';
7193:
7194: -- User defined exception

Line 7191: l_error_level number := FND_LOG.LEVEL_ERROR;

7187: -- activity record
7188: l_activity_rec activity_rec_type;
7189:
7190: -- Variables for the FND Log
7191: l_error_level number := FND_LOG.LEVEL_ERROR;
7192: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_ship_update';
7193:
7194: -- User defined exception
7195: PROCESS_ERROR EXCEPTION;

Line 7244: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7240: WHEN NO_DATA_FOUND THEN
7241: IF ( l_error_level >= G_debug_level) THEN
7242: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7243: fnd_message.set_token('HEADER_ID',p_order_header_id);
7244: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7245: ELSE
7246: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7247: fnd_message.set_token('HEADER_ID',p_order_header_id);
7248: fnd_msg_pub.add;

Line 7293: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7289: WHEN NO_DATA_FOUND THEN
7290: IF ( l_error_level >= G_debug_level) THEN
7291: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7292: fnd_message.set_token('HEADER_ID',DEL.header_id);
7293: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7294: ELSE
7295: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7296: fnd_message.set_token('HEADER_ID',DEL.header_id);
7297: fnd_msg_pub.add;

Line 7393: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7389: IF SQL%NOTFOUND THEN
7390: IF ( l_error_level >= G_debug_level) THEN
7391: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7392: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7393: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7394: ELSE
7395: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7396: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7397: fnd_msg_pub.add;

Line 7419: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7415: WHEN NO_DATA_FOUND THEN
7416: IF ( l_error_level >= G_debug_level) THEN
7417: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7418: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7419: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7420: ELSE
7421: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7422: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7423: fnd_msg_pub.add;

Line 7486: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7482: Exception
7483: When Others then
7484: IF ( l_error_level >= G_debug_level) THEN
7485: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7486: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7487: ELSE
7488: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7489: fnd_msg_pub.add;
7490: END IF;

Line 7550: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7546: IF SQL%NOTFOUND THEN
7547: IF ( l_error_level >= G_debug_level) THEN
7548: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7549: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7550: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7551: ELSE
7552: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7553: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7554: fnd_msg_pub.add;

Line 7581: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7577: IF SQL%NOTFOUND THEN
7578: IF ( l_error_level >= G_debug_level) THEN
7579: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7580: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7581: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7582: ELSE
7583: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7584: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7585: fnd_msg_pub.add;

Line 7708: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7704: IF SQL%NOTFOUND THEN
7705: IF ( l_error_level >= G_debug_level) THEN
7706: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7707: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7708: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7709: ELSE
7710: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7711: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7712: fnd_msg_pub.add;

Line 7734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7730: WHEN NO_DATA_FOUND THEN
7731: IF ( l_error_level >= G_debug_level) THEN
7732: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7733: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7735: ELSE
7736: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7737: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7738: fnd_msg_pub.add;

Line 7802: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

7798: Exception
7799: When Others then
7800: IF ( l_error_level >= G_debug_level) THEN
7801: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7802: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7803: ELSE
7804: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7805: fnd_msg_pub.add;
7806: END IF;

Line 7825: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

7821: IF SQL%NOTFOUND THEN
7822: IF ( l_error_level >= G_debug_level) THEN
7823: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7824: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7825: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7826: ELSE
7827: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7828: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7829: FND_MSG_PUB.ADD;

Line 7954: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

7950: IF SQL%NOTFOUND THEN
7951: IF ( l_error_level >= G_debug_level) THEN
7952: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
7953: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
7954: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7955: ELSE
7956: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
7957: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
7958: FND_MSG_PUB.ADD;

Line 7975: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

7971: IF SQL%NOTFOUND THEN
7972: IF ( l_error_level >= G_debug_level) THEN
7973: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7974: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7975: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7976: ELSE
7977: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7978: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7979: FND_MSG_PUB.ADD;

Line 8073: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

8069: IF SQL%NOTFOUND THEN
8070: IF ( l_error_level >= G_debug_level) THEN
8071: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8072: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8073: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8074: ELSE
8075: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8076: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8077: FND_MSG_PUB.ADD;

Line 8094: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

8090: IF SQL%NOTFOUND THEN
8091: IF ( l_error_level >= G_debug_level) THEN
8092: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8093: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8094: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8095: ELSE
8096: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8097: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8098: FND_MSG_PUB.ADD;

Line 8210: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

8206: IF SQL%NOTFOUND THEN
8207: IF ( l_error_level >= G_debug_level) THEN
8208: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8209: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8210: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8211: ELSE
8212: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8213: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8214: FND_MSG_PUB.ADD;

Line 8231: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

8227: IF SQL%NOTFOUND THEN
8228: IF ( l_error_level >= G_debug_level) THEN
8229: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8230: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8231: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8232: ELSE
8233: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8234: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8235: FND_MSG_PUB.ADD;

Line 8329: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

8325: IF SQL%NOTFOUND THEN
8326: IF ( l_error_level >= G_debug_level) THEN
8327: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8328: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8329: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8330: ELSE
8331: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8332: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8333: FND_MSG_PUB.ADD;

Line 8350: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

8346: IF SQL%NOTFOUND THEN
8347: IF ( l_error_level >= G_debug_level) THEN
8348: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8349: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8350: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8351: ELSE
8352: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8353: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8354: FND_MSG_PUB.ADD;

Line 8533: -- Variables used for FND log

8529:
8530: -- Variables used in the program
8531: l_dummy varchar2(30);
8532:
8533: -- Variables used for FND log
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

Line 8534: l_error_level number := FND_LOG.LEVEL_ERROR;

8530: -- Variables used in the program
8531: l_dummy varchar2(30);
8532:
8533: -- Variables used for FND log
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

Line 8648: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

8644: IF ( l_error_level >= G_debug_level) THEN
8645: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8646: fnd_message.set_token('SQLERRM',SQLERRM);
8647: fnd_message.set_token('SQLCODE',SQLCODE);
8648: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8649: END If;
8650: -- As we commit the processed records in the inner APIs
8651: -- so we rollback only if the p_commit = 'F'
8652: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 8665: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

8661: IF ( l_error_level >= G_debug_level) THEN
8662: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8663: fnd_message.set_token('SQLERRM',SQLERRM);
8664: fnd_message.set_token('SQLCODE',SQLCODE);
8665: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8666: END If;
8667: -- As we commit the processed records in the inner APIs
8668: -- so we rollback only if the p_commit = 'F'
8669: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 8734: -- Variables for FND Log

8730: l_return_status VARCHAR2(30);
8731: l_msg_count NUMBER;
8732: l_msg_data VARCHAR2(20000);
8733:
8734: -- Variables for FND Log
8735: l_error_level number := FND_LOG.LEVEL_ERROR;
8736: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update_conc_prog';
8737:
8738: BEGIN

Line 8735: l_error_level number := FND_LOG.LEVEL_ERROR;

8731: l_msg_count NUMBER;
8732: l_msg_data VARCHAR2(20000);
8733:
8734: -- Variables for FND Log
8735: l_error_level number := FND_LOG.LEVEL_ERROR;
8736: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update_conc_prog';
8737:
8738: BEGIN
8739: -- Initialize API return status to success

Line 8837: -- Variables for FND log

8833: l_success_status CONSTANT VARCHAR2(1) := '0';
8834: l_warning_status CONSTANT VARCHAR2(1) := '1';
8835: l_error_status CONSTANT VARCHAR2(1) := '2';
8836:
8837: -- Variables for FND log
8838: l_error_level number := FND_LOG.LEVEL_ERROR;
8839: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.wip_update_conc_prog';
8840:
8841: BEGIN

Line 8838: l_error_level number := FND_LOG.LEVEL_ERROR;

8834: l_warning_status CONSTANT VARCHAR2(1) := '1';
8835: l_error_status CONSTANT VARCHAR2(1) := '2';
8836:
8837: -- Variables for FND log
8838: l_error_level number := FND_LOG.LEVEL_ERROR;
8839: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.wip_update_conc_prog';
8840:
8841: BEGIN
8842: -- Initialize API return status to success

Line 8941: -- Variables for the FND Log

8937: l_success_status CONSTANT VARCHAR2(1) := '0';
8938: l_warning_status CONSTANT VARCHAR2(1) := '1';
8939: l_error_status CONSTANT VARCHAR2(1) := '2';
8940:
8941: -- Variables for the FND Log
8942: l_error_level number := FND_LOG.LEVEL_ERROR;
8943: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update_conc_prog';
8944:
8945: Begin

Line 8942: l_error_level number := FND_LOG.LEVEL_ERROR;

8938: l_warning_status CONSTANT VARCHAR2(1) := '1';
8939: l_error_status CONSTANT VARCHAR2(1) := '2';
8940:
8941: -- Variables for the FND Log
8942: l_error_level number := FND_LOG.LEVEL_ERROR;
8943: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update_conc_prog';
8944:
8945: Begin
8946: -- Initialize API return status to success

Line 9108: -- Variables for FND Log

9104: l_paramd4 DATE;
9105: l_owner VARCHAR2(240);
9106: l_task_status VARCHAR2(240);
9107:
9108: -- Variables for FND Log
9109: l_error_level number := FND_LOG.LEVEL_ERROR;
9110: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.task_update_conc_prog';
9111:
9112: BEGIN

Line 9109: l_error_level number := FND_LOG.LEVEL_ERROR;

9105: l_owner VARCHAR2(240);
9106: l_task_status VARCHAR2(240);
9107:
9108: -- Variables for FND Log
9109: l_error_level number := FND_LOG.LEVEL_ERROR;
9110: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.task_update_conc_prog';
9111:
9112: BEGIN
9113: