APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on FND_MESSAGE

Line 373: fnd_message.set_name('CSD','CSD_UOM_MISSING');

369: where unit_of_measure = p_from_uom;
370: Exception
371: WHEN NO_DATA_FOUND THEN
372: IF ( l_error_level >= G_debug_level) THEN
373: fnd_message.set_name('CSD','CSD_UOM_MISSING');
374: fnd_message.set_token('UOM',p_from_uom);
375: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
376: ELSE
377: fnd_message.set_name('CSD','CSD_UOM_MISSING');

Line 374: fnd_message.set_token('UOM',p_from_uom);

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

Line 377: fnd_message.set_name('CSD','CSD_UOM_MISSING');

373: fnd_message.set_name('CSD','CSD_UOM_MISSING');
374: fnd_message.set_token('UOM',p_from_uom);
375: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
376: ELSE
377: fnd_message.set_name('CSD','CSD_UOM_MISSING');
378: fnd_message.set_token('UOM',p_from_uom);
379: fnd_msg_pub.add;
380: END IF;
381: RAISE FND_API.G_EXC_ERROR;

Line 378: fnd_message.set_token('UOM',p_from_uom);

374: fnd_message.set_token('UOM',p_from_uom);
375: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
376: ELSE
377: fnd_message.set_name('CSD','CSD_UOM_MISSING');
378: fnd_message.set_token('UOM',p_from_uom);
379: fnd_msg_pub.add;
380: END IF;
381: RAISE FND_API.G_EXC_ERROR;
382: WHEN TOO_MANY_ROWS THEN

Line 384: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');

380: END IF;
381: RAISE FND_API.G_EXC_ERROR;
382: WHEN TOO_MANY_ROWS THEN
383: IF ( l_error_level >= G_debug_level) THEN
384: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
385: fnd_message.set_token('UOM',p_from_uom);
386: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
387: ELSE
388: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');

Line 385: fnd_message.set_token('UOM',p_from_uom);

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

Line 388: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');

384: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
385: fnd_message.set_token('UOM',p_from_uom);
386: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
387: ELSE
388: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
389: fnd_message.set_token('UOM',p_from_uom);
390: fnd_msg_pub.add;
391: END IF;
392: RAISE FND_API.G_EXC_ERROR;

Line 389: fnd_message.set_token('UOM',p_from_uom);

385: fnd_message.set_token('UOM',p_from_uom);
386: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
387: ELSE
388: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
389: fnd_message.set_token('UOM',p_from_uom);
390: fnd_msg_pub.add;
391: END IF;
392: RAISE FND_API.G_EXC_ERROR;
393: End;

Line 416: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');

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

Line 419: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');

415: IF ( l_error_level >= G_debug_level) THEN
416: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
417: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
418: ELSE
419: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
420: fnd_msg_pub.add;
421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;

Line 965: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

961: last_update_login = fnd_global.login_id
962: where repair_job_xref_id = JOB.repair_job_xref_id;
963: IF SQL%NOTFOUND THEN
964: IF ( l_error_level >= G_debug_level) THEN
965: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
966: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
967: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
968: ELSE
969: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 966: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );

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

Line 969: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

965: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
966: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
967: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
968: ELSE
969: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
970: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
971: FND_MSG_PUB.ADD;
972: END IF;
973: RAISE FND_API.G_EXC_ERROR;

Line 970: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );

966: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
967: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
968: ELSE
969: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
970: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
971: FND_MSG_PUB.ADD;
972: END IF;
973: RAISE FND_API.G_EXC_ERROR;
974: End IF;

Line 1088: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

1084: last_update_login = fnd_global.login_id
1085: where repair_job_xref_id = JOB.repair_job_xref_id;
1086: IF SQL%NOTFOUND THEN
1087: IF ( l_error_level >= G_debug_level) THEN
1088: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1089: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1090: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1091: ELSE
1092: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1089: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );

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

Line 1092: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

1088: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1089: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1090: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1091: ELSE
1092: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1093: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1094: FND_MSG_PUB.ADD;
1095: END IF;
1096: RAISE FND_API.G_EXC_ERROR;

Line 1093: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );

1089: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1090: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1091: ELSE
1092: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1093: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1094: FND_MSG_PUB.ADD;
1095: END IF;
1096: RAISE FND_API.G_EXC_ERROR;
1097: End IF;

Line 1220: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

1216: last_update_login = fnd_global.login_id
1217: where repair_job_xref_id = JOB.repair_job_xref_id;
1218: IF SQL%NOTFOUND THEN
1219: IF ( l_error_level >= G_debug_level) THEN
1220: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1221: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1222: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1223: ELSE
1224: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1221: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );

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

Line 1224: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

1220: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1221: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1222: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1223: ELSE
1224: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1225: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1226: FND_MSG_PUB.ADD;
1227: END IF;
1228: RAISE FND_API.G_EXC_ERROR;

Line 1225: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );

1221: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1222: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1223: ELSE
1224: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1225: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1226: FND_MSG_PUB.ADD;
1227: END IF;
1228: RAISE FND_API.G_EXC_ERROR;
1229: End IF;

Line 1273: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');

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

Line 1274: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );

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

Line 1277: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');

1273: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1274: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1275: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1276: ELSE
1277: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1278: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1279: FND_MSG_PUB.ADD;
1280: END IF;
1281: RAISE FND_API.G_EXC_ERROR;

Line 1278: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );

1274: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1275: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1276: ELSE
1277: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1278: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1279: FND_MSG_PUB.ADD;
1280: END IF;
1281: RAISE FND_API.G_EXC_ERROR;
1282: END;

Line 1337: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

1333: last_update_login = fnd_global.login_id
1334: where repair_job_xref_id = JOB.repair_job_xref_id;
1335: IF SQL%NOTFOUND THEN
1336: IF ( l_error_level >= G_debug_level) THEN
1337: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1338: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1339: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1340: ELSE
1341: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1338: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );

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

Line 1341: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

1337: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1338: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1339: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1340: ELSE
1341: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1342: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1343: FND_MSG_PUB.ADD;
1344: END IF;
1345: RAISE FND_API.G_EXC_ERROR;

Line 1342: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );

1338: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1339: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1340: ELSE
1341: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1342: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1343: FND_MSG_PUB.ADD;
1344: END IF;
1345: RAISE FND_API.G_EXC_ERROR;
1346: End IF;

Line 1440: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');

1436: END IF;
1437:
1438:
1439: -- Log messages for the number of records processed
1440: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1441: fnd_message.set_token('TOT_REC',to_char(l_total_rec));
1442: FND_MSG_PUB.ADD;
1443:
1444: -- Retrive the message from the msg stack

Line 1441: fnd_message.set_token('TOT_REC',to_char(l_total_rec));

1437:
1438:
1439: -- Log messages for the number of records processed
1440: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1441: fnd_message.set_token('TOT_REC',to_char(l_total_rec));
1442: FND_MSG_PUB.ADD;
1443:
1444: -- Retrive the message from the msg stack
1445: l_msg_text := fnd_message.get;

Line 1445: l_msg_text := fnd_message.get;

1441: fnd_message.set_token('TOT_REC',to_char(l_total_rec));
1442: FND_MSG_PUB.ADD;
1443:
1444: -- Retrive the message from the msg stack
1445: l_msg_text := fnd_message.get;
1446:
1447: -- Log the number of records processed in concurrent program output and log file
1448: fnd_file.put_line(fnd_file.log,l_msg_text);
1449: fnd_file.put_line(fnd_file.output,l_msg_text);

Line 1712: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

1708: last_update_login = fnd_global.login_id
1709: where repair_job_xref_id = K.repair_job_xref_id;
1710: IF SQL%NOTFOUND THEN
1711: IF ( l_error_level >= G_debug_level) THEN
1712: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1713: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1714: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1715: ELSE
1716: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1713: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );

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

Line 1716: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

1712: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1713: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1714: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1715: ELSE
1716: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1717: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1718: FND_MSG_PUB.ADD;
1719: END IF;
1720: RAISE FND_API.G_EXC_ERROR;

Line 1717: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );

1713: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1714: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1715: ELSE
1716: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1717: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1718: FND_MSG_PUB.ADD;
1719: END IF;
1720: RAISE FND_API.G_EXC_ERROR;
1721: End IF;

Line 1733: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

1729: last_update_login = fnd_global.login_id
1730: where repair_line_id = K.repair_line_id;
1731: IF SQL%NOTFOUND THEN
1732: IF ( l_error_level >= G_debug_level) THEN
1733: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1734: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1735: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1736: ELSE
1737: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 1734: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );

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

Line 1737: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

1733: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1734: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1735: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1736: ELSE
1737: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1738: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1739: FND_MSG_PUB.ADD;
1740: END IF;
1741: RAISE FND_API.G_EXC_ERROR;

Line 1738: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );

1734: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1735: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1736: ELSE
1737: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1738: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1739: FND_MSG_PUB.ADD;
1740: END IF;
1741: RAISE FND_API.G_EXC_ERROR;
1742: End IF;

Line 1999: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1995: p_data => x_msg_data );
1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1997: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
1998: IF ( l_error_level >= G_debug_level) THEN
1999: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2000: fnd_message.set_token('SQLERRM',SQLERRM);
2001: fnd_message.set_token('SQLCODE',SQLCODE);
2002: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2003: END If;

Line 2000: fnd_message.set_token('SQLERRM',SQLERRM);

1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1997: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
1998: IF ( l_error_level >= G_debug_level) THEN
1999: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2000: fnd_message.set_token('SQLERRM',SQLERRM);
2001: fnd_message.set_token('SQLCODE',SQLCODE);
2002: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2003: END If;
2004: -- As we are committing the processed records in the inner APIs

Line 2001: fnd_message.set_token('SQLCODE',SQLCODE);

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

Line 2016: fnd_message.set_name('CSD','CSD_SQL_ERROR');

2012: p_data => x_msg_data );
2013: WHEN OTHERS THEN
2014: Debug('In OTHERS exception',l_mod_name,4 );
2015: IF ( l_error_level >= G_debug_level) THEN
2016: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2017: fnd_message.set_token('SQLERRM',SQLERRM);
2018: fnd_message.set_token('SQLCODE',SQLCODE);
2019: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2020: END If;

Line 2017: fnd_message.set_token('SQLERRM',SQLERRM);

2013: WHEN OTHERS THEN
2014: Debug('In OTHERS exception',l_mod_name,4 );
2015: IF ( l_error_level >= G_debug_level) THEN
2016: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2017: fnd_message.set_token('SQLERRM',SQLERRM);
2018: fnd_message.set_token('SQLCODE',SQLCODE);
2019: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2020: END If;
2021: -- As we are committing the processed records in the inner APIs

Line 2018: fnd_message.set_token('SQLCODE',SQLCODE);

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

Line 2604: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');

2600: and organization_id = i.organization_id;
2601: Exception
2602: When no_data_found then
2603: IF ( l_error_level >= G_debug_level) THEN
2604: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2605: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2606: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2607: ELSE
2608: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');

Line 2605: fnd_message.set_token('ITEM_ID',I.inventory_item_id);

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

Line 2608: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');

2604: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2605: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2606: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2607: ELSE
2608: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2609: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2610: fnd_msg_pub.add;
2611: END IF;
2612: RAISE FND_API.G_EXC_ERROR;

Line 2609: fnd_message.set_token('ITEM_ID',I.inventory_item_id);

2605: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2606: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2607: ELSE
2608: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2609: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2610: fnd_msg_pub.add;
2611: END IF;
2612: RAISE FND_API.G_EXC_ERROR;
2613: When others then

Line 2631: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');

2627: Open rcv_txn_serial_num(i.transaction_id );
2628: Fetch rcv_txn_serial_num into l_st_serial_num, l_lot_number;
2629: IF (rcv_txn_serial_num%NOTFOUND) THEN
2630: IF ( l_error_level >= G_debug_level) THEN
2631: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2632: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2633: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2634: ELSE
2635: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');

Line 2632: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);

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

Line 2635: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');

2631: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2632: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2633: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2634: ELSE
2635: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2636: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2637: FND_MSG_PUB.ADD;
2638: END IF;
2639: RAISE FND_API.G_EXC_ERROR;

Line 2636: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);

2632: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2633: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2634: ELSE
2635: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2636: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2637: FND_MSG_PUB.ADD;
2638: END IF;
2639: RAISE FND_API.G_EXC_ERROR;
2640: END IF;

Line 2662: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');

2658: --and instance_usage_code = 'IN_INVENTORY';
2659: EXCEPTION
2660: WHEN NO_DATA_FOUND THEN
2661: IF ( l_error_level >= G_debug_level) THEN
2662: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2663: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2664: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2665: ELSE
2666: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');

Line 2663: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);

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

Line 2666: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');

2662: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2663: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2664: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2665: ELSE
2666: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2667: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2668: FND_MSG_PUB.ADD;
2669: END IF;
2670: RAISE FND_API.G_EXC_ERROR;

Line 2667: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);

2663: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2664: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2665: ELSE
2666: FND_MESSAGE.SET_NAME('CSD','CSD_INSTANCE_MISSING');
2667: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2668: FND_MSG_PUB.ADD;
2669: END IF;
2670: RAISE FND_API.G_EXC_ERROR;
2671: Debug(' Could not find any IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);

Line 2674: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');

2670: RAISE FND_API.G_EXC_ERROR;
2671: Debug(' Could not find any IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);
2672: WHEN TOO_MANY_ROWS THEN
2673: IF ( l_error_level >= G_debug_level) THEN
2674: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2675: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2676: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2677: ELSE
2678: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');

Line 2675: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);

2671: Debug(' Could not find any IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);
2672: WHEN TOO_MANY_ROWS THEN
2673: IF ( l_error_level >= G_debug_level) THEN
2674: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2675: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2676: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2677: ELSE
2678: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2679: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);

Line 2678: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');

2674: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2675: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2676: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2677: ELSE
2678: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2679: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2680: FND_MSG_PUB.ADD;
2681: END IF;
2682: RAISE FND_API.G_EXC_ERROR;

Line 2679: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);

2675: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2676: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2677: ELSE
2678: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2679: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2680: FND_MSG_PUB.ADD;
2681: END IF;
2682: RAISE FND_API.G_EXC_ERROR;
2683: Debug(' Found many IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);

Line 2758: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');

2754: where source_transaction_id = I.transaction_id;
2755: EXCEPTION
2756: WHEN NO_DATA_FOUND THEN
2757: IF ( l_error_level >= G_debug_level) THEN
2758: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2759: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2760: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2761: ELSE
2762: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');

Line 2759: fnd_message.set_token('ITEM_ID',I.inventory_item_id);

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

Line 2762: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');

2758: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2759: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2760: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2761: ELSE
2762: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2763: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2764: fnd_msg_pub.add;
2765: END IF;
2766: RAISE FND_API.G_EXC_ERROR;

Line 2763: fnd_message.set_token('ITEM_ID',I.inventory_item_id);

2759: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2760: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2761: ELSE
2762: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2763: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2764: fnd_msg_pub.add;
2765: END IF;
2766: RAISE FND_API.G_EXC_ERROR;
2767: END;

Line 2818: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

2814: last_update_login = fnd_global.login_id
2815: where repair_line_id = I.repair_line_id;
2816: IF SQL%NOTFOUND THEN
2817: IF ( l_error_level >= G_debug_level) THEN
2818: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2819: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2820: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2821: ELSE
2822: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 2819: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);

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

Line 2822: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

2818: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2819: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2820: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2821: ELSE
2822: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2823: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2824: fnd_msg_pub.add;
2825: END IF;
2826: RAISE FND_API.G_EXC_ERROR;

Line 2823: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);

2819: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2820: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2821: ELSE
2822: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2823: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2824: fnd_msg_pub.add;
2825: END IF;
2826: RAISE FND_API.G_EXC_ERROR;
2827: END IF;

Line 2841: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

2837: last_update_login = fnd_global.login_id
2838: where repair_line_id = I.repair_line_id;
2839: IF SQL%NOTFOUND THEN
2840: IF ( l_error_level >= G_debug_level) THEN
2841: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2842: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2843: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2844: ELSE
2845: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 2842: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);

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

Line 2845: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

2841: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2842: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2843: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2844: ELSE
2845: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2846: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2847: fnd_msg_pub.add;
2848: END IF;
2849: RAISE FND_API.G_EXC_ERROR;

Line 2846: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);

2842: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2843: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2844: ELSE
2845: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2846: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2847: fnd_msg_pub.add;
2848: END IF;
2849: RAISE FND_API.G_EXC_ERROR;
2850: END IF;

Line 2877: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

2873: last_update_login = fnd_global.login_id
2874: WHERE product_transaction_id = i.product_transaction_id;
2875: IF SQL%NOTFOUND THEN
2876: IF ( l_error_level >= G_debug_level) THEN
2877: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2878: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2879: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2880: ELSE
2881: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 2878: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);

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

Line 2881: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

2877: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2878: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2879: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2880: ELSE
2881: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2882: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2883: fnd_msg_pub.add;
2884: END IF;
2885: RAISE FND_API.G_EXC_ERROR;

Line 2882: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);

2878: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2879: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
2880: ELSE
2881: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2882: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2883: fnd_msg_pub.add;
2884: END IF;
2885: RAISE FND_API.G_EXC_ERROR;
2886: END IF;

Line 2888: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');

2884: END IF;
2885: RAISE FND_API.G_EXC_ERROR;
2886: END IF;
2887:
2888: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2889: fnd_message.set_token('RMA_NO',i.rma_number);
2890: fnd_message.set_token('REP_NO',i.repair_number);
2891: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2892: FND_MSG_PUB.ADD;

Line 2889: fnd_message.set_token('RMA_NO',i.rma_number);

2885: RAISE FND_API.G_EXC_ERROR;
2886: END IF;
2887:
2888: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2889: fnd_message.set_token('RMA_NO',i.rma_number);
2890: fnd_message.set_token('REP_NO',i.repair_number);
2891: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2892: FND_MSG_PUB.ADD;
2893:

Line 2890: fnd_message.set_token('REP_NO',i.repair_number);

2886: END IF;
2887:
2888: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2889: fnd_message.set_token('RMA_NO',i.rma_number);
2890: fnd_message.set_token('REP_NO',i.repair_number);
2891: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2892: FND_MSG_PUB.ADD;
2893:
2894: -- Debug message

Line 2891: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));

2887:
2888: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2889: fnd_message.set_token('RMA_NO',i.rma_number);
2890: fnd_message.set_token('REP_NO',i.repair_number);
2891: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2892: FND_MSG_PUB.ADD;
2893:
2894: -- Debug message
2895: Debug(fnd_message.get,l_mod_name,1);

Line 2895: Debug(fnd_message.get,l_mod_name,1);

2891: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
2892: FND_MSG_PUB.ADD;
2893:
2894: -- Debug message
2895: Debug(fnd_message.get,l_mod_name,1);
2896:
2897: -- Log messages in concurrent log and output file
2898: fnd_file.put_line(fnd_file.log, fnd_message.get);
2899:

Line 2898: fnd_file.put_line(fnd_file.log, fnd_message.get);

2894: -- Debug message
2895: Debug(fnd_message.get,l_mod_name,1);
2896:
2897: -- Log messages in concurrent log and output file
2898: fnd_file.put_line(fnd_file.log, fnd_message.get);
2899:
2900: -- Initialize the activity rec
2901: l_activity_rec := INIT_ACTIVITY_REC ;
2902:

Line 2995: fnd_message.set_name('CSD','CSD_DRC_RMA_TOT_REC_PROC');

2991: END IF;
2992:
2993: -- Log seed messages for the number of records
2994: -- processed by rma update
2995: fnd_message.set_name('CSD','CSD_DRC_RMA_TOT_REC_PROC');
2996: fnd_message.set_token('TOT_REC',to_char(l_total_records));
2997: FND_MSG_PUB.ADD;
2998:
2999: -- Debug Messages

Line 2996: fnd_message.set_token('TOT_REC',to_char(l_total_records));

2992:
2993: -- Log seed messages for the number of records
2994: -- processed by rma update
2995: fnd_message.set_name('CSD','CSD_DRC_RMA_TOT_REC_PROC');
2996: fnd_message.set_token('TOT_REC',to_char(l_total_records));
2997: FND_MSG_PUB.ADD;
2998:
2999: -- Debug Messages
3000: Debug(fnd_message.get,l_mod_name,1);

Line 3000: Debug(fnd_message.get,l_mod_name,1);

2996: fnd_message.set_token('TOT_REC',to_char(l_total_records));
2997: FND_MSG_PUB.ADD;
2998:
2999: -- Debug Messages
3000: Debug(fnd_message.get,l_mod_name,1);
3001:
3002: -- Log the number of records processed in concurrent
3003: -- program output and log file
3004: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 3004: fnd_file.put_line(fnd_file.log,fnd_message.get);

3000: Debug(fnd_message.get,l_mod_name,1);
3001:
3002: -- Log the number of records processed in concurrent
3003: -- program output and log file
3004: fnd_file.put_line(fnd_file.log,fnd_message.get);
3005: fnd_file.put_line(fnd_file.output,fnd_message.get);
3006:
3007: -- Standard check of p_commit.
3008: IF FND_API.To_Boolean( p_commit ) THEN

Line 3005: fnd_file.put_line(fnd_file.output,fnd_message.get);

3001:
3002: -- Log the number of records processed in concurrent
3003: -- program output and log file
3004: fnd_file.put_line(fnd_file.log,fnd_message.get);
3005: fnd_file.put_line(fnd_file.output,fnd_message.get);
3006:
3007: -- Standard check of p_commit.
3008: IF FND_API.To_Boolean( p_commit ) THEN
3009: COMMIT WORK;

Line 3304: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

3300: and cpt.order_header_id = oeh.header_id);
3301: EXCEPTION
3302: WHEN NO_DATA_FOUND THEN
3303: IF ( l_error_level >= G_debug_level) THEN
3304: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3305: fnd_message.set_token('HEADER_ID',p_order_header_id);
3306: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3307: ELSE
3308: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

Line 3305: fnd_message.set_token('HEADER_ID',p_order_header_id);

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

Line 3308: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

3304: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3305: fnd_message.set_token('HEADER_ID',p_order_header_id);
3306: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3307: ELSE
3308: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3309: fnd_message.set_token('HEADER_ID',p_order_header_id);
3310: fnd_msg_pub.add;
3311: END IF;
3312: RAISE FND_API.G_EXC_ERROR;

Line 3309: fnd_message.set_token('HEADER_ID',p_order_header_id);

3305: fnd_message.set_token('HEADER_ID',p_order_header_id);
3306: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3307: ELSE
3308: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3309: fnd_message.set_token('HEADER_ID',p_order_header_id);
3310: fnd_msg_pub.add;
3311: END IF;
3312: RAISE FND_API.G_EXC_ERROR;
3313: END;

Line 3533: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

3529: and cra.serial_number = rcvt.serial_num);
3530: Exception
3531: WHEN NO_DATA_FOUND THEN
3532: IF ( l_error_level >= G_debug_level) THEN
3533: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3534: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3535: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3536: ELSE
3537: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

Line 3534: fnd_message.set_token('TXN_ID',DEL.transaction_id);

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

Line 3537: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

3533: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3534: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3535: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3536: ELSE
3537: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3538: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3539: fnd_msg_pub.add;
3540: END If;
3541: RAISE PROCESS_ERROR;

Line 3538: fnd_message.set_token('TXN_ID',DEL.transaction_id);

3534: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3535: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3536: ELSE
3537: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3538: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3539: fnd_msg_pub.add;
3540: END If;
3541: RAISE PROCESS_ERROR;
3542: END;

Line 3555: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

3551: and serial_number = l_serial_num;
3552: Exception
3553: When NO_DATA_FOUND THEN
3554: IF ( l_error_level >= G_debug_level) THEN
3555: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3556: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3557: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3558: ELSE
3559: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

Line 3556: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 3559: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

3555: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3556: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3557: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3558: ELSE
3559: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3560: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3561: fnd_msg_pub.add;
3562: END If;
3563: When Others THEN

Line 3560: fnd_message.set_token('SERIAL_NUM',l_serial_num);

3556: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3557: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3558: ELSE
3559: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3560: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3561: fnd_msg_pub.add;
3562: END If;
3563: When Others THEN
3564: IF ( l_error_level >= G_debug_level) THEN

Line 3565: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

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

Line 3566: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 3569: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

3565: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3566: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3567: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3568: ELSE
3569: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3570: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3571: fnd_msg_pub.add;
3572: END If;
3573: End;

Line 3570: fnd_message.set_token('SERIAL_NUM',l_serial_num);

3566: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3567: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3568: ELSE
3569: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3570: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3571: fnd_msg_pub.add;
3572: END If;
3573: End;
3574: ELSE

Line 3596: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

3592: where source_transaction_id = DEL.transaction_id;
3593: EXCEPTION
3594: WHEN NO_DATA_FOUND THEN
3595: IF ( l_error_level >= G_debug_level) THEN
3596: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3597: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3598: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3599: ELSE
3600: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

Line 3597: fnd_message.set_token('TXN_ID',DEL.transaction_id);

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

Line 3600: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

3596: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3597: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3598: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3599: ELSE
3600: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3601: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3602: fnd_msg_pub.add;
3603: END IF;
3604: RAISE FND_API.G_EXC_ERROR;

Line 3601: fnd_message.set_token('TXN_ID',DEL.transaction_id);

3597: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3598: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3599: ELSE
3600: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3601: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3602: fnd_msg_pub.add;
3603: END IF;
3604: RAISE FND_API.G_EXC_ERROR;
3605: END;

Line 3644: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

3640: last_update_login = fnd_global.login_id
3641: WHERE repair_line_id = RO.repair_line_id;
3642: IF SQL%NOTFOUND THEN
3643: IF ( l_error_level >= G_debug_level) THEN
3644: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3645: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3647: ELSE
3648: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 3645: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

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

Line 3648: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

3644: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3645: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3647: ELSE
3648: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3649: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3650: fnd_msg_pub.add;
3651: END IF;
3652: RAISE PROCESS_ERROR;

Line 3649: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

3645: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3647: ELSE
3648: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
3649: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
3650: fnd_msg_pub.add;
3651: END IF;
3652: RAISE PROCESS_ERROR;
3653: END IF;

Line 3673: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

3669: last_update_login = fnd_global.login_id
3670: WHERE product_transaction_id = RO.product_transaction_id;
3671: IF SQL%NOTFOUND THEN
3672: IF ( l_error_level >= G_debug_level) THEN
3673: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3674: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3676: ELSE
3677: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 3674: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

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

Line 3677: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

3673: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3674: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3676: ELSE
3677: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3678: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3679: fnd_msg_pub.add;
3680: END IF;
3681: RAISE PROCESS_ERROR;

Line 3678: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

3674: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3676: ELSE
3677: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
3678: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
3679: fnd_msg_pub.add;
3680: END IF;
3681: RAISE PROCESS_ERROR;
3682: END IF;

Line 3901: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

3897: and cra.serial_number = rcvt.serial_num);
3898: Exception
3899: WHEN NO_DATA_FOUND THEN
3900: IF ( l_error_level >= G_debug_level) THEN
3901: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3902: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3903: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3904: ELSE
3905: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

Line 3902: fnd_message.set_token('TXN_ID',DEL.transaction_id);

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

Line 3905: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

3901: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3902: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3903: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3904: ELSE
3905: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3906: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3907: fnd_msg_pub.add;
3908: END If;
3909: RAISE PROCESS_ERROR;

Line 3906: fnd_message.set_token('TXN_ID',DEL.transaction_id);

3902: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3903: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3904: ELSE
3905: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
3906: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3907: fnd_msg_pub.add;
3908: END If;
3909: RAISE PROCESS_ERROR;
3910: END;

Line 3923: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

3919: and serial_number = l_serial_num;
3920: Exception
3921: When NO_DATA_FOUND THEN
3922: IF ( l_error_level >= G_debug_level) THEN
3923: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3924: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3925: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3926: ELSE
3927: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

Line 3924: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 3927: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

3923: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3924: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3925: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3926: ELSE
3927: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3928: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3929: fnd_msg_pub.add;
3930: END If;
3931: When Others THEN

Line 3928: fnd_message.set_token('SERIAL_NUM',l_serial_num);

3924: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3925: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3926: ELSE
3927: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
3928: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3929: fnd_msg_pub.add;
3930: END If;
3931: When Others THEN
3932: IF ( l_error_level >= G_debug_level) THEN

Line 3933: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

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

Line 3934: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 3937: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

3933: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3934: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3935: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3936: ELSE
3937: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3938: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3939: fnd_msg_pub.add;
3940: END If;
3941: End;

Line 3938: fnd_message.set_token('SERIAL_NUM',l_serial_num);

3934: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3935: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3936: ELSE
3937: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
3938: fnd_message.set_token('SERIAL_NUM',l_serial_num);
3939: fnd_msg_pub.add;
3940: END If;
3941: End;
3942: ELSE

Line 3964: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

3960: where source_transaction_id = DEL.transaction_id;
3961: EXCEPTION
3962: WHEN NO_DATA_FOUND THEN
3963: IF ( l_error_level >= G_debug_level) THEN
3964: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3965: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3966: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3967: ELSE
3968: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

Line 3965: fnd_message.set_token('TXN_ID',DEL.transaction_id);

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

Line 3968: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

3964: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3965: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3966: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3967: ELSE
3968: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3969: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3970: fnd_msg_pub.add;
3971: END IF;
3972: RAISE FND_API.G_EXC_ERROR;

Line 3969: fnd_message.set_token('TXN_ID',DEL.transaction_id);

3965: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3966: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
3967: ELSE
3968: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3969: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3970: fnd_msg_pub.add;
3971: END IF;
3972: RAISE FND_API.G_EXC_ERROR;
3973: END;

Line 4012: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

4008: last_update_login = fnd_global.login_id
4009: WHERE repair_line_id = RO.repair_line_id;
4010: IF SQL%NOTFOUND THEN
4011: IF ( l_error_level >= G_debug_level) THEN
4012: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4013: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4015: ELSE
4016: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 4013: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

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

Line 4016: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

4012: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4013: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4015: ELSE
4016: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4017: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4018: fnd_msg_pub.add;
4019: END IF;
4020: RAISE PROCESS_ERROR;

Line 4017: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

4013: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4015: ELSE
4016: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4017: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4018: fnd_msg_pub.add;
4019: END IF;
4020: RAISE PROCESS_ERROR;
4021: END IF;

Line 4042: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

4038: last_update_login = fnd_global.login_id
4039: WHERE product_transaction_id = RO.product_transaction_id;
4040: IF SQL%NOTFOUND THEN
4041: IF ( l_error_level >= G_debug_level) THEN
4042: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4043: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4044: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4045: ELSE
4046: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 4043: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

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

Line 4046: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

4042: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4043: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4044: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4045: ELSE
4046: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4047: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4048: fnd_msg_pub.add;
4049: END IF;
4050: RAISE PROCESS_ERROR;

Line 4047: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

4043: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4044: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4045: ELSE
4046: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4047: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4048: fnd_msg_pub.add;
4049: END IF;
4050: RAISE PROCESS_ERROR;
4051: END IF;

Line 4177: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

4173: and cra.serial_number = rcvt.serial_num);
4174: Exception
4175: WHEN NO_DATA_FOUND THEN
4176: IF ( l_error_level >= G_debug_level) THEN
4177: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4178: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4179: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4180: ELSE
4181: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

Line 4178: fnd_message.set_token('TXN_ID',RCV.transaction_id);

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

Line 4181: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

4177: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4178: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4179: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4180: ELSE
4181: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4182: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4183: fnd_msg_pub.add;
4184: END IF;
4185: RAISE PROCESS_ERROR;

Line 4182: fnd_message.set_token('TXN_ID',RCV.transaction_id);

4178: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4179: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4180: ELSE
4181: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4182: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4183: fnd_msg_pub.add;
4184: END IF;
4185: RAISE PROCESS_ERROR;
4186: END;

Line 4200: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

4196: and serial_number = l_serial_num;
4197: Exception
4198: When NO_DATA_FOUND THEN
4199: IF ( l_error_level >= G_debug_level) THEN
4200: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4201: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4202: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4203: ELSE
4204: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

Line 4201: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 4204: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

4200: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4201: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4202: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4203: ELSE
4204: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4205: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4206: fnd_msg_pub.add;
4207: END If;
4208: When Others THEN

Line 4205: fnd_message.set_token('SERIAL_NUM',l_serial_num);

4201: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4202: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4203: ELSE
4204: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4205: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4206: fnd_msg_pub.add;
4207: END If;
4208: When Others THEN
4209: IF ( l_error_level >= G_debug_level) THEN

Line 4210: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

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

Line 4211: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 4214: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

4210: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4211: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4212: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4213: ELSE
4214: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4215: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4216: fnd_msg_pub.add;
4217: END If;
4218: End;

Line 4215: fnd_message.set_token('SERIAL_NUM',l_serial_num);

4211: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4212: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4213: ELSE
4214: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4215: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4216: fnd_msg_pub.add;
4217: END If;
4218: End;
4219: ELSE

Line 4239: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

4235: where source_transaction_id = RCV.transaction_id;
4236: EXCEPTION
4237: WHEN NO_DATA_FOUND THEN
4238: IF ( l_error_level >= G_debug_level) THEN
4239: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4240: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4241: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4242: ELSE
4243: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

Line 4240: fnd_message.set_token('TXN_ID',RCV.transaction_id);

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

Line 4243: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

4239: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4240: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4241: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4242: ELSE
4243: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4244: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4245: fnd_msg_pub.add;
4246: END IF;
4247: RAISE FND_API.G_EXC_ERROR;

Line 4244: fnd_message.set_token('TXN_ID',RCV.transaction_id);

4240: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4241: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4242: ELSE
4243: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4244: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4245: fnd_msg_pub.add;
4246: END IF;
4247: RAISE FND_API.G_EXC_ERROR;
4248: END;

Line 4287: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

4283: last_update_login = fnd_global.login_id
4284: WHERE repair_line_id = RO.repair_line_id;
4285: IF SQL%NOTFOUND THEN
4286: IF ( l_error_level >= G_debug_level) THEN
4287: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4288: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4289: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4290: ELSE
4291: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 4288: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

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

Line 4291: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

4287: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4288: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4289: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4290: ELSE
4291: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4292: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4293: fnd_msg_pub.add;
4294: END IF;
4295: RAISE PROCESS_ERROR;

Line 4292: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

4288: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4289: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4290: ELSE
4291: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
4292: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
4293: fnd_msg_pub.add;
4294: END IF;
4295: RAISE PROCESS_ERROR;
4296: END IF;

Line 4315: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

4311: last_update_login = fnd_global.login_id
4312: WHERE product_transaction_id = RO.product_transaction_id;
4313: IF SQL%NOTFOUND THEN
4314: IF ( l_error_level >= G_debug_level) THEN
4315: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4316: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4317: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4318: ELSE
4319: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 4316: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

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

Line 4319: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

4315: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4316: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4317: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4318: ELSE
4319: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4320: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4321: fnd_msg_pub.add;
4322: END IF;
4323: RAISE PROCESS_ERROR;

Line 4320: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

4316: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4317: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4318: ELSE
4319: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
4320: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
4321: fnd_msg_pub.add;
4322: END IF;
4323: RAISE PROCESS_ERROR;
4324: END IF;

Line 4720: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

4716: and cpt.order_header_id = oeh.header_id);
4717: EXCEPTION
4718: WHEN NO_DATA_FOUND THEN
4719: IF ( l_error_level >= G_debug_level) THEN
4720: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4721: fnd_message.set_token('HEADER_ID',p_order_header_id);
4722: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4723: ELSE
4724: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

Line 4721: fnd_message.set_token('HEADER_ID',p_order_header_id);

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

Line 4724: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

4720: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4721: fnd_message.set_token('HEADER_ID',p_order_header_id);
4722: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4723: ELSE
4724: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4725: fnd_message.set_token('HEADER_ID',p_order_header_id);
4726: fnd_msg_pub.add;
4727: END IF;
4728: RAISE FND_API.G_EXC_ERROR;

Line 4725: fnd_message.set_token('HEADER_ID',p_order_header_id);

4721: fnd_message.set_token('HEADER_ID',p_order_header_id);
4722: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4723: ELSE
4724: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4725: fnd_message.set_token('HEADER_ID',p_order_header_id);
4726: fnd_msg_pub.add;
4727: END IF;
4728: RAISE FND_API.G_EXC_ERROR;
4729: END;

Line 4949: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

4945: and cra.serial_number = rcvt.serial_num);
4946: Exception
4947: WHEN NO_DATA_FOUND THEN
4948: IF ( l_error_level >= G_debug_level) THEN
4949: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4950: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4951: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4952: ELSE
4953: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

Line 4950: fnd_message.set_token('TXN_ID',DEL.transaction_id);

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

Line 4953: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

4949: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4950: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4951: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4952: ELSE
4953: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4954: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4955: fnd_msg_pub.add;
4956: END If;
4957: RAISE PROCESS_ERROR;

Line 4954: fnd_message.set_token('TXN_ID',DEL.transaction_id);

4950: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4951: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4952: ELSE
4953: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
4954: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4955: fnd_msg_pub.add;
4956: END If;
4957: RAISE PROCESS_ERROR;
4958: END;

Line 4971: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

4967: and serial_number = l_serial_num;
4968: Exception
4969: When NO_DATA_FOUND THEN
4970: IF ( l_error_level >= G_debug_level) THEN
4971: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4972: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4973: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4974: ELSE
4975: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

Line 4972: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 4975: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

4971: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4972: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4973: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4974: ELSE
4975: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4976: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4977: fnd_msg_pub.add;
4978: END If;
4979: When Others THEN

Line 4976: fnd_message.set_token('SERIAL_NUM',l_serial_num);

4972: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4973: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4974: ELSE
4975: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
4976: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4977: fnd_msg_pub.add;
4978: END If;
4979: When Others THEN
4980: IF ( l_error_level >= G_debug_level) THEN

Line 4981: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

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

Line 4982: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 4985: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

4981: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4982: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4983: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4984: ELSE
4985: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4986: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4987: fnd_msg_pub.add;
4988: END If;
4989: End;

Line 4986: fnd_message.set_token('SERIAL_NUM',l_serial_num);

4982: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4983: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
4984: ELSE
4985: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
4986: fnd_message.set_token('SERIAL_NUM',l_serial_num);
4987: fnd_msg_pub.add;
4988: END If;
4989: End;
4990: ELSE

Line 5012: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

5008: where source_transaction_id = DEL.transaction_id;
5009: EXCEPTION
5010: WHEN NO_DATA_FOUND THEN
5011: IF ( l_error_level >= G_debug_level) THEN
5012: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5013: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5015: ELSE
5016: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

Line 5013: fnd_message.set_token('TXN_ID',DEL.transaction_id);

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

Line 5016: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

5012: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5013: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5015: ELSE
5016: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5017: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5018: fnd_msg_pub.add;
5019: END IF;
5020: RAISE FND_API.G_EXC_ERROR;

Line 5017: fnd_message.set_token('TXN_ID',DEL.transaction_id);

5013: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5014: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5015: ELSE
5016: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5017: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5018: fnd_msg_pub.add;
5019: END IF;
5020: RAISE FND_API.G_EXC_ERROR;
5021: END;

Line 5065: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

5061: last_update_login = fnd_global.login_id
5062: WHERE repair_line_id = RO.repair_line_id;
5063: IF SQL%NOTFOUND THEN
5064: IF ( l_error_level >= G_debug_level) THEN
5065: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5066: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5067: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5068: ELSE
5069: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5066: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

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

Line 5069: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

5065: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5066: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5067: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5068: ELSE
5069: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5070: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5071: fnd_msg_pub.add;
5072: END IF;
5073: RAISE PROCESS_ERROR;

Line 5070: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

5066: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5067: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5068: ELSE
5069: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5070: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5071: fnd_msg_pub.add;
5072: END IF;
5073: RAISE PROCESS_ERROR;
5074: END IF;

Line 5094: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

5090: last_update_login = fnd_global.login_id
5091: WHERE product_transaction_id = RO.product_transaction_id;
5092: IF SQL%NOTFOUND THEN
5093: IF ( l_error_level >= G_debug_level) THEN
5094: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5095: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5096: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5097: ELSE
5098: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5095: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

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

Line 5098: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

5094: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5095: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5096: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5097: ELSE
5098: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5099: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5100: fnd_msg_pub.add;
5101: END IF;
5102: RAISE PROCESS_ERROR;

Line 5099: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

5095: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5096: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5097: ELSE
5098: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5099: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5100: fnd_msg_pub.add;
5101: END IF;
5102: RAISE PROCESS_ERROR;
5103: END IF;

Line 5322: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

5318: and cra.serial_number = rcvt.serial_num);
5319: Exception
5320: WHEN NO_DATA_FOUND THEN
5321: IF ( l_error_level >= G_debug_level) THEN
5322: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5323: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5324: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5325: ELSE
5326: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

Line 5323: fnd_message.set_token('TXN_ID',DEL.transaction_id);

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

Line 5326: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

5322: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5323: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5324: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5325: ELSE
5326: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5327: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5328: fnd_msg_pub.add;
5329: END If;
5330: RAISE PROCESS_ERROR;

Line 5327: fnd_message.set_token('TXN_ID',DEL.transaction_id);

5323: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5324: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5325: ELSE
5326: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5327: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5328: fnd_msg_pub.add;
5329: END If;
5330: RAISE PROCESS_ERROR;
5331: END;

Line 5344: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

5340: and serial_number = l_serial_num;
5341: Exception
5342: When NO_DATA_FOUND THEN
5343: IF ( l_error_level >= G_debug_level) THEN
5344: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5345: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5346: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5347: ELSE
5348: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

Line 5345: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 5348: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

5344: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5345: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5346: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5347: ELSE
5348: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5349: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5350: fnd_msg_pub.add;
5351: END If;
5352: When Others THEN

Line 5349: fnd_message.set_token('SERIAL_NUM',l_serial_num);

5345: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5346: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5347: ELSE
5348: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5349: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5350: fnd_msg_pub.add;
5351: END If;
5352: When Others THEN
5353: IF ( l_error_level >= G_debug_level) THEN

Line 5354: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

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

Line 5355: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 5358: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

5354: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5355: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5356: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5357: ELSE
5358: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5359: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5360: fnd_msg_pub.add;
5361: END If;
5362: End;

Line 5359: fnd_message.set_token('SERIAL_NUM',l_serial_num);

5355: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5356: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5357: ELSE
5358: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5359: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5360: fnd_msg_pub.add;
5361: END If;
5362: End;
5363: ELSE

Line 5385: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

5381: where source_transaction_id = DEL.transaction_id;
5382: EXCEPTION
5383: WHEN NO_DATA_FOUND THEN
5384: IF ( l_error_level >= G_debug_level) THEN
5385: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5386: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5387: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5388: ELSE
5389: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

Line 5386: fnd_message.set_token('TXN_ID',DEL.transaction_id);

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

Line 5389: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

5385: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5386: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5387: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5388: ELSE
5389: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5390: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5391: fnd_msg_pub.add;
5392: END IF;
5393: RAISE FND_API.G_EXC_ERROR;

Line 5390: fnd_message.set_token('TXN_ID',DEL.transaction_id);

5386: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5387: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5388: ELSE
5389: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5390: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5391: fnd_msg_pub.add;
5392: END IF;
5393: RAISE FND_API.G_EXC_ERROR;
5394: END;

Line 5438: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

5434: last_update_login = fnd_global.login_id
5435: WHERE repair_line_id = RO.repair_line_id;
5436: IF SQL%NOTFOUND THEN
5437: IF ( l_error_level >= G_debug_level) THEN
5438: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5439: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5440: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5441: ELSE
5442: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5439: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

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

Line 5442: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

5438: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5439: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5440: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5441: ELSE
5442: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5443: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5444: fnd_msg_pub.add;
5445: END IF;
5446: RAISE PROCESS_ERROR;

Line 5443: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

5439: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5440: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5441: ELSE
5442: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5443: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5444: fnd_msg_pub.add;
5445: END IF;
5446: RAISE PROCESS_ERROR;
5447: END IF;

Line 5468: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

5464: last_update_login = fnd_global.login_id
5465: WHERE product_transaction_id = RO.product_transaction_id;
5466: IF SQL%NOTFOUND THEN
5467: IF ( l_error_level >= G_debug_level) THEN
5468: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5469: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5470: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5471: ELSE
5472: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5469: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

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

Line 5472: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

5468: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5469: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5470: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5471: ELSE
5472: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5473: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5474: fnd_msg_pub.add;
5475: END IF;
5476: RAISE PROCESS_ERROR;

Line 5473: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

5469: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5470: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5471: ELSE
5472: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5473: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5474: fnd_msg_pub.add;
5475: END IF;
5476: RAISE PROCESS_ERROR;
5477: END IF;

Line 5611: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

5607: -- and cra.serial_number = rcvt.serial_num);
5608: Exception
5609: WHEN NO_DATA_FOUND THEN
5610: IF ( l_error_level >= G_debug_level) THEN
5611: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5612: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5613: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5614: ELSE
5615: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

Line 5612: fnd_message.set_token('TXN_ID',RCV.transaction_id);

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

Line 5615: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');

5611: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5612: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5613: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5614: ELSE
5615: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5616: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5617: fnd_msg_pub.add;
5618: END IF;
5619: RAISE PROCESS_ERROR;

Line 5616: fnd_message.set_token('TXN_ID',RCV.transaction_id);

5612: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5613: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5614: ELSE
5615: fnd_message.set_name('CSD','CSD_SERIAL_NUM_MISSING');
5616: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5617: fnd_msg_pub.add;
5618: END IF;
5619: RAISE PROCESS_ERROR;
5620: END;

Line 5634: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

5630: and serial_number = l_serial_num;
5631: Exception
5632: When NO_DATA_FOUND THEN
5633: IF ( l_error_level >= G_debug_level) THEN
5634: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5635: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5636: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5637: ELSE
5638: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

Line 5635: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 5638: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');

5634: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5635: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5636: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5637: ELSE
5638: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5639: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5640: fnd_msg_pub.add;
5641: END If;
5642: When Others THEN

Line 5639: fnd_message.set_token('SERIAL_NUM',l_serial_num);

5635: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5636: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5637: ELSE
5638: fnd_message.set_name('CSD','CSD_ITEM_INSTANCE_MISSING');
5639: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5640: fnd_msg_pub.add;
5641: END If;
5642: When Others THEN
5643: IF ( l_error_level >= G_debug_level) THEN

Line 5644: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

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

Line 5645: fnd_message.set_token('SERIAL_NUM',l_serial_num);

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

Line 5648: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');

5644: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5645: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5647: ELSE
5648: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5649: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5650: fnd_msg_pub.add;
5651: END If;
5652: End;

Line 5649: fnd_message.set_token('SERIAL_NUM',l_serial_num);

5645: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5646: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5647: ELSE
5648: fnd_message.set_name('CSD','CSD_INV_SERIAL_NUM');
5649: fnd_message.set_token('SERIAL_NUM',l_serial_num);
5650: fnd_msg_pub.add;
5651: END If;
5652: End;
5653: ELSE

Line 5673: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

5669: where source_transaction_id = RCV.transaction_id;
5670: EXCEPTION
5671: WHEN NO_DATA_FOUND THEN
5672: IF ( l_error_level >= G_debug_level) THEN
5673: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5674: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5676: ELSE
5677: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

Line 5674: fnd_message.set_token('TXN_ID',RCV.transaction_id);

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

Line 5677: fnd_message.set_name('CSD','CSD_INV_TXN_ID');

5673: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5674: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5676: ELSE
5677: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5678: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5679: fnd_msg_pub.add;
5680: END IF;
5681: RAISE FND_API.G_EXC_ERROR;

Line 5678: fnd_message.set_token('TXN_ID',RCV.transaction_id);

5674: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5675: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5676: ELSE
5677: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5678: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5679: fnd_msg_pub.add;
5680: END IF;
5681: RAISE FND_API.G_EXC_ERROR;
5682: END;

Line 5726: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

5722: last_update_login = fnd_global.login_id
5723: WHERE repair_line_id = RO.repair_line_id;
5724: IF SQL%NOTFOUND THEN
5725: IF ( l_error_level >= G_debug_level) THEN
5726: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5727: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5728: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5729: ELSE
5730: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5727: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

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

Line 5730: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

5726: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5727: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5728: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5729: ELSE
5730: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5731: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5732: fnd_msg_pub.add;
5733: END IF;
5734: RAISE PROCESS_ERROR;

Line 5731: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);

5727: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5728: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5729: ELSE
5730: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
5731: fnd_message.set_token('REPAIR_LINE_ID',RO.repair_line_id);
5732: fnd_msg_pub.add;
5733: END IF;
5734: RAISE PROCESS_ERROR;
5735: END IF;

Line 5754: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

5750: last_update_login = fnd_global.login_id
5751: WHERE product_transaction_id = RO.product_transaction_id;
5752: IF SQL%NOTFOUND THEN
5753: IF ( l_error_level >= G_debug_level) THEN
5754: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5755: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5756: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5757: ELSE
5758: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5755: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

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

Line 5758: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

5754: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5755: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5756: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5757: ELSE
5758: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5759: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5760: fnd_msg_pub.add;
5761: END IF;
5762: RAISE PROCESS_ERROR;

Line 5759: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);

5755: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5756: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
5757: ELSE
5758: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
5759: fnd_message.set_token('PROD_TXN_ID',RO.product_transaction_id);
5760: fnd_msg_pub.add;
5761: END IF;
5762: RAISE PROCESS_ERROR;
5763: END IF;

Line 6068: fnd_message.set_name('CSD','CSD_SQL_ERROR');

6064: p_data => x_msg_data );
6065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6066: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
6067: IF ( l_error_level >= G_debug_level) THEN
6068: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6069: fnd_message.set_token('SQLERRM',SQLERRM);
6070: fnd_message.set_token('SQLCODE',SQLCODE);
6071: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6072: END If;

Line 6069: fnd_message.set_token('SQLERRM',SQLERRM);

6065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6066: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
6067: IF ( l_error_level >= G_debug_level) THEN
6068: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6069: fnd_message.set_token('SQLERRM',SQLERRM);
6070: fnd_message.set_token('SQLCODE',SQLCODE);
6071: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6072: END If;
6073: -- As we commit the processed records in the inner APIs

Line 6070: fnd_message.set_token('SQLCODE',SQLCODE);

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

Line 6085: fnd_message.set_name('CSD','CSD_SQL_ERROR');

6081: p_data => x_msg_data );
6082: WHEN OTHERS THEN
6083: Debug('In OTHERS Exception',l_mod_name,4);
6084: IF ( l_error_level >= G_debug_level) THEN
6085: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6086: fnd_message.set_token('SQLERRM',SQLERRM);
6087: fnd_message.set_token('SQLCODE',SQLCODE);
6088: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6089: END If;

Line 6086: fnd_message.set_token('SQLERRM',SQLERRM);

6082: WHEN OTHERS THEN
6083: Debug('In OTHERS Exception',l_mod_name,4);
6084: IF ( l_error_level >= G_debug_level) THEN
6085: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6086: fnd_message.set_token('SQLERRM',SQLERRM);
6087: fnd_message.set_token('SQLCODE',SQLCODE);
6088: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6089: END If;
6090: -- As we commit the processed records in the inner APIs

Line 6087: fnd_message.set_token('SQLCODE',SQLCODE);

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

Line 6585: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');

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

Line 6588: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');

6584: IF ( l_error_level >= G_debug_level) THEN
6585: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6586: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6587: ELSE
6588: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6589: fnd_msg_pub.add;
6590: END IF;
6591: RAISE FND_API.G_EXC_ERROR;
6592: End;

Line 6687: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

6683: last_update_login = fnd_global.login_id
6684: where repair_line_id = I.repair_line_id;
6685: IF SQL%NOTFOUND THEN
6686: IF ( l_error_level >= G_debug_level) THEN
6687: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6688: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6689: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6690: ELSE
6691: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 6688: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);

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

Line 6691: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

6687: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6688: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6689: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6690: ELSE
6691: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6692: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6693: fnd_msg_pub.add;
6694: END IF;
6695: RAISE FND_API.G_EXC_ERROR;

Line 6692: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);

6688: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6689: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6690: ELSE
6691: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6692: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6693: fnd_msg_pub.add;
6694: END IF;
6695: RAISE FND_API.G_EXC_ERROR;
6696: END IF;

Line 6715: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');

6711: Correct message name CSD_INSTANCE_MISSING is used instead of
6712: CSD_INV_INSTANCE_ID.
6713: */
6714: IF ( l_error_level >= G_debug_level) THEN
6715: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6716: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6717: fnd_msg_pub.add;
6718: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6719: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 6716: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);

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

Line 6719: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

Line 6721: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');

6717: fnd_msg_pub.add;
6718: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6719: fnd_file.put_line(fnd_file.log, fnd_message.get);
6720: ELSE
6721: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6722: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6723: fnd_msg_pub.add;
6724: fnd_file.put_line(fnd_file.log, fnd_message.get);
6725: /*Fixed for bug#5563369

Line 6722: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);

6718: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6719: fnd_file.put_line(fnd_file.log, fnd_message.get);
6720: ELSE
6721: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6722: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6723: fnd_msg_pub.add;
6724: fnd_file.put_line(fnd_file.log, fnd_message.get);
6725: /*Fixed for bug#5563369
6726: Correct message name CSD_INSTANCE_MISSING is used instead of

Line 6724: fnd_file.put_line(fnd_file.log, fnd_message.get);

6720: ELSE
6721: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6722: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6723: fnd_msg_pub.add;
6724: fnd_file.put_line(fnd_file.log, fnd_message.get);
6725: /*Fixed for bug#5563369
6726: Correct message name CSD_INSTANCE_MISSING is used instead of
6727: CSD_INV_INSTANCE_ID.
6728: */

Line 6733: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');

6729: END IF;
6730: RAISE FND_API.G_EXC_ERROR;
6731: When OTHERS then
6732: IF ( l_error_level >= G_debug_level) THEN
6733: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6734: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6735: fnd_msg_pub.add;
6736: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6737: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 6734: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);

6730: RAISE FND_API.G_EXC_ERROR;
6731: When OTHERS then
6732: IF ( l_error_level >= G_debug_level) THEN
6733: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6734: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6735: fnd_msg_pub.add;
6736: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6737: fnd_file.put_line(fnd_file.log, fnd_message.get);
6738: ELSE

Line 6737: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

Line 6739: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');

6735: fnd_msg_pub.add;
6736: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6737: fnd_file.put_line(fnd_file.log, fnd_message.get);
6738: ELSE
6739: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6740: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6741: fnd_msg_pub.add;
6742: fnd_file.put_line(fnd_file.log, fnd_message.get);
6743: END IF;

Line 6740: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);

6736: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6737: fnd_file.put_line(fnd_file.log, fnd_message.get);
6738: ELSE
6739: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6740: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6741: fnd_msg_pub.add;
6742: fnd_file.put_line(fnd_file.log, fnd_message.get);
6743: END IF;
6744: RAISE FND_API.G_EXC_ERROR;

Line 6742: fnd_file.put_line(fnd_file.log, fnd_message.get);

6738: ELSE
6739: fnd_message.set_name('CSD','CSD_INSTANCE_MISSING');
6740: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6741: fnd_msg_pub.add;
6742: fnd_file.put_line(fnd_file.log, fnd_message.get);
6743: END IF;
6744: RAISE FND_API.G_EXC_ERROR;
6745: End;
6746:

Line 6777: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

6773: last_update_login = fnd_global.login_id
6774: where product_transaction_id = i.product_transaction_id ;
6775: IF SQL%NOTFOUND THEN
6776: IF ( l_error_level >= G_debug_level) THEN
6777: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
6778: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
6779: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6780: ELSE
6781: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 6778: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);

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

Line 6781: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

6777: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
6778: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
6779: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6780: ELSE
6781: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
6782: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
6783: fnd_msg_pub.add;
6784: END IF;
6785: RAISE FND_API.G_EXC_ERROR;

Line 6782: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);

6778: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
6779: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
6780: ELSE
6781: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
6782: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
6783: fnd_msg_pub.add;
6784: END IF;
6785: RAISE FND_API.G_EXC_ERROR;
6786: END IF;

Line 6903: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');

6899: Debug('At the end of processing cancelled orders in SO_SHIP_UPDATE',l_mod_name,1);
6900: -----------------------
6901:
6902: -- Log seeded messages for the number of processed records
6903: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
6904: fnd_message.set_token('TOT_REC',to_char(l_total_records));
6905: FND_MSG_PUB.ADD;
6906:
6907: -- Debug messages

Line 6904: fnd_message.set_token('TOT_REC',to_char(l_total_records));

6900: -----------------------
6901:
6902: -- Log seeded messages for the number of processed records
6903: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
6904: fnd_message.set_token('TOT_REC',to_char(l_total_records));
6905: FND_MSG_PUB.ADD;
6906:
6907: -- Debug messages
6908: Debug(fnd_message.get,l_mod_name,1);

Line 6908: Debug(fnd_message.get,l_mod_name,1);

6904: fnd_message.set_token('TOT_REC',to_char(l_total_records));
6905: FND_MSG_PUB.ADD;
6906:
6907: -- Debug messages
6908: Debug(fnd_message.get,l_mod_name,1);
6909:
6910: -- Log messages in the concurrent log and output file
6911: fnd_file.put_line(fnd_file.log,fnd_message.get);
6912: fnd_file.put_line(fnd_file.output,fnd_message.get);

Line 6911: fnd_file.put_line(fnd_file.log,fnd_message.get);

6907: -- Debug messages
6908: Debug(fnd_message.get,l_mod_name,1);
6909:
6910: -- Log messages in the concurrent log and output file
6911: fnd_file.put_line(fnd_file.log,fnd_message.get);
6912: fnd_file.put_line(fnd_file.output,fnd_message.get);
6913:
6914: -- Standard check of p_commit.
6915: IF FND_API.To_Boolean( p_commit ) THEN

Line 6912: fnd_file.put_line(fnd_file.output,fnd_message.get);

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

Line 7242: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

7238: where cpt.order_header_id = oeh.header_id );
7239: EXCEPTION
7240: WHEN NO_DATA_FOUND THEN
7241: IF ( l_error_level >= G_debug_level) THEN
7242: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7243: fnd_message.set_token('HEADER_ID',p_order_header_id);
7244: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7245: ELSE
7246: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

Line 7243: fnd_message.set_token('HEADER_ID',p_order_header_id);

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

Line 7246: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

7242: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7243: fnd_message.set_token('HEADER_ID',p_order_header_id);
7244: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7245: ELSE
7246: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7247: fnd_message.set_token('HEADER_ID',p_order_header_id);
7248: fnd_msg_pub.add;
7249: END IF;
7250: RAISE FND_API.G_EXC_ERROR;

Line 7247: fnd_message.set_token('HEADER_ID',p_order_header_id);

7243: fnd_message.set_token('HEADER_ID',p_order_header_id);
7244: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7245: ELSE
7246: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7247: fnd_message.set_token('HEADER_ID',p_order_header_id);
7248: fnd_msg_pub.add;
7249: END IF;
7250: RAISE FND_API.G_EXC_ERROR;
7251: END;

Line 7291: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

7287: and rownum = 1;
7288: EXCEPTION
7289: WHEN NO_DATA_FOUND THEN
7290: IF ( l_error_level >= G_debug_level) THEN
7291: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7292: fnd_message.set_token('HEADER_ID',DEL.header_id);
7293: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7294: ELSE
7295: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

Line 7292: fnd_message.set_token('HEADER_ID',DEL.header_id);

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

Line 7295: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

7291: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7292: fnd_message.set_token('HEADER_ID',DEL.header_id);
7293: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7294: ELSE
7295: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7296: fnd_message.set_token('HEADER_ID',DEL.header_id);
7297: fnd_msg_pub.add;
7298: END IF;
7299: RAISE FND_API.G_EXC_ERROR;

Line 7296: fnd_message.set_token('HEADER_ID',DEL.header_id);

7292: fnd_message.set_token('HEADER_ID',DEL.header_id);
7293: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7294: ELSE
7295: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7296: fnd_message.set_token('HEADER_ID',DEL.header_id);
7297: fnd_msg_pub.add;
7298: END IF;
7299: RAISE FND_API.G_EXC_ERROR;
7300: END;

Line 7391: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

7387: last_update_login = fnd_global.login_id
7388: WHERE product_transaction_id = l_prod_txn_id;
7389: IF SQL%NOTFOUND THEN
7390: IF ( l_error_level >= G_debug_level) THEN
7391: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7392: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7393: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7394: ELSE
7395: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

Line 7392: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);

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

Line 7395: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

7391: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7392: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7393: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7394: ELSE
7395: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7396: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7397: fnd_msg_pub.add;
7398: END IF;
7399: RAISE PROCESS_ERROR;

Line 7396: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);

7392: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7393: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7394: ELSE
7395: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7396: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7397: fnd_msg_pub.add;
7398: END IF;
7399: RAISE PROCESS_ERROR;
7400: END IF;

Line 7417: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

7413: and rownum = 1;
7414: Exception
7415: WHEN NO_DATA_FOUND THEN
7416: IF ( l_error_level >= G_debug_level) THEN
7417: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7418: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7419: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7420: ELSE
7421: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

Line 7418: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);

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

Line 7421: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

7417: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7418: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7419: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7420: ELSE
7421: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7422: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7423: fnd_msg_pub.add;
7424: END IF;
7425: RAISE PROCESS_ERROR;

Line 7422: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);

7418: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7419: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7420: ELSE
7421: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7422: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7423: fnd_msg_pub.add;
7424: END IF;
7425: RAISE PROCESS_ERROR;
7426: End;

Line 7485: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');

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

Line 7488: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');

7484: IF ( l_error_level >= G_debug_level) THEN
7485: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7486: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7487: ELSE
7488: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7489: fnd_msg_pub.add;
7490: END IF;
7491: RAISE PROCESS_ERROR;
7492: END;

Line 7548: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');

7544: and prod_txn_status in('BOOKED','RELEASED')
7545: and rownum <= nvl(DEL.requested_quantity,0) ;
7546: IF SQL%NOTFOUND THEN
7547: IF ( l_error_level >= G_debug_level) THEN
7548: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7549: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7550: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7551: ELSE
7552: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');

Line 7549: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);

7545: and rownum <= nvl(DEL.requested_quantity,0) ;
7546: IF SQL%NOTFOUND THEN
7547: IF ( l_error_level >= G_debug_level) THEN
7548: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7549: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7550: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7551: ELSE
7552: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7553: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);

Line 7552: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');

7548: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7549: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7550: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7551: ELSE
7552: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7553: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7554: fnd_msg_pub.add;
7555: END IF;
7556: RAISE PROCESS_ERROR;

Line 7553: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);

7549: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7550: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7551: ELSE
7552: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7553: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7554: fnd_msg_pub.add;
7555: END IF;
7556: RAISE PROCESS_ERROR;
7557: END IF;

Line 7579: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');

7575: and prod_txn_status in ('BOOKED','RELEASED')
7576: and rownum <= nvl(DEL.requested_quantity,0);
7577: IF SQL%NOTFOUND THEN
7578: IF ( l_error_level >= G_debug_level) THEN
7579: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7580: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7581: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7582: ELSE
7583: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');

Line 7580: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);

7576: and rownum <= nvl(DEL.requested_quantity,0);
7577: IF SQL%NOTFOUND THEN
7578: IF ( l_error_level >= G_debug_level) THEN
7579: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7580: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7581: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7582: ELSE
7583: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7584: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);

Line 7583: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');

7579: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7580: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7581: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7582: ELSE
7583: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7584: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7585: fnd_msg_pub.add;
7586: END IF;
7587: RAISE PROCESS_ERROR;

Line 7584: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);

7580: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7581: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7582: ELSE
7583: fnd_message.set_name('CSD','CSD_INV_ORDER_LINE_ID');
7584: fnd_message.set_token('ORDER_LINE_ID',DEL.line_id);
7585: fnd_msg_pub.add;
7586: END IF;
7587: RAISE PROCESS_ERROR;
7588: END IF;

Line 7706: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

7702: last_update_login = fnd_global.login_id
7703: WHERE product_transaction_id = l_prod_txn_id;
7704: IF SQL%NOTFOUND THEN
7705: IF ( l_error_level >= G_debug_level) THEN
7706: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7707: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7708: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7709: ELSE
7710: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

Line 7707: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);

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

Line 7710: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

7706: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7707: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7708: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7709: ELSE
7710: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7711: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7712: fnd_msg_pub.add;
7713: END IF;
7714: RAISE PROCESS_ERROR;

Line 7711: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);

7707: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7708: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7709: ELSE
7710: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');
7711: fnd_message.set_token('PROD_TXN_ID',l_prod_txn_id);
7712: fnd_msg_pub.add;
7713: END IF;
7714: RAISE PROCESS_ERROR;
7715: END IF;

Line 7732: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

7728: and rownum = 1;
7729: Exception
7730: WHEN NO_DATA_FOUND THEN
7731: IF ( l_error_level >= G_debug_level) THEN
7732: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7733: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7735: ELSE
7736: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

Line 7733: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);

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

Line 7736: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');

7732: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7733: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7735: ELSE
7736: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7737: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7738: fnd_msg_pub.add;
7739: END IF;
7740: RAISE PROCESS_ERROR;

Line 7737: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);

7733: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7735: ELSE
7736: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7737: fnd_message.set_token('ORDER_HEADER_ID',DEL.header_id);
7738: fnd_msg_pub.add;
7739: END IF;
7740: RAISE PROCESS_ERROR;
7741: End;

Line 7801: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');

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

Line 7804: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');

7800: IF ( l_error_level >= G_debug_level) THEN
7801: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7802: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
7803: ELSE
7804: fnd_message.set_name('CSD','CSD_PROD_TXN_INSERT_FAILED');
7805: fnd_msg_pub.add;
7806: END IF;
7807: RAISE PROCESS_ERROR;
7808: END;

Line 7823: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

7819: last_update_login = fnd_global.login_id
7820: where repair_line_id = l_rep_line_id;
7821: IF SQL%NOTFOUND THEN
7822: IF ( l_error_level >= G_debug_level) THEN
7823: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7824: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7825: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7826: ELSE
7827: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 7824: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

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

Line 7827: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

7823: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7824: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7825: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7826: ELSE
7827: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7828: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7829: FND_MSG_PUB.ADD;
7830: END IF;
7831: RAISE PROCESS_ERROR;

Line 7828: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

7824: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7825: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7826: ELSE
7827: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7828: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7829: FND_MSG_PUB.ADD;
7830: END IF;
7831: RAISE PROCESS_ERROR;
7832: END IF;

Line 7952: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

7948: last_update_login = fnd_global.login_id
7949: where product_transaction_id = l_prod_txn_id;
7950: IF SQL%NOTFOUND THEN
7951: IF ( l_error_level >= G_debug_level) THEN
7952: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
7953: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
7954: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7955: ELSE
7956: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

Line 7953: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);

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

Line 7956: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

7952: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
7953: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
7954: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7955: ELSE
7956: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
7957: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
7958: FND_MSG_PUB.ADD;
7959: END IF;
7960: RAISE PROCESS_ERROR;

Line 7957: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);

7953: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
7954: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7955: ELSE
7956: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
7957: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
7958: FND_MSG_PUB.ADD;
7959: END IF;
7960: RAISE PROCESS_ERROR;
7961: END IF;

Line 7973: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

7969: last_update_login = fnd_global.login_id
7970: where repair_line_id = l_rep_line_id;
7971: IF SQL%NOTFOUND THEN
7972: IF ( l_error_level >= G_debug_level) THEN
7973: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7974: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7975: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7976: ELSE
7977: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 7974: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

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

Line 7977: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

7973: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7974: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7975: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7976: ELSE
7977: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7978: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7979: FND_MSG_PUB.ADD;
7980: END IF;
7981: RAISE PROCESS_ERROR;

Line 7978: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

7974: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7975: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
7976: ELSE
7977: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
7978: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
7979: FND_MSG_PUB.ADD;
7980: END IF;
7981: RAISE PROCESS_ERROR;
7982: END IF;

Line 8071: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

8067: last_update_login = fnd_global.login_id
8068: where product_transaction_id = l_prod_txn_id;
8069: IF SQL%NOTFOUND THEN
8070: IF ( l_error_level >= G_debug_level) THEN
8071: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8072: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8073: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8074: ELSE
8075: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 8072: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);

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

Line 8075: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

8071: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8072: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8073: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8074: ELSE
8075: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8076: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8077: FND_MSG_PUB.ADD;
8078: END IF;
8079: RAISE PROCESS_ERROR;

Line 8076: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);

8072: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8073: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8074: ELSE
8075: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8076: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8077: FND_MSG_PUB.ADD;
8078: END IF;
8079: RAISE PROCESS_ERROR;
8080: END IF;

Line 8092: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

8088: last_update_login = fnd_global.login_id
8089: where repair_line_id = l_rep_line_id;
8090: IF SQL%NOTFOUND THEN
8091: IF ( l_error_level >= G_debug_level) THEN
8092: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8093: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8094: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8095: ELSE
8096: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8093: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

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

Line 8096: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

8092: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8093: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8094: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8095: ELSE
8096: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8097: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8098: FND_MSG_PUB.ADD;
8099: END IF;
8100: RAISE PROCESS_ERROR;

Line 8097: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

8093: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8094: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8095: ELSE
8096: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8097: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8098: FND_MSG_PUB.ADD;
8099: END IF;
8100: RAISE PROCESS_ERROR;
8101: END IF;

Line 8208: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

8204: last_update_login = fnd_global.login_id
8205: where product_transaction_id = l_prod_txn_id;
8206: IF SQL%NOTFOUND THEN
8207: IF ( l_error_level >= G_debug_level) THEN
8208: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8209: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8210: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8211: ELSE
8212: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

Line 8209: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);

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

Line 8212: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

8208: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8209: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8210: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8211: ELSE
8212: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8213: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8214: FND_MSG_PUB.ADD;
8215: END IF;
8216: RAISE PROCESS_ERROR;

Line 8213: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);

8209: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8210: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8211: ELSE
8212: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
8213: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8214: FND_MSG_PUB.ADD;
8215: END IF;
8216: RAISE PROCESS_ERROR;
8217: END IF;

Line 8229: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

8225: last_update_login = fnd_global.login_id
8226: where repair_line_id = l_rep_line_id;
8227: IF SQL%NOTFOUND THEN
8228: IF ( l_error_level >= G_debug_level) THEN
8229: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8230: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8231: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8232: ELSE
8233: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8230: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

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

Line 8233: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

8229: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8230: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8231: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8232: ELSE
8233: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8234: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8235: FND_MSG_PUB.ADD;
8236: END IF;
8237: RAISE PROCESS_ERROR;

Line 8234: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

8230: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8231: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8232: ELSE
8233: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8234: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8235: FND_MSG_PUB.ADD;
8236: END IF;
8237: RAISE PROCESS_ERROR;
8238: END IF;

Line 8327: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

8323: last_update_login = fnd_global.login_id
8324: where product_transaction_id = l_prod_txn_id;
8325: IF SQL%NOTFOUND THEN
8326: IF ( l_error_level >= G_debug_level) THEN
8327: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8328: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8329: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8330: ELSE
8331: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 8328: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);

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

Line 8331: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

8327: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8328: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8329: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8330: ELSE
8331: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8332: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8333: FND_MSG_PUB.ADD;
8334: END IF;
8335: RAISE PROCESS_ERROR;

Line 8332: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);

8328: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8329: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8330: ELSE
8331: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');
8332: FND_MESSAGE.SET_TOKEN('PROD_TXN_ID',l_prod_txn_id);
8333: FND_MSG_PUB.ADD;
8334: END IF;
8335: RAISE PROCESS_ERROR;
8336: END IF;

Line 8348: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

8344: last_update_login = fnd_global.login_id
8345: where repair_line_id = l_rep_line_id;
8346: IF SQL%NOTFOUND THEN
8347: IF ( l_error_level >= G_debug_level) THEN
8348: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8349: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8350: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8351: ELSE
8352: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8349: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

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

Line 8352: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

8348: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8349: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8350: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8351: ELSE
8352: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8353: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8354: FND_MSG_PUB.ADD;
8355: END IF;
8356: RAISE PROCESS_ERROR;

Line 8353: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);

8349: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8350: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8351: ELSE
8352: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
8353: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_rep_line_id);
8354: FND_MSG_PUB.ADD;
8355: END IF;
8356: RAISE PROCESS_ERROR;
8357: END IF;

Line 8645: fnd_message.set_name('CSD','CSD_SQL_ERROR');

8641: p_data => x_msg_data );
8642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8643: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
8644: IF ( l_error_level >= G_debug_level) THEN
8645: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8646: fnd_message.set_token('SQLERRM',SQLERRM);
8647: fnd_message.set_token('SQLCODE',SQLCODE);
8648: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8649: END If;

Line 8646: fnd_message.set_token('SQLERRM',SQLERRM);

8642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8643: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
8644: IF ( l_error_level >= G_debug_level) THEN
8645: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8646: fnd_message.set_token('SQLERRM',SQLERRM);
8647: fnd_message.set_token('SQLCODE',SQLCODE);
8648: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8649: END If;
8650: -- As we commit the processed records in the inner APIs

Line 8647: fnd_message.set_token('SQLCODE',SQLCODE);

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

Line 8662: fnd_message.set_name('CSD','CSD_SQL_ERROR');

8658: p_data => x_msg_data );
8659: WHEN OTHERS THEN
8660: Debug('In OTHERS Exception',l_mod_name,4);
8661: IF ( l_error_level >= G_debug_level) THEN
8662: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8663: fnd_message.set_token('SQLERRM',SQLERRM);
8664: fnd_message.set_token('SQLCODE',SQLCODE);
8665: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8666: END If;

Line 8663: fnd_message.set_token('SQLERRM',SQLERRM);

8659: WHEN OTHERS THEN
8660: Debug('In OTHERS Exception',l_mod_name,4);
8661: IF ( l_error_level >= G_debug_level) THEN
8662: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8663: fnd_message.set_token('SQLERRM',SQLERRM);
8664: fnd_message.set_token('SQLCODE',SQLCODE);
8665: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8666: END If;
8667: -- As we commit the processed records in the inner APIs

Line 8664: fnd_message.set_token('SQLCODE',SQLCODE);

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