eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on FND_API

Line 358: x_return_status := FND_API.G_RET_STS_SUCCESS;

354: -- Standard Start of API savepoint
355: SAVEPOINT CONV_TO_RO_UOM;
356:
357: -- Initialize API return status to success
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359:
360: -- Api body starts
361: Debug('At the Beginning of Convert_to_RO_uom',l_mod_name,1);
362:

Line 381: RAISE FND_API.G_EXC_ERROR;

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

Line 392: RAISE FND_API.G_EXC_ERROR;

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;
394: Else
395: -- assign the uom code if it is passed to the api
396: l_from_uom_code := p_from_uom_code;

Line 422: RAISE FND_API.G_EXC_ERROR;

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;
424: ELSE
425: x_result_quantity := p_from_quantity;
426: END IF;

Line 429: WHEN FND_API.G_EXC_ERROR THEN

425: x_result_quantity := p_from_quantity;
426: END IF;
427:
428: EXCEPTION
429: WHEN FND_API.G_EXC_ERROR THEN
430: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
431: ROLLBACK TO CONV_TO_RO_UOM;
432: x_return_status := FND_API.G_RET_STS_ERROR ;
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 430: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);

426: END IF;
427:
428: EXCEPTION
429: WHEN FND_API.G_EXC_ERROR THEN
430: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
431: ROLLBACK TO CONV_TO_RO_UOM;
432: x_return_status := FND_API.G_RET_STS_ERROR ;
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

Line 432: x_return_status := FND_API.G_RET_STS_ERROR ;

428: EXCEPTION
429: WHEN FND_API.G_EXC_ERROR THEN
430: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
431: ROLLBACK TO CONV_TO_RO_UOM;
432: x_return_status := FND_API.G_RET_STS_ERROR ;
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
435: ROLLBACK TO CONV_TO_RO_UOM;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

429: WHEN FND_API.G_EXC_ERROR THEN
430: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
431: ROLLBACK TO CONV_TO_RO_UOM;
432: x_return_status := FND_API.G_RET_STS_ERROR ;
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
435: ROLLBACK TO CONV_TO_RO_UOM;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
437: WHEN OTHERS THEN

Line 434: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

430: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
431: ROLLBACK TO CONV_TO_RO_UOM;
432: x_return_status := FND_API.G_RET_STS_ERROR ;
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
435: ROLLBACK TO CONV_TO_RO_UOM;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
437: WHEN OTHERS THEN
438: Debug('In OTHERS exception',l_mod_name,4);

Line 436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

432: x_return_status := FND_API.G_RET_STS_ERROR ;
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
435: ROLLBACK TO CONV_TO_RO_UOM;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
437: WHEN OTHERS THEN
438: Debug('In OTHERS exception',l_mod_name,4);
439: ROLLBACK TO CONV_TO_RO_UOM;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
437: WHEN OTHERS THEN
438: Debug('In OTHERS exception',l_mod_name,4);
439: ROLLBACK TO CONV_TO_RO_UOM;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441: End CONVERT_TO_RO_UOM;
442:
443: /*-------------------------------------------------------------------------------------*/
444: /* Procedure name: LOG_ACTIVITY */

Line 495: x_return_status := FND_API.G_RET_STS_SUCCESS;

491: -- Standard Start of API savepoint
492: SAVEPOINT LOG_ACTIVITY;
493:
494: -- Initialize API return status to success
495: x_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497: -- Debug messages
498: Debug('At the beginning of log_activity api',l_mod_name,1);
499:

Line 501: IF NOT FND_API.Compatible_API_Call (l_api_version,

497: -- Debug messages
498: Debug('At the beginning of log_activity api',l_mod_name,1);
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call (l_api_version,
502: p_api_version,
503: l_api_name ,
504: G_PKG_NAME )
505: THEN

Line 506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

502: p_api_version,
503: l_api_name ,
504: G_PKG_NAME )
505: THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509: -- Initialize message list if p_init_msg_list is set to TRUE.
510: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 510: IF FND_API.to_Boolean( p_init_msg_list ) THEN

506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509: -- Initialize message list if p_init_msg_list is set to TRUE.
510: IF FND_API.to_Boolean( p_init_msg_list ) THEN
511: FND_MSG_PUB.initialize;
512: END IF;
513:
514: -- Debug messages

Line 608: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

604:
605: -- Debug messages
606: Debug('x_return_status from Validate_And_Write ='||x_return_status,l_mod_name,2);
607:
608: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
609: Debug('Validate_And_Write api failed ',l_mod_name,4);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:

Line 610: RAISE FND_API.G_EXC_ERROR;

606: Debug('x_return_status from Validate_And_Write ='||x_return_status,l_mod_name,2);
607:
608: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
609: Debug('Validate_And_Write api failed ',l_mod_name,4);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:
613: -- Standard check of p_commit.
614: IF FND_API.To_Boolean( p_commit ) THEN

Line 614: IF FND_API.To_Boolean( p_commit ) THEN

610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:
613: -- Standard check of p_commit.
614: IF FND_API.To_Boolean( p_commit ) THEN
615: COMMIT WORK;
616: END IF;
617:
618: -- Standard call to get message count and IF count is get message info.

Line 623: WHEN FND_API.G_EXC_ERROR THEN

619: FND_MSG_PUB.Count_And_Get
620: (p_count => x_msg_count,
621: p_data => x_msg_data );
622: EXCEPTION
623: WHEN FND_API.G_EXC_ERROR THEN
624: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
625: ROLLBACK TO LOG_ACTIVITY;
626: x_return_status := FND_API.G_RET_STS_ERROR ;
627: FND_MSG_PUB.Count_And_Get

Line 624: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);

620: (p_count => x_msg_count,
621: p_data => x_msg_data );
622: EXCEPTION
623: WHEN FND_API.G_EXC_ERROR THEN
624: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
625: ROLLBACK TO LOG_ACTIVITY;
626: x_return_status := FND_API.G_RET_STS_ERROR ;
627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,

Line 626: x_return_status := FND_API.G_RET_STS_ERROR ;

622: EXCEPTION
623: WHEN FND_API.G_EXC_ERROR THEN
624: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
625: ROLLBACK TO LOG_ACTIVITY;
626: x_return_status := FND_API.G_RET_STS_ERROR ;
627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,
629: p_data => x_msg_data );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

626: x_return_status := FND_API.G_RET_STS_ERROR ;
627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,
629: p_data => x_msg_data );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
632: ROLLBACK TO LOG_ACTIVITY;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
634: FND_MSG_PUB.Count_And_Get

Line 631: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,
629: p_data => x_msg_data );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
632: ROLLBACK TO LOG_ACTIVITY;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
634: FND_MSG_PUB.Count_And_Get
635: ( p_count => x_msg_count,

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

629: p_data => x_msg_data );
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
632: ROLLBACK TO LOG_ACTIVITY;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
634: FND_MSG_PUB.Count_And_Get
635: ( p_count => x_msg_count,
636: p_data => x_msg_data );
637: WHEN OTHERS THEN

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

636: p_data => x_msg_data );
637: WHEN OTHERS THEN
638: Debug('In OTHERS exception',l_mod_name,4 );
639: ROLLBACK TO LOG_ACTIVITY;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg

Line 816: x_return_status := FND_API.G_RET_STS_SUCCESS;

812: -- Standard Start of API savepoint
813: SAVEPOINT JOB_COMPLETION_UPDATE;
814:
815: -- Initialize API return status to success
816: x_return_status := FND_API.G_RET_STS_SUCCESS;
817:
818: -- Debug messages
819: Debug('At the Beginning of JOB_COMPLETION_UPDATE',l_mod_name,1);
820:

Line 822: IF NOT FND_API.Compatible_API_Call (l_api_version,

818: -- Debug messages
819: Debug('At the Beginning of JOB_COMPLETION_UPDATE',l_mod_name,1);
820:
821: -- Standard call to check for call compatibility.
822: IF NOT FND_API.Compatible_API_Call (l_api_version,
823: p_api_version,
824: l_api_name ,
825: G_PKG_NAME )
826: THEN

Line 827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

823: p_api_version,
824: l_api_name ,
825: G_PKG_NAME )
826: THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: END IF;
829:
830: -- Initialize message list if p_init_msg_list is set to TRUE.
831: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 831: IF FND_API.to_Boolean( p_init_msg_list ) THEN

827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: END IF;
829:
830: -- Initialize message list if p_init_msg_list is set to TRUE.
831: IF FND_API.to_Boolean( p_init_msg_list ) THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834:
835: -- Keep the record count

Line 973: RAISE FND_API.G_EXC_ERROR;

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;
975:
976: -- Initialize the activity rec
977: l_activity_rec := INIT_ACTIVITY_REC ;

Line 1011: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1007: x_msg_data => x_msg_data,
1008: p_activity_rec => l_activity_rec );
1009:
1010: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1011: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1012: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;
1015: l_SN_mismatch := FALSE;

Line 1013: RAISE FND_API.G_EXC_ERROR;

1009:
1010: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1011: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1012: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;
1015: l_SN_mismatch := FALSE;
1016: EXCEPTION
1017: WHEN NO_DATA_FOUND THEN

Line 1096: RAISE FND_API.G_EXC_ERROR;

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;
1098:
1099: -- Initialize the activity rec
1100: l_activity_rec := INIT_ACTIVITY_REC ;

Line 1132: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1128: x_msg_data => x_msg_data,
1129: p_activity_rec => l_activity_rec );
1130:
1131: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1132: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1133: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:

Line 1134: RAISE FND_API.G_EXC_ERROR;

1130:
1131: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1132: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1133: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:
1137:
1138: -- Initialize the activity rec

Line 1172: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1168: x_msg_data => x_msg_data,
1169: p_activity_rec => l_activity_rec );
1170:
1171: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1172: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1173: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170:
1171: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1172: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1173: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: EXCEPTION
1178: WHEN NO_DATA_FOUND THEN

Line 1228: RAISE FND_API.G_EXC_ERROR;

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;
1230:
1231: -- Initialize the activity rec
1232: l_activity_rec := INIT_ACTIVITY_REC ;

Line 1265: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1261: x_msg_data => x_msg_data,
1262: p_activity_rec => l_activity_rec );
1263:
1264: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1265: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1266: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269:

Line 1267: RAISE FND_API.G_EXC_ERROR;

1263:
1264: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1265: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1266: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269:
1270: EXCEPTION
1271: WHEN NO_DATA_FOUND THEN

Line 1281: RAISE FND_API.G_EXC_ERROR;

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;
1283: END IF;
1284:
1285: ELSE

Line 1345: RAISE FND_API.G_EXC_ERROR;

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;
1347:
1348: -- Initialize the activity rec
1349: l_activity_rec := INIT_ACTIVITY_REC ;

Line 1382: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1378: x_msg_data => x_msg_data,
1379: p_activity_rec => l_activity_rec );
1380:
1381: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1382: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1383: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386: END IF; --IF (MTL.transaction_quantity - l_total_qty)> 0

Line 1384: RAISE FND_API.G_EXC_ERROR;

1380:
1381: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1382: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1383: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386: END IF; --IF (MTL.transaction_quantity - l_total_qty)> 0
1387: END IF;-- if l_remaining_qty <=0
1388:

Line 1390: WHEN FND_API.G_EXC_ERROR THEN

1386: END IF; --IF (MTL.transaction_quantity - l_total_qty)> 0
1387: END IF;-- if l_remaining_qty <=0
1388:
1389: EXCEPTION
1390: WHEN FND_API.G_EXC_ERROR THEN
1391: RAISE FND_API.G_EXC_ERROR;
1392: END;
1393: END LOOP; -- MTL cursor
1394:

Line 1391: RAISE FND_API.G_EXC_ERROR;

1387: END IF;-- if l_remaining_qty <=0
1388:
1389: EXCEPTION
1390: WHEN FND_API.G_EXC_ERROR THEN
1391: RAISE FND_API.G_EXC_ERROR;
1392: END;
1393: END LOOP; -- MTL cursor
1394:
1395: END IF; -- end if serial_number_control_code (2,5)

Line 1401: WHEN FND_API.G_EXC_ERROR THEN

1397:
1398: -- Increment if the record is processed successfully
1399: l_total_rec := l_total_rec + 1;
1400: Exception
1401: WHEN FND_API.G_EXC_ERROR THEN
1402: ROLLBACK TO JOB_COMPLETION;
1403: --x_return_status := FND_API.G_RET_STS_ERROR ;
1404: -- In case of error, exit the loop. It could rarely fail
1405: -- rollback the current record but commit the processed records

Line 1403: --x_return_status := FND_API.G_RET_STS_ERROR ;

1399: l_total_rec := l_total_rec + 1;
1400: Exception
1401: WHEN FND_API.G_EXC_ERROR THEN
1402: ROLLBACK TO JOB_COMPLETION;
1403: --x_return_status := FND_API.G_RET_STS_ERROR ;
1404: -- In case of error, exit the loop. It could rarely fail
1405: -- rollback the current record but commit the processed records
1406: --exit;
1407: WHEN SKIP_RECORD THEN

Line 1411: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1407: WHEN SKIP_RECORD THEN
1408: NULL;
1409: WHEN OTHERS THEN
1410: ROLLBACK TO JOB_COMPLETION;
1411: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1412: -- In case of error, exit the loop. It could rarely fail
1413: -- rollback the current record but commit the processed records
1414: --exit;
1415: END;

Line 1422: IF FND_API.To_Boolean( p_commit ) THEN

1418: -- one should COMMIT less frequently within a PL/SQL loop to
1419: -- prevent ORA-1555 (Snapshot too old) errors
1420: l_count := l_count+1;
1421: IF mod(l_count, l_commit_size) = 0 THEN -- Commit every 500 records
1422: IF FND_API.To_Boolean( p_commit ) THEN
1423: COMMIT WORK;
1424: END IF;
1425: END IF;
1426:

Line 1455: IF FND_API.To_Boolean( p_commit ) THEN

1451: -- Debug message
1452: Debug(l_msg_text,l_mod_name,1 );
1453:
1454: -- Standard check of p_commit.
1455: IF FND_API.To_Boolean( p_commit ) THEN
1456: COMMIT WORK;
1457: END IF;
1458:
1459: -- Standard call to get message count and IF count is get message info.

Line 1464: WHEN FND_API.G_EXC_ERROR THEN

1460: FND_MSG_PUB.Count_And_Get
1461: (p_count => x_msg_count,
1462: p_data => x_msg_data );
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_ERROR THEN
1465: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
1466: ROLLBACK TO JOB_COMPLETION_UPDATE;
1467: x_return_status := FND_API.G_RET_STS_ERROR ;
1468: FND_MSG_PUB.Count_And_Get

Line 1465: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);

1461: (p_count => x_msg_count,
1462: p_data => x_msg_data );
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_ERROR THEN
1465: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
1466: ROLLBACK TO JOB_COMPLETION_UPDATE;
1467: x_return_status := FND_API.G_RET_STS_ERROR ;
1468: FND_MSG_PUB.Count_And_Get
1469: (p_count => x_msg_count,

Line 1467: x_return_status := FND_API.G_RET_STS_ERROR ;

1463: EXCEPTION
1464: WHEN FND_API.G_EXC_ERROR THEN
1465: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
1466: ROLLBACK TO JOB_COMPLETION_UPDATE;
1467: x_return_status := FND_API.G_RET_STS_ERROR ;
1468: FND_MSG_PUB.Count_And_Get
1469: (p_count => x_msg_count,
1470: p_data => x_msg_data );
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1467: x_return_status := FND_API.G_RET_STS_ERROR ;
1468: FND_MSG_PUB.Count_And_Get
1469: (p_count => x_msg_count,
1470: p_data => x_msg_data );
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1472: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1473: ROLLBACK TO JOB_COMPLETION_UPDATE;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1475: FND_MSG_PUB.Count_And_Get

Line 1472: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

1468: FND_MSG_PUB.Count_And_Get
1469: (p_count => x_msg_count,
1470: p_data => x_msg_data );
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1472: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1473: ROLLBACK TO JOB_COMPLETION_UPDATE;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1475: FND_MSG_PUB.Count_And_Get
1476: ( p_count => x_msg_count,

Line 1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1470: p_data => x_msg_data );
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1472: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1473: ROLLBACK TO JOB_COMPLETION_UPDATE;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1475: FND_MSG_PUB.Count_And_Get
1476: ( p_count => x_msg_count,
1477: p_data => x_msg_data );
1478: WHEN OTHERS THEN

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1477: p_data => x_msg_data );
1478: WHEN OTHERS THEN
1479: Debug('In OTHERS exception',l_mod_name,4);
1480: ROLLBACK TO JOB_COMPLETION_UPDATE;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: IF FND_MSG_PUB.Check_Msg_Level
1483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1484: THEN
1485: FND_MSG_PUB.Add_Exc_Msg

Line 1598: x_return_status := FND_API.G_RET_STS_SUCCESS;

1594: -- Standard Start of API savepoint
1595: SAVEPOINT JOB_CREATION_UPDATE;
1596:
1597: -- Initialize API return status to success
1598: x_return_status := FND_API.G_RET_STS_SUCCESS;
1599:
1600: -- Debug messages
1601: Debug('At the Beginning of JOB_CREATION_UPDATE',l_mod_name,1);
1602:

Line 1604: IF NOT FND_API.Compatible_API_Call (l_api_version,

1600: -- Debug messages
1601: Debug('At the Beginning of JOB_CREATION_UPDATE',l_mod_name,1);
1602:
1603: -- Standard call to check for call compatibility.
1604: IF NOT FND_API.Compatible_API_Call (l_api_version,
1605: p_api_version,
1606: l_api_name ,
1607: G_PKG_NAME )
1608: THEN

Line 1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1605: p_api_version,
1606: l_api_name ,
1607: G_PKG_NAME )
1608: THEN
1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1610: END IF;
1611:
1612: -- Initialize message list if p_init_msg_list is set to TRUE.
1613: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1613: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1610: END IF;
1611:
1612: -- Initialize message list if p_init_msg_list is set to TRUE.
1613: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1614: FND_MSG_PUB.initialize;
1615: END IF;
1616:
1617: -- Keeping the running total of the records

Line 1697: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1693:
1694: -- Debug Messages
1695: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
1696:
1697: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1698: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;
1701:

Line 1699: RAISE FND_API.G_EXC_ERROR;

1695: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
1696:
1697: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1698: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;
1701:
1702: -- Updating csd_repair_job_xref with the wip_entity_id
1703: Update csd_repair_job_xref

Line 1720: RAISE FND_API.G_EXC_ERROR;

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;
1722:
1723: -- Updating repair order with the Job allocated qty
1724: Update csd_repairs

Line 1741: RAISE FND_API.G_EXC_ERROR;

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;
1743:
1744: Exception
1745: WHEN FND_API.G_EXC_ERROR THEN

Line 1745: WHEN FND_API.G_EXC_ERROR THEN

1741: RAISE FND_API.G_EXC_ERROR;
1742: End IF;
1743:
1744: Exception
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: ROLLBACK TO JOB_CREATION;
1747: --x_return_status := FND_API.G_RET_STS_ERROR ;
1748: -- exit the loop in case of error. Commit the processed records
1749: -- but rollback the current error record

Line 1747: --x_return_status := FND_API.G_RET_STS_ERROR ;

1743:
1744: Exception
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: ROLLBACK TO JOB_CREATION;
1747: --x_return_status := FND_API.G_RET_STS_ERROR ;
1748: -- exit the loop in case of error. Commit the processed records
1749: -- but rollback the current error record
1750: --exit;
1751: WHEN OTHERS THEN

Line 1753: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1749: -- but rollback the current error record
1750: --exit;
1751: WHEN OTHERS THEN
1752: ROLLBACK TO JOB_CREATION;
1753: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1754: -- exit the loop in case of error. Commit the processed records
1755: -- but rollback the current error record
1756: --exit;
1757: END;

Line 1763: IF FND_API.To_Boolean( p_commit ) THEN

1759: -- one should COMMIT less frequently within a PL/SQL loop to
1760: -- prevent ORA-1555 (Snapshot too old) errors
1761: l_count := l_count+1;
1762: IF mod(l_count, l_commit_size) = 0 THEN -- Commit every 500 records
1763: IF FND_API.To_Boolean( p_commit ) THEN
1764: COMMIT WORK;
1765: END IF;
1766: END IF;
1767: END LOOP; -- End of Job Creation activity

Line 1780: IF FND_API.To_Boolean( p_commit ) THEN

1776: END IF;
1777:
1778:
1779: -- Standard check of p_commit.
1780: IF FND_API.To_Boolean( p_commit ) THEN
1781: COMMIT WORK;
1782: END IF;
1783:
1784: -- Standard call to get message count and IF count is get message info.

Line 1789: WHEN FND_API.G_EXC_ERROR THEN

1785: FND_MSG_PUB.Count_And_Get
1786: (p_count => x_msg_count,
1787: p_data => x_msg_data );
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
1791: ROLLBACK TO JOB_CREATION_UPDATE;
1792: x_return_status := FND_API.G_RET_STS_ERROR ;
1793: FND_MSG_PUB.Count_And_Get

Line 1790: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);

1786: (p_count => x_msg_count,
1787: p_data => x_msg_data );
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
1791: ROLLBACK TO JOB_CREATION_UPDATE;
1792: x_return_status := FND_API.G_RET_STS_ERROR ;
1793: FND_MSG_PUB.Count_And_Get
1794: (p_count => x_msg_count,

Line 1792: x_return_status := FND_API.G_RET_STS_ERROR ;

1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
1791: ROLLBACK TO JOB_CREATION_UPDATE;
1792: x_return_status := FND_API.G_RET_STS_ERROR ;
1793: FND_MSG_PUB.Count_And_Get
1794: (p_count => x_msg_count,
1795: p_data => x_msg_data );
1796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1792: x_return_status := FND_API.G_RET_STS_ERROR ;
1793: FND_MSG_PUB.Count_And_Get
1794: (p_count => x_msg_count,
1795: p_data => x_msg_data );
1796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1797: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1798: ROLLBACK TO JOB_CREATION_UPDATE;
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1800: FND_MSG_PUB.Count_And_Get

Line 1797: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

1793: FND_MSG_PUB.Count_And_Get
1794: (p_count => x_msg_count,
1795: p_data => x_msg_data );
1796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1797: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1798: ROLLBACK TO JOB_CREATION_UPDATE;
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1800: FND_MSG_PUB.Count_And_Get
1801: ( p_count => x_msg_count,

Line 1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1795: p_data => x_msg_data );
1796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1797: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1798: ROLLBACK TO JOB_CREATION_UPDATE;
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1800: FND_MSG_PUB.Count_And_Get
1801: ( p_count => x_msg_count,
1802: p_data => x_msg_data );
1803: WHEN OTHERS THEN

Line 1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1802: p_data => x_msg_data );
1803: WHEN OTHERS THEN
1804: Debug('In OTHERS exception',l_mod_name,4);
1805: ROLLBACK TO JOB_CREATION_UPDATE;
1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1807: IF FND_MSG_PUB.Check_Msg_Level
1808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1809: THEN
1810: FND_MSG_PUB.Add_Exc_Msg

Line 1874: x_return_status := FND_API.G_RET_STS_SUCCESS;

1870: -- Standard Start of API savepoint
1871: SAVEPOINT RECEIPTS_UPDATE;
1872:
1873: -- Initialize API return status to success
1874: x_return_status := FND_API.G_RET_STS_SUCCESS;
1875:
1876: -- Log the api name in the log file
1877: Debug('At the Beginning of Receipts_update',l_mod_name,1);
1878: Debug('p_internal_order_flag ='||p_internal_order_flag,l_mod_name,1);

Line 1883: IF NOT FND_API.Compatible_API_Call (l_api_version,

1879: Debug('p_order_header_id ='||p_order_header_id,l_mod_name,1);
1880: Debug('p_repair_line_id ='||p_repair_line_id,l_mod_name,1);
1881:
1882: -- Standard call to check for call compatibility.
1883: IF NOT FND_API.Compatible_API_Call (l_api_version,
1884: p_api_version,
1885: l_api_name ,
1886: G_PKG_NAME )
1887: THEN

Line 1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1884: p_api_version,
1885: l_api_name ,
1886: G_PKG_NAME )
1887: THEN
1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1889: END IF;
1890:
1891: -- Initialize message list if p_init_msg_list is set to TRUE.
1892: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1892: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1889: END IF;
1890:
1891: -- Initialize message list if p_init_msg_list is set to TRUE.
1892: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1893: FND_MSG_PUB.initialize;
1894: END IF;
1895:
1896: -- Api body starts

Line 1914: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1910: p_order_header_id => p_order_header_id );
1911:
1912: -- Debug messages
1913: Debug('Return Status from IO_SHIP_UPDATE API :'||x_return_status,l_mod_name,2);
1914: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1915: Debug('IO_SHIP_UPDATE failed',l_mod_name,4);
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF;
1918:

Line 1916: RAISE FND_API.G_EXC_ERROR;

1912: -- Debug messages
1913: Debug('Return Status from IO_SHIP_UPDATE API :'||x_return_status,l_mod_name,2);
1914: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1915: Debug('IO_SHIP_UPDATE failed',l_mod_name,4);
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF;
1918:
1919: Debug('Calling IO_RCV_UPDATE API',l_mod_name,2);
1920: -- Call the api for processing the receipt against

Line 1934: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1930: p_order_header_id => p_order_header_id );
1931:
1932: -- Debug messages
1933: Debug('Return Status from IO_RCV_UPDATE API :'||x_return_status,l_mod_name,2);
1934: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1935: Debug('IO_RCV_UPDATE failed',l_mod_name,4);
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;
1938: Else

Line 1936: RAISE FND_API.G_EXC_ERROR;

1932: -- Debug messages
1933: Debug('Return Status from IO_RCV_UPDATE API :'||x_return_status,l_mod_name,2);
1934: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1935: Debug('IO_RCV_UPDATE failed',l_mod_name,4);
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;
1938: Else
1939: -- Debug messages
1940: Debug('Calling RMA_RCV_UPDATE API',l_mod_name,2);

Line 1955: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1951: p_past_num_of_days => p_past_num_of_days);
1952:
1953: -- Debug messages
1954: Debug('Return Status from RMA_RCV_UPDATE API :'||x_return_status,l_mod_name,2);
1955: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1956: Debug('RMA_RCV_UPDATE failed',l_mod_name,4);
1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;
1959: End If;

Line 1957: RAISE FND_API.G_EXC_ERROR;

1953: -- Debug messages
1954: Debug('Return Status from RMA_RCV_UPDATE API :'||x_return_status,l_mod_name,2);
1955: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1956: Debug('RMA_RCV_UPDATE failed',l_mod_name,4);
1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;
1959: End If;
1960: -- bug#7497790, 12.1 FP, subhat.
1961: -- automatically update RO status when item is received.

Line 1962: -- dont show any error messages. Pass p_validation_level = fnd_api.g_valid_level_full to receive messages.

1958: END IF;
1959: End If;
1960: -- bug#7497790, 12.1 FP, subhat.
1961: -- automatically update RO status when item is received.
1962: -- dont show any error messages. Pass p_validation_level = fnd_api.g_valid_level_full to receive messages.
1963: csd_repairs_util.auto_update_ro_status(
1964: p_api_version => 1,
1965: p_commit => p_commit,
1966: p_init_msg_list => p_init_msg_list,

Line 1972: p_validation_level => fnd_api.g_valid_level_none);

1968: x_return_status => x_return_status,
1969: x_msg_count => x_msg_count,
1970: x_msg_data => x_msg_data,
1971: p_event => 'RECEIVE',
1972: p_validation_level => fnd_api.g_valid_level_none);
1973: -- end bug#7497790, 12.1 FP, subhat.
1974:
1975: -- Standard check of p_commit.
1976: IF FND_API.To_Boolean( p_commit ) THEN

Line 1976: IF FND_API.To_Boolean( p_commit ) THEN

1972: p_validation_level => fnd_api.g_valid_level_none);
1973: -- end bug#7497790, 12.1 FP, subhat.
1974:
1975: -- Standard check of p_commit.
1976: IF FND_API.To_Boolean( p_commit ) THEN
1977: COMMIT WORK;
1978: END IF;
1979:
1980: -- Standard call to get message count and IF count is get message info.

Line 1985: WHEN FND_API.G_EXC_ERROR THEN

1981: FND_MSG_PUB.Count_And_Get
1982: (p_count => x_msg_count,
1983: p_data => x_msg_data );
1984: EXCEPTION
1985: WHEN FND_API.G_EXC_ERROR THEN
1986: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
1987: -- As we are committing the processed records in the inner APIs
1988: -- so we rollback only if the p_commit='F'
1989: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 1986: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );

1982: (p_count => x_msg_count,
1983: p_data => x_msg_data );
1984: EXCEPTION
1985: WHEN FND_API.G_EXC_ERROR THEN
1986: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
1987: -- As we are committing the processed records in the inner APIs
1988: -- so we rollback only if the p_commit='F'
1989: IF NOT(FND_API.To_Boolean( p_commit )) THEN
1990: ROLLBACK TO RECEIPTS_UPDATE;

Line 1989: IF NOT(FND_API.To_Boolean( p_commit )) THEN

1985: WHEN FND_API.G_EXC_ERROR THEN
1986: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
1987: -- As we are committing the processed records in the inner APIs
1988: -- so we rollback only if the p_commit='F'
1989: IF NOT(FND_API.To_Boolean( p_commit )) THEN
1990: ROLLBACK TO RECEIPTS_UPDATE;
1991: END IF;
1992: x_return_status := FND_API.G_RET_STS_ERROR ;
1993: FND_MSG_PUB.Count_And_Get

Line 1992: x_return_status := FND_API.G_RET_STS_ERROR ;

1988: -- so we rollback only if the p_commit='F'
1989: IF NOT(FND_API.To_Boolean( p_commit )) THEN
1990: ROLLBACK TO RECEIPTS_UPDATE;
1991: END IF;
1992: x_return_status := FND_API.G_RET_STS_ERROR ;
1993: FND_MSG_PUB.Count_And_Get
1994: (p_count => x_msg_count,
1995: p_data => x_msg_data );
1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1992: x_return_status := FND_API.G_RET_STS_ERROR ;
1993: FND_MSG_PUB.Count_And_Get
1994: (p_count => x_msg_count,
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);

Line 1997: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );

1993: FND_MSG_PUB.Count_And_Get
1994: (p_count => x_msg_count,
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);

Line 2006: IF NOT(FND_API.To_Boolean( p_commit )) THEN

2002: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2003: END If;
2004: -- As we are committing the processed records in the inner APIs
2005: -- so we rollback only if the p_commit='F'
2006: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2007: ROLLBACK TO RECEIPTS_UPDATE;
2008: END IF;
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2010: FND_MSG_PUB.Count_And_Get

Line 2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2005: -- so we rollback only if the p_commit='F'
2006: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2007: ROLLBACK TO RECEIPTS_UPDATE;
2008: END IF;
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2010: FND_MSG_PUB.Count_And_Get
2011: ( p_count => x_msg_count,
2012: p_data => x_msg_data );
2013: WHEN OTHERS THEN

Line 2023: IF NOT(FND_API.To_Boolean( p_commit )) THEN

2019: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2020: END If;
2021: -- As we are committing the processed records in the inner APIs
2022: -- so we rollback only if the p_commit='F'
2023: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2024: ROLLBACK TO RECEIPTS_UPDATE;
2025: END IF;
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2027: IF FND_MSG_PUB.Check_Msg_Level

Line 2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2022: -- so we rollback only if the p_commit='F'
2023: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2024: ROLLBACK TO RECEIPTS_UPDATE;
2025: END IF;
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2027: IF FND_MSG_PUB.Check_Msg_Level
2028: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2029: THEN
2030: FND_MSG_PUB.Add_Exc_Msg

Line 2369: x_return_status := FND_API.G_RET_STS_SUCCESS;

2365: -- Standard Start of API savepoint
2366: SAVEPOINT RMA_RCV_UPDATE;
2367:
2368: -- Initialize API return status to success
2369: x_return_status := FND_API.G_RET_STS_SUCCESS;
2370:
2371: -- Debug messages
2372: Debug('At the Beginning of RMA_RCV_UPDATE',l_mod_name,1);
2373: Debug('Repair Line Id ='||to_char(p_repair_line_id),l_mod_name,1);

Line 2376: IF NOT FND_API.Compatible_API_Call (l_api_version,

2372: Debug('At the Beginning of RMA_RCV_UPDATE',l_mod_name,1);
2373: Debug('Repair Line Id ='||to_char(p_repair_line_id),l_mod_name,1);
2374:
2375: -- Standard call to check for call compatibility.
2376: IF NOT FND_API.Compatible_API_Call (l_api_version,
2377: p_api_version,
2378: l_api_name ,
2379: G_PKG_NAME )
2380: THEN

Line 2381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2377: p_api_version,
2378: l_api_name ,
2379: G_PKG_NAME )
2380: THEN
2381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2382: END IF;
2383:
2384: -- Initialize message list if p_init_msg_list is set to TRUE.
2385: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2385: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2382: END IF;
2383:
2384: -- Initialize message list if p_init_msg_list is set to TRUE.
2385: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2386: FND_MSG_PUB.initialize;
2387: END IF;
2388:
2389: -- Api body starts

Line 2395: RAISE FND_API.G_EXC_ERROR;

2391: -- Validate the repair line id
2392: -- bugfix 4423818 : We need to validate only if p_repair_line_id is NOT NULL
2393: IF(p_repair_line_id is NOT NULL ) THEN
2394: IF NOT(csd_process_util.validate_rep_line_id(p_repair_line_id)) THEN
2395: RAISE FND_API.G_EXC_ERROR;
2396: END IF;
2397: END IF;
2398:
2399: -- Assign the number of processed records in this variable

Line 2526: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2522: p_activity_rec => l_activity_rec );
2523:
2524: -- Debug Messages
2525: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2526: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2527: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2528: RAISE FND_API.G_EXC_ERROR;
2529: END IF;
2530:

Line 2528: RAISE FND_API.G_EXC_ERROR;

2524: -- Debug Messages
2525: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2526: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2527: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2528: RAISE FND_API.G_EXC_ERROR;
2529: END IF;
2530:
2531: ELSIF I.transaction_type = 'REJECT' then
2532: -- Log activities for the reject transactions

Line 2573: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2569: p_activity_rec => l_activity_rec );
2570:
2571: -- Debug Messages
2572: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2573: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2574: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2575: RAISE FND_API.G_EXC_ERROR;
2576: END IF;
2577:

Line 2575: RAISE FND_API.G_EXC_ERROR;

2571: -- Debug Messages
2572: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2573: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2574: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2575: RAISE FND_API.G_EXC_ERROR;
2576: END IF;
2577:
2578: ElSIF I.transaction_type = 'DELIVER' then
2579: --Log activities for the deliver transaction

Line 2612: RAISE FND_API.G_EXC_ERROR;

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
2614: Debug('In Others exception',l_mod_name,4);
2615: RAISE FND_API.G_EXC_ERROR;
2616: End;

Line 2615: RAISE FND_API.G_EXC_ERROR;

2611: END IF;
2612: RAISE FND_API.G_EXC_ERROR;
2613: When others then
2614: Debug('In Others exception',l_mod_name,4);
2615: RAISE FND_API.G_EXC_ERROR;
2616: End;
2617:
2618: Debug('Serial Num Ctl Code ='||TO_CHAR(l_srl_ctl_code),l_mod_name,1);
2619: Debug('Lot Ctl Code ='||TO_CHAR(l_lot_ctl_code),l_mod_name,1);

Line 2639: RAISE FND_API.G_EXC_ERROR;

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;
2641: -- Close the cursor
2642: If rcv_txn_serial_num %isopen then
2643: close rcv_txn_serial_num ;

Line 2670: RAISE FND_API.G_EXC_ERROR;

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);
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');

Line 2682: RAISE FND_API.G_EXC_ERROR;

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);
2684: END;
2685: ELSE
2686: l_instance_id := NULL;

Line 2731: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2727: p_activity_rec => l_activity_rec );
2728:
2729: -- Debug Messages
2730: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2731: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2732: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735: End IF;

Line 2733: RAISE FND_API.G_EXC_ERROR;

2729: -- Debug Messages
2730: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2731: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2732: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735: End IF;
2736:
2737: ELSE

Line 2766: RAISE FND_API.G_EXC_ERROR;

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;
2768: ELSE
2769: l_lot_number := NULL;
2770: END IF;

Line 2791: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2787: ,p_from_quantity => i.received_quantity
2788: ,x_result_quantity => l_result_quantity);
2789:
2790: Debug('Return Status from CONVERT_TO_RO_UOM '||x_return_status,l_mod_name,2);
2791: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2792: Debug('CONVERT_TO_RO_UOM failed ',l_mod_name,4);
2793: RAISE FND_API.G_EXC_ERROR;
2794: END IF;
2795: Else

Line 2793: RAISE FND_API.G_EXC_ERROR;

2789:
2790: Debug('Return Status from CONVERT_TO_RO_UOM '||x_return_status,l_mod_name,2);
2791: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2792: Debug('CONVERT_TO_RO_UOM failed ',l_mod_name,4);
2793: RAISE FND_API.G_EXC_ERROR;
2794: END IF;
2795: Else
2796: l_result_quantity := NVL(i.received_quantity,0);
2797: END IF;

Line 2826: RAISE FND_API.G_EXC_ERROR;

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;
2828:
2829: ELSE
2830: -- Update the qty if the item on ro

Line 2849: RAISE FND_API.G_EXC_ERROR;

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;
2851:
2852: END IF;
2853: End If;

Line 2885: RAISE FND_API.G_EXC_ERROR;

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;
2887:
2888: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2889: fnd_message.set_token('RMA_NO',i.rma_number);

Line 2936: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2932: p_activity_rec => l_activity_rec );
2933:
2934: -- Debug Messages
2935: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2936: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2937: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2938: RAISE FND_API.G_EXC_ERROR;
2939: END IF;
2940: END IF;

Line 2938: RAISE FND_API.G_EXC_ERROR;

2934: -- Debug Messages
2935: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2936: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2937: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2938: RAISE FND_API.G_EXC_ERROR;
2939: END IF;
2940: END IF;
2941:
2942: -- Commit for every 500 records

Line 2947: IF FND_API.To_Boolean( p_commit ) THEN

2943: -- one should COMMIT less frequently within a PL/SQL loop to
2944: -- prevent ORA-1555 (Snapshot too old) errors
2945: l_total_records := l_total_records + 1;
2946: IF mod(l_total_records, l_commit_size) = 0 THEN -- Commit every 500 records
2947: IF FND_API.To_Boolean( p_commit ) THEN
2948: COMMIT WORK;
2949: END IF;
2950: END IF;
2951: EXCEPTION

Line 2952: WHEN FND_API.G_EXC_ERROR THEN

2948: COMMIT WORK;
2949: END IF;
2950: END IF;
2951: EXCEPTION
2952: WHEN FND_API.G_EXC_ERROR THEN
2953: ROLLBACK TO RECEIPT_LINES;
2954: x_return_status := FND_API.G_RET_STS_ERROR ;
2955: EXIT;
2956: -- In case of error, exit the loop. Commit the processed records

Line 2954: x_return_status := FND_API.G_RET_STS_ERROR ;

2950: END IF;
2951: EXCEPTION
2952: WHEN FND_API.G_EXC_ERROR THEN
2953: ROLLBACK TO RECEIPT_LINES;
2954: x_return_status := FND_API.G_RET_STS_ERROR ;
2955: EXIT;
2956: -- In case of error, exit the loop. Commit the processed records
2957: -- and rollback the error record
2958: -- RAISE FND_API.G_EXC_ERROR;

Line 2958: -- RAISE FND_API.G_EXC_ERROR;

2954: x_return_status := FND_API.G_RET_STS_ERROR ;
2955: EXIT;
2956: -- In case of error, exit the loop. Commit the processed records
2957: -- and rollback the error record
2958: -- RAISE FND_API.G_EXC_ERROR;
2959: WHEN SKIP_RECORD THEN
2960: NULL;
2961: END;
2962: END LOOP;

Line 3008: IF FND_API.To_Boolean( p_commit ) THEN

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;
3010: END IF;
3011:
3012: -- Standard call to get message count and IF count is get message info.

Line 3017: WHEN FND_API.G_EXC_ERROR THEN

3013: FND_MSG_PUB.Count_And_Get
3014: (p_count => x_msg_count,
3015: p_data => x_msg_data );
3016: EXCEPTION
3017: WHEN FND_API.G_EXC_ERROR THEN
3018: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
3019: ROLLBACK TO RMA_RCV_UPDATE;
3020: x_return_status := FND_API.G_RET_STS_ERROR ;
3021: FND_MSG_PUB.Count_And_Get

Line 3018: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );

3014: (p_count => x_msg_count,
3015: p_data => x_msg_data );
3016: EXCEPTION
3017: WHEN FND_API.G_EXC_ERROR THEN
3018: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
3019: ROLLBACK TO RMA_RCV_UPDATE;
3020: x_return_status := FND_API.G_RET_STS_ERROR ;
3021: FND_MSG_PUB.Count_And_Get
3022: (p_count => x_msg_count,

Line 3020: x_return_status := FND_API.G_RET_STS_ERROR ;

3016: EXCEPTION
3017: WHEN FND_API.G_EXC_ERROR THEN
3018: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
3019: ROLLBACK TO RMA_RCV_UPDATE;
3020: x_return_status := FND_API.G_RET_STS_ERROR ;
3021: FND_MSG_PUB.Count_And_Get
3022: (p_count => x_msg_count,
3023: p_data => x_msg_data );
3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3020: x_return_status := FND_API.G_RET_STS_ERROR ;
3021: FND_MSG_PUB.Count_And_Get
3022: (p_count => x_msg_count,
3023: p_data => x_msg_data );
3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3025: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
3026: ROLLBACK TO RMA_RCV_UPDATE;
3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3028: FND_MSG_PUB.Count_And_Get

Line 3025: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );

3021: FND_MSG_PUB.Count_And_Get
3022: (p_count => x_msg_count,
3023: p_data => x_msg_data );
3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3025: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
3026: ROLLBACK TO RMA_RCV_UPDATE;
3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3028: FND_MSG_PUB.Count_And_Get
3029: ( p_count => x_msg_count,

Line 3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3023: p_data => x_msg_data );
3024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3025: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
3026: ROLLBACK TO RMA_RCV_UPDATE;
3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3028: FND_MSG_PUB.Count_And_Get
3029: ( p_count => x_msg_count,
3030: p_data => x_msg_data );
3031: WHEN OTHERS THEN

Line 3034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3030: p_data => x_msg_data );
3031: WHEN OTHERS THEN
3032: Debug('In OTHERS exception',l_mod_name,4 );
3033: ROLLBACK TO RMA_RCV_UPDATE;
3034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3035: IF FND_MSG_PUB.Check_Msg_Level
3036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3037: THEN
3038: FND_MSG_PUB.Add_Exc_Msg

Line 3263: x_return_status := FND_API.G_RET_STS_SUCCESS;

3259: -- Standard Start of API savepoint
3260: SAVEPOINT IO_RCV_UPDATE;
3261:
3262: -- Initialize API return status to success
3263: x_return_status := FND_API.G_RET_STS_SUCCESS;
3264:
3265: -- Debug messages
3266: Debug('Beginning of IO_RCV_UPDATE',l_mod_name,1);
3267: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);

Line 3270: IF NOT FND_API.Compatible_API_Call (l_api_version,

3266: Debug('Beginning of IO_RCV_UPDATE',l_mod_name,1);
3267: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);
3268:
3269: -- Standard call to check for call compatibility.
3270: IF NOT FND_API.Compatible_API_Call (l_api_version,
3271: p_api_version,
3272: l_api_name ,
3273: G_PKG_NAME )
3274: THEN

Line 3275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3271: p_api_version,
3272: l_api_name ,
3273: G_PKG_NAME )
3274: THEN
3275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3276: END IF;
3277:
3278: -- Initialize message list if p_init_msg_list is set to TRUE.
3279: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3279: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3276: END IF;
3277:
3278: -- Initialize message list if p_init_msg_list is set to TRUE.
3279: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3280: FND_MSG_PUB.initialize;
3281: END IF;
3282:
3283: -- Api body starts

Line 3312: RAISE FND_API.G_EXC_ERROR;

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;
3314: END IF;
3315:
3316:

Line 3478: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3474: p_activity_rec => l_activity_rec );
3475:
3476: -- Debug Messages
3477: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3478: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3479: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3480: RAISE FND_API.G_EXC_ERROR;
3481: END IF;
3482:

Line 3480: RAISE FND_API.G_EXC_ERROR;

3476: -- Debug Messages
3477: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3478: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3479: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3480: RAISE FND_API.G_EXC_ERROR;
3481: END IF;
3482:
3483: -- Check if there are "DELIVER" txn lines against the accept lines
3484: -- If found, then process the deliver lines also

Line 3604: RAISE FND_API.G_EXC_ERROR;

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;
3606: ELSE
3607: l_lot_num := NULL;
3608: END IF;

Line 3740: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3736: p_activity_rec => l_activity_rec );
3737:
3738: -- Debug Messages
3739: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3740: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3741: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3742: RAISE FND_API.G_EXC_ERROR;
3743: END IF;
3744:

Line 3742: RAISE FND_API.G_EXC_ERROR;

3738: -- Debug Messages
3739: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3740: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3741: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3742: RAISE FND_API.G_EXC_ERROR;
3743: END IF;
3744:
3745: IF (l_pt_del_qty + l_rcvd_qty) >= l_line_del_qty THEN
3746: Debug(' Exiting the DEL loop',l_mod_name,1);

Line 3846: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3842: p_activity_rec => l_activity_rec );
3843:
3844: -- Debug Messages
3845: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3846: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3847: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3848: RAISE FND_API.G_EXC_ERROR;
3849: END IF;
3850:

Line 3848: RAISE FND_API.G_EXC_ERROR;

3844: -- Debug Messages
3845: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3846: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3847: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3848: RAISE FND_API.G_EXC_ERROR;
3849: END IF;
3850:
3851: -- Check if there are "DELIVER" txn lines against the reject lines
3852: -- If found, then process the deliver lines also

Line 3972: RAISE FND_API.G_EXC_ERROR;

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;
3974: ELSE
3975: l_lot_num := NULL;
3976: END IF;

Line 4110: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4106: p_activity_rec => l_activity_rec );
4107:
4108: -- Debug Messages
4109: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4110: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4111: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
4112: RAISE FND_API.G_EXC_ERROR;
4113: END IF;
4114:

Line 4112: RAISE FND_API.G_EXC_ERROR;

4108: -- Debug Messages
4109: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4110: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4111: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
4112: RAISE FND_API.G_EXC_ERROR;
4113: END IF;
4114:
4115: IF (l_pt_del_qty + l_rcvd_qty) >= l_line_del_qty THEN
4116: Debug(' Exiting the DEL loop',l_mod_name,1);

Line 4247: RAISE FND_API.G_EXC_ERROR;

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;
4249: ELSE
4250: -- Non-Serialized Case but not lot controlled
4251: l_lot_num := NULL;

Line 4381: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4377: p_activity_rec => l_activity_rec );
4378:
4379: -- Debug Messages
4380: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4381: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4382: Debug('LOG_ACTIVITY api failed ',l_mod_name,1);
4383: RAISE FND_API.G_EXC_ERROR;
4384: END IF;
4385:

Line 4383: RAISE FND_API.G_EXC_ERROR;

4379: -- Debug Messages
4380: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4381: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4382: Debug('LOG_ACTIVITY api failed ',l_mod_name,1);
4383: RAISE FND_API.G_EXC_ERROR;
4384: END IF;
4385:
4386: IF l_pt_del_qty+ l_rcvd_qty >= l_line_qty THEN
4387: Debug(' exiting the RCV loop',l_mod_name,1);

Line 4405: --RAISE FND_API.G_EXC_ERROR;

4401: ROLLBACK TO RCV_LINES;
4402: Debug(' In Process error exception, exiting the loop',l_mod_name,1);
4403: -- In case of error, exit the loop. Commit the processed records
4404: -- and rollback the error record
4405: --RAISE FND_API.G_EXC_ERROR;
4406: x_return_status := FND_API.G_RET_STS_ERROR ;
4407: EXIT;
4408: END;
4409: END LOOP;

Line 4406: x_return_status := FND_API.G_RET_STS_ERROR ;

4402: Debug(' In Process error exception, exiting the loop',l_mod_name,1);
4403: -- In case of error, exit the loop. Commit the processed records
4404: -- and rollback the error record
4405: --RAISE FND_API.G_EXC_ERROR;
4406: x_return_status := FND_API.G_RET_STS_ERROR ;
4407: EXIT;
4408: END;
4409: END LOOP;
4410:

Line 4421: IF FND_API.To_Boolean( p_commit ) THEN

4417: END IF;
4418:
4419:
4420: -- Standard check of p_commit.
4421: IF FND_API.To_Boolean( p_commit ) THEN
4422: COMMIT WORK;
4423: END IF;
4424:
4425: -- Standard call to get message count and IF count is get message info.

Line 4430: WHEN FND_API.G_EXC_ERROR THEN

4426: FND_MSG_PUB.Count_And_Get
4427: (p_count => x_msg_count,
4428: p_data => x_msg_data);
4429: EXCEPTION
4430: WHEN FND_API.G_EXC_ERROR THEN
4431: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
4432: ROLLBACK TO IO_RCV_UPDATE;
4433: x_return_status := FND_API.G_RET_STS_ERROR ;
4434: FND_MSG_PUB.Count_And_Get

Line 4431: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);

4427: (p_count => x_msg_count,
4428: p_data => x_msg_data);
4429: EXCEPTION
4430: WHEN FND_API.G_EXC_ERROR THEN
4431: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
4432: ROLLBACK TO IO_RCV_UPDATE;
4433: x_return_status := FND_API.G_RET_STS_ERROR ;
4434: FND_MSG_PUB.Count_And_Get
4435: (p_count => x_msg_count,

Line 4433: x_return_status := FND_API.G_RET_STS_ERROR ;

4429: EXCEPTION
4430: WHEN FND_API.G_EXC_ERROR THEN
4431: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
4432: ROLLBACK TO IO_RCV_UPDATE;
4433: x_return_status := FND_API.G_RET_STS_ERROR ;
4434: FND_MSG_PUB.Count_And_Get
4435: (p_count => x_msg_count,
4436: p_data => x_msg_data );
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4433: x_return_status := FND_API.G_RET_STS_ERROR ;
4434: FND_MSG_PUB.Count_And_Get
4435: (p_count => x_msg_count,
4436: p_data => x_msg_data );
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
4439: ROLLBACK TO IO_RCV_UPDATE;
4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4441: FND_MSG_PUB.Count_And_Get

Line 4438: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

4434: FND_MSG_PUB.Count_And_Get
4435: (p_count => x_msg_count,
4436: p_data => x_msg_data );
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
4439: ROLLBACK TO IO_RCV_UPDATE;
4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4441: FND_MSG_PUB.Count_And_Get
4442: ( p_count => x_msg_count,

Line 4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4436: p_data => x_msg_data );
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
4439: ROLLBACK TO IO_RCV_UPDATE;
4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4441: FND_MSG_PUB.Count_And_Get
4442: ( p_count => x_msg_count,
4443: p_data => x_msg_data );
4444: WHEN OTHERS THEN

Line 4447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4443: p_data => x_msg_data );
4444: WHEN OTHERS THEN
4445: Debug('In OTHERS exception',l_mod_name,4);
4446: ROLLBACK TO IO_RCV_UPDATE;
4447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4448: IF FND_MSG_PUB.Check_Msg_Level
4449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4450: THEN
4451: FND_MSG_PUB.Add_Exc_Msg

Line 4679: x_return_status := FND_API.G_RET_STS_SUCCESS;

4675: -- Standard Start of API savepoint
4676: SAVEPOINT IO_RCV_UPDATE_MOVE_OUT;
4677:
4678: -- Initialize API return status to success
4679: x_return_status := FND_API.G_RET_STS_SUCCESS;
4680:
4681: -- Debug messages
4682: Debug('Beginning of IO_RCV_UPDATE_MOVE_OUT',l_mod_name,1);
4683: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);

Line 4686: IF NOT FND_API.Compatible_API_Call (l_api_version,

4682: Debug('Beginning of IO_RCV_UPDATE_MOVE_OUT',l_mod_name,1);
4683: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);
4684:
4685: -- Standard call to check for call compatibility.
4686: IF NOT FND_API.Compatible_API_Call (l_api_version,
4687: p_api_version,
4688: l_api_name ,
4689: G_PKG_NAME )
4690: THEN

Line 4691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4687: p_api_version,
4688: l_api_name ,
4689: G_PKG_NAME )
4690: THEN
4691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4692: END IF;
4693:
4694: -- Initialize message list if p_init_msg_list is set to TRUE.
4695: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4695: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4692: END IF;
4693:
4694: -- Initialize message list if p_init_msg_list is set to TRUE.
4695: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4696: FND_MSG_PUB.initialize;
4697: END IF;
4698:
4699: -- Api body starts

Line 4728: RAISE FND_API.G_EXC_ERROR;

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;
4730: END IF;
4731:
4732:

Line 4894: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4890: p_activity_rec => l_activity_rec );
4891:
4892: -- Debug Messages
4893: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4894: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4895: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
4896: RAISE FND_API.G_EXC_ERROR;
4897: END IF;
4898:

Line 4896: RAISE FND_API.G_EXC_ERROR;

4892: -- Debug Messages
4893: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4894: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4895: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
4896: RAISE FND_API.G_EXC_ERROR;
4897: END IF;
4898:
4899: -- Check if there are "DELIVER" txn lines against the accept lines
4900: -- If found, then process the deliver lines also

Line 5020: RAISE FND_API.G_EXC_ERROR;

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;
5022: ELSE
5023: l_lot_num := NULL;
5024: END IF;

Line 5161: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5157: p_activity_rec => l_activity_rec );
5158:
5159: -- Debug Messages
5160: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5161: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5162: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5163: RAISE FND_API.G_EXC_ERROR;
5164: END IF;
5165:

Line 5163: RAISE FND_API.G_EXC_ERROR;

5159: -- Debug Messages
5160: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5161: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5162: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5163: RAISE FND_API.G_EXC_ERROR;
5164: END IF;
5165:
5166: IF (l_pt_del_qty + l_rcvd_qty) >= l_line_del_qty THEN
5167: Debug(' Exiting the DEL loop',l_mod_name,1);

Line 5267: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5263: p_activity_rec => l_activity_rec );
5264:
5265: -- Debug Messages
5266: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5267: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5268: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5269: RAISE FND_API.G_EXC_ERROR;
5270: END IF;
5271:

Line 5269: RAISE FND_API.G_EXC_ERROR;

5265: -- Debug Messages
5266: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5267: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5268: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5269: RAISE FND_API.G_EXC_ERROR;
5270: END IF;
5271:
5272: -- Check if there are "DELIVER" txn lines against the reject lines
5273: -- If found, then process the deliver lines also

Line 5393: RAISE FND_API.G_EXC_ERROR;

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;
5395: ELSE
5396: l_lot_num := NULL;
5397: END IF;

Line 5536: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5532: p_activity_rec => l_activity_rec );
5533:
5534: -- Debug Messages
5535: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5536: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5537: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5538: RAISE FND_API.G_EXC_ERROR;
5539: END IF;
5540:

Line 5538: RAISE FND_API.G_EXC_ERROR;

5534: -- Debug Messages
5535: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5536: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5537: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5538: RAISE FND_API.G_EXC_ERROR;
5539: END IF;
5540:
5541: IF (l_pt_del_qty + l_rcvd_qty) >= l_line_del_qty THEN
5542: Debug(' Exiting the DEL loop',l_mod_name,1);

Line 5681: RAISE FND_API.G_EXC_ERROR;

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;
5683: ELSE
5684: -- Non-Serialized Case but not lot controlled
5685: l_lot_num := NULL;

Line 5820: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5816: p_activity_rec => l_activity_rec );
5817:
5818: -- Debug Messages
5819: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5820: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5821: Debug('LOG_ACTIVITY api failed ',l_mod_name,1);
5822: RAISE FND_API.G_EXC_ERROR;
5823: END IF;
5824:

Line 5822: RAISE FND_API.G_EXC_ERROR;

5818: -- Debug Messages
5819: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5820: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5821: Debug('LOG_ACTIVITY api failed ',l_mod_name,1);
5822: RAISE FND_API.G_EXC_ERROR;
5823: END IF;
5824:
5825: IF l_pt_del_qty+ l_rcvd_qty >= l_line_qty THEN
5826: Debug(' exiting the RCV loop',l_mod_name,1);

Line 5844: --RAISE FND_API.G_EXC_ERROR;

5840: ROLLBACK TO RCV_LINES;
5841: Debug(' In Process error exception, exiting the loop',l_mod_name,1);
5842: -- In case of error, exit the loop. Commit the processed records
5843: -- and rollback the error record
5844: --RAISE FND_API.G_EXC_ERROR;
5845: x_return_status := FND_API.G_RET_STS_ERROR ;
5846: EXIT;
5847: END;
5848: END LOOP;

Line 5845: x_return_status := FND_API.G_RET_STS_ERROR ;

5841: Debug(' In Process error exception, exiting the loop',l_mod_name,1);
5842: -- In case of error, exit the loop. Commit the processed records
5843: -- and rollback the error record
5844: --RAISE FND_API.G_EXC_ERROR;
5845: x_return_status := FND_API.G_RET_STS_ERROR ;
5846: EXIT;
5847: END;
5848: END LOOP;
5849:

Line 5860: IF FND_API.To_Boolean( p_commit ) THEN

5856: END IF;
5857:
5858:
5859: -- Standard check of p_commit.
5860: IF FND_API.To_Boolean( p_commit ) THEN
5861: COMMIT WORK;
5862: END IF;
5863:
5864: -- Standard call to get message count and IF count is get message info.

Line 5869: WHEN FND_API.G_EXC_ERROR THEN

5865: FND_MSG_PUB.Count_And_Get
5866: (p_count => x_msg_count,
5867: p_data => x_msg_data);
5868: EXCEPTION
5869: WHEN FND_API.G_EXC_ERROR THEN
5870: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
5871: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5872: x_return_status := FND_API.G_RET_STS_ERROR ;
5873: FND_MSG_PUB.Count_And_Get

Line 5870: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);

5866: (p_count => x_msg_count,
5867: p_data => x_msg_data);
5868: EXCEPTION
5869: WHEN FND_API.G_EXC_ERROR THEN
5870: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
5871: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5872: x_return_status := FND_API.G_RET_STS_ERROR ;
5873: FND_MSG_PUB.Count_And_Get
5874: (p_count => x_msg_count,

Line 5872: x_return_status := FND_API.G_RET_STS_ERROR ;

5868: EXCEPTION
5869: WHEN FND_API.G_EXC_ERROR THEN
5870: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
5871: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5872: x_return_status := FND_API.G_RET_STS_ERROR ;
5873: FND_MSG_PUB.Count_And_Get
5874: (p_count => x_msg_count,
5875: p_data => x_msg_data );
5876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5872: x_return_status := FND_API.G_RET_STS_ERROR ;
5873: FND_MSG_PUB.Count_And_Get
5874: (p_count => x_msg_count,
5875: p_data => x_msg_data );
5876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5877: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
5878: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5880: FND_MSG_PUB.Count_And_Get

Line 5877: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

5873: FND_MSG_PUB.Count_And_Get
5874: (p_count => x_msg_count,
5875: p_data => x_msg_data );
5876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5877: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
5878: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5880: FND_MSG_PUB.Count_And_Get
5881: ( p_count => x_msg_count,

Line 5879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5875: p_data => x_msg_data );
5876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5877: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
5878: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5880: FND_MSG_PUB.Count_And_Get
5881: ( p_count => x_msg_count,
5882: p_data => x_msg_data );
5883: WHEN OTHERS THEN

Line 5886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5882: p_data => x_msg_data );
5883: WHEN OTHERS THEN
5884: Debug('In OTHERS exception',l_mod_name,4);
5885: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
5886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5887: IF FND_MSG_PUB.Check_Msg_Level
5888: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5889: THEN
5890: FND_MSG_PUB.Add_Exc_Msg

Line 5955: x_return_status := FND_API.G_RET_STS_SUCCESS;

5951: -- Standard Start of API savepoint
5952: SAVEPOINT SHIP_UPDATE;
5953:
5954: -- Initialize API return status to success
5955: x_return_status := FND_API.G_RET_STS_SUCCESS;
5956:
5957: -- Log the api name in the log file
5958: Debug('At the Beginning of shipment Update ',l_mod_name,1);
5959: Debug('p_internal_order_flag ='||p_internal_order_flag,l_mod_name,1);

Line 5964: IF NOT FND_API.Compatible_API_Call (l_api_version,

5960: Debug('p_order_header_id ='||p_order_header_id,l_mod_name,1);
5961: Debug('p_repair_line_id ='||p_repair_line_id,l_mod_name,1);
5962:
5963: -- Standard call to check for call compatibility.
5964: IF NOT FND_API.Compatible_API_Call (l_api_version,
5965: p_api_version,
5966: l_api_name ,
5967: G_PKG_NAME )
5968: THEN

Line 5969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5965: p_api_version,
5966: l_api_name ,
5967: G_PKG_NAME )
5968: THEN
5969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5970: END IF;
5971:
5972: -- Initialize message list if p_init_msg_list is set to TRUE.
5973: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 5973: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5970: END IF;
5971:
5972: -- Initialize message list if p_init_msg_list is set to TRUE.
5973: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5974: FND_MSG_PUB.initialize;
5975: END IF;
5976:
5977: -- Api body starts

Line 5992: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5988: x_msg_data => x_msg_data ,
5989: p_order_header_id => p_order_header_id);
5990:
5991: Debug('Return status from IO_SHIP_UPDATE '||x_return_status,l_mod_name,2);
5992: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5993: Debug('IO_SHIP_UPDATE failed ',l_mod_name,4);
5994: RAISE FND_API.G_EXC_ERROR;
5995: END IF;
5996:

Line 5994: RAISE FND_API.G_EXC_ERROR;

5990:
5991: Debug('Return status from IO_SHIP_UPDATE '||x_return_status,l_mod_name,2);
5992: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5993: Debug('IO_SHIP_UPDATE failed ',l_mod_name,4);
5994: RAISE FND_API.G_EXC_ERROR;
5995: END IF;
5996:
5997: /*Fixed for bug#5564180/FP#5845995
5998: Call to API IO_RCV_UPDATE_MOVE_OUT is added so that

Line 6017: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6013: p_order_header_id => p_order_header_id );
6014:
6015: -- Debug messages
6016: Debug('Return Status from IO_RCV_UPDATE_MOVE_OUT :'||x_return_status,l_mod_name,2);
6017: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6018: Debug('IO_RCV_UPDATE_MOVE_OUT failed',l_mod_name,4);
6019: RAISE FND_API.G_EXC_ERROR;
6020: END IF;
6021:

Line 6019: RAISE FND_API.G_EXC_ERROR;

6015: -- Debug messages
6016: Debug('Return Status from IO_RCV_UPDATE_MOVE_OUT :'||x_return_status,l_mod_name,2);
6017: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6018: Debug('IO_RCV_UPDATE_MOVE_OUT failed',l_mod_name,4);
6019: RAISE FND_API.G_EXC_ERROR;
6020: END IF;
6021:
6022:
6023: Else

Line 6038: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6034: p_repair_line_id => p_repair_line_id,
6035: p_past_num_of_days => p_past_num_of_days);
6036:
6037: Debug('Return status from SO_SHIP_UPDATE '||x_return_status,l_mod_name,2);
6038: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6039: Debug('SO_SHIP_UPDATE failed ',l_mod_name,4);
6040: RAISE FND_API.G_EXC_ERROR;
6041: END IF;
6042: End If;

Line 6040: RAISE FND_API.G_EXC_ERROR;

6036:
6037: Debug('Return status from SO_SHIP_UPDATE '||x_return_status,l_mod_name,2);
6038: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6039: Debug('SO_SHIP_UPDATE failed ',l_mod_name,4);
6040: RAISE FND_API.G_EXC_ERROR;
6041: END IF;
6042: End If;
6043:
6044: -- Standard check of p_commit.

Line 6045: IF FND_API.To_Boolean( p_commit ) THEN

6041: END IF;
6042: End If;
6043:
6044: -- Standard check of p_commit.
6045: IF FND_API.To_Boolean( p_commit ) THEN
6046: COMMIT WORK;
6047: END IF;
6048:
6049: -- Standard call to get message count and IF count is get message info.

Line 6054: WHEN FND_API.G_EXC_ERROR THEN

6050: FND_MSG_PUB.Count_And_Get
6051: (p_count => x_msg_count,
6052: p_data => x_msg_data );
6053: EXCEPTION
6054: WHEN FND_API.G_EXC_ERROR THEN
6055: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
6056: -- As we commit the processed records in the inner APIs
6057: -- so we rollback only if the p_commit= 'F'
6058: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 6055: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

6051: (p_count => x_msg_count,
6052: p_data => x_msg_data );
6053: EXCEPTION
6054: WHEN FND_API.G_EXC_ERROR THEN
6055: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
6056: -- As we commit the processed records in the inner APIs
6057: -- so we rollback only if the p_commit= 'F'
6058: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6059: ROLLBACK TO SHIP_UPDATE;

Line 6058: IF NOT(FND_API.To_Boolean( p_commit )) THEN

6054: WHEN FND_API.G_EXC_ERROR THEN
6055: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
6056: -- As we commit the processed records in the inner APIs
6057: -- so we rollback only if the p_commit= 'F'
6058: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6059: ROLLBACK TO SHIP_UPDATE;
6060: END IF;
6061: x_return_status := FND_API.G_RET_STS_ERROR ;
6062: FND_MSG_PUB.Count_And_Get

Line 6061: x_return_status := FND_API.G_RET_STS_ERROR ;

6057: -- so we rollback only if the p_commit= 'F'
6058: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6059: ROLLBACK TO SHIP_UPDATE;
6060: END IF;
6061: x_return_status := FND_API.G_RET_STS_ERROR ;
6062: FND_MSG_PUB.Count_And_Get
6063: (p_count => x_msg_count,
6064: p_data => x_msg_data );
6065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6061: x_return_status := FND_API.G_RET_STS_ERROR ;
6062: FND_MSG_PUB.Count_And_Get
6063: (p_count => x_msg_count,
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);

Line 6066: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);

6062: FND_MSG_PUB.Count_And_Get
6063: (p_count => x_msg_count,
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);

Line 6075: IF NOT(FND_API.To_Boolean( p_commit )) THEN

6071: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6072: END If;
6073: -- As we commit the processed records in the inner APIs
6074: -- so we rollback only if the p_commit= 'F'
6075: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6076: ROLLBACK TO SHIP_UPDATE;
6077: END IF;
6078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6079: FND_MSG_PUB.Count_And_Get

Line 6078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6074: -- so we rollback only if the p_commit= 'F'
6075: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6076: ROLLBACK TO SHIP_UPDATE;
6077: END IF;
6078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6079: FND_MSG_PUB.Count_And_Get
6080: ( p_count => x_msg_count,
6081: p_data => x_msg_data );
6082: WHEN OTHERS THEN

Line 6092: IF NOT(FND_API.To_Boolean( p_commit )) THEN

6088: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6089: END If;
6090: -- As we commit the processed records in the inner APIs
6091: -- so we rollback only if the p_commit= 'F'
6092: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6093: ROLLBACK TO SHIP_UPDATE;
6094: END IF;
6095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6096: IF FND_MSG_PUB.Check_Msg_Level

Line 6095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6091: -- so we rollback only if the p_commit= 'F'
6092: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6093: ROLLBACK TO SHIP_UPDATE;
6094: END IF;
6095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6096: IF FND_MSG_PUB.Check_Msg_Level
6097: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6098: THEN
6099: FND_MSG_PUB.Add_Exc_Msg

Line 6437: x_return_status := FND_API.G_RET_STS_SUCCESS;

6433: -- Standard Start of API savepoint
6434: SAVEPOINT SO_SHIP_UPDATE;
6435:
6436: -- Initialize API return status to success
6437: x_return_status := FND_API.G_RET_STS_SUCCESS;
6438:
6439: -- Debug messages
6440: Debug('At the Beginning of ship Update ',l_mod_name,1);
6441: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);

Line 6444: IF NOT FND_API.Compatible_API_Call (l_api_version,

6440: Debug('At the Beginning of ship Update ',l_mod_name,1);
6441: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);
6442:
6443: -- Standard call to check for call compatibility.
6444: IF NOT FND_API.Compatible_API_Call (l_api_version,
6445: p_api_version,
6446: l_api_name ,
6447: G_PKG_NAME )
6448: THEN

Line 6449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6445: p_api_version,
6446: l_api_name ,
6447: G_PKG_NAME )
6448: THEN
6449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6450: END IF;
6451:
6452: -- Initialize message list if p_init_msg_list is set to TRUE.
6453: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 6453: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6450: END IF;
6451:
6452: -- Initialize message list if p_init_msg_list is set to TRUE.
6453: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6454: FND_MSG_PUB.initialize;
6455: END IF;
6456:
6457: -- Api body starts

Line 6463: RAISE FND_API.G_EXC_ERROR;

6459: -- Validate the repair line id
6460: -- bugfix 4423818 : We need to validate only if p_repair_line_id is NOT NULL
6461: IF(p_repair_line_id is NOT NULL ) THEN
6462: IF NOT(csd_process_util.validate_rep_line_id(p_repair_line_id)) THEN
6463: RAISE FND_API.G_EXC_ERROR;
6464: END IF;
6465: END IF;
6466:
6467: --Bug#6779806

Line 6591: RAISE FND_API.G_EXC_ERROR;

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;
6593:
6594: IF l_srl_ctl_code in (2,5,6) THEN
6595: Debug('Item is Serialized',l_mod_name,1);

Line 6641: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6637: p_activity_rec => l_activity_rec );
6638:
6639: -- Debug Messages
6640: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
6641: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6642: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
6643: RAISE FND_API.G_EXC_ERROR;
6644: END IF;
6645:

Line 6643: RAISE FND_API.G_EXC_ERROR;

6639: -- Debug Messages
6640: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
6641: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6642: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
6643: RAISE FND_API.G_EXC_ERROR;
6644: END IF;
6645:
6646: END IF; -- end of serial number mismatch
6647:

Line 6667: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6663: ,x_result_quantity => l_result_ship_qty);
6664:
6665: -- Debug messages
6666: Debug('Return Status from CONVERT_TO_RO_uom :'||x_return_status,l_mod_name,2);
6667: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6668: Debug('CONVERT_TO_RO_uom api failed ',l_mod_name,4);
6669: RAISE FND_API.G_EXC_ERROR;
6670: END IF;
6671: ELSE

Line 6669: RAISE FND_API.G_EXC_ERROR;

6665: -- Debug messages
6666: Debug('Return Status from CONVERT_TO_RO_uom :'||x_return_status,l_mod_name,2);
6667: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6668: Debug('CONVERT_TO_RO_uom api failed ',l_mod_name,4);
6669: RAISE FND_API.G_EXC_ERROR;
6670: END IF;
6671: ELSE
6672: l_result_ship_qty := I.shipped_quantity;
6673: END IF;

Line 6695: RAISE FND_API.G_EXC_ERROR;

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;
6697: END IF;
6698:
6699:

Line 6730: RAISE FND_API.G_EXC_ERROR;

6726: Correct message name CSD_INSTANCE_MISSING is used instead of
6727: CSD_INV_INSTANCE_ID.
6728: */
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);

Line 6744: RAISE FND_API.G_EXC_ERROR;

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:
6747: --bug#6779806
6748: ELSIF (nvl(l_ib_flag,'N') = 'Y') THEN

Line 6785: RAISE FND_API.G_EXC_ERROR;

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;
6787:
6788: -- Updating the product txn with the status
6789: -- if the line qty is fully rcvd

Line 6847: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6843: p_activity_rec => l_activity_rec );
6844:
6845: -- Debug Messages
6846: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
6847: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6848: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
6849: RAISE FND_API.G_EXC_ERROR;
6850: END IF;
6851:

Line 6849: RAISE FND_API.G_EXC_ERROR;

6845: -- Debug Messages
6846: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
6847: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6848: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
6849: RAISE FND_API.G_EXC_ERROR;
6850: END IF;
6851:
6852: END IF;
6853:

Line 6857: WHEN FND_API.G_EXC_ERROR THEN

6853:
6854: End if; --end If (I.date_shipped is not null) --bug#7285024
6855:
6856: EXCEPTION
6857: WHEN FND_API.G_EXC_ERROR THEN
6858: Debug('In FND_API.G_EXC_ERROR EXCEPTION',l_mod_name,4);
6859: ROLLBACK TO SHIPMENT_LINES;
6860: -- In case of error, exit the loop. Commit the processed records
6861: -- and rollback the error record

Line 6858: Debug('In FND_API.G_EXC_ERROR EXCEPTION',l_mod_name,4);

6854: End if; --end If (I.date_shipped is not null) --bug#7285024
6855:
6856: EXCEPTION
6857: WHEN FND_API.G_EXC_ERROR THEN
6858: Debug('In FND_API.G_EXC_ERROR EXCEPTION',l_mod_name,4);
6859: ROLLBACK TO SHIPMENT_LINES;
6860: -- In case of error, exit the loop. Commit the processed records
6861: -- and rollback the error record
6862: --RAISE FND_API.G_EXC_ERROR;

Line 6862: --RAISE FND_API.G_EXC_ERROR;

6858: Debug('In FND_API.G_EXC_ERROR EXCEPTION',l_mod_name,4);
6859: ROLLBACK TO SHIPMENT_LINES;
6860: -- In case of error, exit the loop. Commit the processed records
6861: -- and rollback the error record
6862: --RAISE FND_API.G_EXC_ERROR;
6863: x_return_status := FND_API.G_RET_STS_ERROR ;
6864: EXIT;
6865: END;
6866: -- Commit for every 500 records

Line 6863: x_return_status := FND_API.G_RET_STS_ERROR ;

6859: ROLLBACK TO SHIPMENT_LINES;
6860: -- In case of error, exit the loop. Commit the processed records
6861: -- and rollback the error record
6862: --RAISE FND_API.G_EXC_ERROR;
6863: x_return_status := FND_API.G_RET_STS_ERROR ;
6864: EXIT;
6865: END;
6866: -- Commit for every 500 records
6867: -- one should COMMIT less frequently within a PL/SQL loop to

Line 6871: IF FND_API.To_Boolean( p_commit ) THEN

6867: -- one should COMMIT less frequently within a PL/SQL loop to
6868: -- prevent ORA-1555 (Snapshot too old) errors
6869: l_total_records := l_total_records + 1;
6870: IF mod(l_total_records, l_commit_size) = 0 THEN -- Commit every 500 records
6871: IF FND_API.To_Boolean( p_commit ) THEN
6872: COMMIT WORK;
6873: END IF;
6874: END IF;
6875: END LOOP;

Line 6915: IF FND_API.To_Boolean( p_commit ) THEN

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;
6917: END IF;
6918:
6919: -- Standard call to get message count and IF count is get message info.

Line 6925: WHEN FND_API.G_EXC_ERROR THEN

6921: (p_count => x_msg_count,
6922: p_data => x_msg_data);
6923:
6924: EXCEPTION
6925: WHEN FND_API.G_EXC_ERROR THEN
6926: Debug('FND_API.G_EXC_ERROR Exception',l_mod_name,4);
6927: ROLLBACK TO SO_SHIP_UPDATE;
6928: x_return_status := FND_API.G_RET_STS_ERROR ;
6929: FND_MSG_PUB.Count_And_Get

Line 6926: Debug('FND_API.G_EXC_ERROR Exception',l_mod_name,4);

6922: p_data => x_msg_data);
6923:
6924: EXCEPTION
6925: WHEN FND_API.G_EXC_ERROR THEN
6926: Debug('FND_API.G_EXC_ERROR Exception',l_mod_name,4);
6927: ROLLBACK TO SO_SHIP_UPDATE;
6928: x_return_status := FND_API.G_RET_STS_ERROR ;
6929: FND_MSG_PUB.Count_And_Get
6930: (p_count => x_msg_count,

Line 6928: x_return_status := FND_API.G_RET_STS_ERROR ;

6924: EXCEPTION
6925: WHEN FND_API.G_EXC_ERROR THEN
6926: Debug('FND_API.G_EXC_ERROR Exception',l_mod_name,4);
6927: ROLLBACK TO SO_SHIP_UPDATE;
6928: x_return_status := FND_API.G_RET_STS_ERROR ;
6929: FND_MSG_PUB.Count_And_Get
6930: (p_count => x_msg_count,
6931: p_data => x_msg_data );
6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6928: x_return_status := FND_API.G_RET_STS_ERROR ;
6929: FND_MSG_PUB.Count_And_Get
6930: (p_count => x_msg_count,
6931: p_data => x_msg_data );
6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6933: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
6934: ROLLBACK TO SO_SHIP_UPDATE;
6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6936: FND_MSG_PUB.Count_And_Get

Line 6933: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);

6929: FND_MSG_PUB.Count_And_Get
6930: (p_count => x_msg_count,
6931: p_data => x_msg_data );
6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6933: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
6934: ROLLBACK TO SO_SHIP_UPDATE;
6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6936: FND_MSG_PUB.Count_And_Get
6937: ( p_count => x_msg_count,

Line 6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6931: p_data => x_msg_data );
6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6933: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
6934: ROLLBACK TO SO_SHIP_UPDATE;
6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6936: FND_MSG_PUB.Count_And_Get
6937: ( p_count => x_msg_count,
6938: p_data => x_msg_data );
6939: WHEN OTHERS THEN

Line 6942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6938: p_data => x_msg_data );
6939: WHEN OTHERS THEN
6940: Debug('OTHERS Exception',l_mod_name,4);
6941: ROLLBACK TO SO_SHIP_UPDATE;
6942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6943: IF FND_MSG_PUB.Check_Msg_Level
6944: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6945: THEN
6946: FND_MSG_PUB.Add_Exc_Msg

Line 7204: x_return_status := FND_API.G_RET_STS_SUCCESS;

7200: -- Standard Start of API savepoint
7201: SAVEPOINT IO_SHIP_UPDATE;
7202:
7203: -- Initialize API return status to success
7204: x_return_status := FND_API.G_RET_STS_SUCCESS;
7205:
7206: Debug('At the Beginning of IO_SHIP_UPDATE',l_mod_name,1 );
7207: Debug('Order Header Id ='||p_order_header_id,l_mod_name,1);
7208:

Line 7210: IF NOT FND_API.Compatible_API_Call (l_api_version,

7206: Debug('At the Beginning of IO_SHIP_UPDATE',l_mod_name,1 );
7207: Debug('Order Header Id ='||p_order_header_id,l_mod_name,1);
7208:
7209: -- Standard call to check for call compatibility.
7210: IF NOT FND_API.Compatible_API_Call (l_api_version,
7211: p_api_version,
7212: l_api_name ,
7213: G_PKG_NAME )
7214: THEN

Line 7215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7211: p_api_version,
7212: l_api_name ,
7213: G_PKG_NAME )
7214: THEN
7215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7216: END IF;
7217:
7218: -- Initialize message list if p_init_msg_list is set to TRUE.
7219: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 7219: IF FND_API.to_Boolean( p_init_msg_list ) THEN

7215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7216: END IF;
7217:
7218: -- Initialize message list if p_init_msg_list is set to TRUE.
7219: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7220: FND_MSG_PUB.initialize;
7221: END IF;
7222:
7223: -- Api body starts

Line 7250: RAISE FND_API.G_EXC_ERROR;

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;
7252: END IF;
7253:
7254: --FOR DEL in DELIVERY_LINES(p_order_header_id)

Line 7299: RAISE FND_API.G_EXC_ERROR;

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;
7301:
7302: -- Debug messages
7303: Debug('l_action_type ='||l_action_type,l_mod_name,1);

Line 7873: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

7869:
7870: -- Debug Messages
7871: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
7872:
7873: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7874: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
7875: RAISE FND_API.G_EXC_ERROR;
7876: END IF;
7877:

Line 7875: RAISE FND_API.G_EXC_ERROR;

7871: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
7872:
7873: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7874: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
7875: RAISE FND_API.G_EXC_ERROR;
7876: END IF;
7877:
7878: END IF; -- end of del.released_status in ('c','i')
7879:

Line 8151: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8147: p_activity_rec => l_activity_rec );
8148:
8149: -- Debug Messages
8150: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8151: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8152: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8153: RAISE FND_API.G_EXC_ERROR;
8154: END IF;
8155:

Line 8153: RAISE FND_API.G_EXC_ERROR;

8149: -- Debug Messages
8150: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8151: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8152: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8153: RAISE FND_API.G_EXC_ERROR;
8154: END IF;
8155:
8156: EXCEPTION
8157: WHEN PROCESS_ERROR THEN

Line 8159: RAISE FND_API.G_EXC_ERROR;

8155:
8156: EXCEPTION
8157: WHEN PROCESS_ERROR THEN
8158: Debug('Encountered PROCESS_ERROR exception in UT cursor',l_mod_name,1);
8159: RAISE FND_API.G_EXC_ERROR;
8160: WHEN SKIP_RECORD THEN
8161: Debug('Skipping record in UT cursor',l_mod_name,1);
8162: NULL;
8163: END;

Line 8407: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8403: p_activity_rec => l_activity_rec );
8404:
8405: -- Debug Messages
8406: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8407: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8408: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8409: RAISE FND_API.G_EXC_ERROR;
8410: END IF;
8411:

Line 8409: RAISE FND_API.G_EXC_ERROR;

8405: -- Debug Messages
8406: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8407: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8408: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8409: RAISE FND_API.G_EXC_ERROR;
8410: END IF;
8411:
8412: EXCEPTION
8413: WHEN PROCESS_ERROR THEN

Line 8415: RAISE FND_API.G_EXC_ERROR;

8411:
8412: EXCEPTION
8413: WHEN PROCESS_ERROR THEN
8414: Debug('Encountered PROCESS_ERROR exception in UT cursor',l_mod_name,1);
8415: RAISE FND_API.G_EXC_ERROR;
8416: WHEN SKIP_RECORD THEN
8417: Debug('Skipping record in UT cursor',l_mod_name,1);
8418: NULL;
8419: END;

Line 8431: RAISE FND_API.G_EXC_ERROR;

8427:
8428: EXCEPTION
8429: WHEN PROCESS_ERROR THEN
8430: Debug('Encountered PROCESS_ERROR exception in DELUT cursor',l_mod_name,1);
8431: RAISE FND_API.G_EXC_ERROR;
8432: WHEN SKIP_RECORD THEN
8433: NULL;
8434: WHEN OTHERS THEN
8435: Debug('Encountered OTHERS in DEL cursor',l_mod_name,1);

Line 8436: RAISE FND_API.G_EXC_ERROR;

8432: WHEN SKIP_RECORD THEN
8433: NULL;
8434: WHEN OTHERS THEN
8435: Debug('Encountered OTHERS in DEL cursor',l_mod_name,1);
8436: RAISE FND_API.G_EXC_ERROR;
8437: END;
8438: END LOOP;
8439:
8440: IF(DELIVERY_LINES_ALL%ISOPEN ) THEN

Line 8449: IF FND_API.To_Boolean( p_commit ) THEN

8445: END IF;
8446:
8447:
8448: -- Standard check of p_commit.
8449: IF FND_API.To_Boolean( p_commit ) THEN
8450: COMMIT WORK;
8451: END IF;
8452:
8453: -- Standard call to get message count and IF count is get message info.

Line 8459: WHEN FND_API.G_EXC_ERROR THEN

8455: (p_count => x_msg_count,
8456: p_data => x_msg_data);
8457:
8458: EXCEPTION
8459: WHEN FND_API.G_EXC_ERROR THEN
8460: ROLLBACK TO IO_SHIP_UPDATE;
8461: x_return_status := FND_API.G_RET_STS_ERROR ;
8462: FND_MSG_PUB.Count_And_Get
8463: (p_count => x_msg_count,

Line 8461: x_return_status := FND_API.G_RET_STS_ERROR ;

8457:
8458: EXCEPTION
8459: WHEN FND_API.G_EXC_ERROR THEN
8460: ROLLBACK TO IO_SHIP_UPDATE;
8461: x_return_status := FND_API.G_RET_STS_ERROR ;
8462: FND_MSG_PUB.Count_And_Get
8463: (p_count => x_msg_count,
8464: p_data => x_msg_data );
8465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8461: x_return_status := FND_API.G_RET_STS_ERROR ;
8462: FND_MSG_PUB.Count_And_Get
8463: (p_count => x_msg_count,
8464: p_data => x_msg_data );
8465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8466: ROLLBACK TO IO_SHIP_UPDATE;
8467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8468: FND_MSG_PUB.Count_And_Get
8469: ( p_count => x_msg_count,

Line 8467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8463: (p_count => x_msg_count,
8464: p_data => x_msg_data );
8465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8466: ROLLBACK TO IO_SHIP_UPDATE;
8467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8468: FND_MSG_PUB.Count_And_Get
8469: ( p_count => x_msg_count,
8470: p_data => x_msg_data );
8471: WHEN OTHERS THEN

Line 8473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8469: ( p_count => x_msg_count,
8470: p_data => x_msg_data );
8471: WHEN OTHERS THEN
8472: ROLLBACK TO IO_SHIP_UPDATE;
8473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8474: IF FND_MSG_PUB.Check_Msg_Level
8475: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8476: THEN
8477: FND_MSG_PUB.Add_Exc_Msg

Line 8542: x_return_status := FND_API.G_RET_STS_SUCCESS;

8538: -- Standard Start of API savepoint
8539: SAVEPOINT WIP_UPDATE;
8540:
8541: -- Initialize API return status to success
8542: x_return_status := FND_API.G_RET_STS_SUCCESS;
8543:
8544: -- Debug Messages
8545: Debug('At the Beginning of Wip_update ',l_mod_name,1);
8546: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);

Line 8549: IF NOT FND_API.Compatible_API_Call (l_api_version,

8545: Debug('At the Beginning of Wip_update ',l_mod_name,1);
8546: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);
8547:
8548: -- Standard call to check for call compatibility.
8549: IF NOT FND_API.Compatible_API_Call (l_api_version,
8550: p_api_version,
8551: l_api_name ,
8552: G_PKG_NAME )
8553: THEN

Line 8554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8550: p_api_version,
8551: l_api_name ,
8552: G_PKG_NAME )
8553: THEN
8554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8555: END IF;
8556:
8557: -- Initialize message list if p_init_msg_list is set to TRUE.
8558: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 8558: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8555: END IF;
8556:
8557: -- Initialize message list if p_init_msg_list is set to TRUE.
8558: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8559: FND_MSG_PUB.initialize;
8560: END IF;
8561:
8562: -- Api body starts

Line 8568: RAISE FND_API.G_EXC_ERROR;

8564: -- Validate the repair line id
8565: IF p_repair_line_id is not null THEN
8566: IF NOT(csd_process_util.validate_rep_line_id(p_repair_line_id)) THEN
8567: Debug('Validate_rep_line_id failed',l_mod_name,1);
8568: RAISE FND_API.G_EXC_ERROR;
8569: END IF;
8570: END IF;
8571:
8572: -- Debug messages

Line 8588: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8584:
8585: -- Debug messages
8586: Debug('Return Status from JOB_CREATION_UPDATE :'||x_return_status,l_mod_name,2);
8587:
8588: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8589: -- Debug messages
8590: Debug(' JOB_CREATION_UPDATE failed ',l_mod_name,4);
8591: RAISE FND_API.G_EXC_ERROR;
8592: END IF;

Line 8591: RAISE FND_API.G_EXC_ERROR;

8587:
8588: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8589: -- Debug messages
8590: Debug(' JOB_CREATION_UPDATE failed ',l_mod_name,4);
8591: RAISE FND_API.G_EXC_ERROR;
8592: END IF;
8593:
8594: IF NVL(p_upd_job_completion,'Y') = 'Y' THEN
8595: -- Only if the update_job_completion is 'Y', then

Line 8614: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8610:
8611: -- Debug messages
8612: Debug('Return Status from JOB_COMPLETION_UPDATE :'||x_return_status,l_mod_name,2);
8613:
8614: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8615: -- Debug messages
8616: Debug(' JOB_COMPLETION_UPDATE failed ',l_mod_name,4);
8617: RAISE FND_API.G_EXC_ERROR;
8618: END IF;

Line 8617: RAISE FND_API.G_EXC_ERROR;

8613:
8614: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8615: -- Debug messages
8616: Debug(' JOB_COMPLETION_UPDATE failed ',l_mod_name,4);
8617: RAISE FND_API.G_EXC_ERROR;
8618: END IF;
8619: END IF;
8620:
8621: -- Standard check of p_commit.

Line 8622: IF FND_API.To_Boolean( p_commit ) THEN

8618: END IF;
8619: END IF;
8620:
8621: -- Standard check of p_commit.
8622: IF FND_API.To_Boolean( p_commit ) THEN
8623: COMMIT WORK;
8624: END IF;
8625:
8626: -- Standard call to get message count and IF count is get message info.

Line 8631: WHEN FND_API.G_EXC_ERROR THEN

8627: FND_MSG_PUB.Count_And_Get
8628: (p_count => x_msg_count,
8629: p_data => x_msg_data);
8630: EXCEPTION
8631: WHEN FND_API.G_EXC_ERROR THEN
8632: Debug('In FND_API.G_EXC_ERROR Exception',l_mod_name,4);
8633: -- As we commit the processed records in the inner APIs
8634: -- so we rollback only if the p_commit = 'F'
8635: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 8632: Debug('In FND_API.G_EXC_ERROR Exception',l_mod_name,4);

8628: (p_count => x_msg_count,
8629: p_data => x_msg_data);
8630: EXCEPTION
8631: WHEN FND_API.G_EXC_ERROR THEN
8632: Debug('In FND_API.G_EXC_ERROR Exception',l_mod_name,4);
8633: -- As we commit the processed records in the inner APIs
8634: -- so we rollback only if the p_commit = 'F'
8635: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8636: ROLLBACK TO WIP_UPDATE;

Line 8635: IF NOT(FND_API.To_Boolean( p_commit )) THEN

8631: WHEN FND_API.G_EXC_ERROR THEN
8632: Debug('In FND_API.G_EXC_ERROR Exception',l_mod_name,4);
8633: -- As we commit the processed records in the inner APIs
8634: -- so we rollback only if the p_commit = 'F'
8635: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8636: ROLLBACK TO WIP_UPDATE;
8637: END IF;
8638: x_return_status := FND_API.G_RET_STS_ERROR ;
8639: FND_MSG_PUB.Count_And_Get

Line 8638: x_return_status := FND_API.G_RET_STS_ERROR ;

8634: -- so we rollback only if the p_commit = 'F'
8635: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8636: ROLLBACK TO WIP_UPDATE;
8637: END IF;
8638: x_return_status := FND_API.G_RET_STS_ERROR ;
8639: FND_MSG_PUB.Count_And_Get
8640: (p_count => x_msg_count,
8641: p_data => x_msg_data );
8642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8638: x_return_status := FND_API.G_RET_STS_ERROR ;
8639: FND_MSG_PUB.Count_And_Get
8640: (p_count => x_msg_count,
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);

Line 8643: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);

8639: FND_MSG_PUB.Count_And_Get
8640: (p_count => x_msg_count,
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);

Line 8652: IF NOT(FND_API.To_Boolean( p_commit )) THEN

8648: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8649: END If;
8650: -- As we commit the processed records in the inner APIs
8651: -- so we rollback only if the p_commit = 'F'
8652: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8653: ROLLBACK TO WIP_UPDATE;
8654: END IF;
8655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8656: FND_MSG_PUB.Count_And_Get

Line 8655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8651: -- so we rollback only if the p_commit = 'F'
8652: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8653: ROLLBACK TO WIP_UPDATE;
8654: END IF;
8655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8656: FND_MSG_PUB.Count_And_Get
8657: ( p_count => x_msg_count,
8658: p_data => x_msg_data );
8659: WHEN OTHERS THEN

Line 8669: IF NOT(FND_API.To_Boolean( p_commit )) THEN

8665: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8666: END If;
8667: -- As we commit the processed records in the inner APIs
8668: -- so we rollback only if the p_commit = 'F'
8669: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8670: ROLLBACK TO WIP_UPDATE;
8671: END IF;
8672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8673: IF FND_MSG_PUB.Check_Msg_Level

Line 8672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8668: -- so we rollback only if the p_commit = 'F'
8669: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8670: ROLLBACK TO WIP_UPDATE;
8671: END IF;
8672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8673: IF FND_MSG_PUB.Check_Msg_Level
8674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8675: THEN
8676: FND_MSG_PUB.Add_Exc_Msg

Line 8740: l_return_status := FND_API.G_RET_STS_SUCCESS;

8736: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update_conc_prog';
8737:
8738: BEGIN
8739: -- Initialize API return status to success
8740: l_return_status := FND_API.G_RET_STS_SUCCESS;
8741:
8742: -- Initialize the error code and error buffer
8743: retcode := l_success_status;
8744: errbuf := '';

Line 8761: p_commit => FND_API.G_TRUE,

8757:
8758: -- Api body starts
8759: RECEIPTS_UPDATE
8760: ( p_api_version => l_api_version,
8761: p_commit => FND_API.G_TRUE,
8762: p_init_msg_list => FND_API.G_TRUE,
8763: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8764: x_return_status => l_return_status,
8765: x_msg_count => l_msg_count,

Line 8762: p_init_msg_list => FND_API.G_TRUE,

8758: -- Api body starts
8759: RECEIPTS_UPDATE
8760: ( p_api_version => l_api_version,
8761: p_commit => FND_API.G_TRUE,
8762: p_init_msg_list => FND_API.G_TRUE,
8763: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8764: x_return_status => l_return_status,
8765: x_msg_count => l_msg_count,
8766: x_msg_data => l_msg_data,

Line 8763: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

8759: RECEIPTS_UPDATE
8760: ( p_api_version => l_api_version,
8761: p_commit => FND_API.G_TRUE,
8762: p_init_msg_list => FND_API.G_TRUE,
8763: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8764: x_return_status => l_return_status,
8765: x_msg_count => l_msg_count,
8766: x_msg_data => l_msg_data,
8767: p_internal_order_flag => l_internal_order_flag,

Line 8775: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8771:
8772: -- Debug messages
8773: Debug('Return Status from RECEIPTS_UPDATE :'||l_return_status,l_mod_name,2);
8774:
8775: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8776: -- Concatenate the message from the message stack
8777: IF l_msg_count > 1 then
8778: FOR i IN 1..l_msg_count LOOP
8779: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

Line 8779: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

8775: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8776: -- Concatenate the message from the message stack
8777: IF l_msg_count > 1 then
8778: FOR i IN 1..l_msg_count LOOP
8779: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8780: END LOOP ;
8781: END IF ;
8782: Debug(l_msg_data,l_mod_name,4);
8783: RAISE FND_API.G_EXC_ERROR;

Line 8783: RAISE FND_API.G_EXC_ERROR;

8779: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8780: END LOOP ;
8781: END IF ;
8782: Debug(l_msg_data,l_mod_name,4);
8783: RAISE FND_API.G_EXC_ERROR;
8784: END IF;
8785: Exception
8786: WHEN FND_API.G_EXC_ERROR THEN
8787: retcode := l_error_status;

Line 8786: WHEN FND_API.G_EXC_ERROR THEN

8782: Debug(l_msg_data,l_mod_name,4);
8783: RAISE FND_API.G_EXC_ERROR;
8784: END IF;
8785: Exception
8786: WHEN FND_API.G_EXC_ERROR THEN
8787: retcode := l_error_status;
8788: errbuf := l_msg_data;
8789: WHEN Others then
8790: -- Handle others exception

Line 8843: l_return_status := FND_API.G_RET_STS_SUCCESS;

8839: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.wip_update_conc_prog';
8840:
8841: BEGIN
8842: -- Initialize API return status to success
8843: l_return_status := FND_API.G_RET_STS_SUCCESS;
8844:
8845: -- Initialize the error buffer and error code
8846: retcode := l_success_status;
8847: errbuf := '';

Line 8862: p_commit => FND_API.G_TRUE,

8858: -- then send the repair line Id. Else it will take all the
8859: -- unprocessed repair orders
8860: WIP_UPDATE
8861: ( p_api_version => l_api_version,
8862: p_commit => FND_API.G_TRUE,
8863: p_init_msg_list => FND_API.G_TRUE,
8864: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8865: x_return_status => l_return_status,
8866: x_msg_count => l_msg_count,

Line 8863: p_init_msg_list => FND_API.G_TRUE,

8859: -- unprocessed repair orders
8860: WIP_UPDATE
8861: ( p_api_version => l_api_version,
8862: p_commit => FND_API.G_TRUE,
8863: p_init_msg_list => FND_API.G_TRUE,
8864: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8865: x_return_status => l_return_status,
8866: x_msg_count => l_msg_count,
8867: x_msg_data => l_msg_data,

Line 8864: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

8860: WIP_UPDATE
8861: ( p_api_version => l_api_version,
8862: p_commit => FND_API.G_TRUE,
8863: p_init_msg_list => FND_API.G_TRUE,
8864: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8865: x_return_status => l_return_status,
8866: x_msg_count => l_msg_count,
8867: x_msg_data => l_msg_data,
8868: p_upd_job_completion => p_upd_job_completion,

Line 8875: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8871: -- Debug statement
8872: Debug('Return Status from WIP_UPDATE :'||l_return_status,l_mod_name,2);
8873:
8874: -- Raise error message if the API returns status <> 'S'
8875: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8876: IF l_msg_count > 1 then
8877: FOR i IN 1..l_msg_count LOOP
8878: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8879: END LOOP ;

Line 8878: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

8874: -- Raise error message if the API returns status <> 'S'
8875: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8876: IF l_msg_count > 1 then
8877: FOR i IN 1..l_msg_count LOOP
8878: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8879: END LOOP ;
8880: END IF ;
8881: Debug(l_msg_data,l_mod_name,4);
8882: RAISE FND_API.G_EXC_ERROR;

Line 8882: RAISE FND_API.G_EXC_ERROR;

8878: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8879: END LOOP ;
8880: END IF ;
8881: Debug(l_msg_data,l_mod_name,4);
8882: RAISE FND_API.G_EXC_ERROR;
8883: END IF;
8884:
8885: Exception
8886: WHEN FND_API.G_EXC_ERROR THEN

Line 8886: WHEN FND_API.G_EXC_ERROR THEN

8882: RAISE FND_API.G_EXC_ERROR;
8883: END IF;
8884:
8885: Exception
8886: WHEN FND_API.G_EXC_ERROR THEN
8887: retcode := l_error_status;
8888: errbuf := l_msg_data;
8889: WHEN Others then
8890: -- Handle others exception

Line 8947: l_return_status := FND_API.G_RET_STS_SUCCESS;

8943: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update_conc_prog';
8944:
8945: Begin
8946: -- Initialize API return status to success
8947: l_return_status := FND_API.G_RET_STS_SUCCESS;
8948:
8949: -- Initialize the error message and error buffer
8950: retcode := l_success_status;
8951: errbuf := '';

Line 8968: p_commit => FND_API.G_TRUE,

8964: Debug('Calling SHIP_UPDATE ',l_mod_name,2);
8965:
8966: SHIP_UPDATE
8967: ( p_api_version => l_api_version,
8968: p_commit => FND_API.G_TRUE,
8969: p_init_msg_list => FND_API.G_TRUE,
8970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8971: x_return_status => l_return_status,
8972: x_msg_count => l_msg_count,

Line 8969: p_init_msg_list => FND_API.G_TRUE,

8965:
8966: SHIP_UPDATE
8967: ( p_api_version => l_api_version,
8968: p_commit => FND_API.G_TRUE,
8969: p_init_msg_list => FND_API.G_TRUE,
8970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8971: x_return_status => l_return_status,
8972: x_msg_count => l_msg_count,
8973: x_msg_data => l_msg_data,

Line 8970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

8966: SHIP_UPDATE
8967: ( p_api_version => l_api_version,
8968: p_commit => FND_API.G_TRUE,
8969: p_init_msg_list => FND_API.G_TRUE,
8970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8971: x_return_status => l_return_status,
8972: x_msg_count => l_msg_count,
8973: x_msg_data => l_msg_data,
8974: p_internal_order_flag => l_internal_order_flag,

Line 8982: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8978:
8979: -- Debug message
8980: Debug('Return Status from SHIP_UPDATE :'||l_return_status,l_mod_name,2);
8981:
8982: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8983: -- Concatenate the message from the message stack
8984: IF l_msg_count > 1 then
8985: FOR i IN 1..l_msg_count LOOP
8986: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

Line 8986: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

8982: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8983: -- Concatenate the message from the message stack
8984: IF l_msg_count > 1 then
8985: FOR i IN 1..l_msg_count LOOP
8986: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8987: END LOOP ;
8988: END IF ;
8989: Debug(l_msg_data,l_mod_name,4);
8990: RAISE FND_API.G_EXC_ERROR ;

Line 8990: RAISE FND_API.G_EXC_ERROR ;

8986: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
8987: END LOOP ;
8988: END IF ;
8989: Debug(l_msg_data,l_mod_name,4);
8990: RAISE FND_API.G_EXC_ERROR ;
8991: END IF;
8992: Exception
8993: WHEN FND_API.G_EXC_ERROR THEN
8994: retcode := l_error_status;

Line 8993: WHEN FND_API.G_EXC_ERROR THEN

8989: Debug(l_msg_data,l_mod_name,4);
8990: RAISE FND_API.G_EXC_ERROR ;
8991: END IF;
8992: Exception
8993: WHEN FND_API.G_EXC_ERROR THEN
8994: retcode := l_error_status;
8995: errbuf := l_msg_data;
8996: WHEN Others then
8997: -- Handle others exception

Line 9115: x_return_status := FND_API.G_RET_STS_SUCCESS;

9111:
9112: BEGIN
9113:
9114: -- Initialize API return status to success
9115: x_return_status := FND_API.G_RET_STS_SUCCESS;
9116:
9117: -- Initialize the error message and error buffer
9118: retcode := '0';
9119: errbuf := '';

Line 9206: p_init_msg_list => FND_API.G_FALSE,

9202: Debug('Calling Validate_And_Write ',l_mod_name,2);
9203:
9204: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
9205: (p_Api_Version_Number => l_api_version ,
9206: p_init_msg_list => FND_API.G_FALSE,
9207: p_commit => FND_API.G_FALSE,
9208: p_validation_level => NULL,
9209: p_action_code => 0,
9210: px_REPAIR_HISTORY_ID => l_repair_history_id,

Line 9207: p_commit => FND_API.G_FALSE,

9203:
9204: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
9205: (p_Api_Version_Number => l_api_version ,
9206: p_init_msg_list => FND_API.G_FALSE,
9207: p_commit => FND_API.G_FALSE,
9208: p_validation_level => NULL,
9209: p_action_code => 0,
9210: px_REPAIR_HISTORY_ID => l_repair_history_id,
9211: p_OBJECT_VERSION_NUMBER => null, -- travi ovn validation

Line 9277: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

9273: X_Msg_Data => x_msg_data
9274: );
9275:
9276: Debug('Return Status from Validate_And_Write :'||x_return_status,l_mod_name,2);
9277: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9278: -- Debug messages
9279: Debug(' JOB_COMPLETION_UPDATE failed ',l_mod_name,4);
9280: RAISE FND_API.G_EXC_ERROR;
9281: END IF;

Line 9280: RAISE FND_API.G_EXC_ERROR;

9276: Debug('Return Status from Validate_And_Write :'||x_return_status,l_mod_name,2);
9277: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9278: -- Debug messages
9279: Debug(' JOB_COMPLETION_UPDATE failed ',l_mod_name,4);
9280: RAISE FND_API.G_EXC_ERROR;
9281: END IF;
9282:
9283: -- -------------------
9284: -- Api body ends here

Line 9293: IF FND_API.To_Boolean( FND_API.G_FALSE ) THEN

9289: end if; -- End of check for l_rep_hist_id
9290: end loop;
9291:
9292: -- Standard check of p_commit.
9293: IF FND_API.To_Boolean( FND_API.G_FALSE ) THEN
9294: COMMIT WORK;
9295: END IF;
9296:
9297: -- Standard call to get message count and IF count is get message info.

Line 9303: WHEN FND_API.G_EXC_ERROR THEN

9299: (p_count => x_msg_count,
9300: p_data => x_msg_data );
9301:
9302: EXCEPTION
9303: WHEN FND_API.G_EXC_ERROR THEN
9304: ROLLBACK TO Update_rep_task_hist;
9305: x_return_status := FND_API.G_RET_STS_ERROR ;
9306: FND_MSG_PUB.Count_And_Get
9307: (p_count => x_msg_count,

Line 9305: x_return_status := FND_API.G_RET_STS_ERROR ;

9301:
9302: EXCEPTION
9303: WHEN FND_API.G_EXC_ERROR THEN
9304: ROLLBACK TO Update_rep_task_hist;
9305: x_return_status := FND_API.G_RET_STS_ERROR ;
9306: FND_MSG_PUB.Count_And_Get
9307: (p_count => x_msg_count,
9308: p_data => x_msg_data );
9309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9305: x_return_status := FND_API.G_RET_STS_ERROR ;
9306: FND_MSG_PUB.Count_And_Get
9307: (p_count => x_msg_count,
9308: p_data => x_msg_data );
9309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9311: ROLLBACK TO Update_rep_task_hist;
9312: FND_MSG_PUB.Count_And_Get
9313: ( p_count => x_msg_count,

Line 9310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9306: FND_MSG_PUB.Count_And_Get
9307: (p_count => x_msg_count,
9308: p_data => x_msg_data );
9309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9311: ROLLBACK TO Update_rep_task_hist;
9312: FND_MSG_PUB.Count_And_Get
9313: ( p_count => x_msg_count,
9314: p_data => x_msg_data );

Line 9316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9312: FND_MSG_PUB.Count_And_Get
9313: ( p_count => x_msg_count,
9314: p_data => x_msg_data );
9315: WHEN OTHERS THEN
9316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9317: ROLLBACK TO Update_rep_task_hist;
9318: IF FND_MSG_PUB.Check_Msg_Level
9319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9320: THEN

Line 9390: if(p_commit = FND_API.G_TRUE) THEN

9386: IF c_product_transaction_id%isopen then
9387: CLOSE c_product_transaction_id;
9388: END IF;
9389:
9390: if(p_commit = FND_API.G_TRUE) THEN
9391: commit;
9392: END IF;
9393: End;
9394:

Line 9466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9462: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
9463: WHERE PRODUCT_TRANSACTION_ID = l_product_txn_id;
9464: EXCEPTION
9465: WHEN OTHERS THEN
9466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9467: END;
9468: END LOOP;
9469:
9470: END check_for_cancelled_order;

Line 9567: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

9563: p_internal_order_flag => 'N',
9564: p_order_header_id => null,
9565: p_repair_line_id => l_orig_source_id);
9566:
9567: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9568: resultout := 'COMPLETE:ERROR';
9569: ELSE
9570: resultout := 'COMPLETE:SUCCESS';
9571: END IF;

Line 9589: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

9585: p_internal_order_flag => 'N' ,
9586: p_order_header_id => null,
9587: p_repair_line_id => l_orig_source_id);
9588:
9589: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9590: resultout := 'COMPLETE:ERROR';
9591: ELSE
9592: resultout := 'COMPLETE:SUCCESS';
9593: END IF;

Line 9599: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

9595: END IF;
9596:
9597: -- If the return status is error then raise
9598: -- the Business Event
9599: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9600:
9601: CSD_REPAIRS_PVT.LAUNCH_WFEXCEPTION_BEVENT(
9602: p_return_status => l_return_status,
9603: p_msg_count => l_msg_count,