[Home] [Help]
376: where unit_of_measure = p_from_uom;
377: Exception
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');
377: Exception
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);
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;
387: END IF;
388: RAISE FND_API.G_EXC_ERROR;
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;
387: END IF;
388: RAISE FND_API.G_EXC_ERROR;
389: WHEN TOO_MANY_ROWS THEN
387: END IF;
388: RAISE FND_API.G_EXC_ERROR;
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');
388: RAISE FND_API.G_EXC_ERROR;
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);
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;
398: END IF;
399: RAISE FND_API.G_EXC_ERROR;
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;
398: END IF;
399: RAISE FND_API.G_EXC_ERROR;
400: End;
419:
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;
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;
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
968: last_update_login = fnd_global.login_id
969: where repair_job_xref_id = JOB.repair_job_xref_id;
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');
969: where repair_job_xref_id = JOB.repair_job_xref_id;
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 );
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;
979: END IF;
980: RAISE FND_API.G_EXC_ERROR;
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;
979: END IF;
980: RAISE FND_API.G_EXC_ERROR;
981: End IF;
1091: last_update_login = fnd_global.login_id
1092: where repair_job_xref_id = JOB.repair_job_xref_id;
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');
1092: where repair_job_xref_id = JOB.repair_job_xref_id;
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 );
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;
1102: END IF;
1103: RAISE FND_API.G_EXC_ERROR;
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;
1102: END IF;
1103: RAISE FND_API.G_EXC_ERROR;
1104: End IF;
1223: last_update_login = fnd_global.login_id
1224: where repair_job_xref_id = JOB.repair_job_xref_id;
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');
1224: where repair_job_xref_id = JOB.repair_job_xref_id;
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 );
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;
1234: END IF;
1235: RAISE FND_API.G_EXC_ERROR;
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;
1234: END IF;
1235: RAISE FND_API.G_EXC_ERROR;
1236: End IF;
1276:
1277: EXCEPTION
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');
1277: EXCEPTION
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 );
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;
1287: END IF;
1288: RAISE FND_API.G_EXC_ERROR;
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;
1287: END IF;
1288: RAISE FND_API.G_EXC_ERROR;
1289: END;
1340: last_update_login = fnd_global.login_id
1341: where repair_job_xref_id = JOB.repair_job_xref_id;
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');
1341: where repair_job_xref_id = JOB.repair_job_xref_id;
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 );
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;
1351: END IF;
1352: RAISE FND_API.G_EXC_ERROR;
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;
1351: END IF;
1352: RAISE FND_API.G_EXC_ERROR;
1353: End IF;
1443: END IF;
1444:
1445:
1446: -- Log messages for the number of records processed
1447: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1448: fnd_message.set_token('TOT_REC',to_char(l_total_rec));
1449: FND_MSG_PUB.ADD;
1450:
1451: -- Retrive the message from the msg stack
1444:
1445:
1446: -- Log messages for the number of records processed
1447: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1448: fnd_message.set_token('TOT_REC',to_char(l_total_rec));
1449: FND_MSG_PUB.ADD;
1450:
1451: -- Retrive the message from the msg stack
1452: l_msg_text := fnd_message.get;
1448: fnd_message.set_token('TOT_REC',to_char(l_total_rec));
1449: FND_MSG_PUB.ADD;
1450:
1451: -- Retrive the message from the msg stack
1452: l_msg_text := fnd_message.get;
1453:
1454: -- Log the number of records processed in concurrent program output and log file
1455: fnd_file.put_line(fnd_file.log,l_msg_text);
1456: fnd_file.put_line(fnd_file.output,l_msg_text);
1715: last_update_login = fnd_global.login_id
1716: where repair_job_xref_id = K.repair_job_xref_id;
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');
1716: where repair_job_xref_id = K.repair_job_xref_id;
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 );
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;
1726: END IF;
1727: RAISE FND_API.G_EXC_ERROR;
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;
1726: END IF;
1727: RAISE FND_API.G_EXC_ERROR;
1728: End IF;
1736: last_update_login = fnd_global.login_id
1737: where repair_line_id = K.repair_line_id;
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');
1737: where repair_line_id = K.repair_line_id;
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 );
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;
1747: END IF;
1748: RAISE FND_API.G_EXC_ERROR;
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;
1747: END IF;
1748: RAISE FND_API.G_EXC_ERROR;
1749: End IF;
2043: p_data => x_msg_data );
2044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2045: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
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;
2044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2045: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
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
2045: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
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'
2060: p_data => x_msg_data );
2061: WHEN OTHERS THEN
2062: Debug('In OTHERS exception',l_mod_name,4 );
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;
2061: WHEN OTHERS THEN
2062: Debug('In OTHERS exception',l_mod_name,4 );
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
2062: Debug('In OTHERS exception',l_mod_name,4 );
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'
2666: and organization_id = i.organization_id;
2667: Exception
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');
2667: Exception
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);
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;
2677: END IF;
2678: RAISE FND_API.G_EXC_ERROR;
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;
2677: END IF;
2678: RAISE FND_API.G_EXC_ERROR;
2679: When others then
2693: Open rcv_txn_serial_num(i.transaction_id );
2694: Fetch rcv_txn_serial_num into l_st_serial_num, l_lot_number;
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');
2694: Fetch rcv_txn_serial_num into l_st_serial_num, l_lot_number;
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);
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;
2704: END IF;
2705: RAISE FND_API.G_EXC_ERROR;
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;
2704: END IF;
2705: RAISE FND_API.G_EXC_ERROR;
2706: END IF;
2727: --and instance_usage_code = 'IN_INVENTORY';
2728: EXCEPTION
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
2728: EXCEPTION
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');
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);
2738: FND_MSG_PUB.ADD;
2739: END IF;
2740:
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);
2738: FND_MSG_PUB.ADD;
2739: END IF;
2740:
2741: --RAISE FND_API.G_EXC_ERROR;
2750:
2751: Debug(' Could not find any IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);
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
2751: Debug(' Could not find any IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);
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');
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);
2761: FND_MSG_PUB.ADD;
2762: END IF;
2763: RAISE FND_API.G_EXC_ERROR;
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);
2761: FND_MSG_PUB.ADD;
2762: END IF;
2763: RAISE FND_API.G_EXC_ERROR;
2764: Debug(' Found many IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);
2836: where source_transaction_id = I.transaction_id;
2837: EXCEPTION
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');
2837: EXCEPTION
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);
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;
2847: END IF;
2848: RAISE FND_API.G_EXC_ERROR;
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;
2847: END IF;
2848: RAISE FND_API.G_EXC_ERROR;
2849:
2907: last_update_login = fnd_global.login_id
2908: where repair_line_id = I.repair_line_id;
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');
2908: where repair_line_id = I.repair_line_id;
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);
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;
2918: END IF;
2919: RAISE FND_API.G_EXC_ERROR;
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;
2918: END IF;
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2930: last_update_login = fnd_global.login_id
2931: where repair_line_id = I.repair_line_id;
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');
2931: where repair_line_id = I.repair_line_id;
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);
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;
2941: END IF;
2942: RAISE FND_API.G_EXC_ERROR;
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;
2941: END IF;
2942: RAISE FND_API.G_EXC_ERROR;
2943: END IF;
2966: last_update_login = fnd_global.login_id
2967: WHERE product_transaction_id = i.product_transaction_id;
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');
2967: WHERE product_transaction_id = i.product_transaction_id;
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);
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;
2977: END IF;
2978: RAISE FND_API.G_EXC_ERROR;
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;
2977: END IF;
2978: RAISE FND_API.G_EXC_ERROR;
2979: END IF;
2977: END IF;
2978: RAISE FND_API.G_EXC_ERROR;
2979: END IF;
2980:
2981: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2982: fnd_message.set_token('RMA_NO',i.rma_number);
2983: fnd_message.set_token('REP_NO',i.repair_number);
2984: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2985: FND_MSG_PUB.ADD;
2978: RAISE FND_API.G_EXC_ERROR;
2979: END IF;
2980:
2981: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2982: fnd_message.set_token('RMA_NO',i.rma_number);
2983: fnd_message.set_token('REP_NO',i.repair_number);
2984: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2985: FND_MSG_PUB.ADD;
2986:
2979: END IF;
2980:
2981: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2982: fnd_message.set_token('RMA_NO',i.rma_number);
2983: fnd_message.set_token('REP_NO',i.repair_number);
2984: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2985: FND_MSG_PUB.ADD;
2986:
2987: --bug#13505961
2980:
2981: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2982: fnd_message.set_token('RMA_NO',i.rma_number);
2983: fnd_message.set_token('REP_NO',i.repair_number);
2984: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2985: FND_MSG_PUB.ADD;
2986:
2987: --bug#13505961
2988: --need to update the received organization_id
2993:
2994: --bug#13505961
2995:
2996: -- Debug message
2997: Debug(fnd_message.get,l_mod_name,1);
2998:
2999: -- Log messages in concurrent log and output file
3000: fnd_file.put_line(fnd_file.log, fnd_message.get);
3001:
2996: -- Debug message
2997: Debug(fnd_message.get,l_mod_name,1);
2998:
2999: -- Log messages in concurrent log and output file
3000: fnd_file.put_line(fnd_file.log, fnd_message.get);
3001:
3002: -- Initialize the activity rec
3003: l_activity_rec := INIT_ACTIVITY_REC ;
3004:
3147: END IF;
3148:
3149: -- Log seed messages for the number of records
3150: -- processed by rma update
3151: fnd_message.set_name('CSD','CSD_DRC_RMA_TOT_REC_PROC');
3152: fnd_message.set_token('TOT_REC',to_char(l_total_records));
3153: FND_MSG_PUB.ADD;
3154:
3155: -- Debug Messages
3148:
3149: -- Log seed messages for the number of records
3150: -- processed by rma update
3151: fnd_message.set_name('CSD','CSD_DRC_RMA_TOT_REC_PROC');
3152: fnd_message.set_token('TOT_REC',to_char(l_total_records));
3153: FND_MSG_PUB.ADD;
3154:
3155: -- Debug Messages
3156: Debug(fnd_message.get,l_mod_name,1);
3152: fnd_message.set_token('TOT_REC',to_char(l_total_records));
3153: FND_MSG_PUB.ADD;
3154:
3155: -- Debug Messages
3156: Debug(fnd_message.get,l_mod_name,1);
3157:
3158: -- Log the number of records processed in concurrent
3159: -- program output and log file
3160: fnd_file.put_line(fnd_file.log,fnd_message.get);
3156: Debug(fnd_message.get,l_mod_name,1);
3157:
3158: -- Log the number of records processed in concurrent
3159: -- program output and log file
3160: fnd_file.put_line(fnd_file.log,fnd_message.get);
3161: fnd_file.put_line(fnd_file.output,fnd_message.get);
3162:
3163: -- Standard check of p_commit.
3164: IF FND_API.To_Boolean( p_commit ) THEN
3157:
3158: -- Log the number of records processed in concurrent
3159: -- program output and log file
3160: fnd_file.put_line(fnd_file.log,fnd_message.get);
3161: fnd_file.put_line(fnd_file.output,fnd_message.get);
3162:
3163: -- Standard check of p_commit.
3164: IF FND_API.To_Boolean( p_commit ) THEN
3165: COMMIT WORK;
3461: and cpt.order_header_id = oeh.header_id);
3462: EXCEPTION
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');
3462: EXCEPTION
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);
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;
3472: END IF;
3473: RAISE FND_API.G_EXC_ERROR;
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;
3472: END IF;
3473: RAISE FND_API.G_EXC_ERROR;
3474: END;
3690: and cra.serial_number = rcvt.serial_num);
3691: Exception
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');
3691: Exception
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);
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;
3701: END If;
3702: RAISE PROCESS_ERROR;
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;
3701: END If;
3702: RAISE PROCESS_ERROR;
3703: END;
3712: and serial_number = l_serial_num;
3713: Exception
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');
3713: Exception
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);
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;
3723: END If;
3724: When Others THEN
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;
3723: END If;
3724: When Others THEN
3725: IF ( l_error_level >= G_debug_level) THEN
3722: fnd_msg_pub.add;
3723: END If;
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');
3723: END If;
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);
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;
3733: END If;
3734: End;
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;
3733: END If;
3734: End;
3735: ELSE
3753: where source_transaction_id = DEL.transaction_id;
3754: EXCEPTION
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');
3754: EXCEPTION
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);
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;
3764: END IF;
3765: RAISE FND_API.G_EXC_ERROR;
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;
3764: END IF;
3765: RAISE FND_API.G_EXC_ERROR;
3766: END;
3801: last_update_login = fnd_global.login_id
3802: WHERE repair_line_id = RO.repair_line_id;
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');
3802: WHERE repair_line_id = RO.repair_line_id;
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);
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;
3812: END IF;
3813: RAISE PROCESS_ERROR;
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;
3812: END IF;
3813: RAISE PROCESS_ERROR;
3814: END IF;
3830: last_update_login = fnd_global.login_id
3831: WHERE product_transaction_id = RO.product_transaction_id;
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');
3831: WHERE product_transaction_id = RO.product_transaction_id;
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);
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;
3841: END IF;
3842: RAISE PROCESS_ERROR;
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;
3841: END IF;
3842: RAISE PROCESS_ERROR;
3843: END IF;
4058: and cra.serial_number = rcvt.serial_num);
4059: Exception
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');
4059: Exception
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);
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;
4069: END If;
4070: RAISE PROCESS_ERROR;
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;
4069: END If;
4070: RAISE PROCESS_ERROR;
4071: END;
4080: and serial_number = l_serial_num;
4081: Exception
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');
4081: Exception
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);
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;
4091: END If;
4092: When Others THEN
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;
4091: END If;
4092: When Others THEN
4093: IF ( l_error_level >= G_debug_level) THEN
4090: fnd_msg_pub.add;
4091: END If;
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');
4091: END If;
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);
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;
4101: END If;
4102: End;
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;
4101: END If;
4102: End;
4103: ELSE
4121: where source_transaction_id = DEL.transaction_id;
4122: EXCEPTION
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');
4122: EXCEPTION
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);
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;
4132: END IF;
4133: RAISE FND_API.G_EXC_ERROR;
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;
4132: END IF;
4133: RAISE FND_API.G_EXC_ERROR;
4134: END;
4169: last_update_login = fnd_global.login_id
4170: WHERE repair_line_id = RO.repair_line_id;
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');
4170: WHERE repair_line_id = RO.repair_line_id;
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);
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;
4180: END IF;
4181: RAISE PROCESS_ERROR;
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;
4180: END IF;
4181: RAISE PROCESS_ERROR;
4182: END IF;
4199: last_update_login = fnd_global.login_id
4200: WHERE product_transaction_id = RO.product_transaction_id;
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');
4200: WHERE product_transaction_id = RO.product_transaction_id;
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);
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;
4210: END IF;
4211: RAISE PROCESS_ERROR;
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;
4210: END IF;
4211: RAISE PROCESS_ERROR;
4212: END IF;
4334: and cra.serial_number = rcvt.serial_num);
4335: Exception
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');
4335: Exception
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);
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;
4345: END IF;
4346: RAISE PROCESS_ERROR;
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;
4345: END IF;
4346: RAISE PROCESS_ERROR;
4347: END;
4357: and serial_number = l_serial_num;
4358: Exception
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');
4358: Exception
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);
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;
4368: END If;
4369: When Others THEN
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;
4368: END If;
4369: When Others THEN
4370: IF ( l_error_level >= G_debug_level) THEN
4367: fnd_msg_pub.add;
4368: END If;
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');
4368: END If;
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);
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;
4378: END If;
4379: End;
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;
4378: END If;
4379: End;
4380: ELSE
4396: where source_transaction_id = RCV.transaction_id;
4397: EXCEPTION
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');
4397: EXCEPTION
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);
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;
4407: END IF;
4408: RAISE FND_API.G_EXC_ERROR;
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;
4407: END IF;
4408: RAISE FND_API.G_EXC_ERROR;
4409: END;
4444: last_update_login = fnd_global.login_id
4445: WHERE repair_line_id = RO.repair_line_id;
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');
4445: WHERE repair_line_id = RO.repair_line_id;
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);
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;
4455: END IF;
4456: RAISE PROCESS_ERROR;
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;
4455: END IF;
4456: RAISE PROCESS_ERROR;
4457: END IF;
4472: last_update_login = fnd_global.login_id
4473: WHERE product_transaction_id = RO.product_transaction_id;
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');
4473: WHERE product_transaction_id = RO.product_transaction_id;
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);
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;
4483: END IF;
4484: RAISE PROCESS_ERROR;
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;
4483: END IF;
4484: RAISE PROCESS_ERROR;
4485: END IF;
4877: and cpt.order_header_id = oeh.header_id);
4878: EXCEPTION
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');
4878: EXCEPTION
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);
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;
4888: END IF;
4889: RAISE FND_API.G_EXC_ERROR;
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;
4888: END IF;
4889: RAISE FND_API.G_EXC_ERROR;
4890: END;
5106: and cra.serial_number = rcvt.serial_num);
5107: Exception
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');
5107: Exception
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);
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;
5117: END If;
5118: RAISE PROCESS_ERROR;
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;
5117: END If;
5118: RAISE PROCESS_ERROR;
5119: END;
5128: and serial_number = l_serial_num;
5129: Exception
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');
5129: Exception
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);
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;
5139: END If;
5140: When Others THEN
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;
5139: END If;
5140: When Others THEN
5141: IF ( l_error_level >= G_debug_level) THEN
5138: fnd_msg_pub.add;
5139: END If;
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');
5139: END If;
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);
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;
5149: END If;
5150: End;
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;
5149: END If;
5150: End;
5151: ELSE
5169: where source_transaction_id = DEL.transaction_id;
5170: EXCEPTION
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');
5170: EXCEPTION
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);
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;
5180: END IF;
5181: RAISE FND_API.G_EXC_ERROR;
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;
5180: END IF;
5181: RAISE FND_API.G_EXC_ERROR;
5182: END;
5222: last_update_login = fnd_global.login_id
5223: WHERE repair_line_id = RO.repair_line_id;
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');
5223: WHERE repair_line_id = RO.repair_line_id;
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);
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;
5233: END IF;
5234: RAISE PROCESS_ERROR;
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;
5233: END IF;
5234: RAISE PROCESS_ERROR;
5235: END IF;
5251: last_update_login = fnd_global.login_id
5252: WHERE product_transaction_id = RO.product_transaction_id;
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');
5252: WHERE product_transaction_id = RO.product_transaction_id;
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);
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;
5262: END IF;
5263: RAISE PROCESS_ERROR;
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;
5262: END IF;
5263: RAISE PROCESS_ERROR;
5264: END IF;
5479: and cra.serial_number = rcvt.serial_num);
5480: Exception
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');
5480: Exception
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);
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;
5490: END If;
5491: RAISE PROCESS_ERROR;
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;
5490: END If;
5491: RAISE PROCESS_ERROR;
5492: END;
5501: and serial_number = l_serial_num;
5502: Exception
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');
5502: Exception
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);
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;
5512: END If;
5513: When Others THEN
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;
5512: END If;
5513: When Others THEN
5514: IF ( l_error_level >= G_debug_level) THEN
5511: fnd_msg_pub.add;
5512: END If;
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');
5512: END If;
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);
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;
5522: END If;
5523: End;
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;
5522: END If;
5523: End;
5524: ELSE
5542: where source_transaction_id = DEL.transaction_id;
5543: EXCEPTION
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');
5543: EXCEPTION
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);
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;
5553: END IF;
5554: RAISE FND_API.G_EXC_ERROR;
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;
5553: END IF;
5554: RAISE FND_API.G_EXC_ERROR;
5555: END;
5595: last_update_login = fnd_global.login_id
5596: WHERE repair_line_id = RO.repair_line_id;
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');
5596: WHERE repair_line_id = RO.repair_line_id;
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);
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;
5606: END IF;
5607: RAISE PROCESS_ERROR;
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;
5606: END IF;
5607: RAISE PROCESS_ERROR;
5608: END IF;
5625: last_update_login = fnd_global.login_id
5626: WHERE product_transaction_id = RO.product_transaction_id;
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');
5626: WHERE product_transaction_id = RO.product_transaction_id;
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);
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;
5636: END IF;
5637: RAISE PROCESS_ERROR;
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;
5636: END IF;
5637: RAISE PROCESS_ERROR;
5638: END IF;
5768: -- and cra.serial_number = rcvt.serial_num);
5769: Exception
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');
5769: Exception
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);
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;
5779: END IF;
5780: RAISE PROCESS_ERROR;
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;
5779: END IF;
5780: RAISE PROCESS_ERROR;
5781: END;
5791: and serial_number = l_serial_num;
5792: Exception
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');
5792: Exception
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);
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;
5802: END If;
5803: When Others THEN
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;
5802: END If;
5803: When Others THEN
5804: IF ( l_error_level >= G_debug_level) THEN
5801: fnd_msg_pub.add;
5802: END If;
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');
5802: END If;
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);
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;
5812: END If;
5813: End;
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;
5812: END If;
5813: End;
5814: ELSE
5830: where source_transaction_id = RCV.transaction_id;
5831: EXCEPTION
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');
5831: EXCEPTION
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);
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;
5841: END IF;
5842: RAISE FND_API.G_EXC_ERROR;
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;
5841: END IF;
5842: RAISE FND_API.G_EXC_ERROR;
5843: END;
5883: last_update_login = fnd_global.login_id
5884: WHERE repair_line_id = RO.repair_line_id;
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');
5884: WHERE repair_line_id = RO.repair_line_id;
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);
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;
5894: END IF;
5895: RAISE PROCESS_ERROR;
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;
5894: END IF;
5895: RAISE PROCESS_ERROR;
5896: END IF;
5911: last_update_login = fnd_global.login_id
5912: WHERE product_transaction_id = RO.product_transaction_id;
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');
5912: WHERE product_transaction_id = RO.product_transaction_id;
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);
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;
5922: END IF;
5923: RAISE PROCESS_ERROR;
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;
5922: END IF;
5923: RAISE PROCESS_ERROR;
5924: END IF;
6263: p_data => x_msg_data );
6264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6265: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;
6264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6265: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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
6265: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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'
6280: p_data => x_msg_data );
6281: WHEN OTHERS THEN
6282: Debug('In OTHERS Exception',l_mod_name,4);
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;
6281: WHEN OTHERS THEN
6282: Debug('In OTHERS Exception',l_mod_name,4);
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
6282: Debug('In OTHERS Exception',l_mod_name,4);
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'
6813: and organization_id = i.organization_id;
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;
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;
6823: RAISE FND_API.G_EXC_ERROR;
6824: End;
6915: last_update_login = fnd_global.login_id
6916: where repair_line_id = I.repair_line_id;
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');
6916: where repair_line_id = I.repair_line_id;
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);
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;
6926: END IF;
6927: RAISE FND_API.G_EXC_ERROR;
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;
6926: END IF;
6927: RAISE FND_API.G_EXC_ERROR;
6928: END IF;
6944: Correct message name CSD_INSTANCE_MISSING is used instead of
6945: CSD_INV_INSTANCE_ID.
6946: */
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);
6945: CSD_INV_INSTANCE_ID.
6946: */
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
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);
6956: fnd_msg_pub.add;
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);
6956: fnd_msg_pub.add;
6957: fnd_file.put_line(fnd_file.log, fnd_message.get);
6958: /*Fixed for bug#5563369
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);
6956: fnd_msg_pub.add;
6957: fnd_file.put_line(fnd_file.log, fnd_message.get);
6958: /*Fixed for bug#5563369
6959: Correct message name CSD_INSTANCE_MISSING is used instead of
6953: ELSE
6954: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6955: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6956: fnd_msg_pub.add;
6957: fnd_file.put_line(fnd_file.log, fnd_message.get);
6958: /*Fixed for bug#5563369
6959: Correct message name CSD_INSTANCE_MISSING is used instead of
6960: CSD_INV_INSTANCE_ID.
6961: */
6973: Debug(' Could not find any IB instance for the Serial Num ='||I.shipped_serial_num, l_mod_name,1);
6974:
6975: When OTHERS then
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);
6974:
6975: When OTHERS then
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
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);
6985: fnd_msg_pub.add;
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);
6985: fnd_msg_pub.add;
6986: fnd_file.put_line(fnd_file.log, fnd_message.get);
6987: END IF;
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);
6985: fnd_msg_pub.add;
6986: fnd_file.put_line(fnd_file.log, fnd_message.get);
6987: END IF;
6988: RAISE FND_API.G_EXC_ERROR;
6982: ELSE
6983: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6984: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6985: fnd_msg_pub.add;
6986: fnd_file.put_line(fnd_file.log, fnd_message.get);
6987: END IF;
6988: RAISE FND_API.G_EXC_ERROR;
6989: End;
6990:
7021: last_update_login = fnd_global.login_id
7022: where product_transaction_id = i.product_transaction_id ;
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');
7022: where product_transaction_id = i.product_transaction_id ;
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);
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;
7032: END IF;
7033: RAISE FND_API.G_EXC_ERROR;
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;
7032: END IF;
7033: RAISE FND_API.G_EXC_ERROR;
7034: END IF;
7186: Debug('At the end of processing cancelled orders in SO_SHIP_UPDATE',l_mod_name,1);
7187: -----------------------
7188:
7189: -- Log seeded messages for the number of processed records
7190: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
7191: fnd_message.set_token('TOT_REC',to_char(l_total_records));
7192: FND_MSG_PUB.ADD;
7193:
7194: -- Debug messages
7187: -----------------------
7188:
7189: -- Log seeded messages for the number of processed records
7190: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
7191: fnd_message.set_token('TOT_REC',to_char(l_total_records));
7192: FND_MSG_PUB.ADD;
7193:
7194: -- Debug messages
7195: Debug(fnd_message.get,l_mod_name,1);
7191: fnd_message.set_token('TOT_REC',to_char(l_total_records));
7192: FND_MSG_PUB.ADD;
7193:
7194: -- Debug messages
7195: Debug(fnd_message.get,l_mod_name,1);
7196:
7197: -- Log messages in the concurrent log and output file
7198: fnd_file.put_line(fnd_file.log,fnd_message.get);
7199: fnd_file.put_line(fnd_file.output,fnd_message.get);
7194: -- Debug messages
7195: Debug(fnd_message.get,l_mod_name,1);
7196:
7197: -- Log messages in the concurrent log and output file
7198: fnd_file.put_line(fnd_file.log,fnd_message.get);
7199: fnd_file.put_line(fnd_file.output,fnd_message.get);
7200:
7201: -- Standard check of p_commit.
7202: IF FND_API.To_Boolean( p_commit ) THEN
7195: Debug(fnd_message.get,l_mod_name,1);
7196:
7197: -- Log messages in the concurrent log and output file
7198: fnd_file.put_line(fnd_file.log,fnd_message.get);
7199: fnd_file.put_line(fnd_file.output,fnd_message.get);
7200:
7201: -- Standard check of p_commit.
7202: IF FND_API.To_Boolean( p_commit ) THEN
7203: COMMIT WORK;
7530: where cpt.order_header_id = oeh.header_id );
7531: EXCEPTION
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');
7531: EXCEPTION
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);
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;
7541: END IF;
7542: RAISE FND_API.G_EXC_ERROR;
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;
7541: END IF;
7542: RAISE FND_API.G_EXC_ERROR;
7543: END;
7579: and rownum = 1;
7580: EXCEPTION
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');
7580: EXCEPTION
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);
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;
7590: END IF;
7591: RAISE FND_API.G_EXC_ERROR;
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;
7590: END IF;
7591: RAISE FND_API.G_EXC_ERROR;
7592: END;
7679: last_update_login = fnd_global.login_id
7680: WHERE product_transaction_id = l_prod_txn_id;
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');
7680: WHERE product_transaction_id = l_prod_txn_id;
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);
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;
7690: END IF;
7691: RAISE PROCESS_ERROR;
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;
7690: END IF;
7691: RAISE PROCESS_ERROR;
7692: END IF;
7705: and rownum = 1;
7706: Exception
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');
7706: Exception
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);
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;
7716: END IF;
7717: RAISE PROCESS_ERROR;
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;
7716: END IF;
7717: RAISE PROCESS_ERROR;
7718: End;
7773: P_UNIT_NUMBER => '');
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;
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;
7783: RAISE PROCESS_ERROR;
7784: END;
7836: and prod_txn_status in('BOOKED','RELEASED')
7837: and rownum <= nvl(DEL.requested_quantity,0) ;
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');
7837: and rownum <= nvl(DEL.requested_quantity,0) ;
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);
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;
7847: END IF;
7848: RAISE PROCESS_ERROR;
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;
7847: END IF;
7848: RAISE PROCESS_ERROR;
7849: END IF;
7867: and prod_txn_status in ('BOOKED','RELEASED')
7868: and rownum <= nvl(DEL.requested_quantity,0);
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');
7868: and rownum <= nvl(DEL.requested_quantity,0);
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);
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;
7878: END IF;
7879: RAISE PROCESS_ERROR;
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;
7878: END IF;
7879: RAISE PROCESS_ERROR;
7880: END IF;
7994: last_update_login = fnd_global.login_id
7995: WHERE product_transaction_id = l_prod_txn_id;
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');
7995: WHERE product_transaction_id = l_prod_txn_id;
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);
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;
8005: END IF;
8006: RAISE PROCESS_ERROR;
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;
8005: END IF;
8006: RAISE PROCESS_ERROR;
8007: END IF;
8020: and rownum = 1;
8021: Exception
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');
8021: Exception
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);
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;
8031: END IF;
8032: RAISE PROCESS_ERROR;
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;
8031: END IF;
8032: RAISE PROCESS_ERROR;
8033: End;
8089:
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;
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;
8099: RAISE PROCESS_ERROR;
8100: END;
8111: last_update_login = fnd_global.login_id
8112: where repair_line_id = l_rep_line_id;
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');
8112: where repair_line_id = l_rep_line_id;
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);
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;
8122: END IF;
8123: RAISE PROCESS_ERROR;
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;
8122: END IF;
8123: RAISE PROCESS_ERROR;
8124: END IF;
8240: last_update_login = fnd_global.login_id
8241: where product_transaction_id = l_prod_txn_id;
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');
8241: where product_transaction_id = l_prod_txn_id;
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);
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;
8251: END IF;
8252: RAISE PROCESS_ERROR;
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;
8251: END IF;
8252: RAISE PROCESS_ERROR;
8253: END IF;
8261: last_update_login = fnd_global.login_id
8262: where repair_line_id = l_rep_line_id;
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');
8262: where repair_line_id = l_rep_line_id;
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);
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;
8272: END IF;
8273: RAISE PROCESS_ERROR;
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;
8272: END IF;
8273: RAISE PROCESS_ERROR;
8274: END IF;
8359: last_update_login = fnd_global.login_id
8360: where product_transaction_id = l_prod_txn_id;
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');
8360: where product_transaction_id = l_prod_txn_id;
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);
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;
8370: END IF;
8371: RAISE PROCESS_ERROR;
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;
8370: END IF;
8371: RAISE PROCESS_ERROR;
8372: END IF;
8380: last_update_login = fnd_global.login_id
8381: where repair_line_id = l_rep_line_id;
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');
8381: where repair_line_id = l_rep_line_id;
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);
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;
8391: END IF;
8392: RAISE PROCESS_ERROR;
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;
8391: END IF;
8392: RAISE PROCESS_ERROR;
8393: END IF;
8496: last_update_login = fnd_global.login_id
8497: where product_transaction_id = l_prod_txn_id;
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');
8497: where product_transaction_id = l_prod_txn_id;
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);
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;
8507: END IF;
8508: RAISE PROCESS_ERROR;
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;
8507: END IF;
8508: RAISE PROCESS_ERROR;
8509: END IF;
8517: last_update_login = fnd_global.login_id
8518: where repair_line_id = l_rep_line_id;
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');
8518: where repair_line_id = l_rep_line_id;
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);
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;
8528: END IF;
8529: RAISE PROCESS_ERROR;
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;
8528: END IF;
8529: RAISE PROCESS_ERROR;
8530: END IF;
8615: last_update_login = fnd_global.login_id
8616: where product_transaction_id = l_prod_txn_id;
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');
8616: where product_transaction_id = l_prod_txn_id;
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);
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;
8626: END IF;
8627: RAISE PROCESS_ERROR;
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;
8626: END IF;
8627: RAISE PROCESS_ERROR;
8628: END IF;
8636: last_update_login = fnd_global.login_id
8637: where repair_line_id = l_rep_line_id;
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');
8637: where repair_line_id = l_rep_line_id;
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);
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;
8647: END IF;
8648: RAISE PROCESS_ERROR;
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;
8647: END IF;
8648: RAISE PROCESS_ERROR;
8649: END IF;
8933: p_data => x_msg_data );
8934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8935: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;
8934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8935: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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
8935: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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'
8950: p_data => x_msg_data );
8951: WHEN OTHERS THEN
8952: Debug('In OTHERS Exception',l_mod_name,4);
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;
8951: WHEN OTHERS THEN
8952: Debug('In OTHERS Exception',l_mod_name,4);
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
8952: Debug('In OTHERS Exception',l_mod_name,4);
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'