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:
15: --bug#8261344
16: G_CSD_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';

Line 193: -- Variables used in FND Log

189: p_mod_name in varchar2,
190: p_severity_level in number
191: ) IS
192:
193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;

190: p_severity_level in number
191: ) IS
192:
193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;

Line 195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

191: ) IS
192:
193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 196: l_event_level number := FND_LOG.LEVEL_EVENT;

192:
193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
200:

Line 197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
200:
201: BEGIN

Line 198: l_error_level number := FND_LOG.LEVEL_ERROR;

194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
200:
201: BEGIN
202:

Line 199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
200:
201: BEGIN
202:
203: IF p_severity_level = 1 THEN

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

201: BEGIN
202:
203: IF p_severity_level = 1 THEN
204: IF ( l_stat_level >= G_debug_level) THEN
205: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);
206: END IF;
207: ELSIF p_severity_level = 2 THEN
208: IF ( l_proc_level >= G_debug_level) THEN
209: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);

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

205: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);
206: END IF;
207: ELSIF p_severity_level = 2 THEN
208: IF ( l_proc_level >= G_debug_level) THEN
209: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);
210: END IF;
211: ELSIF p_severity_level = 3 THEN
212: IF ( l_event_level >= G_debug_level) THEN
213: FND_LOG.STRING(l_event_level,p_mod_name,p_message);

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

209: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);
210: END IF;
211: ELSIF p_severity_level = 3 THEN
212: IF ( l_event_level >= G_debug_level) THEN
213: FND_LOG.STRING(l_event_level,p_mod_name,p_message);
214: END IF;
215: ELSIF p_severity_level = 4 THEN
216: IF ( l_excep_level >= G_debug_level) THEN
217: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);

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

213: FND_LOG.STRING(l_event_level,p_mod_name,p_message);
214: END IF;
215: ELSIF p_severity_level = 4 THEN
216: IF ( l_excep_level >= G_debug_level) THEN
217: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);
218: END IF;
219: ELSIF p_severity_level = 5 THEN
220: IF ( l_error_level >= G_debug_level) THEN
221: FND_LOG.STRING(l_error_level,p_mod_name,p_message);

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

217: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);
218: END IF;
219: ELSIF p_severity_level = 5 THEN
220: IF ( l_error_level >= G_debug_level) THEN
221: FND_LOG.STRING(l_error_level,p_mod_name,p_message);
222: END IF;
223: ELSIF p_severity_level = 6 THEN
224: IF ( l_unexp_level >= G_debug_level) THEN
225: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);

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

221: FND_LOG.STRING(l_error_level,p_mod_name,p_message);
222: END IF;
223: ELSIF p_severity_level = 6 THEN
224: IF ( l_unexp_level >= G_debug_level) THEN
225: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);
226: END IF;
227: END IF;
228:
229: END DEBUG;

Line 356: -- Variables used in FND Log

352:
353: -- Variables used in the API
354: l_from_uom_code mtl_units_of_measure.uom_code%type;
355:
356: -- Variables used in FND Log
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

Line 357: l_error_level number := FND_LOG.LEVEL_ERROR;

353: -- Variables used in the API
354: l_from_uom_code mtl_units_of_measure.uom_code%type;
355:
356: -- Variables used in FND Log
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

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

378: WHEN NO_DATA_FOUND THEN
379: IF ( l_error_level >= G_debug_level) THEN
380: fnd_message.set_name('CSD','CSD_UOM_MISSING');
381: fnd_message.set_token('UOM',p_from_uom);
382: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
383: ELSE
384: fnd_message.set_name('CSD','CSD_UOM_MISSING');
385: fnd_message.set_token('UOM',p_from_uom);
386: fnd_msg_pub.add;

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

389: WHEN TOO_MANY_ROWS THEN
390: IF ( l_error_level >= G_debug_level) THEN
391: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
392: fnd_message.set_token('UOM',p_from_uom);
393: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
394: ELSE
395: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
396: fnd_message.set_token('UOM',p_from_uom);
397: fnd_msg_pub.add;

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

420: -- if the inv_convert api fails then it returns -99999
421: IF x_result_quantity < 0 then
422: IF ( l_error_level >= G_debug_level) THEN
423: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
424: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
425: ELSE
426: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
427: fnd_msg_pub.add;
428: END IF;

Line 493: -- Variable used in FND log

489:
490: -- Variables used in API
491: l_rep_hist_id NUMBER;
492:
493: -- Variable used in FND log
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

Line 494: l_error_level number := FND_LOG.LEVEL_ERROR;

490: -- Variables used in API
491: l_rep_hist_id NUMBER;
492:
493: -- Variable used in FND log
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

Line 722: -- Variable used in FND log

718:
719: -- Define a record of activity_rec_type
720: l_activity_rec activity_rec_type;
721:
722: -- Variable used in FND log
723: l_error_level number := FND_LOG.LEVEL_ERROR;
724: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.job_completion_update';
725:
726: -- User defined exception

Line 723: l_error_level number := FND_LOG.LEVEL_ERROR;

719: -- Define a record of activity_rec_type
720: l_activity_rec activity_rec_type;
721:
722: -- Variable used in FND log
723: l_error_level number := FND_LOG.LEVEL_ERROR;
724: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.job_completion_update';
725:
726: -- User defined exception
727: SKIP_RECORD EXCEPTION;

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

970: IF SQL%NOTFOUND THEN
971: IF ( l_error_level >= G_debug_level) THEN
972: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
973: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
974: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
975: ELSE
976: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
977: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
978: FND_MSG_PUB.ADD;

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

1093: IF SQL%NOTFOUND THEN
1094: IF ( l_error_level >= G_debug_level) THEN
1095: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1096: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1097: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1098: ELSE
1099: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1100: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1101: FND_MSG_PUB.ADD;

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

1225: IF SQL%NOTFOUND THEN
1226: IF ( l_error_level >= G_debug_level) THEN
1227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1228: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1229: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1230: ELSE
1231: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1232: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1233: FND_MSG_PUB.ADD;

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

1278: WHEN NO_DATA_FOUND THEN
1279: IF ( l_error_level >= G_debug_level) THEN
1280: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1281: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1282: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1283: ELSE
1284: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1285: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1286: FND_MSG_PUB.ADD;

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

1342: IF SQL%NOTFOUND THEN
1343: IF ( l_error_level >= G_debug_level) THEN
1344: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1345: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1346: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1347: ELSE
1348: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1349: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1350: FND_MSG_PUB.ADD;

Line 1553: -- Variable used in FND log

1549:
1550: -- activity record
1551: l_activity_rec activity_rec_type;
1552:
1553: -- Variable used in FND log
1554: l_error_level number := FND_LOG.LEVEL_ERROR;
1555: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.job_creation_update';
1556:
1557: -- This cursor gets all the records in csd_repair_job_xref

Line 1554: l_error_level number := FND_LOG.LEVEL_ERROR;

1550: -- activity record
1551: l_activity_rec activity_rec_type;
1552:
1553: -- Variable used in FND log
1554: l_error_level number := FND_LOG.LEVEL_ERROR;
1555: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.job_creation_update';
1556:
1557: -- This cursor gets all the records in csd_repair_job_xref
1558: -- that does not have wip_entity_id.

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

1717: IF SQL%NOTFOUND THEN
1718: IF ( l_error_level >= G_debug_level) THEN
1719: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1720: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1721: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1722: ELSE
1723: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1724: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1725: FND_MSG_PUB.ADD;

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

1738: IF SQL%NOTFOUND THEN
1739: IF ( l_error_level >= G_debug_level) THEN
1740: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1741: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1742: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1743: ELSE
1744: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1745: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1746: FND_MSG_PUB.ADD;

Line 1872: -- Variable used in FND log

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
1873: l_error_level number := FND_LOG.LEVEL_ERROR;
1874: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update';
1875:
1876: --bug#8261344

Line 1873: l_error_level number := FND_LOG.LEVEL_ERROR;

1869: l_api_name CONSTANT VARCHAR2(30) := 'RECEIPTS_UPDATE';
1870: l_api_version CONSTANT NUMBER := 1.0;
1871:
1872: -- Variable used in FND log
1873: l_error_level number := FND_LOG.LEVEL_ERROR;
1874: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update';
1875:
1876: --bug#8261344
1877: l_return_status varchar2(1);

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

2046: IF ( l_error_level >= G_debug_level) THEN
2047: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2048: fnd_message.set_token('SQLERRM',SQLERRM);
2049: fnd_message.set_token('SQLCODE',SQLCODE);
2050: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2051: END If;
2052: -- As we are committing the processed records in the inner APIs
2053: -- so we rollback only if the p_commit='F'
2054: IF NOT(FND_API.To_Boolean( p_commit )) THEN

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

2063: IF ( l_error_level >= G_debug_level) THEN
2064: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2065: fnd_message.set_token('SQLERRM',SQLERRM);
2066: fnd_message.set_token('SQLCODE',SQLCODE);
2067: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2068: END If;
2069: -- As we are committing the processed records in the inner APIs
2070: -- so we rollback only if the p_commit='F'
2071: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 2156: -- Variables for FND Log

2152: --bug#6753684, 6742512
2153: l_From_Date Date;
2154: l_TO_Date Date;
2155:
2156: -- Variables for FND Log
2157: l_error_level number := FND_LOG.LEVEL_ERROR;
2158: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.rma_rcv_update';
2159:
2160: -- User defined exceptions

Line 2157: l_error_level number := FND_LOG.LEVEL_ERROR;

2153: l_From_Date Date;
2154: l_TO_Date Date;
2155:
2156: -- Variables for FND Log
2157: l_error_level number := FND_LOG.LEVEL_ERROR;
2158: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.rma_rcv_update';
2159:
2160: -- User defined exceptions
2161: SKIP_RECORD EXCEPTION;

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

2668: When no_data_found then
2669: IF ( l_error_level >= G_debug_level) THEN
2670: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2671: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2672: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2673: ELSE
2674: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2675: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2676: fnd_msg_pub.add;

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

2695: IF (rcv_txn_serial_num%NOTFOUND) THEN
2696: IF ( l_error_level >= G_debug_level) THEN
2697: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2698: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2699: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2700: ELSE
2701: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2702: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2703: FND_MSG_PUB.ADD;

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

2729: WHEN NO_DATA_FOUND THEN
2730: IF ( l_error_level >= G_debug_level) THEN
2731: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2732: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2733: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2734: FND_MSG_PUB.ADD; -- swai: bug 12547701 need to add message to the stack
2735: ELSE
2736: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2737: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);

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

2752: WHEN TOO_MANY_ROWS THEN
2753: IF ( l_error_level >= G_debug_level) THEN
2754: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2755: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2756: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2757: FND_MSG_PUB.ADD; -- swai: bug 12547701 need to add message to the stack
2758: ELSE
2759: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2760: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);

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

2838: WHEN NO_DATA_FOUND THEN
2839: IF ( l_error_level >= G_debug_level) THEN
2840: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2841: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2842: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2843: ELSE
2844: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2845: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2846: fnd_msg_pub.add;

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

2909: IF SQL%NOTFOUND THEN
2910: IF ( l_error_level >= G_debug_level) THEN
2911: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2912: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2913: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2914: ELSE
2915: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2916: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2917: fnd_msg_pub.add;

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

2932: IF SQL%NOTFOUND THEN
2933: IF ( l_error_level >= G_debug_level) THEN
2934: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2935: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2936: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2937: ELSE
2938: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2939: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2940: fnd_msg_pub.add;

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

2968: IF SQL%NOTFOUND THEN
2969: IF ( l_error_level >= G_debug_level) THEN
2970: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2971: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2972: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2973: ELSE
2974: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2975: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2976: fnd_msg_pub.add;

Line 3278: -- Variable for the FND log file

3274:
3275: -- activity record
3276: l_activity_rec activity_rec_type;
3277:
3278: -- Variable for the FND log file
3279: l_error_level number := FND_LOG.LEVEL_ERROR;
3280: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_rcv_update';
3281:
3282: -- User defined exception

Line 3279: l_error_level number := FND_LOG.LEVEL_ERROR;

3275: -- activity record
3276: l_activity_rec activity_rec_type;
3277:
3278: -- Variable for the FND log file
3279: l_error_level number := FND_LOG.LEVEL_ERROR;
3280: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_rcv_update';
3281:
3282: -- User defined exception
3283: SKIP_RECORD EXCEPTION;

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

3463: WHEN NO_DATA_FOUND THEN
3464: IF ( l_error_level >= G_debug_level) THEN
3465: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3466: fnd_message.set_token('HEADER_ID',p_order_header_id);
3467: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3468: ELSE
3469: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3470: fnd_message.set_token('HEADER_ID',p_order_header_id);
3471: fnd_msg_pub.add;

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

3692: WHEN NO_DATA_FOUND THEN
3693: IF ( l_error_level >= G_debug_level) THEN
3694: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3695: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3696: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3697: ELSE
3698: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3699: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3700: fnd_msg_pub.add;

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

3714: When NO_DATA_FOUND THEN
3715: IF ( l_error_level >= G_debug_level) THEN
3716: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3717: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3718: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3719: ELSE
3720: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3721: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3722: fnd_msg_pub.add;

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

3724: When Others THEN
3725: IF ( l_error_level >= G_debug_level) THEN
3726: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3727: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3728: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3729: ELSE
3730: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3731: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3732: fnd_msg_pub.add;

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

3755: WHEN NO_DATA_FOUND THEN
3756: IF ( l_error_level >= G_debug_level) THEN
3757: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3758: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3759: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3760: ELSE
3761: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3762: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3763: fnd_msg_pub.add;

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

3803: IF SQL%NOTFOUND THEN
3804: IF ( l_error_level >= G_debug_level) THEN
3805: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3806: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3807: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3808: ELSE
3809: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3810: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3811: fnd_msg_pub.add;

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

3832: IF SQL%NOTFOUND THEN
3833: IF ( l_error_level >= G_debug_level) THEN
3834: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3835: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3836: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3837: ELSE
3838: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3839: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3840: fnd_msg_pub.add;

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

4060: WHEN NO_DATA_FOUND THEN
4061: IF ( l_error_level >= G_debug_level) THEN
4062: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4063: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4064: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4065: ELSE
4066: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4067: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4068: fnd_msg_pub.add;

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

4082: When NO_DATA_FOUND THEN
4083: IF ( l_error_level >= G_debug_level) THEN
4084: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4085: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4086: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4087: ELSE
4088: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4089: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4090: fnd_msg_pub.add;

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

4092: When Others THEN
4093: IF ( l_error_level >= G_debug_level) THEN
4094: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4095: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4096: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4097: ELSE
4098: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4099: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4100: fnd_msg_pub.add;

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

4123: WHEN NO_DATA_FOUND THEN
4124: IF ( l_error_level >= G_debug_level) THEN
4125: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4126: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4127: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4128: ELSE
4129: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4130: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4131: fnd_msg_pub.add;

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

4171: IF SQL%NOTFOUND THEN
4172: IF ( l_error_level >= G_debug_level) THEN
4173: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4174: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4175: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4176: ELSE
4177: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4178: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4179: fnd_msg_pub.add;

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

4201: IF SQL%NOTFOUND THEN
4202: IF ( l_error_level >= G_debug_level) THEN
4203: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4204: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4205: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4206: ELSE
4207: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4208: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4209: fnd_msg_pub.add;

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

4336: WHEN NO_DATA_FOUND THEN
4337: IF ( l_error_level >= G_debug_level) THEN
4338: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4339: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4340: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4341: ELSE
4342: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4343: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4344: fnd_msg_pub.add;

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

4359: When NO_DATA_FOUND THEN
4360: IF ( l_error_level >= G_debug_level) THEN
4361: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4362: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4363: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4364: ELSE
4365: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4366: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4367: fnd_msg_pub.add;

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

4369: When Others THEN
4370: IF ( l_error_level >= G_debug_level) THEN
4371: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4372: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4373: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4374: ELSE
4375: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4376: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4377: fnd_msg_pub.add;

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

4398: WHEN NO_DATA_FOUND THEN
4399: IF ( l_error_level >= G_debug_level) THEN
4400: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4401: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4402: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4403: ELSE
4404: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4405: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4406: fnd_msg_pub.add;

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

4446: IF SQL%NOTFOUND THEN
4447: IF ( l_error_level >= G_debug_level) THEN
4448: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4449: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4450: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4451: ELSE
4452: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4453: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4454: fnd_msg_pub.add;

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

4474: IF SQL%NOTFOUND THEN
4475: IF ( l_error_level >= G_debug_level) THEN
4476: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4477: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4478: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4479: ELSE
4480: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4481: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4482: fnd_msg_pub.add;

Line 4692: -- Variable for the FND log file

4688:
4689: -- activity record
4690: l_activity_rec activity_rec_type;
4691:
4692: -- Variable for the FND log file
4693: l_error_level number := FND_LOG.LEVEL_ERROR;
4694: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_rcv_update_move_out';
4695:
4696: -- User defined exception

Line 4693: l_error_level number := FND_LOG.LEVEL_ERROR;

4689: -- activity record
4690: l_activity_rec activity_rec_type;
4691:
4692: -- Variable for the FND log file
4693: l_error_level number := FND_LOG.LEVEL_ERROR;
4694: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_rcv_update_move_out';
4695:
4696: -- User defined exception
4697: SKIP_RECORD EXCEPTION;

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

4879: WHEN NO_DATA_FOUND THEN
4880: IF ( l_error_level >= G_debug_level) THEN
4881: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4882: fnd_message.set_token('HEADER_ID',p_order_header_id);
4883: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4884: ELSE
4885: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4886: fnd_message.set_token('HEADER_ID',p_order_header_id);
4887: fnd_msg_pub.add;

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

5108: WHEN NO_DATA_FOUND THEN
5109: IF ( l_error_level >= G_debug_level) THEN
5110: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5111: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5112: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5113: ELSE
5114: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5115: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5116: fnd_msg_pub.add;

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

5130: When NO_DATA_FOUND THEN
5131: IF ( l_error_level >= G_debug_level) THEN
5132: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5133: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5134: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5135: ELSE
5136: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5137: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5138: fnd_msg_pub.add;

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

5140: When Others THEN
5141: IF ( l_error_level >= G_debug_level) THEN
5142: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5143: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5144: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5145: ELSE
5146: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5147: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5148: fnd_msg_pub.add;

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

5171: WHEN NO_DATA_FOUND THEN
5172: IF ( l_error_level >= G_debug_level) THEN
5173: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5174: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5175: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5176: ELSE
5177: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5178: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5179: fnd_msg_pub.add;

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

5224: IF SQL%NOTFOUND THEN
5225: IF ( l_error_level >= G_debug_level) THEN
5226: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5227: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5228: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5229: ELSE
5230: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5231: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5232: fnd_msg_pub.add;

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

5253: IF SQL%NOTFOUND THEN
5254: IF ( l_error_level >= G_debug_level) THEN
5255: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5256: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5257: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5258: ELSE
5259: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5260: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5261: fnd_msg_pub.add;

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

5481: WHEN NO_DATA_FOUND THEN
5482: IF ( l_error_level >= G_debug_level) THEN
5483: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5484: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5485: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5486: ELSE
5487: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5488: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5489: fnd_msg_pub.add;

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

5503: When NO_DATA_FOUND THEN
5504: IF ( l_error_level >= G_debug_level) THEN
5505: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5506: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5507: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5508: ELSE
5509: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5510: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5511: fnd_msg_pub.add;

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

5513: When Others THEN
5514: IF ( l_error_level >= G_debug_level) THEN
5515: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5516: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5517: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5518: ELSE
5519: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5520: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5521: fnd_msg_pub.add;

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

5544: WHEN NO_DATA_FOUND THEN
5545: IF ( l_error_level >= G_debug_level) THEN
5546: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5547: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5548: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5549: ELSE
5550: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5551: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5552: fnd_msg_pub.add;

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

5597: IF SQL%NOTFOUND THEN
5598: IF ( l_error_level >= G_debug_level) THEN
5599: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5600: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5601: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5602: ELSE
5603: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5604: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5605: fnd_msg_pub.add;

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

5627: IF SQL%NOTFOUND THEN
5628: IF ( l_error_level >= G_debug_level) THEN
5629: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5630: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5631: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5632: ELSE
5633: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5634: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5635: fnd_msg_pub.add;

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

5770: WHEN NO_DATA_FOUND THEN
5771: IF ( l_error_level >= G_debug_level) THEN
5772: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5773: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5774: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5775: ELSE
5776: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5777: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5778: fnd_msg_pub.add;

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

5793: When NO_DATA_FOUND THEN
5794: IF ( l_error_level >= G_debug_level) THEN
5795: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5796: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5797: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5798: ELSE
5799: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5800: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5801: fnd_msg_pub.add;

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

5803: When Others THEN
5804: IF ( l_error_level >= G_debug_level) THEN
5805: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5806: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5807: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5808: ELSE
5809: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5810: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5811: fnd_msg_pub.add;

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

5832: WHEN NO_DATA_FOUND THEN
5833: IF ( l_error_level >= G_debug_level) THEN
5834: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5835: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5836: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5837: ELSE
5838: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5839: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5840: fnd_msg_pub.add;

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

5885: IF SQL%NOTFOUND THEN
5886: IF ( l_error_level >= G_debug_level) THEN
5887: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5888: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5889: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5890: ELSE
5891: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5892: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5893: fnd_msg_pub.add;

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

5913: IF SQL%NOTFOUND THEN
5914: IF ( l_error_level >= G_debug_level) THEN
5915: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5916: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5917: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5918: ELSE
5919: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5920: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5921: fnd_msg_pub.add;

Line 6107: -- Variables in FND log

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
6108: l_error_level number := FND_LOG.LEVEL_ERROR;
6109: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update';
6110:
6111: --bug#8261344

Line 6108: l_error_level number := FND_LOG.LEVEL_ERROR;

6104: l_api_name CONSTANT VARCHAR2(30) := 'SHIPMENT_UPDATE';
6105: l_api_version CONSTANT NUMBER := 1.0;
6106:
6107: -- Variables in FND log
6108: l_error_level number := FND_LOG.LEVEL_ERROR;
6109: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update';
6110:
6111: --bug#8261344
6112: l_return_status varchar2(1);

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

6266: IF ( l_error_level >= G_debug_level) THEN
6267: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6268: fnd_message.set_token('SQLERRM',SQLERRM);
6269: fnd_message.set_token('SQLCODE',SQLCODE);
6270: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6271: END If;
6272: -- As we commit the processed records in the inner APIs
6273: -- so we rollback only if the p_commit= 'F'
6274: IF NOT(FND_API.To_Boolean( p_commit )) THEN

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

6283: IF ( l_error_level >= G_debug_level) THEN
6284: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6285: fnd_message.set_token('SQLERRM',SQLERRM);
6286: fnd_message.set_token('SQLCODE',SQLCODE);
6287: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6288: END If;
6289: -- As we commit the processed records in the inner APIs
6290: -- so we rollback only if the p_commit= 'F'
6291: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 6630: -- Variables used for FND Log

6626: --bug#6753684, 6742512
6627: l_From_Date Date;
6628: l_TO_Date Date;
6629:
6630: -- Variables used for FND Log
6631: l_error_level number := FND_LOG.LEVEL_ERROR;
6632: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.so_ship_update';
6633:
6634: --bug#8261344

Line 6631: l_error_level number := FND_LOG.LEVEL_ERROR;

6627: l_From_Date Date;
6628: l_TO_Date Date;
6629:
6630: -- Variables used for FND Log
6631: l_error_level number := FND_LOG.LEVEL_ERROR;
6632: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.so_ship_update';
6633:
6634: --bug#8261344
6635: l_skip_record BOOLEAN := FALSE;

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

6814: Exception
6815: When no_data_found then
6816: IF ( l_error_level >= G_debug_level) THEN
6817: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6818: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6819: ELSE
6820: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6821: fnd_msg_pub.add;
6822: END IF;

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

6917: IF SQL%NOTFOUND THEN
6918: IF ( l_error_level >= G_debug_level) THEN
6919: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6920: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6921: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6922: ELSE
6923: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6924: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6925: fnd_msg_pub.add;

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

6947: IF ( l_error_level >= G_debug_level) THEN
6948: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6949: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6950: fnd_msg_pub.add;
6951: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6952: fnd_file.put_line(fnd_file.log, fnd_message.get);
6953: ELSE
6954: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6955: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);

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

6976: IF ( l_error_level >= G_debug_level) THEN
6977: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6978: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6979: fnd_msg_pub.add;
6980: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6981: fnd_file.put_line(fnd_file.log, fnd_message.get);
6982: ELSE
6983: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6984: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);

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

7023: IF SQL%NOTFOUND THEN
7024: IF ( l_error_level >= G_debug_level) THEN
7025: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
7026: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
7027: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7028: ELSE
7029: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
7030: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
7031: fnd_msg_pub.add;

Line 7482: -- Variables for the FND Log

7478:
7479: -- activity record
7480: l_activity_rec activity_rec_type;
7481:
7482: -- Variables for the FND Log
7483: l_error_level number := FND_LOG.LEVEL_ERROR;
7484: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_ship_update';
7485:
7486: -- User defined exception

Line 7483: l_error_level number := FND_LOG.LEVEL_ERROR;

7479: -- activity record
7480: l_activity_rec activity_rec_type;
7481:
7482: -- Variables for the FND Log
7483: l_error_level number := FND_LOG.LEVEL_ERROR;
7484: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.io_ship_update';
7485:
7486: -- User defined exception
7487: PROCESS_ERROR EXCEPTION;

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

7532: WHEN NO_DATA_FOUND THEN
7533: IF ( l_error_level >= G_debug_level) THEN
7534: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7535: fnd_message.set_token('HEADER_ID',p_order_header_id);
7536: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7537: ELSE
7538: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7539: fnd_message.set_token('HEADER_ID',p_order_header_id);
7540: fnd_msg_pub.add;

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

7581: WHEN NO_DATA_FOUND THEN
7582: IF ( l_error_level >= G_debug_level) THEN
7583: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7584: fnd_message.set_token('HEADER_ID',DEL.header_id);
7585: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7586: ELSE
7587: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7588: fnd_message.set_token('HEADER_ID',DEL.header_id);
7589: fnd_msg_pub.add;

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

7681: IF SQL%NOTFOUND THEN
7682: IF ( l_error_level >= G_debug_level) THEN
7683: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7684: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7685: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7686: ELSE
7687: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7688: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7689: fnd_msg_pub.add;

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

7707: WHEN NO_DATA_FOUND THEN
7708: IF ( l_error_level >= G_debug_level) THEN
7709: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7710: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7711: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7712: ELSE
7713: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7714: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7715: fnd_msg_pub.add;

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

7774: Exception
7775: When Others then
7776: IF ( l_error_level >= G_debug_level) THEN
7777: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7778: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7779: ELSE
7780: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7781: fnd_msg_pub.add;
7782: END IF;

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

7838: IF SQL%NOTFOUND THEN
7839: IF ( l_error_level >= G_debug_level) THEN
7840: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7841: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7842: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7843: ELSE
7844: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7845: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7846: fnd_msg_pub.add;

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

7869: IF SQL%NOTFOUND THEN
7870: IF ( l_error_level >= G_debug_level) THEN
7871: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7872: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7873: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7874: ELSE
7875: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7876: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7877: fnd_msg_pub.add;

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

7996: IF SQL%NOTFOUND THEN
7997: IF ( l_error_level >= G_debug_level) THEN
7998: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7999: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
8000: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
8001: ELSE
8002: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
8003: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
8004: fnd_msg_pub.add;

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

8022: WHEN NO_DATA_FOUND THEN
8023: IF ( l_error_level >= G_debug_level) THEN
8024: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
8025: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
8026: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
8027: ELSE
8028: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
8029: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
8030: fnd_msg_pub.add;

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

8090: Exception
8091: When Others then
8092: IF ( l_error_level >= G_debug_level) THEN
8093: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
8094: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
8095: ELSE
8096: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
8097: fnd_msg_pub.add;
8098: END IF;

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

8113: IF SQL%NOTFOUND THEN
8114: IF ( l_error_level >= G_debug_level) THEN
8115: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8116: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8117: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8118: ELSE
8119: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8120: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8121: FND_MSG_PUB.ADD;

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

8242: IF SQL%NOTFOUND THEN
8243: IF ( l_error_level >= G_debug_level) THEN
8244: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8245: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8246: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8247: ELSE
8248: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8249: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8250: FND_MSG_PUB.ADD;

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

8263: IF SQL%NOTFOUND THEN
8264: IF ( l_error_level >= G_debug_level) THEN
8265: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8266: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8267: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8268: ELSE
8269: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8270: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8271: FND_MSG_PUB.ADD;

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

8361: IF SQL%NOTFOUND THEN
8362: IF ( l_error_level >= G_debug_level) THEN
8363: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8364: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8365: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8366: ELSE
8367: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8368: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8369: FND_MSG_PUB.ADD;

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

8382: IF SQL%NOTFOUND THEN
8383: IF ( l_error_level >= G_debug_level) THEN
8384: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8385: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8386: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8387: ELSE
8388: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8389: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8390: FND_MSG_PUB.ADD;

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

8498: IF SQL%NOTFOUND THEN
8499: IF ( l_error_level >= G_debug_level) THEN
8500: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8501: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8502: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8503: ELSE
8504: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8505: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8506: FND_MSG_PUB.ADD;

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

8519: IF SQL%NOTFOUND THEN
8520: IF ( l_error_level >= G_debug_level) THEN
8521: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8522: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8523: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8524: ELSE
8525: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8526: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8527: FND_MSG_PUB.ADD;

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

8617: IF SQL%NOTFOUND THEN
8618: IF ( l_error_level >= G_debug_level) THEN
8619: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8620: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8621: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8622: ELSE
8623: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8624: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8625: FND_MSG_PUB.ADD;

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

8638: IF SQL%NOTFOUND THEN
8639: IF ( l_error_level >= G_debug_level) THEN
8640: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8641: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8642: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8643: ELSE
8644: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8645: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8646: FND_MSG_PUB.ADD;

Line 8825: -- Variables used for FND log

8821:
8822: -- Variables used in the program
8823: l_dummy varchar2(30);
8824:
8825: -- Variables used for FND log
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

Line 8826: l_error_level number := FND_LOG.LEVEL_ERROR;

8822: -- Variables used in the program
8823: l_dummy varchar2(30);
8824:
8825: -- Variables used for FND log
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

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

8936: IF ( l_error_level >= G_debug_level) THEN
8937: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8938: fnd_message.set_token('SQLERRM',SQLERRM);
8939: fnd_message.set_token('SQLCODE',SQLCODE);
8940: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8941: END If;
8942: -- As we commit the processed records in the inner APIs
8943: -- so we rollback only if the p_commit = 'F'
8944: IF NOT(FND_API.To_Boolean( p_commit )) THEN

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

8953: IF ( l_error_level >= G_debug_level) THEN
8954: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8955: fnd_message.set_token('SQLERRM',SQLERRM);
8956: fnd_message.set_token('SQLCODE',SQLCODE);
8957: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8958: END If;
8959: -- As we commit the processed records in the inner APIs
8960: -- so we rollback only if the p_commit = 'F'
8961: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 9027: -- Variables for FND Log

9023: l_msg_count NUMBER;
9024: l_msg_data VARCHAR2(30000); --bug#8261344
9025: l_msg_text VARCHAR2(2000); -- swai: bug 12547701
9026:
9027: -- Variables for FND Log
9028: l_error_level number := FND_LOG.LEVEL_ERROR;
9029: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update_conc_prog';
9030:
9031: BEGIN

Line 9028: l_error_level number := FND_LOG.LEVEL_ERROR;

9024: l_msg_data VARCHAR2(30000); --bug#8261344
9025: l_msg_text VARCHAR2(2000); -- swai: bug 12547701
9026:
9027: -- Variables for FND Log
9028: l_error_level number := FND_LOG.LEVEL_ERROR;
9029: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update_conc_prog';
9030:
9031: BEGIN
9032: -- Initialize API return status to success

Line 9161: -- Variables for FND log

9157: l_success_status CONSTANT VARCHAR2(1) := '0';
9158: l_warning_status CONSTANT VARCHAR2(1) := '1';
9159: l_error_status CONSTANT VARCHAR2(1) := '2';
9160:
9161: -- Variables for FND log
9162: l_error_level number := FND_LOG.LEVEL_ERROR;
9163: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.wip_update_conc_prog';
9164:
9165: BEGIN

Line 9162: l_error_level number := FND_LOG.LEVEL_ERROR;

9158: l_warning_status CONSTANT VARCHAR2(1) := '1';
9159: l_error_status CONSTANT VARCHAR2(1) := '2';
9160:
9161: -- Variables for FND log
9162: l_error_level number := FND_LOG.LEVEL_ERROR;
9163: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.wip_update_conc_prog';
9164:
9165: BEGIN
9166: -- Initialize API return status to success

Line 9266: -- Variables for the FND Log

9262: l_success_status CONSTANT VARCHAR2(1) := '0';
9263: l_warning_status CONSTANT VARCHAR2(1) := '1';
9264: l_error_status CONSTANT VARCHAR2(1) := '2';
9265:
9266: -- Variables for the FND Log
9267: l_error_level number := FND_LOG.LEVEL_ERROR;
9268: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update_conc_prog';
9269:
9270: Begin

Line 9267: l_error_level number := FND_LOG.LEVEL_ERROR;

9263: l_warning_status CONSTANT VARCHAR2(1) := '1';
9264: l_error_status CONSTANT VARCHAR2(1) := '2';
9265:
9266: -- Variables for the FND Log
9267: l_error_level number := FND_LOG.LEVEL_ERROR;
9268: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update_conc_prog';
9269:
9270: Begin
9271: -- Initialize API return status to success

Line 9460: -- Variables for FND Log

9456: l_paramd4 DATE;
9457: l_owner VARCHAR2(240);
9458: l_task_status VARCHAR2(240);
9459:
9460: -- Variables for FND Log
9461: l_error_level number := FND_LOG.LEVEL_ERROR;
9462: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.task_update_conc_prog';
9463:
9464: BEGIN

Line 9461: l_error_level number := FND_LOG.LEVEL_ERROR;

9457: l_owner VARCHAR2(240);
9458: l_task_status VARCHAR2(240);
9459:
9460: -- Variables for FND Log
9461: l_error_level number := FND_LOG.LEVEL_ERROR;
9462: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.task_update_conc_prog';
9463:
9464: BEGIN
9465: