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 365: x_return_status := FND_API.G_RET_STS_SUCCESS;

361: -- Standard Start of API savepoint
362: SAVEPOINT CONV_TO_RO_UOM;
363:
364: -- Initialize API return status to success
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: -- Api body starts
368: Debug('At the Beginning of Convert_to_RO_uom',l_mod_name,1);
369:

Line 388: RAISE FND_API.G_EXC_ERROR;

384: fnd_message.set_name('CSD','CSD_UOM_MISSING');
385: fnd_message.set_token('UOM',p_from_uom);
386: fnd_msg_pub.add;
387: END IF;
388: RAISE FND_API.G_EXC_ERROR;
389: WHEN TOO_MANY_ROWS THEN
390: IF ( l_error_level >= G_debug_level) THEN
391: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
392: fnd_message.set_token('UOM',p_from_uom);

Line 399: RAISE FND_API.G_EXC_ERROR;

395: fnd_message.set_name('CSD','CSD_MANY_UOM_FOUND');
396: fnd_message.set_token('UOM',p_from_uom);
397: fnd_msg_pub.add;
398: END IF;
399: RAISE FND_API.G_EXC_ERROR;
400: End;
401: Else
402: -- assign the uom code if it is passed to the api
403: l_from_uom_code := p_from_uom_code;

Line 429: RAISE FND_API.G_EXC_ERROR;

425: ELSE
426: fnd_message.set_name('CSD','CSD_INV_UM_CONV_FAILED');
427: fnd_msg_pub.add;
428: END IF;
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431: ELSE
432: x_result_quantity := p_from_quantity;
433: END IF;

Line 436: WHEN FND_API.G_EXC_ERROR THEN

432: x_result_quantity := p_from_quantity;
433: END IF;
434:
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
438: ROLLBACK TO CONV_TO_RO_UOM;
439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

433: END IF;
434:
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
438: ROLLBACK TO CONV_TO_RO_UOM;
439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);

Line 439: x_return_status := FND_API.G_RET_STS_ERROR ;

435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
438: ROLLBACK TO CONV_TO_RO_UOM;
439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
442: ROLLBACK TO CONV_TO_RO_UOM;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

436: WHEN FND_API.G_EXC_ERROR THEN
437: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
438: ROLLBACK TO CONV_TO_RO_UOM;
439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
442: ROLLBACK TO CONV_TO_RO_UOM;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: WHEN OTHERS THEN

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

437: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
438: ROLLBACK TO CONV_TO_RO_UOM;
439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
442: ROLLBACK TO CONV_TO_RO_UOM;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: WHEN OTHERS THEN
445: Debug('In OTHERS exception',l_mod_name,4);

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
442: ROLLBACK TO CONV_TO_RO_UOM;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: WHEN OTHERS THEN
445: Debug('In OTHERS exception',l_mod_name,4);
446: ROLLBACK TO CONV_TO_RO_UOM;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: WHEN OTHERS THEN
445: Debug('In OTHERS exception',l_mod_name,4);
446: ROLLBACK TO CONV_TO_RO_UOM;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: End CONVERT_TO_RO_UOM;
449:
450: /*-------------------------------------------------------------------------------------*/
451: /* Procedure name: LOG_ACTIVITY */

Line 502: x_return_status := FND_API.G_RET_STS_SUCCESS;

498: -- Standard Start of API savepoint
499: SAVEPOINT LOG_ACTIVITY;
500:
501: -- Initialize API return status to success
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503:
504: -- Debug messages
505: Debug('At the beginning of log_activity api',l_mod_name,1);
506:

Line 508: IF NOT FND_API.Compatible_API_Call (l_api_version,

504: -- Debug messages
505: Debug('At the beginning of log_activity api',l_mod_name,1);
506:
507: -- Standard call to check for call compatibility.
508: IF NOT FND_API.Compatible_API_Call (l_api_version,
509: p_api_version,
510: l_api_name ,
511: G_PKG_NAME )
512: THEN

Line 513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

509: p_api_version,
510: l_api_name ,
511: G_PKG_NAME )
512: THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515:
516: -- Initialize message list if p_init_msg_list is set to TRUE.
517: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 517: IF FND_API.to_Boolean( p_init_msg_list ) THEN

513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515:
516: -- Initialize message list if p_init_msg_list is set to TRUE.
517: IF FND_API.to_Boolean( p_init_msg_list ) THEN
518: FND_MSG_PUB.initialize;
519: END IF;
520:
521: -- Debug messages

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

611:
612: -- Debug messages
613: Debug('x_return_status from Validate_And_Write ='||x_return_status,l_mod_name,2);
614:
615: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
616: Debug('Validate_And_Write api failed ',l_mod_name,4);
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:

Line 617: RAISE FND_API.G_EXC_ERROR;

613: Debug('x_return_status from Validate_And_Write ='||x_return_status,l_mod_name,2);
614:
615: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
616: Debug('Validate_And_Write api failed ',l_mod_name,4);
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: -- Standard check of p_commit.
621: IF FND_API.To_Boolean( p_commit ) THEN

Line 621: IF FND_API.To_Boolean( p_commit ) THEN

617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: -- Standard check of p_commit.
621: IF FND_API.To_Boolean( p_commit ) THEN
622: COMMIT WORK;
623: END IF;
624:
625: -- Standard call to get message count and IF count is get message info.

Line 630: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 633: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

633: x_return_status := FND_API.G_RET_STS_ERROR ;
634: FND_MSG_PUB.Count_And_Get
635: (p_count => x_msg_count,
636: p_data => x_msg_data );
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
639: ROLLBACK TO LOG_ACTIVITY;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: FND_MSG_PUB.Count_And_Get

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

634: FND_MSG_PUB.Count_And_Get
635: (p_count => x_msg_count,
636: p_data => x_msg_data );
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
639: ROLLBACK TO LOG_ACTIVITY;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: FND_MSG_PUB.Count_And_Get
642: ( p_count => x_msg_count,

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

643: p_data => x_msg_data );
644: WHEN OTHERS THEN
645: Debug('In OTHERS exception',l_mod_name,4 );
646: ROLLBACK TO LOG_ACTIVITY;
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
648: IF FND_MSG_PUB.Check_Msg_Level
649: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg

Line 823: x_return_status := FND_API.G_RET_STS_SUCCESS;

819: -- Standard Start of API savepoint
820: SAVEPOINT JOB_COMPLETION_UPDATE;
821:
822: -- Initialize API return status to success
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: -- Debug messages
826: Debug('At the Beginning of JOB_COMPLETION_UPDATE',l_mod_name,1);
827:

Line 829: IF NOT FND_API.Compatible_API_Call (l_api_version,

825: -- Debug messages
826: Debug('At the Beginning of JOB_COMPLETION_UPDATE',l_mod_name,1);
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call (l_api_version,
830: p_api_version,
831: l_api_name ,
832: G_PKG_NAME )
833: THEN

Line 834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

830: p_api_version,
831: l_api_name ,
832: G_PKG_NAME )
833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836:
837: -- Initialize message list if p_init_msg_list is set to TRUE.
838: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 838: IF FND_API.to_Boolean( p_init_msg_list ) THEN

834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836:
837: -- Initialize message list if p_init_msg_list is set to TRUE.
838: IF FND_API.to_Boolean( p_init_msg_list ) THEN
839: FND_MSG_PUB.initialize;
840: END IF;
841:
842: -- Keep the record count

Line 980: RAISE FND_API.G_EXC_ERROR;

976: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
977: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
978: FND_MSG_PUB.ADD;
979: END IF;
980: RAISE FND_API.G_EXC_ERROR;
981: End IF;
982:
983: -- Initialize the activity rec
984: l_activity_rec := INIT_ACTIVITY_REC ;

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

1014: x_msg_data => x_msg_data,
1015: p_activity_rec => l_activity_rec );
1016:
1017: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1018: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1019: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: l_SN_mismatch := FALSE;

Line 1020: RAISE FND_API.G_EXC_ERROR;

1016:
1017: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1018: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1019: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: l_SN_mismatch := FALSE;
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN

Line 1103: RAISE FND_API.G_EXC_ERROR;

1099: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1100: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1101: FND_MSG_PUB.ADD;
1102: END IF;
1103: RAISE FND_API.G_EXC_ERROR;
1104: End IF;
1105:
1106: -- Initialize the activity rec
1107: l_activity_rec := INIT_ACTIVITY_REC ;

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

1135: x_msg_data => x_msg_data,
1136: p_activity_rec => l_activity_rec );
1137:
1138: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1139: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1140: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1141: RAISE FND_API.G_EXC_ERROR;
1142: END IF;
1143:

Line 1141: RAISE FND_API.G_EXC_ERROR;

1137:
1138: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1139: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1140: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1141: RAISE FND_API.G_EXC_ERROR;
1142: END IF;
1143:
1144:
1145: -- Initialize the activity rec

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

1175: x_msg_data => x_msg_data,
1176: p_activity_rec => l_activity_rec );
1177:
1178: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1179: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1180: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183:

Line 1181: RAISE FND_API.G_EXC_ERROR;

1177:
1178: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1179: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1180: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183:
1184: EXCEPTION
1185: WHEN NO_DATA_FOUND THEN

Line 1235: RAISE FND_API.G_EXC_ERROR;

1231: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1232: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1233: FND_MSG_PUB.ADD;
1234: END IF;
1235: RAISE FND_API.G_EXC_ERROR;
1236: End IF;
1237:
1238: -- Initialize the activity rec
1239: l_activity_rec := INIT_ACTIVITY_REC ;

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

1268: x_msg_data => x_msg_data,
1269: p_activity_rec => l_activity_rec );
1270:
1271: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1272: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1273: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1274: RAISE FND_API.G_EXC_ERROR;
1275: END IF;
1276:

Line 1274: RAISE FND_API.G_EXC_ERROR;

1270:
1271: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1272: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1273: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1274: RAISE FND_API.G_EXC_ERROR;
1275: END IF;
1276:
1277: EXCEPTION
1278: WHEN NO_DATA_FOUND THEN

Line 1288: RAISE FND_API.G_EXC_ERROR;

1284: FND_MESSAGE.SET_NAME('CSD','CSD_INV_WIP_ENTITY_ID');
1285: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',JOB.wip_entity_id );
1286: FND_MSG_PUB.ADD;
1287: END IF;
1288: RAISE FND_API.G_EXC_ERROR;
1289: END;
1290: END IF;
1291:
1292: ELSE

Line 1352: RAISE FND_API.G_EXC_ERROR;

1348: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1349: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',JOB.repair_job_xref_id );
1350: FND_MSG_PUB.ADD;
1351: END IF;
1352: RAISE FND_API.G_EXC_ERROR;
1353: End IF;
1354:
1355: -- Initialize the activity rec
1356: l_activity_rec := INIT_ACTIVITY_REC ;

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

1385: x_msg_data => x_msg_data,
1386: p_activity_rec => l_activity_rec );
1387:
1388: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1389: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1390: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1391: RAISE FND_API.G_EXC_ERROR;
1392: END IF;
1393: END IF; --IF (MTL.transaction_quantity - l_total_qty)> 0

Line 1391: RAISE FND_API.G_EXC_ERROR;

1387:
1388: Debug('x_return_status from LOG_ACTIVITY ='||x_return_status,l_mod_name,2);
1389: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1390: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1391: RAISE FND_API.G_EXC_ERROR;
1392: END IF;
1393: END IF; --IF (MTL.transaction_quantity - l_total_qty)> 0
1394: END IF;-- if l_remaining_qty <=0
1395:

Line 1397: WHEN FND_API.G_EXC_ERROR THEN

1393: END IF; --IF (MTL.transaction_quantity - l_total_qty)> 0
1394: END IF;-- if l_remaining_qty <=0
1395:
1396: EXCEPTION
1397: WHEN FND_API.G_EXC_ERROR THEN
1398: RAISE FND_API.G_EXC_ERROR;
1399: END;
1400: END LOOP; -- MTL cursor
1401:

Line 1398: RAISE FND_API.G_EXC_ERROR;

1394: END IF;-- if l_remaining_qty <=0
1395:
1396: EXCEPTION
1397: WHEN FND_API.G_EXC_ERROR THEN
1398: RAISE FND_API.G_EXC_ERROR;
1399: END;
1400: END LOOP; -- MTL cursor
1401:
1402: END IF; -- end if serial_number_control_code (2,5)

Line 1408: WHEN FND_API.G_EXC_ERROR THEN

1404:
1405: -- Increment if the record is processed successfully
1406: l_total_rec := l_total_rec + 1;
1407: Exception
1408: WHEN FND_API.G_EXC_ERROR THEN
1409: ROLLBACK TO JOB_COMPLETION;
1410: --x_return_status := FND_API.G_RET_STS_ERROR ;
1411: -- In case of error, exit the loop. It could rarely fail
1412: -- rollback the current record but commit the processed records

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

1406: l_total_rec := l_total_rec + 1;
1407: Exception
1408: WHEN FND_API.G_EXC_ERROR THEN
1409: ROLLBACK TO JOB_COMPLETION;
1410: --x_return_status := FND_API.G_RET_STS_ERROR ;
1411: -- In case of error, exit the loop. It could rarely fail
1412: -- rollback the current record but commit the processed records
1413: --exit;
1414: WHEN SKIP_RECORD THEN

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

1414: WHEN SKIP_RECORD THEN
1415: NULL;
1416: WHEN OTHERS THEN
1417: ROLLBACK TO JOB_COMPLETION;
1418: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: -- In case of error, exit the loop. It could rarely fail
1420: -- rollback the current record but commit the processed records
1421: --exit;
1422: END;

Line 1429: IF FND_API.To_Boolean( p_commit ) THEN

1425: -- one should COMMIT less frequently within a PL/SQL loop to
1426: -- prevent ORA-1555 (Snapshot too old) errors
1427: l_count := l_count+1;
1428: IF mod(l_count, l_commit_size) = 0 THEN -- Commit every 500 records
1429: IF FND_API.To_Boolean( p_commit ) THEN
1430: COMMIT WORK;
1431: END IF;
1432: END IF;
1433:

Line 1462: IF FND_API.To_Boolean( p_commit ) THEN

1458: -- Debug message
1459: Debug(l_msg_text,l_mod_name,1 );
1460:
1461: -- Standard check of p_commit.
1462: IF FND_API.To_Boolean( p_commit ) THEN
1463: COMMIT WORK;
1464: END IF;
1465:
1466: -- Standard call to get message count and IF count is get message info.

Line 1471: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 1474: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1474: x_return_status := FND_API.G_RET_STS_ERROR ;
1475: FND_MSG_PUB.Count_And_Get
1476: (p_count => x_msg_count,
1477: p_data => x_msg_data );
1478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1479: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1480: ROLLBACK TO JOB_COMPLETION_UPDATE;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: FND_MSG_PUB.Count_And_Get

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

1475: FND_MSG_PUB.Count_And_Get
1476: (p_count => x_msg_count,
1477: p_data => x_msg_data );
1478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1479: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1480: ROLLBACK TO JOB_COMPLETION_UPDATE;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: FND_MSG_PUB.Count_And_Get
1483: ( p_count => x_msg_count,

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1484: p_data => x_msg_data );
1485: WHEN OTHERS THEN
1486: Debug('In OTHERS exception',l_mod_name,4);
1487: ROLLBACK TO JOB_COMPLETION_UPDATE;
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1489: IF FND_MSG_PUB.Check_Msg_Level
1490: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1491: THEN
1492: FND_MSG_PUB.Add_Exc_Msg

Line 1605: x_return_status := FND_API.G_RET_STS_SUCCESS;

1601: -- Standard Start of API savepoint
1602: SAVEPOINT JOB_CREATION_UPDATE;
1603:
1604: -- Initialize API return status to success
1605: x_return_status := FND_API.G_RET_STS_SUCCESS;
1606:
1607: -- Debug messages
1608: Debug('At the Beginning of JOB_CREATION_UPDATE',l_mod_name,1);
1609:

Line 1611: IF NOT FND_API.Compatible_API_Call (l_api_version,

1607: -- Debug messages
1608: Debug('At the Beginning of JOB_CREATION_UPDATE',l_mod_name,1);
1609:
1610: -- Standard call to check for call compatibility.
1611: IF NOT FND_API.Compatible_API_Call (l_api_version,
1612: p_api_version,
1613: l_api_name ,
1614: G_PKG_NAME )
1615: THEN

Line 1616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1612: p_api_version,
1613: l_api_name ,
1614: G_PKG_NAME )
1615: THEN
1616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1617: END IF;
1618:
1619: -- Initialize message list if p_init_msg_list is set to TRUE.
1620: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1620: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1617: END IF;
1618:
1619: -- Initialize message list if p_init_msg_list is set to TRUE.
1620: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1621: FND_MSG_PUB.initialize;
1622: END IF;
1623:
1624: -- Keeping the running total of the records

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

1700:
1701: -- Debug Messages
1702: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
1703:
1704: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1705: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1706: RAISE FND_API.G_EXC_ERROR;
1707: END IF;
1708:

Line 1706: RAISE FND_API.G_EXC_ERROR;

1702: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
1703:
1704: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1705: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
1706: RAISE FND_API.G_EXC_ERROR;
1707: END IF;
1708:
1709: -- Updating csd_repair_job_xref with the wip_entity_id
1710: Update csd_repair_job_xref

Line 1727: RAISE FND_API.G_EXC_ERROR;

1723: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');
1724: FND_MESSAGE.SET_TOKEN('REP_JOB_XREF_ID',K.repair_job_xref_id );
1725: FND_MSG_PUB.ADD;
1726: END IF;
1727: RAISE FND_API.G_EXC_ERROR;
1728: End IF;
1729:
1730: -- Updating repair order with the Job allocated qty
1731: Update csd_repairs

Line 1748: RAISE FND_API.G_EXC_ERROR;

1744: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');
1745: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',K.repair_line_id );
1746: FND_MSG_PUB.ADD;
1747: END IF;
1748: RAISE FND_API.G_EXC_ERROR;
1749: End IF;
1750:
1751: Exception
1752: WHEN FND_API.G_EXC_ERROR THEN

Line 1752: WHEN FND_API.G_EXC_ERROR THEN

1748: RAISE FND_API.G_EXC_ERROR;
1749: End IF;
1750:
1751: Exception
1752: WHEN FND_API.G_EXC_ERROR THEN
1753: ROLLBACK TO JOB_CREATION;
1754: --x_return_status := FND_API.G_RET_STS_ERROR ;
1755: -- exit the loop in case of error. Commit the processed records
1756: -- but rollback the current error record

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

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

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

1756: -- but rollback the current error record
1757: --exit;
1758: WHEN OTHERS THEN
1759: ROLLBACK TO JOB_CREATION;
1760: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1761: -- exit the loop in case of error. Commit the processed records
1762: -- but rollback the current error record
1763: --exit;
1764: END;

Line 1770: IF FND_API.To_Boolean( p_commit ) THEN

1766: -- one should COMMIT less frequently within a PL/SQL loop to
1767: -- prevent ORA-1555 (Snapshot too old) errors
1768: l_count := l_count+1;
1769: IF mod(l_count, l_commit_size) = 0 THEN -- Commit every 500 records
1770: IF FND_API.To_Boolean( p_commit ) THEN
1771: COMMIT WORK;
1772: END IF;
1773: END IF;
1774: END LOOP; -- End of Job Creation activity

Line 1787: IF FND_API.To_Boolean( p_commit ) THEN

1783: END IF;
1784:
1785:
1786: -- Standard check of p_commit.
1787: IF FND_API.To_Boolean( p_commit ) THEN
1788: COMMIT WORK;
1789: END IF;
1790:
1791: -- Standard call to get message count and IF count is get message info.

Line 1796: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 1799: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1799: x_return_status := FND_API.G_RET_STS_ERROR ;
1800: FND_MSG_PUB.Count_And_Get
1801: (p_count => x_msg_count,
1802: p_data => x_msg_data );
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1805: ROLLBACK TO JOB_CREATION_UPDATE;
1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1807: FND_MSG_PUB.Count_And_Get

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

1800: FND_MSG_PUB.Count_And_Get
1801: (p_count => x_msg_count,
1802: p_data => x_msg_data );
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
1805: ROLLBACK TO JOB_CREATION_UPDATE;
1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1807: FND_MSG_PUB.Count_And_Get
1808: ( p_count => x_msg_count,

Line 1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1809: p_data => x_msg_data );
1810: WHEN OTHERS THEN
1811: Debug('In OTHERS exception',l_mod_name,4);
1812: ROLLBACK TO JOB_CREATION_UPDATE;
1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1814: IF FND_MSG_PUB.Check_Msg_Level
1815: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1816: THEN
1817: FND_MSG_PUB.Add_Exc_Msg

Line 1885: x_return_status := FND_API.G_RET_STS_SUCCESS;

1881: -- Standard Start of API savepoint
1882: SAVEPOINT RECEIPTS_UPDATE;
1883:
1884: -- Initialize API return status to success
1885: x_return_status := FND_API.G_RET_STS_SUCCESS;
1886:
1887: -- Log the api name in the log file
1888: Debug('At the Beginning of Receipts_update',l_mod_name,1);
1889: Debug('p_internal_order_flag ='||p_internal_order_flag,l_mod_name,1);

Line 1894: IF NOT FND_API.Compatible_API_Call (l_api_version,

1890: Debug('p_order_header_id ='||p_order_header_id,l_mod_name,1);
1891: Debug('p_repair_line_id ='||p_repair_line_id,l_mod_name,1);
1892:
1893: -- Standard call to check for call compatibility.
1894: IF NOT FND_API.Compatible_API_Call (l_api_version,
1895: p_api_version,
1896: l_api_name ,
1897: G_PKG_NAME )
1898: THEN

Line 1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1895: p_api_version,
1896: l_api_name ,
1897: G_PKG_NAME )
1898: THEN
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900: END IF;
1901:
1902: -- Initialize message list if p_init_msg_list is set to TRUE.
1903: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1903: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900: END IF;
1901:
1902: -- Initialize message list if p_init_msg_list is set to TRUE.
1903: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1904: FND_MSG_PUB.initialize;
1905: END IF;
1906:
1907: -- Api body starts

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

1921: p_order_header_id => p_order_header_id );
1922:
1923: -- Debug messages
1924: Debug('Return Status from IO_SHIP_UPDATE API :'||x_return_status,l_mod_name,2);
1925: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1926: Debug('IO_SHIP_UPDATE failed',l_mod_name,4);
1927: RAISE FND_API.G_EXC_ERROR;
1928: END IF;
1929:

Line 1927: RAISE FND_API.G_EXC_ERROR;

1923: -- Debug messages
1924: Debug('Return Status from IO_SHIP_UPDATE API :'||x_return_status,l_mod_name,2);
1925: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1926: Debug('IO_SHIP_UPDATE failed',l_mod_name,4);
1927: RAISE FND_API.G_EXC_ERROR;
1928: END IF;
1929:
1930: Debug('Calling IO_RCV_UPDATE API',l_mod_name,2);
1931: -- Call the api for processing the receipt against

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

1941: p_order_header_id => p_order_header_id );
1942:
1943: -- Debug messages
1944: Debug('Return Status from IO_RCV_UPDATE API :'||x_return_status,l_mod_name,2);
1945: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1946: Debug('IO_RCV_UPDATE failed',l_mod_name,4);
1947: RAISE FND_API.G_EXC_ERROR;
1948: END IF;
1949: Else

Line 1947: RAISE FND_API.G_EXC_ERROR;

1943: -- Debug messages
1944: Debug('Return Status from IO_RCV_UPDATE API :'||x_return_status,l_mod_name,2);
1945: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1946: Debug('IO_RCV_UPDATE failed',l_mod_name,4);
1947: RAISE FND_API.G_EXC_ERROR;
1948: END IF;
1949: Else
1950: -- Debug messages
1951: Debug('Calling RMA_RCV_UPDATE API',l_mod_name,2);

Line 1986: l_msg_data_warning := l_msg_data_warning ||' : '||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

1982: l_msg_data_warning := null;
1983: -- Concatenate the message from the message stack
1984: IF x_msg_count >= 1 then
1985: FOR i IN 1..x_msg_count LOOP
1986: l_msg_data_warning := l_msg_data_warning ||' : '||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
1987: Debug('l_msg_data_warning loop :'||l_msg_data_warning,l_mod_name,2);
1988: END LOOP ;
1989: END IF ;
1990: Debug(l_msg_data_warning,l_mod_name,4);

Line 1992: ELSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1988: END LOOP ;
1989: END IF ;
1990: Debug(l_msg_data_warning,l_mod_name,4);
1991: */
1992: ELSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1993: Debug('RMA_RCV_UPDATE failed',l_mod_name,4);
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996:

Line 1994: RAISE FND_API.G_EXC_ERROR;

1990: Debug(l_msg_data_warning,l_mod_name,4);
1991: */
1992: ELSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1993: Debug('RMA_RCV_UPDATE failed',l_mod_name,4);
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996:
1997: End If;
1998:

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

1997: End If;
1998:
1999: -- bug#7497790, 12.1 FP, subhat.
2000: -- automatically update RO status when item is received.
2001: -- dont show any error messages. Pass p_validation_level = fnd_api.g_valid_level_full to receive messages.
2002: csd_repairs_util.auto_update_ro_status(
2003: p_api_version => 1,
2004: p_commit => p_commit,
2005: p_init_msg_list => FND_API.G_FALSE, -- swai: bug 12547701 do not clear msg stack

Line 2005: p_init_msg_list => FND_API.G_FALSE, -- swai: bug 12547701 do not clear msg stack

2001: -- dont show any error messages. Pass p_validation_level = fnd_api.g_valid_level_full to receive messages.
2002: csd_repairs_util.auto_update_ro_status(
2003: p_api_version => 1,
2004: p_commit => p_commit,
2005: p_init_msg_list => FND_API.G_FALSE, -- swai: bug 12547701 do not clear msg stack
2006: p_repair_line_id => p_repair_line_id,
2007: x_return_status => x_return_status,
2008: x_msg_count => x_msg_count,
2009: x_msg_data => x_msg_data,

Line 2011: p_validation_level => fnd_api.g_valid_level_none);

2007: x_return_status => x_return_status,
2008: x_msg_count => x_msg_count,
2009: x_msg_data => x_msg_data,
2010: p_event => 'RECEIVE',
2011: p_validation_level => fnd_api.g_valid_level_none);
2012: -- end bug#7497790, 12.1 FP, subhat.
2013:
2014: -- Standard check of p_commit.
2015: IF FND_API.To_Boolean( p_commit ) THEN

Line 2015: IF FND_API.To_Boolean( p_commit ) THEN

2011: p_validation_level => fnd_api.g_valid_level_none);
2012: -- end bug#7497790, 12.1 FP, subhat.
2013:
2014: -- Standard check of p_commit.
2015: IF FND_API.To_Boolean( p_commit ) THEN
2016: COMMIT WORK;
2017: END IF;
2018:
2019: -- Standard call to get message count and IF count is get message info.

Line 2033: WHEN FND_API.G_EXC_ERROR THEN

2029: -- x_msg_data := l_msg_data_warning; -- swai: bug 12547701
2030: END IF;
2031:
2032: EXCEPTION
2033: WHEN FND_API.G_EXC_ERROR THEN
2034: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
2035: -- As we are committing the processed records in the inner APIs
2036: -- so we rollback only if the p_commit='F'
2037: IF NOT(FND_API.To_Boolean( p_commit )) THEN

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

2030: END IF;
2031:
2032: EXCEPTION
2033: WHEN FND_API.G_EXC_ERROR THEN
2034: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
2035: -- As we are committing the processed records in the inner APIs
2036: -- so we rollback only if the p_commit='F'
2037: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2038: ROLLBACK TO RECEIPTS_UPDATE;

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

2033: WHEN FND_API.G_EXC_ERROR THEN
2034: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
2035: -- As we are committing the processed records in the inner APIs
2036: -- so we rollback only if the p_commit='F'
2037: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2038: ROLLBACK TO RECEIPTS_UPDATE;
2039: END IF;
2040: x_return_status := FND_API.G_RET_STS_ERROR ;
2041: FND_MSG_PUB.Count_And_Get

Line 2040: x_return_status := FND_API.G_RET_STS_ERROR ;

2036: -- so we rollback only if the p_commit='F'
2037: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2038: ROLLBACK TO RECEIPTS_UPDATE;
2039: END IF;
2040: x_return_status := FND_API.G_RET_STS_ERROR ;
2041: FND_MSG_PUB.Count_And_Get
2042: (p_count => x_msg_count,
2043: p_data => x_msg_data );
2044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2040: x_return_status := FND_API.G_RET_STS_ERROR ;
2041: FND_MSG_PUB.Count_And_Get
2042: (p_count => x_msg_count,
2043: p_data => x_msg_data );
2044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2045: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
2046: IF ( l_error_level >= G_debug_level) THEN
2047: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2048: fnd_message.set_token('SQLERRM',SQLERRM);

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

2041: FND_MSG_PUB.Count_And_Get
2042: (p_count => x_msg_count,
2043: p_data => x_msg_data );
2044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2045: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
2046: IF ( l_error_level >= G_debug_level) THEN
2047: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2048: fnd_message.set_token('SQLERRM',SQLERRM);
2049: fnd_message.set_token('SQLCODE',SQLCODE);

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

2050: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2051: END If;
2052: -- As we are committing the processed records in the inner APIs
2053: -- so we rollback only if the p_commit='F'
2054: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2055: ROLLBACK TO RECEIPTS_UPDATE;
2056: END IF;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2058: FND_MSG_PUB.Count_And_Get

Line 2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2053: -- so we rollback only if the p_commit='F'
2054: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2055: ROLLBACK TO RECEIPTS_UPDATE;
2056: END IF;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2058: FND_MSG_PUB.Count_And_Get
2059: ( p_count => x_msg_count,
2060: p_data => x_msg_data );
2061: WHEN OTHERS THEN

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

2067: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2068: END If;
2069: -- As we are committing the processed records in the inner APIs
2070: -- so we rollback only if the p_commit='F'
2071: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2072: ROLLBACK TO RECEIPTS_UPDATE;
2073: END IF;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2075: IF FND_MSG_PUB.Check_Msg_Level

Line 2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2070: -- so we rollback only if the p_commit='F'
2071: IF NOT(FND_API.To_Boolean( p_commit )) THEN
2072: ROLLBACK TO RECEIPTS_UPDATE;
2073: END IF;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2075: IF FND_MSG_PUB.Check_Msg_Level
2076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2077: THEN
2078: FND_MSG_PUB.Add_Exc_Msg

Line 2431: x_return_status := FND_API.G_RET_STS_SUCCESS;

2427: -- Standard Start of API savepoint
2428: SAVEPOINT RMA_RCV_UPDATE;
2429:
2430: -- Initialize API return status to success
2431: x_return_status := FND_API.G_RET_STS_SUCCESS;
2432:
2433: -- Debug messages
2434: Debug('At the Beginning of RMA_RCV_UPDATE',l_mod_name,1);
2435: Debug('Repair Line Id ='||to_char(p_repair_line_id),l_mod_name,1);

Line 2438: IF NOT FND_API.Compatible_API_Call (l_api_version,

2434: Debug('At the Beginning of RMA_RCV_UPDATE',l_mod_name,1);
2435: Debug('Repair Line Id ='||to_char(p_repair_line_id),l_mod_name,1);
2436:
2437: -- Standard call to check for call compatibility.
2438: IF NOT FND_API.Compatible_API_Call (l_api_version,
2439: p_api_version,
2440: l_api_name ,
2441: G_PKG_NAME )
2442: THEN

Line 2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2439: p_api_version,
2440: l_api_name ,
2441: G_PKG_NAME )
2442: THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: END IF;
2445:
2446: -- Initialize message list if p_init_msg_list is set to TRUE.
2447: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2447: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: END IF;
2445:
2446: -- Initialize message list if p_init_msg_list is set to TRUE.
2447: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2448: FND_MSG_PUB.initialize;
2449: END IF;
2450:
2451: -- Api body starts

Line 2457: RAISE FND_API.G_EXC_ERROR;

2453: -- Validate the repair line id
2454: -- bugfix 4423818 : We need to validate only if p_repair_line_id is NOT NULL
2455: IF(p_repair_line_id is NOT NULL ) THEN
2456: IF NOT(csd_process_util.validate_rep_line_id(p_repair_line_id)) THEN
2457: RAISE FND_API.G_EXC_ERROR;
2458: END IF;
2459: END IF;
2460:
2461: -- Assign the number of processed records in this variable

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

2588: p_activity_rec => l_activity_rec );
2589:
2590: -- Debug Messages
2591: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2592: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2593: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2594: RAISE FND_API.G_EXC_ERROR;
2595: END IF;
2596:

Line 2594: RAISE FND_API.G_EXC_ERROR;

2590: -- Debug Messages
2591: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2592: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2593: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2594: RAISE FND_API.G_EXC_ERROR;
2595: END IF;
2596:
2597: ELSIF I.transaction_type = 'REJECT' then
2598: -- Log activities for the reject transactions

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

2635: p_activity_rec => l_activity_rec );
2636:
2637: -- Debug Messages
2638: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2639: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2640: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2641: RAISE FND_API.G_EXC_ERROR;
2642: END IF;
2643:

Line 2641: RAISE FND_API.G_EXC_ERROR;

2637: -- Debug Messages
2638: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2639: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2640: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2641: RAISE FND_API.G_EXC_ERROR;
2642: END IF;
2643:
2644: ElSIF I.transaction_type = 'DELIVER' then
2645: --Log activities for the deliver transaction

Line 2678: RAISE FND_API.G_EXC_ERROR;

2674: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2675: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2676: fnd_msg_pub.add;
2677: END IF;
2678: RAISE FND_API.G_EXC_ERROR;
2679: When others then
2680: Debug('In Others exception',l_mod_name,4);
2681: RAISE FND_API.G_EXC_ERROR;
2682: End;

Line 2681: RAISE FND_API.G_EXC_ERROR;

2677: END IF;
2678: RAISE FND_API.G_EXC_ERROR;
2679: When others then
2680: Debug('In Others exception',l_mod_name,4);
2681: RAISE FND_API.G_EXC_ERROR;
2682: End;
2683:
2684: Debug('Serial Num Ctl Code ='||TO_CHAR(l_srl_ctl_code),l_mod_name,1);
2685: Debug('Lot Ctl Code ='||TO_CHAR(l_lot_ctl_code),l_mod_name,1);

Line 2705: RAISE FND_API.G_EXC_ERROR;

2701: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_MISSING');
2702: FND_MESSAGE.SET_TOKEN('TXN_ID',i.transaction_id);
2703: FND_MSG_PUB.ADD;
2704: END IF;
2705: RAISE FND_API.G_EXC_ERROR;
2706: END IF;
2707: -- Close the cursor
2708: If rcv_txn_serial_num %isopen then
2709: close rcv_txn_serial_num ;

Line 2741: --RAISE FND_API.G_EXC_ERROR;

2737: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2738: FND_MSG_PUB.ADD;
2739: END IF;
2740:
2741: --RAISE FND_API.G_EXC_ERROR;
2742: --bug#8261344
2743: -- swai: bug 12547701 updated if statement
2744: IF(NVL(fnd_profile.value('CSD_LOGISTICS_PROGRAM_ERROR'), 'S') = 'S') THEN
2745: RAISE FND_API.G_EXC_ERROR;

Line 2745: RAISE FND_API.G_EXC_ERROR;

2741: --RAISE FND_API.G_EXC_ERROR;
2742: --bug#8261344
2743: -- swai: bug 12547701 updated if statement
2744: IF(NVL(fnd_profile.value('CSD_LOGISTICS_PROGRAM_ERROR'), 'S') = 'S') THEN
2745: RAISE FND_API.G_EXC_ERROR;
2746: else
2747: l_skip_record := TRUE;
2748: l_warning_return := TRUE;
2749: end if;

Line 2763: RAISE FND_API.G_EXC_ERROR;

2759: FND_MESSAGE.SET_NAME('CSD','CSD_FOUND_MANY_INSTANCE');
2760: FND_MESSAGE.SET_TOKEN('SERIAL_NUM',l_st_serial_num);
2761: FND_MSG_PUB.ADD;
2762: END IF;
2763: RAISE FND_API.G_EXC_ERROR;
2764: Debug(' Found many IB instance for the Serial Num ='||l_st_serial_num, l_mod_name,1);
2765: END;
2766: ELSE
2767: l_instance_id := NULL;

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

2809: p_activity_rec => l_activity_rec );
2810:
2811: -- Debug Messages
2812: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2813: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2814: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2815: RAISE FND_API.G_EXC_ERROR;
2816: END IF;
2817: End IF; --end for IF (l_st_serial_num <> I.SOURCE_SERIAL_NUMBER)

Line 2815: RAISE FND_API.G_EXC_ERROR;

2811: -- Debug Messages
2812: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
2813: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2814: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
2815: RAISE FND_API.G_EXC_ERROR;
2816: END IF;
2817: End IF; --end for IF (l_st_serial_num <> I.SOURCE_SERIAL_NUMBER)
2818:
2819: ELSE ---esle for IF l_srl_ctl_code in (2,5,6)

Line 2848: RAISE FND_API.G_EXC_ERROR;

2844: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
2845: fnd_message.set_token('ITEM_ID',I.inventory_item_id);
2846: fnd_msg_pub.add;
2847: END IF;
2848: RAISE FND_API.G_EXC_ERROR;
2849:
2850: --bug#16017759
2851: WHEN TOO_MANY_ROWS THEN
2852: -- that means multiple lotnumbers were entered during receipt (repair_quantity > 1)

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

2880: ,p_from_quantity => i.received_quantity
2881: ,x_result_quantity => l_result_quantity);
2882:
2883: Debug('Return Status from CONVERT_TO_RO_UOM '||x_return_status,l_mod_name,2);
2884: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2885: Debug('CONVERT_TO_RO_UOM failed ',l_mod_name,4);
2886: RAISE FND_API.G_EXC_ERROR;
2887: END IF;
2888: Else

Line 2886: RAISE FND_API.G_EXC_ERROR;

2882:
2883: Debug('Return Status from CONVERT_TO_RO_UOM '||x_return_status,l_mod_name,2);
2884: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2885: Debug('CONVERT_TO_RO_UOM failed ',l_mod_name,4);
2886: RAISE FND_API.G_EXC_ERROR;
2887: END IF;
2888: Else
2889: l_result_quantity := NVL(i.received_quantity,0);
2890: END IF;

Line 2919: RAISE FND_API.G_EXC_ERROR;

2915: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2916: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2917: fnd_msg_pub.add;
2918: END IF;
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:
2922: ELSE
2923: -- Update the qty if the item on ro

Line 2942: RAISE FND_API.G_EXC_ERROR;

2938: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
2939: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
2940: fnd_msg_pub.add;
2941: END IF;
2942: RAISE FND_API.G_EXC_ERROR;
2943: END IF;
2944:
2945: END IF;
2946: End If;

Line 2978: RAISE FND_API.G_EXC_ERROR;

2974: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
2975: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
2976: fnd_msg_pub.add;
2977: END IF;
2978: RAISE FND_API.G_EXC_ERROR;
2979: END IF;
2980:
2981: fnd_message.set_name('CSD','CSD_DRC_RMA_RECEIPT');
2982: fnd_message.set_token('RMA_NO',i.rma_number);

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

3034: p_activity_rec => l_activity_rec );
3035:
3036: -- Debug Messages
3037: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3038: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3039: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3040: RAISE FND_API.G_EXC_ERROR;
3041: END IF;
3042:

Line 3040: RAISE FND_API.G_EXC_ERROR;

3036: -- Debug Messages
3037: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3038: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3039: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3040: RAISE FND_API.G_EXC_ERROR;
3041: END IF;
3042:
3043: -- subhat, resolve by date enhancement. Calculate resolve by date if calculation is set as RMA_RECEIPT.
3044: IF I.action_code IN ( 'CUST_PROD','EXCHANGE') AND I.action_type in ('RMA')

Line 3070: IF x_return_status <> fnd_api.g_ret_sts_success

3066: x_msg_count => x_msg_count,
3067: x_msg_data => x_msg_data,
3068: x_resolve_by_date => x_resolve_by_date);
3069: -- all errors from this API should not be raised. We log it as an error message.
3070: IF x_return_status <> fnd_api.g_ret_sts_success
3071: THEN
3072: Debug('The resolve by date calculation errored out.',l_mod_name,1);
3073: Debug('Possibly a missing contracts setup.',l_mod_name,1);
3074: Debug('message count is '||x_msg_count||' and message data is '||x_msg_data,l_mod_name,1);

Line 3076: -- we dont need a NVL for x_resolve_by_date or comparision with FND_API.g_miss_date.

3072: Debug('The resolve by date calculation errored out.',l_mod_name,1);
3073: Debug('Possibly a missing contracts setup.',l_mod_name,1);
3074: Debug('message count is '||x_msg_count||' and message data is '||x_msg_data,l_mod_name,1);
3075: END IF;
3076: -- we dont need a NVL for x_resolve_by_date or comparision with FND_API.g_miss_date.
3077: -- in case the get_contract_resolve_by_date errors out, it should not corrupt the out
3078: -- variable.
3079:
3080: UPDATE csd_repairs SET resolve_by_date = x_resolve_by_date

Line 3099: IF FND_API.To_Boolean( p_commit ) THEN

3095: If NOT(l_skip_record) Then
3096: l_total_records := l_total_records + 1;
3097: end if;
3098: IF mod(l_total_records, l_commit_size) = 0 THEN -- Commit every 500 records
3099: IF FND_API.To_Boolean( p_commit ) THEN
3100: COMMIT WORK;
3101: END IF;
3102: END IF;
3103:

Line 3108: WHEN FND_API.G_EXC_ERROR THEN

3104: --bug#8261344
3105: l_skip_record := FALSE;
3106:
3107: EXCEPTION
3108: WHEN FND_API.G_EXC_ERROR THEN
3109: ROLLBACK TO RECEIPT_LINES;
3110: x_return_status := FND_API.G_RET_STS_ERROR ;
3111: EXIT;
3112: -- In case of error, exit the loop. Commit the processed records

Line 3110: x_return_status := FND_API.G_RET_STS_ERROR ;

3106:
3107: EXCEPTION
3108: WHEN FND_API.G_EXC_ERROR THEN
3109: ROLLBACK TO RECEIPT_LINES;
3110: x_return_status := FND_API.G_RET_STS_ERROR ;
3111: EXIT;
3112: -- In case of error, exit the loop. Commit the processed records
3113: -- and rollback the error record
3114: -- RAISE FND_API.G_EXC_ERROR;

Line 3114: -- RAISE FND_API.G_EXC_ERROR;

3110: x_return_status := FND_API.G_RET_STS_ERROR ;
3111: EXIT;
3112: -- In case of error, exit the loop. Commit the processed records
3113: -- and rollback the error record
3114: -- RAISE FND_API.G_EXC_ERROR;
3115: WHEN SKIP_RECORD THEN
3116: NULL;
3117: END;
3118: END LOOP;

Line 3164: IF FND_API.To_Boolean( p_commit ) THEN

3160: fnd_file.put_line(fnd_file.log,fnd_message.get);
3161: fnd_file.put_line(fnd_file.output,fnd_message.get);
3162:
3163: -- Standard check of p_commit.
3164: IF FND_API.To_Boolean( p_commit ) THEN
3165: COMMIT WORK;
3166: END IF;
3167:
3168: --bug#8261344

Line 3178: WHEN FND_API.G_EXC_ERROR THEN

3174: FND_MSG_PUB.Count_And_Get
3175: (p_count => x_msg_count,
3176: p_data => x_msg_data );
3177: EXCEPTION
3178: WHEN FND_API.G_EXC_ERROR THEN
3179: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
3180: ROLLBACK TO RMA_RCV_UPDATE;
3181: x_return_status := FND_API.G_RET_STS_ERROR ;
3182: FND_MSG_PUB.Count_And_Get

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

3175: (p_count => x_msg_count,
3176: p_data => x_msg_data );
3177: EXCEPTION
3178: WHEN FND_API.G_EXC_ERROR THEN
3179: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
3180: ROLLBACK TO RMA_RCV_UPDATE;
3181: x_return_status := FND_API.G_RET_STS_ERROR ;
3182: FND_MSG_PUB.Count_And_Get
3183: (p_count => x_msg_count,

Line 3181: x_return_status := FND_API.G_RET_STS_ERROR ;

3177: EXCEPTION
3178: WHEN FND_API.G_EXC_ERROR THEN
3179: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4 );
3180: ROLLBACK TO RMA_RCV_UPDATE;
3181: x_return_status := FND_API.G_RET_STS_ERROR ;
3182: FND_MSG_PUB.Count_And_Get
3183: (p_count => x_msg_count,
3184: p_data => x_msg_data );
3185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3181: x_return_status := FND_API.G_RET_STS_ERROR ;
3182: FND_MSG_PUB.Count_And_Get
3183: (p_count => x_msg_count,
3184: p_data => x_msg_data );
3185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3186: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
3187: ROLLBACK TO RMA_RCV_UPDATE;
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3189: FND_MSG_PUB.Count_And_Get

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

3182: FND_MSG_PUB.Count_And_Get
3183: (p_count => x_msg_count,
3184: p_data => x_msg_data );
3185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3186: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
3187: ROLLBACK TO RMA_RCV_UPDATE;
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3189: FND_MSG_PUB.Count_And_Get
3190: ( p_count => x_msg_count,

Line 3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3184: p_data => x_msg_data );
3185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3186: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4 );
3187: ROLLBACK TO RMA_RCV_UPDATE;
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3189: FND_MSG_PUB.Count_And_Get
3190: ( p_count => x_msg_count,
3191: p_data => x_msg_data );
3192: WHEN OTHERS THEN

Line 3195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3191: p_data => x_msg_data );
3192: WHEN OTHERS THEN
3193: Debug('In OTHERS exception',l_mod_name,4 );
3194: ROLLBACK TO RMA_RCV_UPDATE;
3195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3196: IF FND_MSG_PUB.Check_Msg_Level
3197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3198: THEN
3199: FND_MSG_PUB.Add_Exc_Msg

Line 3424: x_return_status := FND_API.G_RET_STS_SUCCESS;

3420: -- Standard Start of API savepoint
3421: SAVEPOINT IO_RCV_UPDATE;
3422:
3423: -- Initialize API return status to success
3424: x_return_status := FND_API.G_RET_STS_SUCCESS;
3425:
3426: -- Debug messages
3427: Debug('Beginning of IO_RCV_UPDATE',l_mod_name,1);
3428: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);

Line 3431: IF NOT FND_API.Compatible_API_Call (l_api_version,

3427: Debug('Beginning of IO_RCV_UPDATE',l_mod_name,1);
3428: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);
3429:
3430: -- Standard call to check for call compatibility.
3431: IF NOT FND_API.Compatible_API_Call (l_api_version,
3432: p_api_version,
3433: l_api_name ,
3434: G_PKG_NAME )
3435: THEN

Line 3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3432: p_api_version,
3433: l_api_name ,
3434: G_PKG_NAME )
3435: THEN
3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3437: END IF;
3438:
3439: -- Initialize message list if p_init_msg_list is set to TRUE.
3440: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3440: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3437: END IF;
3438:
3439: -- Initialize message list if p_init_msg_list is set to TRUE.
3440: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3441: FND_MSG_PUB.initialize;
3442: END IF;
3443:
3444: -- Api body starts

Line 3473: RAISE FND_API.G_EXC_ERROR;

3469: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
3470: fnd_message.set_token('HEADER_ID',p_order_header_id);
3471: fnd_msg_pub.add;
3472: END IF;
3473: RAISE FND_API.G_EXC_ERROR;
3474: END;
3475: END IF;
3476:
3477:

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

3635: p_activity_rec => l_activity_rec );
3636:
3637: -- Debug Messages
3638: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3639: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3640: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3641: RAISE FND_API.G_EXC_ERROR;
3642: END IF;
3643:

Line 3641: RAISE FND_API.G_EXC_ERROR;

3637: -- Debug Messages
3638: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3639: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3640: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3641: RAISE FND_API.G_EXC_ERROR;
3642: END IF;
3643:
3644: -- Check if there are "DELIVER" txn lines against the accept lines
3645: -- If found, then process the deliver lines also

Line 3765: RAISE FND_API.G_EXC_ERROR;

3761: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
3762: fnd_message.set_token('TXN_ID',DEL.transaction_id);
3763: fnd_msg_pub.add;
3764: END IF;
3765: RAISE FND_API.G_EXC_ERROR;
3766: END;
3767: ELSE
3768: l_lot_num := NULL;
3769: END IF;

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

3897: p_activity_rec => l_activity_rec );
3898:
3899: -- Debug Messages
3900: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3901: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3902: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;
3905:

Line 3903: RAISE FND_API.G_EXC_ERROR;

3899: -- Debug Messages
3900: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
3901: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3902: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
3903: RAISE FND_API.G_EXC_ERROR;
3904: END IF;
3905:
3906: IF (l_pt_del_qty + l_rcvd_qty) >= l_line_del_qty THEN
3907: Debug(' Exiting the DEL loop',l_mod_name,1);

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

4003: p_activity_rec => l_activity_rec );
4004:
4005: -- Debug Messages
4006: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4007: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4008: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
4009: RAISE FND_API.G_EXC_ERROR;
4010: END IF;
4011:

Line 4009: RAISE FND_API.G_EXC_ERROR;

4005: -- Debug Messages
4006: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4007: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4008: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
4009: RAISE FND_API.G_EXC_ERROR;
4010: END IF;
4011:
4012: -- Check if there are "DELIVER" txn lines against the reject lines
4013: -- If found, then process the deliver lines also

Line 4133: RAISE FND_API.G_EXC_ERROR;

4129: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4130: fnd_message.set_token('TXN_ID',DEL.transaction_id);
4131: fnd_msg_pub.add;
4132: END IF;
4133: RAISE FND_API.G_EXC_ERROR;
4134: END;
4135: ELSE
4136: l_lot_num := NULL;
4137: END IF;

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

4267: p_activity_rec => l_activity_rec );
4268:
4269: -- Debug Messages
4270: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4271: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4272: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
4273: RAISE FND_API.G_EXC_ERROR;
4274: END IF;
4275:

Line 4273: RAISE FND_API.G_EXC_ERROR;

4269: -- Debug Messages
4270: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4271: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4272: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
4273: RAISE FND_API.G_EXC_ERROR;
4274: END IF;
4275:
4276: IF (l_pt_del_qty + l_rcvd_qty) >= l_line_del_qty THEN
4277: Debug(' Exiting the DEL loop',l_mod_name,1);

Line 4408: RAISE FND_API.G_EXC_ERROR;

4404: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
4405: fnd_message.set_token('TXN_ID',RCV.transaction_id);
4406: fnd_msg_pub.add;
4407: END IF;
4408: RAISE FND_API.G_EXC_ERROR;
4409: END;
4410: ELSE
4411: -- Non-Serialized Case but not lot controlled
4412: l_lot_num := NULL;

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

4538: p_activity_rec => l_activity_rec );
4539:
4540: -- Debug Messages
4541: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4542: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4543: Debug('LOG_ACTIVITY api failed ',l_mod_name,1);
4544: RAISE FND_API.G_EXC_ERROR;
4545: END IF;
4546:

Line 4544: RAISE FND_API.G_EXC_ERROR;

4540: -- Debug Messages
4541: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
4542: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4543: Debug('LOG_ACTIVITY api failed ',l_mod_name,1);
4544: RAISE FND_API.G_EXC_ERROR;
4545: END IF;
4546:
4547: IF l_pt_del_qty+ l_rcvd_qty >= l_line_qty THEN
4548: Debug(' exiting the RCV loop',l_mod_name,1);

Line 4566: --RAISE FND_API.G_EXC_ERROR;

4562: ROLLBACK TO RCV_LINES;
4563: Debug(' In Process error exception, exiting the loop',l_mod_name,1);
4564: -- In case of error, exit the loop. Commit the processed records
4565: -- and rollback the error record
4566: --RAISE FND_API.G_EXC_ERROR;
4567: x_return_status := FND_API.G_RET_STS_ERROR ;
4568: EXIT;
4569: END;
4570: END LOOP;

Line 4567: x_return_status := FND_API.G_RET_STS_ERROR ;

4563: Debug(' In Process error exception, exiting the loop',l_mod_name,1);
4564: -- In case of error, exit the loop. Commit the processed records
4565: -- and rollback the error record
4566: --RAISE FND_API.G_EXC_ERROR;
4567: x_return_status := FND_API.G_RET_STS_ERROR ;
4568: EXIT;
4569: END;
4570: END LOOP;
4571:

Line 4582: IF FND_API.To_Boolean( p_commit ) THEN

4578: END IF;
4579:
4580:
4581: -- Standard check of p_commit.
4582: IF FND_API.To_Boolean( p_commit ) THEN
4583: COMMIT WORK;
4584: END IF;
4585:
4586: -- Standard call to get message count and IF count is get message info.

Line 4591: WHEN FND_API.G_EXC_ERROR THEN

4587: FND_MSG_PUB.Count_And_Get
4588: (p_count => x_msg_count,
4589: p_data => x_msg_data);
4590: EXCEPTION
4591: WHEN FND_API.G_EXC_ERROR THEN
4592: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
4593: ROLLBACK TO IO_RCV_UPDATE;
4594: x_return_status := FND_API.G_RET_STS_ERROR ;
4595: FND_MSG_PUB.Count_And_Get

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

4588: (p_count => x_msg_count,
4589: p_data => x_msg_data);
4590: EXCEPTION
4591: WHEN FND_API.G_EXC_ERROR THEN
4592: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
4593: ROLLBACK TO IO_RCV_UPDATE;
4594: x_return_status := FND_API.G_RET_STS_ERROR ;
4595: FND_MSG_PUB.Count_And_Get
4596: (p_count => x_msg_count,

Line 4594: x_return_status := FND_API.G_RET_STS_ERROR ;

4590: EXCEPTION
4591: WHEN FND_API.G_EXC_ERROR THEN
4592: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
4593: ROLLBACK TO IO_RCV_UPDATE;
4594: x_return_status := FND_API.G_RET_STS_ERROR ;
4595: FND_MSG_PUB.Count_And_Get
4596: (p_count => x_msg_count,
4597: p_data => x_msg_data );
4598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4594: x_return_status := FND_API.G_RET_STS_ERROR ;
4595: FND_MSG_PUB.Count_And_Get
4596: (p_count => x_msg_count,
4597: p_data => x_msg_data );
4598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4599: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
4600: ROLLBACK TO IO_RCV_UPDATE;
4601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4602: FND_MSG_PUB.Count_And_Get

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

4595: FND_MSG_PUB.Count_And_Get
4596: (p_count => x_msg_count,
4597: p_data => x_msg_data );
4598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4599: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
4600: ROLLBACK TO IO_RCV_UPDATE;
4601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4602: FND_MSG_PUB.Count_And_Get
4603: ( p_count => x_msg_count,

Line 4601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4597: p_data => x_msg_data );
4598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4599: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
4600: ROLLBACK TO IO_RCV_UPDATE;
4601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4602: FND_MSG_PUB.Count_And_Get
4603: ( p_count => x_msg_count,
4604: p_data => x_msg_data );
4605: WHEN OTHERS THEN

Line 4608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4604: p_data => x_msg_data );
4605: WHEN OTHERS THEN
4606: Debug('In OTHERS exception',l_mod_name,4);
4607: ROLLBACK TO IO_RCV_UPDATE;
4608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4609: IF FND_MSG_PUB.Check_Msg_Level
4610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4611: THEN
4612: FND_MSG_PUB.Add_Exc_Msg

Line 4840: x_return_status := FND_API.G_RET_STS_SUCCESS;

4836: -- Standard Start of API savepoint
4837: SAVEPOINT IO_RCV_UPDATE_MOVE_OUT;
4838:
4839: -- Initialize API return status to success
4840: x_return_status := FND_API.G_RET_STS_SUCCESS;
4841:
4842: -- Debug messages
4843: Debug('Beginning of IO_RCV_UPDATE_MOVE_OUT',l_mod_name,1);
4844: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);

Line 4847: IF NOT FND_API.Compatible_API_Call (l_api_version,

4843: Debug('Beginning of IO_RCV_UPDATE_MOVE_OUT',l_mod_name,1);
4844: Debug('Order Header Id='||to_char(p_order_header_id),l_mod_name,1);
4845:
4846: -- Standard call to check for call compatibility.
4847: IF NOT FND_API.Compatible_API_Call (l_api_version,
4848: p_api_version,
4849: l_api_name ,
4850: G_PKG_NAME )
4851: THEN

Line 4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4848: p_api_version,
4849: l_api_name ,
4850: G_PKG_NAME )
4851: THEN
4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4853: END IF;
4854:
4855: -- Initialize message list if p_init_msg_list is set to TRUE.
4856: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4856: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4853: END IF;
4854:
4855: -- Initialize message list if p_init_msg_list is set to TRUE.
4856: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4857: FND_MSG_PUB.initialize;
4858: END IF;
4859:
4860: -- Api body starts

Line 4889: RAISE FND_API.G_EXC_ERROR;

4885: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
4886: fnd_message.set_token('HEADER_ID',p_order_header_id);
4887: fnd_msg_pub.add;
4888: END IF;
4889: RAISE FND_API.G_EXC_ERROR;
4890: END;
4891: END IF;
4892:
4893:

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

5051: p_activity_rec => l_activity_rec );
5052:
5053: -- Debug Messages
5054: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5055: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5056: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5057: RAISE FND_API.G_EXC_ERROR;
5058: END IF;
5059:

Line 5057: RAISE FND_API.G_EXC_ERROR;

5053: -- Debug Messages
5054: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5055: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5056: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5057: RAISE FND_API.G_EXC_ERROR;
5058: END IF;
5059:
5060: -- Check if there are "DELIVER" txn lines against the accept lines
5061: -- If found, then process the deliver lines also

Line 5181: RAISE FND_API.G_EXC_ERROR;

5177: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5178: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5179: fnd_msg_pub.add;
5180: END IF;
5181: RAISE FND_API.G_EXC_ERROR;
5182: END;
5183: ELSE
5184: l_lot_num := NULL;
5185: END IF;

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

5318: p_activity_rec => l_activity_rec );
5319:
5320: -- Debug Messages
5321: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5322: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5323: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5324: RAISE FND_API.G_EXC_ERROR;
5325: END IF;
5326:

Line 5324: RAISE FND_API.G_EXC_ERROR;

5320: -- Debug Messages
5321: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5322: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5323: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5324: RAISE FND_API.G_EXC_ERROR;
5325: END IF;
5326:
5327: IF (l_pt_del_qty + l_rcvd_qty) >= l_line_del_qty THEN
5328: Debug(' Exiting the DEL loop',l_mod_name,1);

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

5424: p_activity_rec => l_activity_rec );
5425:
5426: -- Debug Messages
5427: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5428: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5429: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5430: RAISE FND_API.G_EXC_ERROR;
5431: END IF;
5432:

Line 5430: RAISE FND_API.G_EXC_ERROR;

5426: -- Debug Messages
5427: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5428: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5429: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5430: RAISE FND_API.G_EXC_ERROR;
5431: END IF;
5432:
5433: -- Check if there are "DELIVER" txn lines against the reject lines
5434: -- If found, then process the deliver lines also

Line 5554: RAISE FND_API.G_EXC_ERROR;

5550: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5551: fnd_message.set_token('TXN_ID',DEL.transaction_id);
5552: fnd_msg_pub.add;
5553: END IF;
5554: RAISE FND_API.G_EXC_ERROR;
5555: END;
5556: ELSE
5557: l_lot_num := NULL;
5558: END IF;

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

5693: p_activity_rec => l_activity_rec );
5694:
5695: -- Debug Messages
5696: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5697: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5698: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5699: RAISE FND_API.G_EXC_ERROR;
5700: END IF;
5701:

Line 5699: RAISE FND_API.G_EXC_ERROR;

5695: -- Debug Messages
5696: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5697: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5698: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
5699: RAISE FND_API.G_EXC_ERROR;
5700: END IF;
5701:
5702: IF (l_pt_del_qty + l_rcvd_qty) >= l_line_del_qty THEN
5703: Debug(' Exiting the DEL loop',l_mod_name,1);

Line 5842: RAISE FND_API.G_EXC_ERROR;

5838: fnd_message.set_name('CSD','CSD_INV_TXN_ID');
5839: fnd_message.set_token('TXN_ID',RCV.transaction_id);
5840: fnd_msg_pub.add;
5841: END IF;
5842: RAISE FND_API.G_EXC_ERROR;
5843: END;
5844: ELSE
5845: -- Non-Serialized Case but not lot controlled
5846: l_lot_num := NULL;

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

5977: p_activity_rec => l_activity_rec );
5978:
5979: -- Debug Messages
5980: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5981: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5982: Debug('LOG_ACTIVITY api failed ',l_mod_name,1);
5983: RAISE FND_API.G_EXC_ERROR;
5984: END IF;
5985:

Line 5983: RAISE FND_API.G_EXC_ERROR;

5979: -- Debug Messages
5980: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
5981: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5982: Debug('LOG_ACTIVITY api failed ',l_mod_name,1);
5983: RAISE FND_API.G_EXC_ERROR;
5984: END IF;
5985:
5986: IF l_pt_del_qty+ l_rcvd_qty >= l_line_qty THEN
5987: Debug(' exiting the RCV loop',l_mod_name,1);

Line 6005: --RAISE FND_API.G_EXC_ERROR;

6001: ROLLBACK TO RCV_LINES;
6002: Debug(' In Process error exception, exiting the loop',l_mod_name,1);
6003: -- In case of error, exit the loop. Commit the processed records
6004: -- and rollback the error record
6005: --RAISE FND_API.G_EXC_ERROR;
6006: x_return_status := FND_API.G_RET_STS_ERROR ;
6007: EXIT;
6008: END;
6009: END LOOP;

Line 6006: x_return_status := FND_API.G_RET_STS_ERROR ;

6002: Debug(' In Process error exception, exiting the loop',l_mod_name,1);
6003: -- In case of error, exit the loop. Commit the processed records
6004: -- and rollback the error record
6005: --RAISE FND_API.G_EXC_ERROR;
6006: x_return_status := FND_API.G_RET_STS_ERROR ;
6007: EXIT;
6008: END;
6009: END LOOP;
6010:

Line 6021: IF FND_API.To_Boolean( p_commit ) THEN

6017: END IF;
6018:
6019:
6020: -- Standard check of p_commit.
6021: IF FND_API.To_Boolean( p_commit ) THEN
6022: COMMIT WORK;
6023: END IF;
6024:
6025: -- Standard call to get message count and IF count is get message info.

Line 6030: WHEN FND_API.G_EXC_ERROR THEN

6026: FND_MSG_PUB.Count_And_Get
6027: (p_count => x_msg_count,
6028: p_data => x_msg_data);
6029: EXCEPTION
6030: WHEN FND_API.G_EXC_ERROR THEN
6031: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
6032: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
6033: x_return_status := FND_API.G_RET_STS_ERROR ;
6034: FND_MSG_PUB.Count_And_Get

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

6027: (p_count => x_msg_count,
6028: p_data => x_msg_data);
6029: EXCEPTION
6030: WHEN FND_API.G_EXC_ERROR THEN
6031: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
6032: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
6033: x_return_status := FND_API.G_RET_STS_ERROR ;
6034: FND_MSG_PUB.Count_And_Get
6035: (p_count => x_msg_count,

Line 6033: x_return_status := FND_API.G_RET_STS_ERROR ;

6029: EXCEPTION
6030: WHEN FND_API.G_EXC_ERROR THEN
6031: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
6032: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
6033: x_return_status := FND_API.G_RET_STS_ERROR ;
6034: FND_MSG_PUB.Count_And_Get
6035: (p_count => x_msg_count,
6036: p_data => x_msg_data );
6037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6033: x_return_status := FND_API.G_RET_STS_ERROR ;
6034: FND_MSG_PUB.Count_And_Get
6035: (p_count => x_msg_count,
6036: p_data => x_msg_data );
6037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6038: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
6039: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
6040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6041: FND_MSG_PUB.Count_And_Get

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

6034: FND_MSG_PUB.Count_And_Get
6035: (p_count => x_msg_count,
6036: p_data => x_msg_data );
6037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6038: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
6039: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
6040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6041: FND_MSG_PUB.Count_And_Get
6042: ( p_count => x_msg_count,

Line 6040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6036: p_data => x_msg_data );
6037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6038: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
6039: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
6040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6041: FND_MSG_PUB.Count_And_Get
6042: ( p_count => x_msg_count,
6043: p_data => x_msg_data );
6044: WHEN OTHERS THEN

Line 6047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6043: p_data => x_msg_data );
6044: WHEN OTHERS THEN
6045: Debug('In OTHERS exception',l_mod_name,4);
6046: ROLLBACK TO IO_RCV_UPDATE_MOVE_OUT;
6047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6048: IF FND_MSG_PUB.Check_Msg_Level
6049: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6050: THEN
6051: FND_MSG_PUB.Add_Exc_Msg

Line 6121: x_return_status := FND_API.G_RET_STS_SUCCESS;

6117: -- Standard Start of API savepoint
6118: SAVEPOINT SHIP_UPDATE;
6119:
6120: -- Initialize API return status to success
6121: x_return_status := FND_API.G_RET_STS_SUCCESS;
6122:
6123: -- Log the api name in the log file
6124: Debug('At the Beginning of shipment Update ',l_mod_name,1);
6125: Debug('p_internal_order_flag ='||p_internal_order_flag,l_mod_name,1);

Line 6130: IF NOT FND_API.Compatible_API_Call (l_api_version,

6126: Debug('p_order_header_id ='||p_order_header_id,l_mod_name,1);
6127: Debug('p_repair_line_id ='||p_repair_line_id,l_mod_name,1);
6128:
6129: -- Standard call to check for call compatibility.
6130: IF NOT FND_API.Compatible_API_Call (l_api_version,
6131: p_api_version,
6132: l_api_name ,
6133: G_PKG_NAME )
6134: THEN

Line 6135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6131: p_api_version,
6132: l_api_name ,
6133: G_PKG_NAME )
6134: THEN
6135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6136: END IF;
6137:
6138: -- Initialize message list if p_init_msg_list is set to TRUE.
6139: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 6139: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6136: END IF;
6137:
6138: -- Initialize message list if p_init_msg_list is set to TRUE.
6139: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6140: FND_MSG_PUB.initialize;
6141: END IF;
6142:
6143: -- Api body starts

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

6154: x_msg_data => x_msg_data ,
6155: p_order_header_id => p_order_header_id);
6156:
6157: Debug('Return status from IO_SHIP_UPDATE '||x_return_status,l_mod_name,2);
6158: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6159: Debug('IO_SHIP_UPDATE failed ',l_mod_name,4);
6160: RAISE FND_API.G_EXC_ERROR;
6161: END IF;
6162:

Line 6160: RAISE FND_API.G_EXC_ERROR;

6156:
6157: Debug('Return status from IO_SHIP_UPDATE '||x_return_status,l_mod_name,2);
6158: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6159: Debug('IO_SHIP_UPDATE failed ',l_mod_name,4);
6160: RAISE FND_API.G_EXC_ERROR;
6161: END IF;
6162:
6163: /*Fixed for bug#5564180/FP#5845995
6164: Call to API IO_RCV_UPDATE_MOVE_OUT is added so that

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

6179: p_order_header_id => p_order_header_id );
6180:
6181: -- Debug messages
6182: Debug('Return Status from IO_RCV_UPDATE_MOVE_OUT :'||x_return_status,l_mod_name,2);
6183: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6184: Debug('IO_RCV_UPDATE_MOVE_OUT failed',l_mod_name,4);
6185: RAISE FND_API.G_EXC_ERROR;
6186: END IF;
6187:

Line 6185: RAISE FND_API.G_EXC_ERROR;

6181: -- Debug messages
6182: Debug('Return Status from IO_RCV_UPDATE_MOVE_OUT :'||x_return_status,l_mod_name,2);
6183: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6184: Debug('IO_RCV_UPDATE_MOVE_OUT failed',l_mod_name,4);
6185: RAISE FND_API.G_EXC_ERROR;
6186: END IF;
6187:
6188:
6189: Else

Line 6221: l_msg_data_warning := l_msg_data_warning ||' : '||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

6217: l_msg_data_warning := null;
6218: -- Concatenate the message from the message stack
6219: IF x_msg_count >= 1 then
6220: FOR i IN 1..x_msg_count LOOP
6221: l_msg_data_warning := l_msg_data_warning ||' : '||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
6222: Debug('l_msg_data_warning loop :'||l_msg_data_warning,l_mod_name,2);
6223: END LOOP ;
6224: END IF ;
6225: Debug(l_msg_data_warning,l_mod_name,4);

Line 6227: ELSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6223: END LOOP ;
6224: END IF ;
6225: Debug(l_msg_data_warning,l_mod_name,4);
6226: */
6227: ELSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6228: Debug('SO_SHIP_UPDATE failed ',l_mod_name,4);
6229: RAISE FND_API.G_EXC_ERROR;
6230: END IF;
6231:

Line 6229: RAISE FND_API.G_EXC_ERROR;

6225: Debug(l_msg_data_warning,l_mod_name,4);
6226: */
6227: ELSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6228: Debug('SO_SHIP_UPDATE failed ',l_mod_name,4);
6229: RAISE FND_API.G_EXC_ERROR;
6230: END IF;
6231:
6232: End If;
6233:

Line 6235: IF FND_API.To_Boolean( p_commit ) THEN

6231:
6232: End If;
6233:
6234: -- Standard check of p_commit.
6235: IF FND_API.To_Boolean( p_commit ) THEN
6236: COMMIT WORK;
6237: END IF;
6238:
6239: -- Standard call to get message count and IF count is get message info.

Line 6253: WHEN FND_API.G_EXC_ERROR THEN

6249: -- x_msg_data := l_msg_data_warning; -- swai: bug 12547701
6250: END IF;
6251:
6252: EXCEPTION
6253: WHEN FND_API.G_EXC_ERROR THEN
6254: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
6255: -- As we commit the processed records in the inner APIs
6256: -- so we rollback only if the p_commit= 'F'
6257: IF NOT(FND_API.To_Boolean( p_commit )) THEN

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

6250: END IF;
6251:
6252: EXCEPTION
6253: WHEN FND_API.G_EXC_ERROR THEN
6254: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
6255: -- As we commit the processed records in the inner APIs
6256: -- so we rollback only if the p_commit= 'F'
6257: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6258: ROLLBACK TO SHIP_UPDATE;

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

6253: WHEN FND_API.G_EXC_ERROR THEN
6254: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
6255: -- As we commit the processed records in the inner APIs
6256: -- so we rollback only if the p_commit= 'F'
6257: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6258: ROLLBACK TO SHIP_UPDATE;
6259: END IF;
6260: x_return_status := FND_API.G_RET_STS_ERROR ;
6261: FND_MSG_PUB.Count_And_Get

Line 6260: x_return_status := FND_API.G_RET_STS_ERROR ;

6256: -- so we rollback only if the p_commit= 'F'
6257: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6258: ROLLBACK TO SHIP_UPDATE;
6259: END IF;
6260: x_return_status := FND_API.G_RET_STS_ERROR ;
6261: FND_MSG_PUB.Count_And_Get
6262: (p_count => x_msg_count,
6263: p_data => x_msg_data );
6264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6260: x_return_status := FND_API.G_RET_STS_ERROR ;
6261: FND_MSG_PUB.Count_And_Get
6262: (p_count => x_msg_count,
6263: p_data => x_msg_data );
6264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6265: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
6266: IF ( l_error_level >= G_debug_level) THEN
6267: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6268: fnd_message.set_token('SQLERRM',SQLERRM);

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

6261: FND_MSG_PUB.Count_And_Get
6262: (p_count => x_msg_count,
6263: p_data => x_msg_data );
6264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6265: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
6266: IF ( l_error_level >= G_debug_level) THEN
6267: fnd_message.set_name('CSD','CSD_SQL_ERROR');
6268: fnd_message.set_token('SQLERRM',SQLERRM);
6269: fnd_message.set_token('SQLCODE',SQLCODE);

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

6270: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6271: END If;
6272: -- As we commit the processed records in the inner APIs
6273: -- so we rollback only if the p_commit= 'F'
6274: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6275: ROLLBACK TO SHIP_UPDATE;
6276: END IF;
6277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6278: FND_MSG_PUB.Count_And_Get

Line 6277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6273: -- so we rollback only if the p_commit= 'F'
6274: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6275: ROLLBACK TO SHIP_UPDATE;
6276: END IF;
6277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6278: FND_MSG_PUB.Count_And_Get
6279: ( p_count => x_msg_count,
6280: p_data => x_msg_data );
6281: WHEN OTHERS THEN

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

6287: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
6288: END If;
6289: -- As we commit the processed records in the inner APIs
6290: -- so we rollback only if the p_commit= 'F'
6291: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6292: ROLLBACK TO SHIP_UPDATE;
6293: END IF;
6294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6295: IF FND_MSG_PUB.Check_Msg_Level

Line 6294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6290: -- so we rollback only if the p_commit= 'F'
6291: IF NOT(FND_API.To_Boolean( p_commit )) THEN
6292: ROLLBACK TO SHIP_UPDATE;
6293: END IF;
6294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6295: IF FND_MSG_PUB.Check_Msg_Level
6296: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6297: THEN
6298: FND_MSG_PUB.Add_Exc_Msg

Line 6646: x_return_status := FND_API.G_RET_STS_SUCCESS;

6642: -- Standard Start of API savepoint
6643: SAVEPOINT SO_SHIP_UPDATE;
6644:
6645: -- Initialize API return status to success
6646: x_return_status := FND_API.G_RET_STS_SUCCESS;
6647: l_flag := 0; -- bug#7572853
6648:
6649: -- Debug messages
6650: Debug('At the Beginning of ship Update ',l_mod_name,1);

Line 6654: IF NOT FND_API.Compatible_API_Call (l_api_version,

6650: Debug('At the Beginning of ship Update ',l_mod_name,1);
6651: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);
6652:
6653: -- Standard call to check for call compatibility.
6654: IF NOT FND_API.Compatible_API_Call (l_api_version,
6655: p_api_version,
6656: l_api_name ,
6657: G_PKG_NAME )
6658: THEN

Line 6659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6655: p_api_version,
6656: l_api_name ,
6657: G_PKG_NAME )
6658: THEN
6659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6660: END IF;
6661:
6662: -- Initialize message list if p_init_msg_list is set to TRUE.
6663: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 6663: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6660: END IF;
6661:
6662: -- Initialize message list if p_init_msg_list is set to TRUE.
6663: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6664: FND_MSG_PUB.initialize;
6665: END IF;
6666:
6667: -- Api body starts

Line 6673: RAISE FND_API.G_EXC_ERROR;

6669: -- Validate the repair line id
6670: -- bugfix 4423818 : We need to validate only if p_repair_line_id is NOT NULL
6671: IF(p_repair_line_id is NOT NULL ) THEN
6672: IF NOT(csd_process_util.validate_rep_line_id(p_repair_line_id)) THEN
6673: RAISE FND_API.G_EXC_ERROR;
6674: END IF;
6675: END IF;
6676:
6677: --Bug#6779806

Line 6823: RAISE FND_API.G_EXC_ERROR;

6819: ELSE
6820: fnd_message.set_name('CSD','CSD_INVALID_INVENTORY_ITEM');
6821: fnd_msg_pub.add;
6822: END IF;
6823: RAISE FND_API.G_EXC_ERROR;
6824: End;
6825:
6826: IF l_srl_ctl_code in (2,5,6) THEN
6827: Debug('Item is Serialized',l_mod_name,1);

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

6869: p_activity_rec => l_activity_rec );
6870:
6871: -- Debug Messages
6872: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
6873: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6874: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
6875: RAISE FND_API.G_EXC_ERROR;
6876: END IF;
6877:

Line 6875: RAISE FND_API.G_EXC_ERROR;

6871: -- Debug Messages
6872: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
6873: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6874: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
6875: RAISE FND_API.G_EXC_ERROR;
6876: END IF;
6877:
6878: END IF; -- end of serial number mismatch
6879:

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

6895: ,x_result_quantity => l_result_ship_qty);
6896:
6897: -- Debug messages
6898: Debug('Return Status from CONVERT_TO_RO_uom :'||x_return_status,l_mod_name,2);
6899: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6900: Debug('CONVERT_TO_RO_uom api failed ',l_mod_name,4);
6901: RAISE FND_API.G_EXC_ERROR;
6902: END IF;
6903: ELSE

Line 6901: RAISE FND_API.G_EXC_ERROR;

6897: -- Debug messages
6898: Debug('Return Status from CONVERT_TO_RO_uom :'||x_return_status,l_mod_name,2);
6899: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6900: Debug('CONVERT_TO_RO_uom api failed ',l_mod_name,4);
6901: RAISE FND_API.G_EXC_ERROR;
6902: END IF;
6903: ELSE
6904: l_result_ship_qty := I.shipped_quantity;
6905: END IF;

Line 6927: RAISE FND_API.G_EXC_ERROR;

6923: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');
6924: fnd_message.set_token('REPAIR_LINE_ID',I.repair_line_id);
6925: fnd_msg_pub.add;
6926: END IF;
6927: RAISE FND_API.G_EXC_ERROR;
6928: END IF;
6929: END IF;
6930:
6931:

Line 6967: RAISE FND_API.G_EXC_ERROR;

6963:
6964: --bug#8261344
6965: -- swai: bug 12547701 changed if statement
6966: IF(NVL(fnd_profile.value('CSD_LOGISTICS_PROGRAM_ERROR'), 'S') = 'S') THEN
6967: RAISE FND_API.G_EXC_ERROR;
6968: else
6969: -- RAISE FND_API.G_EXC_ERROR;
6970: l_skip_record := TRUE;
6971: l_warning_return := TRUE;

Line 6969: -- RAISE FND_API.G_EXC_ERROR;

6965: -- swai: bug 12547701 changed if statement
6966: IF(NVL(fnd_profile.value('CSD_LOGISTICS_PROGRAM_ERROR'), 'S') = 'S') THEN
6967: RAISE FND_API.G_EXC_ERROR;
6968: else
6969: -- RAISE FND_API.G_EXC_ERROR;
6970: l_skip_record := TRUE;
6971: l_warning_return := TRUE;
6972: end if;
6973: Debug(' Could not find any IB instance for the Serial Num ='||I.shipped_serial_num, l_mod_name,1);

Line 6988: RAISE FND_API.G_EXC_ERROR;

6984: fnd_message.set_token('SERIAL_NUM',I.shipped_serial_num);
6985: fnd_msg_pub.add;
6986: fnd_file.put_line(fnd_file.log, fnd_message.get);
6987: END IF;
6988: RAISE FND_API.G_EXC_ERROR;
6989: End;
6990:
6991: --bug#6779806
6992: ELSIF (nvl(l_ib_flag,'N') = 'Y') THEN

Line 7033: RAISE FND_API.G_EXC_ERROR;

7029: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');
7030: fnd_message.set_token('PROD_TXN_ID',I.product_transaction_id);
7031: fnd_msg_pub.add;
7032: END IF;
7033: RAISE FND_API.G_EXC_ERROR;
7034: END IF;
7035:
7036: -- Updating the product txn with the status
7037: -- if the line qty is fully rcvd

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

7062: );
7063: -- Debug Messages
7064: Debug('after call POST_UPDATE_PROD_TXN l_flag '||l_flag,l_mod_name,2);
7065: Debug('Return Status from CSD_UPDATE_SHIP_PROGRAM_CUHK:'||x_return_status,l_mod_name,2);
7066: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7067: Debug('POST_UPDATE_PROD_TXN api failed ',l_mod_name,4);
7068: RAISE FND_API.G_EXC_ERROR;
7069: END IF;
7070:

Line 7068: RAISE FND_API.G_EXC_ERROR;

7064: Debug('after call POST_UPDATE_PROD_TXN l_flag '||l_flag,l_mod_name,2);
7065: Debug('Return Status from CSD_UPDATE_SHIP_PROGRAM_CUHK:'||x_return_status,l_mod_name,2);
7066: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7067: Debug('POST_UPDATE_PROD_TXN api failed ',l_mod_name,4);
7068: RAISE FND_API.G_EXC_ERROR;
7069: END IF;
7070:
7071: Debug('l_flag '||l_flag,l_mod_name,2);
7072:

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

7119: p_activity_rec => l_activity_rec );
7120:
7121: -- Debug Messages
7122: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
7123: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7124: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
7125: RAISE FND_API.G_EXC_ERROR;
7126: END IF;
7127:

Line 7125: RAISE FND_API.G_EXC_ERROR;

7121: -- Debug Messages
7122: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
7123: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7124: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
7125: RAISE FND_API.G_EXC_ERROR;
7126: END IF;
7127:
7128: END IF;
7129: end if; --end if (l_flag = ) Bug 7572853

Line 7136: WHEN FND_API.G_EXC_ERROR THEN

7132:
7133: End if; --end If (I.date_shipped is not null) --bug#7285024
7134:
7135: EXCEPTION
7136: WHEN FND_API.G_EXC_ERROR THEN
7137: Debug('In FND_API.G_EXC_ERROR EXCEPTION',l_mod_name,4);
7138: ROLLBACK TO SHIPMENT_LINES;
7139: -- In case of error, exit the loop. Commit the processed records
7140: -- and rollback the error record

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

7133: End if; --end If (I.date_shipped is not null) --bug#7285024
7134:
7135: EXCEPTION
7136: WHEN FND_API.G_EXC_ERROR THEN
7137: Debug('In FND_API.G_EXC_ERROR EXCEPTION',l_mod_name,4);
7138: ROLLBACK TO SHIPMENT_LINES;
7139: -- In case of error, exit the loop. Commit the processed records
7140: -- and rollback the error record
7141: --RAISE FND_API.G_EXC_ERROR;

Line 7141: --RAISE FND_API.G_EXC_ERROR;

7137: Debug('In FND_API.G_EXC_ERROR EXCEPTION',l_mod_name,4);
7138: ROLLBACK TO SHIPMENT_LINES;
7139: -- In case of error, exit the loop. Commit the processed records
7140: -- and rollback the error record
7141: --RAISE FND_API.G_EXC_ERROR;
7142: x_return_status := FND_API.G_RET_STS_ERROR ;
7143: EXIT;
7144: END;
7145: -- Commit for every 500 records

Line 7142: x_return_status := FND_API.G_RET_STS_ERROR ;

7138: ROLLBACK TO SHIPMENT_LINES;
7139: -- In case of error, exit the loop. Commit the processed records
7140: -- and rollback the error record
7141: --RAISE FND_API.G_EXC_ERROR;
7142: x_return_status := FND_API.G_RET_STS_ERROR ;
7143: EXIT;
7144: END;
7145: -- Commit for every 500 records
7146: -- one should COMMIT less frequently within a PL/SQL loop to

Line 7154: IF FND_API.To_Boolean( p_commit ) THEN

7150: If NOT(l_skip_record) Then
7151: l_total_records := l_total_records + 1;
7152: end if;
7153: IF mod(l_total_records, l_commit_size) = 0 THEN -- Commit every 500 records
7154: IF FND_API.To_Boolean( p_commit ) THEN
7155: COMMIT WORK;
7156: END IF;
7157: END IF;
7158:

Line 7202: IF FND_API.To_Boolean( p_commit ) THEN

7198: fnd_file.put_line(fnd_file.log,fnd_message.get);
7199: fnd_file.put_line(fnd_file.output,fnd_message.get);
7200:
7201: -- Standard check of p_commit.
7202: IF FND_API.To_Boolean( p_commit ) THEN
7203: COMMIT WORK;
7204: END IF;
7205:
7206: --bug#8261344

Line 7217: WHEN FND_API.G_EXC_ERROR THEN

7213: (p_count => x_msg_count,
7214: p_data => x_msg_data);
7215:
7216: EXCEPTION
7217: WHEN FND_API.G_EXC_ERROR THEN
7218: Debug('FND_API.G_EXC_ERROR Exception',l_mod_name,4);
7219: ROLLBACK TO SO_SHIP_UPDATE;
7220: x_return_status := FND_API.G_RET_STS_ERROR ;
7221: FND_MSG_PUB.Count_And_Get

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

7214: p_data => x_msg_data);
7215:
7216: EXCEPTION
7217: WHEN FND_API.G_EXC_ERROR THEN
7218: Debug('FND_API.G_EXC_ERROR Exception',l_mod_name,4);
7219: ROLLBACK TO SO_SHIP_UPDATE;
7220: x_return_status := FND_API.G_RET_STS_ERROR ;
7221: FND_MSG_PUB.Count_And_Get
7222: (p_count => x_msg_count,

Line 7220: x_return_status := FND_API.G_RET_STS_ERROR ;

7216: EXCEPTION
7217: WHEN FND_API.G_EXC_ERROR THEN
7218: Debug('FND_API.G_EXC_ERROR Exception',l_mod_name,4);
7219: ROLLBACK TO SO_SHIP_UPDATE;
7220: x_return_status := FND_API.G_RET_STS_ERROR ;
7221: FND_MSG_PUB.Count_And_Get
7222: (p_count => x_msg_count,
7223: p_data => x_msg_data );
7224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7220: x_return_status := FND_API.G_RET_STS_ERROR ;
7221: FND_MSG_PUB.Count_And_Get
7222: (p_count => x_msg_count,
7223: p_data => x_msg_data );
7224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7225: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
7226: ROLLBACK TO SO_SHIP_UPDATE;
7227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7228: FND_MSG_PUB.Count_And_Get

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

7221: FND_MSG_PUB.Count_And_Get
7222: (p_count => x_msg_count,
7223: p_data => x_msg_data );
7224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7225: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
7226: ROLLBACK TO SO_SHIP_UPDATE;
7227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7228: FND_MSG_PUB.Count_And_Get
7229: ( p_count => x_msg_count,

Line 7227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7223: p_data => x_msg_data );
7224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7225: Debug('FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
7226: ROLLBACK TO SO_SHIP_UPDATE;
7227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7228: FND_MSG_PUB.Count_And_Get
7229: ( p_count => x_msg_count,
7230: p_data => x_msg_data );
7231: WHEN OTHERS THEN

Line 7234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7230: p_data => x_msg_data );
7231: WHEN OTHERS THEN
7232: Debug('OTHERS Exception',l_mod_name,4);
7233: ROLLBACK TO SO_SHIP_UPDATE;
7234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7235: IF FND_MSG_PUB.Check_Msg_Level
7236: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7237: THEN
7238: FND_MSG_PUB.Add_Exc_Msg

Line 7496: x_return_status := FND_API.G_RET_STS_SUCCESS;

7492: -- Standard Start of API savepoint
7493: SAVEPOINT IO_SHIP_UPDATE;
7494:
7495: -- Initialize API return status to success
7496: x_return_status := FND_API.G_RET_STS_SUCCESS;
7497:
7498: Debug('At the Beginning of IO_SHIP_UPDATE',l_mod_name,1 );
7499: Debug('Order Header Id ='||p_order_header_id,l_mod_name,1);
7500:

Line 7502: IF NOT FND_API.Compatible_API_Call (l_api_version,

7498: Debug('At the Beginning of IO_SHIP_UPDATE',l_mod_name,1 );
7499: Debug('Order Header Id ='||p_order_header_id,l_mod_name,1);
7500:
7501: -- Standard call to check for call compatibility.
7502: IF NOT FND_API.Compatible_API_Call (l_api_version,
7503: p_api_version,
7504: l_api_name ,
7505: G_PKG_NAME )
7506: THEN

Line 7507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7503: p_api_version,
7504: l_api_name ,
7505: G_PKG_NAME )
7506: THEN
7507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7508: END IF;
7509:
7510: -- Initialize message list if p_init_msg_list is set to TRUE.
7511: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 7511: IF FND_API.to_Boolean( p_init_msg_list ) THEN

7507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7508: END IF;
7509:
7510: -- Initialize message list if p_init_msg_list is set to TRUE.
7511: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7512: FND_MSG_PUB.initialize;
7513: END IF;
7514:
7515: -- Api body starts

Line 7542: RAISE FND_API.G_EXC_ERROR;

7538: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7539: fnd_message.set_token('HEADER_ID',p_order_header_id);
7540: fnd_msg_pub.add;
7541: END IF;
7542: RAISE FND_API.G_EXC_ERROR;
7543: END;
7544: END IF;
7545:
7546: --FOR DEL in DELIVERY_LINES(p_order_header_id)

Line 7591: RAISE FND_API.G_EXC_ERROR;

7587: fnd_message.set_name('CSD','CSD_INV_ORD_HEADER_ID');
7588: fnd_message.set_token('HEADER_ID',DEL.header_id);
7589: fnd_msg_pub.add;
7590: END IF;
7591: RAISE FND_API.G_EXC_ERROR;
7592: END;
7593:
7594: -- Debug messages
7595: Debug('l_action_type ='||l_action_type,l_mod_name,1);

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

8161:
8162: -- Debug Messages
8163: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8164:
8165: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8166: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8167: RAISE FND_API.G_EXC_ERROR;
8168: END IF;
8169:

Line 8167: RAISE FND_API.G_EXC_ERROR;

8163: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8164:
8165: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8166: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8167: RAISE FND_API.G_EXC_ERROR;
8168: END IF;
8169:
8170: END IF; -- end of del.released_status in ('c','i')
8171:

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

8439: p_activity_rec => l_activity_rec );
8440:
8441: -- Debug Messages
8442: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8443: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8444: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8445: RAISE FND_API.G_EXC_ERROR;
8446: END IF;
8447:

Line 8445: RAISE FND_API.G_EXC_ERROR;

8441: -- Debug Messages
8442: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8443: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8444: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8445: RAISE FND_API.G_EXC_ERROR;
8446: END IF;
8447:
8448: EXCEPTION
8449: WHEN PROCESS_ERROR THEN

Line 8451: RAISE FND_API.G_EXC_ERROR;

8447:
8448: EXCEPTION
8449: WHEN PROCESS_ERROR THEN
8450: Debug('Encountered PROCESS_ERROR exception in UT cursor',l_mod_name,1);
8451: RAISE FND_API.G_EXC_ERROR;
8452: WHEN SKIP_RECORD THEN
8453: Debug('Skipping record in UT cursor',l_mod_name,1);
8454: NULL;
8455: END;

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

8695: p_activity_rec => l_activity_rec );
8696:
8697: -- Debug Messages
8698: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8699: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8700: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8701: RAISE FND_API.G_EXC_ERROR;
8702: END IF;
8703:

Line 8701: RAISE FND_API.G_EXC_ERROR;

8697: -- Debug Messages
8698: Debug('Return Status from LOG_ACTIVITY:'||x_return_status,l_mod_name,2);
8699: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8700: Debug('LOG_ACTIVITY api failed ',l_mod_name,4);
8701: RAISE FND_API.G_EXC_ERROR;
8702: END IF;
8703:
8704: EXCEPTION
8705: WHEN PROCESS_ERROR THEN

Line 8707: RAISE FND_API.G_EXC_ERROR;

8703:
8704: EXCEPTION
8705: WHEN PROCESS_ERROR THEN
8706: Debug('Encountered PROCESS_ERROR exception in UT cursor',l_mod_name,1);
8707: RAISE FND_API.G_EXC_ERROR;
8708: WHEN SKIP_RECORD THEN
8709: Debug('Skipping record in UT cursor',l_mod_name,1);
8710: NULL;
8711: END;

Line 8723: RAISE FND_API.G_EXC_ERROR;

8719:
8720: EXCEPTION
8721: WHEN PROCESS_ERROR THEN
8722: Debug('Encountered PROCESS_ERROR exception in DELUT cursor',l_mod_name,1);
8723: RAISE FND_API.G_EXC_ERROR;
8724: WHEN SKIP_RECORD THEN
8725: NULL;
8726: WHEN OTHERS THEN
8727: Debug('Encountered OTHERS in DEL cursor',l_mod_name,1);

Line 8728: RAISE FND_API.G_EXC_ERROR;

8724: WHEN SKIP_RECORD THEN
8725: NULL;
8726: WHEN OTHERS THEN
8727: Debug('Encountered OTHERS in DEL cursor',l_mod_name,1);
8728: RAISE FND_API.G_EXC_ERROR;
8729: END;
8730: END LOOP;
8731:
8732: IF(DELIVERY_LINES_ALL%ISOPEN ) THEN

Line 8741: IF FND_API.To_Boolean( p_commit ) THEN

8737: END IF;
8738:
8739:
8740: -- Standard check of p_commit.
8741: IF FND_API.To_Boolean( p_commit ) THEN
8742: COMMIT WORK;
8743: END IF;
8744:
8745: -- Standard call to get message count and IF count is get message info.

Line 8751: WHEN FND_API.G_EXC_ERROR THEN

8747: (p_count => x_msg_count,
8748: p_data => x_msg_data);
8749:
8750: EXCEPTION
8751: WHEN FND_API.G_EXC_ERROR THEN
8752: ROLLBACK TO IO_SHIP_UPDATE;
8753: x_return_status := FND_API.G_RET_STS_ERROR ;
8754: FND_MSG_PUB.Count_And_Get
8755: (p_count => x_msg_count,

Line 8753: x_return_status := FND_API.G_RET_STS_ERROR ;

8749:
8750: EXCEPTION
8751: WHEN FND_API.G_EXC_ERROR THEN
8752: ROLLBACK TO IO_SHIP_UPDATE;
8753: x_return_status := FND_API.G_RET_STS_ERROR ;
8754: FND_MSG_PUB.Count_And_Get
8755: (p_count => x_msg_count,
8756: p_data => x_msg_data );
8757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8753: x_return_status := FND_API.G_RET_STS_ERROR ;
8754: FND_MSG_PUB.Count_And_Get
8755: (p_count => x_msg_count,
8756: p_data => x_msg_data );
8757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8758: ROLLBACK TO IO_SHIP_UPDATE;
8759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8760: FND_MSG_PUB.Count_And_Get
8761: ( p_count => x_msg_count,

Line 8759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8755: (p_count => x_msg_count,
8756: p_data => x_msg_data );
8757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8758: ROLLBACK TO IO_SHIP_UPDATE;
8759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8760: FND_MSG_PUB.Count_And_Get
8761: ( p_count => x_msg_count,
8762: p_data => x_msg_data );
8763: WHEN OTHERS THEN

Line 8765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8761: ( p_count => x_msg_count,
8762: p_data => x_msg_data );
8763: WHEN OTHERS THEN
8764: ROLLBACK TO IO_SHIP_UPDATE;
8765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8766: IF FND_MSG_PUB.Check_Msg_Level
8767: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8768: THEN
8769: FND_MSG_PUB.Add_Exc_Msg

Line 8834: x_return_status := FND_API.G_RET_STS_SUCCESS;

8830: -- Standard Start of API savepoint
8831: SAVEPOINT WIP_UPDATE;
8832:
8833: -- Initialize API return status to success
8834: x_return_status := FND_API.G_RET_STS_SUCCESS;
8835:
8836: -- Debug Messages
8837: Debug('At the Beginning of Wip_update ',l_mod_name,1);
8838: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);

Line 8841: IF NOT FND_API.Compatible_API_Call (l_api_version,

8837: Debug('At the Beginning of Wip_update ',l_mod_name,1);
8838: Debug('Repair Line Id ='||p_repair_line_id,l_mod_name,1);
8839:
8840: -- Standard call to check for call compatibility.
8841: IF NOT FND_API.Compatible_API_Call (l_api_version,
8842: p_api_version,
8843: l_api_name ,
8844: G_PKG_NAME )
8845: THEN

Line 8846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8842: p_api_version,
8843: l_api_name ,
8844: G_PKG_NAME )
8845: THEN
8846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8847: END IF;
8848:
8849: -- Initialize message list if p_init_msg_list is set to TRUE.
8850: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 8850: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8847: END IF;
8848:
8849: -- Initialize message list if p_init_msg_list is set to TRUE.
8850: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8851: FND_MSG_PUB.initialize;
8852: END IF;
8853:
8854: -- Api body starts

Line 8860: RAISE FND_API.G_EXC_ERROR;

8856: -- Validate the repair line id
8857: IF p_repair_line_id is not null THEN
8858: IF NOT(csd_process_util.validate_rep_line_id(p_repair_line_id)) THEN
8859: Debug('Validate_rep_line_id failed',l_mod_name,1);
8860: RAISE FND_API.G_EXC_ERROR;
8861: END IF;
8862: END IF;
8863:
8864: -- Debug messages

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

8876:
8877: -- Debug messages
8878: Debug('Return Status from JOB_CREATION_UPDATE :'||x_return_status,l_mod_name,2);
8879:
8880: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8881: -- Debug messages
8882: Debug(' JOB_CREATION_UPDATE failed ',l_mod_name,4);
8883: RAISE FND_API.G_EXC_ERROR;
8884: END IF;

Line 8883: RAISE FND_API.G_EXC_ERROR;

8879:
8880: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8881: -- Debug messages
8882: Debug(' JOB_CREATION_UPDATE failed ',l_mod_name,4);
8883: RAISE FND_API.G_EXC_ERROR;
8884: END IF;
8885:
8886: IF NVL(p_upd_job_completion,'Y') = 'Y' THEN
8887: -- Only if the update_job_completion is 'Y', then

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

8902:
8903: -- Debug messages
8904: Debug('Return Status from JOB_COMPLETION_UPDATE :'||x_return_status,l_mod_name,2);
8905:
8906: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8907: -- Debug messages
8908: Debug(' JOB_COMPLETION_UPDATE failed ',l_mod_name,4);
8909: RAISE FND_API.G_EXC_ERROR;
8910: END IF;

Line 8909: RAISE FND_API.G_EXC_ERROR;

8905:
8906: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8907: -- Debug messages
8908: Debug(' JOB_COMPLETION_UPDATE failed ',l_mod_name,4);
8909: RAISE FND_API.G_EXC_ERROR;
8910: END IF;
8911: END IF;
8912:
8913: -- Standard check of p_commit.

Line 8914: IF FND_API.To_Boolean( p_commit ) THEN

8910: END IF;
8911: END IF;
8912:
8913: -- Standard check of p_commit.
8914: IF FND_API.To_Boolean( p_commit ) THEN
8915: COMMIT WORK;
8916: END IF;
8917:
8918: -- Standard call to get message count and IF count is get message info.

Line 8923: WHEN FND_API.G_EXC_ERROR THEN

8919: FND_MSG_PUB.Count_And_Get
8920: (p_count => x_msg_count,
8921: p_data => x_msg_data);
8922: EXCEPTION
8923: WHEN FND_API.G_EXC_ERROR THEN
8924: Debug('In FND_API.G_EXC_ERROR Exception',l_mod_name,4);
8925: -- As we commit the processed records in the inner APIs
8926: -- so we rollback only if the p_commit = 'F'
8927: IF NOT(FND_API.To_Boolean( p_commit )) THEN

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

8920: (p_count => x_msg_count,
8921: p_data => x_msg_data);
8922: EXCEPTION
8923: WHEN FND_API.G_EXC_ERROR THEN
8924: Debug('In FND_API.G_EXC_ERROR Exception',l_mod_name,4);
8925: -- As we commit the processed records in the inner APIs
8926: -- so we rollback only if the p_commit = 'F'
8927: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8928: ROLLBACK TO WIP_UPDATE;

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

8923: WHEN FND_API.G_EXC_ERROR THEN
8924: Debug('In FND_API.G_EXC_ERROR Exception',l_mod_name,4);
8925: -- As we commit the processed records in the inner APIs
8926: -- so we rollback only if the p_commit = 'F'
8927: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8928: ROLLBACK TO WIP_UPDATE;
8929: END IF;
8930: x_return_status := FND_API.G_RET_STS_ERROR ;
8931: FND_MSG_PUB.Count_And_Get

Line 8930: x_return_status := FND_API.G_RET_STS_ERROR ;

8926: -- so we rollback only if the p_commit = 'F'
8927: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8928: ROLLBACK TO WIP_UPDATE;
8929: END IF;
8930: x_return_status := FND_API.G_RET_STS_ERROR ;
8931: FND_MSG_PUB.Count_And_Get
8932: (p_count => x_msg_count,
8933: p_data => x_msg_data );
8934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8930: x_return_status := FND_API.G_RET_STS_ERROR ;
8931: FND_MSG_PUB.Count_And_Get
8932: (p_count => x_msg_count,
8933: p_data => x_msg_data );
8934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8935: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
8936: IF ( l_error_level >= G_debug_level) THEN
8937: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8938: fnd_message.set_token('SQLERRM',SQLERRM);

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

8931: FND_MSG_PUB.Count_And_Get
8932: (p_count => x_msg_count,
8933: p_data => x_msg_data );
8934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8935: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
8936: IF ( l_error_level >= G_debug_level) THEN
8937: fnd_message.set_name('CSD','CSD_SQL_ERROR');
8938: fnd_message.set_token('SQLERRM',SQLERRM);
8939: fnd_message.set_token('SQLCODE',SQLCODE);

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

8940: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8941: END If;
8942: -- As we commit the processed records in the inner APIs
8943: -- so we rollback only if the p_commit = 'F'
8944: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8945: ROLLBACK TO WIP_UPDATE;
8946: END IF;
8947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8948: FND_MSG_PUB.Count_And_Get

Line 8947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8943: -- so we rollback only if the p_commit = 'F'
8944: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8945: ROLLBACK TO WIP_UPDATE;
8946: END IF;
8947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8948: FND_MSG_PUB.Count_And_Get
8949: ( p_count => x_msg_count,
8950: p_data => x_msg_data );
8951: WHEN OTHERS THEN

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

8957: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
8958: END If;
8959: -- As we commit the processed records in the inner APIs
8960: -- so we rollback only if the p_commit = 'F'
8961: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8962: ROLLBACK TO WIP_UPDATE;
8963: END IF;
8964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8965: IF FND_MSG_PUB.Check_Msg_Level

Line 8964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8960: -- so we rollback only if the p_commit = 'F'
8961: IF NOT(FND_API.To_Boolean( p_commit )) THEN
8962: ROLLBACK TO WIP_UPDATE;
8963: END IF;
8964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8965: IF FND_MSG_PUB.Check_Msg_Level
8966: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8967: THEN
8968: FND_MSG_PUB.Add_Exc_Msg

Line 9033: l_return_status := FND_API.G_RET_STS_SUCCESS;

9029: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.receipts_update_conc_prog';
9030:
9031: BEGIN
9032: -- Initialize API return status to success
9033: l_return_status := FND_API.G_RET_STS_SUCCESS;
9034:
9035: -- Initialize the error code and error buffer
9036: retcode := l_success_status;
9037: errbuf := '';

Line 9054: p_commit => FND_API.G_TRUE,

9050:
9051: -- Api body starts
9052: RECEIPTS_UPDATE
9053: ( p_api_version => l_api_version,
9054: p_commit => FND_API.G_TRUE,
9055: p_init_msg_list => FND_API.G_TRUE,
9056: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9057: x_return_status => l_return_status,
9058: x_msg_count => l_msg_count,

Line 9055: p_init_msg_list => FND_API.G_TRUE,

9051: -- Api body starts
9052: RECEIPTS_UPDATE
9053: ( p_api_version => l_api_version,
9054: p_commit => FND_API.G_TRUE,
9055: p_init_msg_list => FND_API.G_TRUE,
9056: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9057: x_return_status => l_return_status,
9058: x_msg_count => l_msg_count,
9059: x_msg_data => l_msg_data,

Line 9056: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9052: RECEIPTS_UPDATE
9053: ( p_api_version => l_api_version,
9054: p_commit => FND_API.G_TRUE,
9055: p_init_msg_list => FND_API.G_TRUE,
9056: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9057: x_return_status => l_return_status,
9058: x_msg_count => l_msg_count,
9059: x_msg_data => l_msg_data,
9060: p_internal_order_flag => l_internal_order_flag,

Line 9077: l_msg_text := FND_MSG_PUB.Get(i,FND_API.G_FALSE);

9073: -- Write the messages in the message stack to both log and output files
9074: -- Also concatenate the messages to l_msg_data
9075: IF l_msg_count > 1 then
9076: FOR i IN 1..l_msg_count LOOP
9077: l_msg_text := FND_MSG_PUB.Get(i,FND_API.G_FALSE);
9078: fnd_file.put_line(fnd_file.log,l_msg_text);
9079: fnd_file.put_line(fnd_file.output,l_msg_text);
9080: l_msg_data := l_msg_data||l_msg_text;
9081: END LOOP ;

Line 9094: ElSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

9090: ELSIF ((l_return_status = G_CSD_RET_STS_WARNING) AND
9091: (NVL(fnd_profile.value('CSD_LOGISTICS_PROGRAM_ERROR'), 'S') = 'A')) THEN
9092: retcode := l_warning_status;
9093: errbuf := l_msg_data;
9094: ElSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9095: -- swai: bug 12547701 no need to concatenate here since it was already done
9096: /*
9097: -- Concatenate the message from the message stack
9098: IF l_msg_count > 1 then

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

9096: /*
9097: -- Concatenate the message from the message stack
9098: IF l_msg_count > 1 then
9099: FOR i IN 1..l_msg_count LOOP
9100: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
9101: END LOOP ;
9102: END IF ;
9103: */
9104:

Line 9106: RAISE FND_API.G_EXC_ERROR;

9102: END IF ;
9103: */
9104:
9105: Debug(l_msg_data,l_mod_name,4);
9106: RAISE FND_API.G_EXC_ERROR;
9107: END IF;
9108:
9109: Exception
9110: WHEN FND_API.G_EXC_ERROR THEN

Line 9110: WHEN FND_API.G_EXC_ERROR THEN

9106: RAISE FND_API.G_EXC_ERROR;
9107: END IF;
9108:
9109: Exception
9110: WHEN FND_API.G_EXC_ERROR THEN
9111: retcode := l_error_status;
9112: errbuf := l_msg_data;
9113: WHEN Others then
9114: -- Handle others exception

Line 9167: l_return_status := FND_API.G_RET_STS_SUCCESS;

9163: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.wip_update_conc_prog';
9164:
9165: BEGIN
9166: -- Initialize API return status to success
9167: l_return_status := FND_API.G_RET_STS_SUCCESS;
9168:
9169: -- Initialize the error buffer and error code
9170: retcode := l_success_status;
9171: errbuf := '';

Line 9186: p_commit => FND_API.G_TRUE,

9182: -- then send the repair line Id. Else it will take all the
9183: -- unprocessed repair orders
9184: WIP_UPDATE
9185: ( p_api_version => l_api_version,
9186: p_commit => FND_API.G_TRUE,
9187: p_init_msg_list => FND_API.G_TRUE,
9188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9189: x_return_status => l_return_status,
9190: x_msg_count => l_msg_count,

Line 9187: p_init_msg_list => FND_API.G_TRUE,

9183: -- unprocessed repair orders
9184: WIP_UPDATE
9185: ( p_api_version => l_api_version,
9186: p_commit => FND_API.G_TRUE,
9187: p_init_msg_list => FND_API.G_TRUE,
9188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9189: x_return_status => l_return_status,
9190: x_msg_count => l_msg_count,
9191: x_msg_data => l_msg_data,

Line 9188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9184: WIP_UPDATE
9185: ( p_api_version => l_api_version,
9186: p_commit => FND_API.G_TRUE,
9187: p_init_msg_list => FND_API.G_TRUE,
9188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9189: x_return_status => l_return_status,
9190: x_msg_count => l_msg_count,
9191: x_msg_data => l_msg_data,
9192: p_upd_job_completion => p_upd_job_completion,

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

9195: -- Debug statement
9196: Debug('Return Status from WIP_UPDATE :'||l_return_status,l_mod_name,2);
9197:
9198: -- Raise error message if the API returns status <> 'S'
9199: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9200: IF l_msg_count > 1 then
9201: FOR i IN 1..l_msg_count LOOP
9202: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
9203: END LOOP ;

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

9198: -- Raise error message if the API returns status <> 'S'
9199: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9200: IF l_msg_count > 1 then
9201: FOR i IN 1..l_msg_count LOOP
9202: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
9203: END LOOP ;
9204: END IF ;
9205: Debug(l_msg_data,l_mod_name,4);
9206: RAISE FND_API.G_EXC_ERROR;

Line 9206: RAISE FND_API.G_EXC_ERROR;

9202: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
9203: END LOOP ;
9204: END IF ;
9205: Debug(l_msg_data,l_mod_name,4);
9206: RAISE FND_API.G_EXC_ERROR;
9207: END IF;
9208:
9209: Exception
9210: WHEN FND_API.G_EXC_ERROR THEN

Line 9210: WHEN FND_API.G_EXC_ERROR THEN

9206: RAISE FND_API.G_EXC_ERROR;
9207: END IF;
9208:
9209: Exception
9210: WHEN FND_API.G_EXC_ERROR THEN
9211: retcode := l_error_status;
9212: errbuf := l_msg_data;
9213: WHEN Others then
9214: -- Handle others exception

Line 9272: l_return_status := FND_API.G_RET_STS_SUCCESS;

9268: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.ship_update_conc_prog';
9269:
9270: Begin
9271: -- Initialize API return status to success
9272: l_return_status := FND_API.G_RET_STS_SUCCESS;
9273:
9274: -- Initialize the error message and error buffer
9275: retcode := l_success_status;
9276: errbuf := '';

Line 9293: p_commit => FND_API.G_TRUE,

9289: Debug('Calling SHIP_UPDATE ',l_mod_name,2);
9290:
9291: SHIP_UPDATE
9292: ( p_api_version => l_api_version,
9293: p_commit => FND_API.G_TRUE,
9294: p_init_msg_list => FND_API.G_TRUE,
9295: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9296: x_return_status => l_return_status,
9297: x_msg_count => l_msg_count,

Line 9294: p_init_msg_list => FND_API.G_TRUE,

9290:
9291: SHIP_UPDATE
9292: ( p_api_version => l_api_version,
9293: p_commit => FND_API.G_TRUE,
9294: p_init_msg_list => FND_API.G_TRUE,
9295: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9296: x_return_status => l_return_status,
9297: x_msg_count => l_msg_count,
9298: x_msg_data => l_msg_data,

Line 9295: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9291: SHIP_UPDATE
9292: ( p_api_version => l_api_version,
9293: p_commit => FND_API.G_TRUE,
9294: p_init_msg_list => FND_API.G_TRUE,
9295: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9296: x_return_status => l_return_status,
9297: x_msg_count => l_msg_count,
9298: x_msg_data => l_msg_data,
9299: p_internal_order_flag => l_internal_order_flag,

Line 9313: l_msg_text := FND_MSG_PUB.Get(i,FND_API.G_FALSE);

9309: -- Write the messages in the message stack to both log and output files
9310: -- Also concatenate the messages to l_msg_data
9311: IF l_msg_count > 1 then
9312: FOR i IN 1..l_msg_count LOOP
9313: l_msg_text := FND_MSG_PUB.Get(i,FND_API.G_FALSE);
9314: fnd_file.put_line(fnd_file.log,l_msg_text);
9315: fnd_file.put_line(fnd_file.output,l_msg_text);
9316: l_msg_data := l_msg_data||l_msg_text;
9317: END LOOP ;

Line 9330: ELSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

9326: ELSIF ((l_return_status = G_CSD_RET_STS_WARNING) AND
9327: (NVL(fnd_profile.value('CSD_LOGISTICS_PROGRAM_ERROR'), 'S') = 'A')) THEN
9328: retcode := l_warning_status;
9329: errbuf := l_msg_data;
9330: ELSIF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9331: -- swai: bug 12547701 no need to concatenate here since it was already done
9332: /*
9333: -- Concatenate the message from the message stack
9334: IF l_msg_count > 1 then

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

9332: /*
9333: -- Concatenate the message from the message stack
9334: IF l_msg_count > 1 then
9335: FOR i IN 1..l_msg_count LOOP
9336: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
9337: END LOOP ;
9338: END IF ;
9339: */
9340:

Line 9342: RAISE FND_API.G_EXC_ERROR ;

9338: END IF ;
9339: */
9340:
9341: Debug(l_msg_data,l_mod_name,4);
9342: RAISE FND_API.G_EXC_ERROR ;
9343: END IF;
9344: Exception
9345: WHEN FND_API.G_EXC_ERROR THEN
9346: retcode := l_error_status;

Line 9345: WHEN FND_API.G_EXC_ERROR THEN

9341: Debug(l_msg_data,l_mod_name,4);
9342: RAISE FND_API.G_EXC_ERROR ;
9343: END IF;
9344: Exception
9345: WHEN FND_API.G_EXC_ERROR THEN
9346: retcode := l_error_status;
9347: errbuf := l_msg_data;
9348: WHEN Others then
9349: -- Handle others exception

Line 9467: x_return_status := FND_API.G_RET_STS_SUCCESS;

9463:
9464: BEGIN
9465:
9466: -- Initialize API return status to success
9467: x_return_status := FND_API.G_RET_STS_SUCCESS;
9468:
9469: -- Initialize the error message and error buffer
9470: retcode := '0';
9471: errbuf := '';

Line 9558: p_init_msg_list => FND_API.G_FALSE,

9554: Debug('Calling Validate_And_Write ',l_mod_name,2);
9555:
9556: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
9557: (p_Api_Version_Number => l_api_version ,
9558: p_init_msg_list => FND_API.G_FALSE,
9559: p_commit => FND_API.G_FALSE,
9560: p_validation_level => NULL,
9561: p_action_code => 0,
9562: px_REPAIR_HISTORY_ID => l_repair_history_id,

Line 9559: p_commit => FND_API.G_FALSE,

9555:
9556: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
9557: (p_Api_Version_Number => l_api_version ,
9558: p_init_msg_list => FND_API.G_FALSE,
9559: p_commit => FND_API.G_FALSE,
9560: p_validation_level => NULL,
9561: p_action_code => 0,
9562: px_REPAIR_HISTORY_ID => l_repair_history_id,
9563: p_OBJECT_VERSION_NUMBER => null, -- travi ovn validation

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

9625: X_Msg_Data => x_msg_data
9626: );
9627:
9628: Debug('Return Status from Validate_And_Write :'||x_return_status,l_mod_name,2);
9629: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9630: -- Debug messages
9631: Debug(' JOB_COMPLETION_UPDATE failed ',l_mod_name,4);
9632: RAISE FND_API.G_EXC_ERROR;
9633: END IF;

Line 9632: RAISE FND_API.G_EXC_ERROR;

9628: Debug('Return Status from Validate_And_Write :'||x_return_status,l_mod_name,2);
9629: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9630: -- Debug messages
9631: Debug(' JOB_COMPLETION_UPDATE failed ',l_mod_name,4);
9632: RAISE FND_API.G_EXC_ERROR;
9633: END IF;
9634:
9635: -- -------------------
9636: -- Api body ends here

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

9641: end if; -- End of check for l_rep_hist_id
9642: end loop;
9643:
9644: -- Standard check of p_commit.
9645: IF FND_API.To_Boolean( FND_API.G_FALSE ) THEN
9646: COMMIT WORK;
9647: END IF;
9648:
9649: -- Standard call to get message count and IF count is get message info.

Line 9655: WHEN FND_API.G_EXC_ERROR THEN

9651: (p_count => x_msg_count,
9652: p_data => x_msg_data );
9653:
9654: EXCEPTION
9655: WHEN FND_API.G_EXC_ERROR THEN
9656: ROLLBACK TO Update_rep_task_hist;
9657: x_return_status := FND_API.G_RET_STS_ERROR ;
9658: FND_MSG_PUB.Count_And_Get
9659: (p_count => x_msg_count,

Line 9657: x_return_status := FND_API.G_RET_STS_ERROR ;

9653:
9654: EXCEPTION
9655: WHEN FND_API.G_EXC_ERROR THEN
9656: ROLLBACK TO Update_rep_task_hist;
9657: x_return_status := FND_API.G_RET_STS_ERROR ;
9658: FND_MSG_PUB.Count_And_Get
9659: (p_count => x_msg_count,
9660: p_data => x_msg_data );
9661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9657: x_return_status := FND_API.G_RET_STS_ERROR ;
9658: FND_MSG_PUB.Count_And_Get
9659: (p_count => x_msg_count,
9660: p_data => x_msg_data );
9661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9663: ROLLBACK TO Update_rep_task_hist;
9664: FND_MSG_PUB.Count_And_Get
9665: ( p_count => x_msg_count,

Line 9662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9658: FND_MSG_PUB.Count_And_Get
9659: (p_count => x_msg_count,
9660: p_data => x_msg_data );
9661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9663: ROLLBACK TO Update_rep_task_hist;
9664: FND_MSG_PUB.Count_And_Get
9665: ( p_count => x_msg_count,
9666: p_data => x_msg_data );

Line 9668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9664: FND_MSG_PUB.Count_And_Get
9665: ( p_count => x_msg_count,
9666: p_data => x_msg_data );
9667: WHEN OTHERS THEN
9668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9669: ROLLBACK TO Update_rep_task_hist;
9670: IF FND_MSG_PUB.Check_Msg_Level
9671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9672: THEN

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

9738: IF c_product_transaction_id%isopen then
9739: CLOSE c_product_transaction_id;
9740: END IF;
9741:
9742: if(p_commit = FND_API.G_TRUE) THEN
9743: commit;
9744: END IF;
9745: End;
9746:

Line 9818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9814: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
9815: WHERE PRODUCT_TRANSACTION_ID = l_product_txn_id;
9816: EXCEPTION
9817: WHEN OTHERS THEN
9818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9819: END;
9820: END LOOP;
9821:
9822: END check_for_cancelled_order;

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

9915: p_internal_order_flag => 'N',
9916: p_order_header_id => null,
9917: p_repair_line_id => l_orig_source_id);
9918:
9919: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9920: resultout := 'COMPLETE:ERROR';
9921: ELSE
9922: resultout := 'COMPLETE:SUCCESS';
9923: END IF;

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

9937: p_internal_order_flag => 'N' ,
9938: p_order_header_id => null,
9939: p_repair_line_id => l_orig_source_id);
9940:
9941: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9942: resultout := 'COMPLETE:ERROR';
9943: ELSE
9944: resultout := 'COMPLETE:SUCCESS';
9945: END IF;

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

9947: END IF;
9948:
9949: -- If the return status is error then raise
9950: -- the Business Event
9951: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
9952:
9953: CSD_REPAIRS_PVT.LAUNCH_WFEXCEPTION_BEVENT(
9954: p_return_status => l_return_status,
9955: p_msg_count => l_msg_count,