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_REPAIR_ACTUAL_PROCESS_PVT dependencies on FND_API

Line 135: x_warning_flag := FND_API.G_FALSE;

131: 'p_repair_type_id: ' || p_repair_type_id);
132: end if;
133:
134: -- Set the warning flag
135: x_warning_flag := FND_API.G_FALSE;
136:
137: if (lc_stat_level >= lc_debug_level) then
138: FND_LOG.STRING(lc_stat_level, lc_mod_name,
139: 'Before the FOR LOOP for C_Resource_Item_Not_Defined.');

Line 144: x_warning_flag := FND_API.G_TRUE;

140: end if;
141:
142: -- Simply gets all records and log warnings for each of them.
143: FOR i_rec IN C_Resource_Item_Not_Defined LOOP
144: x_warning_flag := FND_API.G_TRUE;
145: if (lc_stat_level >= lc_debug_level) then
146: FND_LOG.STRING(lc_stat_level, lc_mod_name,
147: 'The billing item is not defined for the Resource = ' || i_rec.RESOURCE_CODE);
148: end if;

Line 175: x_warning_flag := FND_API.G_TRUE;

171: FOR i_rec IN C_Resource_Item_In_Depot_Org LOOP
172:
173: IF i_rec.Quantity > 0 THEN
174: IF ( i_rec.DEPOT_ITEM_ID IS NULL ) THEN
175: x_warning_flag := FND_API.G_TRUE;
176: if (lc_stat_level >= lc_debug_level) then
177: FND_LOG.STRING(lc_stat_level, lc_mod_name,
178: 'The item ' || i_rec.WIP_ITEM_NAME || ' is not defined in the Service '
179: || 'Validation Organization. It is defined only in the WIP organization.');

Line 186: x_warning_flag := FND_API.G_TRUE;

182: -- 'The item $ITEM_NAME is not defined in the Service Validation Organization. It is defined only in the WIP organization.
183: FND_MESSAGE.set_token( 'ITEM_NAME', i_rec.WIP_ITEM_NAME );
184: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
185: ELSIF ( i_rec.BILLING_TYPE IS NULL ) THEN
186: x_warning_flag := FND_API.G_TRUE;
187: if (lc_stat_level >= lc_debug_level) then
188: FND_LOG.STRING(lc_stat_level, lc_mod_name,
189: 'Billing type is not defined for the item ' || i_rec.WIP_ITEM_NAME);
190: end if;

Line 213: x_warning_flag := FND_API.G_TRUE;

209:
210: -- Simply gets all records and log warnings for each of them.
211: FOR i_rec IN C_Resource_Txn_Billing_Type LOOP
212: IF i_rec.Quantity > 0 THEN
213: x_warning_flag := FND_API.G_TRUE;
214: if (lc_stat_level >= lc_debug_level) then
215: FND_LOG.STRING(lc_stat_level, lc_mod_name,
216: 'Unable to determine service activity billing type for the item ' || i_rec.DEPOT_ITEM_NAME);
217: end if;

Line 366: x_warning_flag := FND_API.G_FALSE;

362: 'p_repair_type_id: ' || p_repair_type_id);
363: end if;
364:
365: -- Set the warning flag
366: x_warning_flag := FND_API.G_FALSE;
367:
368: if (lc_stat_level >= lc_debug_level) then
369: FND_LOG.STRING(lc_stat_level, lc_mod_name,
370: 'Before the FOR LOOP for C_MTL_Item_In_Depot_Org.');

Line 387: x_warning_flag := FND_API.G_TRUE;

383: FND_LOG.STRING(lc_stat_level, lc_mod_name,
384: 'The item ' || i_rec.WIP_ITEM_NAME || ' is not defined in the Service '
385: || 'Validation Organization. It is defined only in the WIP organization.');
386: end if;
387: x_warning_flag := FND_API.G_TRUE;
388: FND_MESSAGE.set_name('CSD','CSD_ACT_ITEM_NOT_SRV_ORG');
389: -- The item $ITEM_NAME is not defined in the Service Validation Organization. It is defined only in the WIP organization.
390: FND_MESSAGE.set_token('ITEM_NAME', i_rec.WIP_ITEM_NAME);
391: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

Line 397: x_warning_flag := FND_API.G_TRUE;

393: if (lc_stat_level >= lc_debug_level) then
394: FND_LOG.STRING(lc_stat_level, lc_mod_name,
395: 'Billing type is not defined for the item ' || i_rec.WIP_ITEM_NAME);
396: end if;
397: x_warning_flag := FND_API.G_TRUE;
398: FND_MESSAGE.set_name('CSD','CSD_ACT_ITEM_NO_BILLING_TYPE');
399: -- '''Billing type'' is not defined for the item $ITEM_NAME.
400: FND_MESSAGE.set_token('ITEM_NAME', i_rec.WIP_ITEM_NAME);
401: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );

Line 419: x_warning_flag := FND_API.G_TRUE;

415:
416: -- Simply gets all records and log warnings for each of them.
417: FOR i_rec IN C_MTL_Txn_Billing_Type LOOP
418: IF i_rec.Quantity > 0 THEN
419: x_warning_flag := FND_API.G_TRUE;
420: if (lc_stat_level >= lc_debug_level) then
421: FND_LOG.STRING(lc_stat_level, lc_mod_name,
422: 'Unable to determine service activity billing type for the item ' || i_rec.DEPOT_ITEM_NAME);
423: end if;

Line 591: IF NOT FND_API.Compatible_API_Call (lc_api_version,

587: -- Standard start of API Savepoint
588: Savepoint Import_Actuals_Task_sp;
589:
590: -- Standard call to check for call compatibility.
591: IF NOT FND_API.Compatible_API_Call (lc_api_version,
592: p_api_version,
593: lc_api_name ,
594: G_PKG_NAME )
595: THEN

Line 596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

592: p_api_version,
593: lc_api_name ,
594: G_PKG_NAME )
595: THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:
599: -- Initialize message list if p_init_msg_list is set to TRUE.
600: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 600: IF FND_API.to_Boolean( p_init_msg_list ) THEN

596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:
599: -- Initialize message list if p_init_msg_list is set to TRUE.
600: IF FND_API.to_Boolean( p_init_msg_list ) THEN
601: FND_MSG_PUB.initialize;
602: END IF;
603:
604: -- logging

Line 627: x_return_status := FND_API.G_RET_STS_SUCCESS;

623: 'p_repair_actual_id: ' || p_repair_actual_id);
624: end if;
625:
626: -- Initialize API return status to success
627: x_return_status := FND_API.G_RET_STS_SUCCESS;
628:
629: --
630: -- Begin API Body
631: --

Line 634: x_warning_flag := FND_API.G_FALSE;

630: -- Begin API Body
631: --
632:
633: -- Initialzing the warning flag.
634: x_warning_flag := FND_API.G_FALSE;
635:
636: -- Validate mandatory input parameters.
637: if (lc_proc_level >= lc_debug_level) then
638: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 685: RAISE FND_API.G_EXC_ERROR;

681: -- repair order currency. It was found that, one or more
682: -- charge line(s) are in a currency different than the
683: -- repair order currency.
684: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: -- Before we start the process of copying the
689: -- lines, we purge any existing error messages for the

Line 697: -- p_commit => FND_API.G_TRUE,

693: 'Calling CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');
694: end if;
695: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs(
696: p_api_version => 1.0,
697: -- p_commit => FND_API.G_TRUE,
698: -- p_init_msg_list => FND_API.G_FALSE,
699: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
700: p_module_code => G_MSG_MODULE_CODE_ACT,
701: p_source_entity_id1 => p_repair_line_id,

Line 698: -- p_init_msg_list => FND_API.G_FALSE,

694: end if;
695: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs(
696: p_api_version => 1.0,
697: -- p_commit => FND_API.G_TRUE,
698: -- p_init_msg_list => FND_API.G_FALSE,
699: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
700: p_module_code => G_MSG_MODULE_CODE_ACT,
701: p_source_entity_id1 => p_repair_line_id,
702: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_TASK,

Line 699: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,

695: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs(
696: p_api_version => 1.0,
697: -- p_commit => FND_API.G_TRUE,
698: -- p_init_msg_list => FND_API.G_FALSE,
699: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
700: p_module_code => G_MSG_MODULE_CODE_ACT,
701: p_source_entity_id1 => p_repair_line_id,
702: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_TASK,
703: p_source_entity_id2 => NULL, -- Since we want to delete all messages.

Line 716: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

712: end if;
713:
714: -- Stall the process if we were unable to purge
715: -- the older messages.
716: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;
719:
720: -- swai: bug 7122368

Line 717: RAISE FND_API.G_EXC_ERROR;

713:
714: -- Stall the process if we were unable to purge
715: -- the older messages.
716: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;
719:
720: -- swai: bug 7122368
721: Get_Default_Third_Party_Info (p_repair_line_id => p_repair_line_id,

Line 861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

857: -- Throw an error if the API returned an error.
858: -- We do not stall the process if we find an error in
859: -- copying the charge line. We continue processing of
860: -- other lines. We just skip the current row.
861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864:
865: IF (l_curr_actual_line_rec.repair_actual_line_id IS NULL) THEN

Line 862: RAISE FND_API.G_EXC_ERROR;

858: -- We do not stall the process if we find an error in
859: -- copying the charge line. We continue processing of
860: -- other lines. We just skip the current row.
861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864:
865: IF (l_curr_actual_line_rec.repair_actual_line_id IS NULL) THEN
866: if (lc_proc_level >= lc_debug_level) then

Line 873: RAISE FND_API.G_EXC_ERROR;

869: end if;
870: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_NULL_ACTUAL_ID');
871: -- 'Unable to create a repair actual line. Create API returned NULL for the repair actual line identifier.
872: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:
876: EXCEPTION
877: WHEN FND_API.G_EXC_ERROR THEN

Line 877: WHEN FND_API.G_EXC_ERROR THEN

873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:
876: EXCEPTION
877: WHEN FND_API.G_EXC_ERROR THEN
878: l_skip_curr_row := TRUE;
879: if (lc_excep_level >= lc_debug_level) then
880: FND_LOG.STRING(lc_excep_level, lc_mod_name,
881: 'Encountered an EXC error while creating a repair actual line.');

Line 934: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

930: -- Throw an error if the API returned an error.
931: -- We do not stall the process if we find an error in
932: -- copying the charge line. We continue processing of
933: -- other lines. We just skip the current row.
934: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937:
938: EXCEPTION

Line 935: RAISE FND_API.G_EXC_ERROR;

931: -- We do not stall the process if we find an error in
932: -- copying the charge line. We continue processing of
933: -- other lines. We just skip the current row.
934: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937:
938: EXCEPTION
939: WHEN FND_API.G_EXC_ERROR THEN

Line 939: WHEN FND_API.G_EXC_ERROR THEN

935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937:
938: EXCEPTION
939: WHEN FND_API.G_EXC_ERROR THEN
940: l_skip_curr_row := TRUE;
941: if (lc_proc_level >= lc_debug_level) then
942: FND_LOG.STRING(lc_proc_level, lc_mod_name,
943: 'Encountered an EXEC error while updating a repair actual line with billing information.');

Line 968: x_warning_flag := FND_API.G_TRUE;

964:
965: -- we rollback any updates/inserts for the current
966: -- record and set the warning flag to TRUE.
967: ROLLBACK TO current_actual_line_sp;
968: x_warning_flag := FND_API.G_TRUE;
969:
970: -- Increment the total count.
971: l_import_line_failed_count := l_import_line_failed_count + 1;
972:

Line 995: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

991: end if;
992:
993: -- If we are unable to log messages then we stop
994: -- further processing.
995: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
996: if (lc_proc_level >= lc_debug_level) then
997: FND_LOG.STRING(lc_proc_level, lc_mod_name,
998: 'Unable to save messages using the generic logging utility.');
999: end if;

Line 1003: RAISE FND_API.G_EXC_ERROR;

999: end if;
1000: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
1001: -- Unable to save messages using the generic logging utility.
1002: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005:
1006: END IF;
1007:

Line 1010: x_warning_flag := FND_API.G_TRUE;

1006: END IF;
1007:
1008: END LOOP;
1009:
1010: x_warning_flag := FND_API.G_TRUE;
1011:
1012: -- If no eligible task debrief lines found for import.
1013: IF( l_import_line_total_count <= 0 ) THEN
1014: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_INELIGIBLE');

Line 1034: -- p_commit => FND_API.G_TRUE,

1030: end if;
1031:
1032: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs(
1033: p_api_version => 1.0,
1034: -- p_commit => FND_API.G_TRUE,
1035: -- p_init_msg_list => FND_API.G_FALSE,
1036: -- p_validation_level => p_validation_level,
1037: p_module_code => G_MSG_MODULE_CODE_ACT,
1038: p_source_entity_id1 => p_repair_line_id,

Line 1035: -- p_init_msg_list => FND_API.G_FALSE,

1031:
1032: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs(
1033: p_api_version => 1.0,
1034: -- p_commit => FND_API.G_TRUE,
1035: -- p_init_msg_list => FND_API.G_FALSE,
1036: -- p_validation_level => p_validation_level,
1037: p_module_code => G_MSG_MODULE_CODE_ACT,
1038: p_source_entity_id1 => p_repair_line_id,
1039: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_TASK,

Line 1052: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1048: end if;
1049:
1050: -- If we are unable to log messages then we
1051: -- throw an error.
1052: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1053: if (lc_proc_level >= lc_debug_level) then
1054: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1055: 'Unable to save messages using the generic logging utility.');
1056: end if;

Line 1060: RAISE FND_API.G_EXC_ERROR;

1056: end if;
1057: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
1058: -- Unable to save messages using the generic logging utility.
1059: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1060: RAISE FND_API.G_EXC_ERROR;
1061: END IF;
1062:
1063: -- Standard check of p_commit.
1064: IF FND_API.To_Boolean( p_commit ) THEN

Line 1064: IF FND_API.To_Boolean( p_commit ) THEN

1060: RAISE FND_API.G_EXC_ERROR;
1061: END IF;
1062:
1063: -- Standard check of p_commit.
1064: IF FND_API.To_Boolean( p_commit ) THEN
1065: COMMIT WORK;
1066: END IF;
1067:
1068: -- logging

Line 1075: WHEN FND_API.G_EXC_ERROR THEN

1071: 'Leaving CSD_REPAIR_ACTUAL_PROCESS_PVT.import_actuals_from_task');
1072: end if;
1073:
1074: EXCEPTION
1075: WHEN FND_API.G_EXC_ERROR THEN
1076: x_return_status := FND_API.G_RET_STS_ERROR ;
1077: ROLLBACK TO Import_Actuals_Task_sp;
1078: FND_MSG_PUB.Count_And_Get
1079: (p_count => x_msg_count,

Line 1076: x_return_status := FND_API.G_RET_STS_ERROR ;

1072: end if;
1073:
1074: EXCEPTION
1075: WHEN FND_API.G_EXC_ERROR THEN
1076: x_return_status := FND_API.G_RET_STS_ERROR ;
1077: ROLLBACK TO Import_Actuals_Task_sp;
1078: FND_MSG_PUB.Count_And_Get
1079: (p_count => x_msg_count,
1080: p_data => x_msg_data );

Line 1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1083: IF (lc_excep_level >= lc_debug_level) THEN
1084: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1085: 'EXC_ERROR['||x_msg_data||']');
1086: END IF;
1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089: ROLLBACK TO Import_Actuals_Task_sp;
1090: FND_MSG_PUB.Count_And_Get
1091: ( p_count => x_msg_count,

Line 1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1084: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1085: 'EXC_ERROR['||x_msg_data||']');
1086: END IF;
1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089: ROLLBACK TO Import_Actuals_Task_sp;
1090: FND_MSG_PUB.Count_And_Get
1091: ( p_count => x_msg_count,
1092: p_data => x_msg_data );

Line 1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1096: FND_LOG.STRING(lc_excep_level, lc_mod_name,
1097: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
1098: END IF;
1099: WHEN OTHERS THEN
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: ROLLBACK TO Import_Actuals_Task_sp;
1102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1103: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,lc_api_name );
1104: END IF;

Line 1348: IF NOT FND_API.Compatible_API_Call( lc_api_version,

1344: -- Standard Start of API savepoint
1345: SAVEPOINT Import_actuals_wip_sp;
1346:
1347: -- Standard call to check for call compatibility.
1348: IF NOT FND_API.Compatible_API_Call( lc_api_version,
1349: p_api_version,
1350: lc_api_name,
1351: G_PKG_NAME ) THEN
1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1348: IF NOT FND_API.Compatible_API_Call( lc_api_version,
1349: p_api_version,
1350: lc_api_name,
1351: G_PKG_NAME ) THEN
1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1353: END IF;
1354:
1355: -- Initialize message list if p_init_msg_list is set to TRUE.
1356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1353: END IF;
1354:
1355: -- Initialize message list if p_init_msg_list is set to TRUE.
1356: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1357: FND_MSG_PUB.initialize;
1358: END IF;
1359:
1360: -- logging

Line 1393: x_return_status := FND_API.G_RET_STS_SUCCESS;

1389: 'p_organization_id: ' || p_organization_id);
1390: end if;
1391:
1392: -- Initialize API return status to success
1393: x_return_status := FND_API.G_RET_STS_SUCCESS;
1394:
1395: --
1396: -- Begin API Body
1397: --

Line 1399: x_warning_flag := FND_API.G_FALSE;

1395: --
1396: -- Begin API Body
1397: --
1398:
1399: x_warning_flag := FND_API.G_FALSE;
1400:
1401: --DBMS_OUTPUT.put_line( 'before api begin' );
1402:
1403: -- Validate mandatory input parameters.

Line 1517: RAISE FND_API.G_EXC_ERROR;

1513: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_DEFAULT_PL_IMPORT');
1514: -- Unable to determine default price list for the repair order.
1515: -- A default price list must be selected for the repair order to import actual lines.
1516: FND_MSG_PUB.ADD;
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:
1520: --DBMS_OUTPUT.put_line( 'The price list is available ' );
1521:

Line 1529: -- p_commit => FND_API.G_TRUE,

1525: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1526: 'Calling CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');
1527: end if;
1528: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs( p_api_version => 1.0,
1529: -- p_commit => FND_API.G_TRUE,
1530: -- p_init_msg_list => FND_API.G_FALSE,
1531: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_module_code => G_MSG_MODULE_CODE_ACT,
1533: p_source_entity_id1 => p_repair_line_id,

Line 1530: -- p_init_msg_list => FND_API.G_FALSE,

1526: 'Calling CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');
1527: end if;
1528: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs( p_api_version => 1.0,
1529: -- p_commit => FND_API.G_TRUE,
1530: -- p_init_msg_list => FND_API.G_FALSE,
1531: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_module_code => G_MSG_MODULE_CODE_ACT,
1533: p_source_entity_id1 => p_repair_line_id,
1534: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_WIP,

Line 1531: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1527: end if;
1528: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs( p_api_version => 1.0,
1529: -- p_commit => FND_API.G_TRUE,
1530: -- p_init_msg_list => FND_API.G_FALSE,
1531: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1532: p_module_code => G_MSG_MODULE_CODE_ACT,
1533: p_source_entity_id1 => p_repair_line_id,
1534: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_WIP,
1535: p_source_entity_id2 => NULL,-- Purge all records for the entity

Line 1547: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1543: end if;
1544:
1545: -- Do not proceed if unable to purge.
1546: -- Throw an error if the API returned 'no success'.
1547: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551: -- Log info messages for all the wip jobs that are shared with other

Line 1548: RAISE FND_API.G_EXC_ERROR;

1544:
1545: -- Do not proceed if unable to purge.
1546: -- Throw an error if the API returned 'no success'.
1547: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551: -- Log info messages for all the wip jobs that are shared with other
1552: -- repair orders.

Line 1579: -- p_commit => FND_API.G_TRUE,

1575: end if;
1576: -- We have to log message individually as wip_entity_id is required for
1577: -- logging messages.
1578: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
1579: -- p_commit => FND_API.G_TRUE,
1580: -- p_init_msg_list => FND_API.G_FALSE,
1581: -- p_validation_level => p_validation_level,
1582: p_module_code => G_MSG_MODULE_CODE_ACT,
1583: p_source_entity_id1 => p_repair_line_id,

Line 1580: -- p_init_msg_list => FND_API.G_FALSE,

1576: -- We have to log message individually as wip_entity_id is required for
1577: -- logging messages.
1578: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
1579: -- p_commit => FND_API.G_TRUE,
1580: -- p_init_msg_list => FND_API.G_FALSE,
1581: -- p_validation_level => p_validation_level,
1582: p_module_code => G_MSG_MODULE_CODE_ACT,
1583: p_source_entity_id1 => p_repair_line_id,
1584: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_WIP,

Line 1595: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1591: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1592: 'Returned from CSD_GEN_ERRMSGS_PVT.save_fnd_msgs');
1593: end if;
1594:
1595: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1596: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
1597: RAISE GENERIC_MSG_SAVE_FAILED;
1598: END IF;
1599:

Line 1646: l_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;

1642: -- CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE is specific to
1643: -- Actuals.
1644: l_actual_lines_tbl CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE;
1645:
1646: l_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;
1647: x_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;
1648: l_actuals_count NUMBER := 0;
1649:
1650: l_message VARCHAR2(30) := NULL;

Line 1647: x_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;

1643: -- Actuals.
1644: l_actual_lines_tbl CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE;
1645:
1646: l_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;
1647: x_curr_warning_flag VARCHAR2(5) := FND_API.G_FALSE;
1648: l_actuals_count NUMBER := 0;
1649:
1650: l_message VARCHAR2(30) := NULL;
1651:

Line 1652: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1648: l_actuals_count NUMBER := 0;
1649:
1650: l_message VARCHAR2(30) := NULL;
1651:
1652: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1653: l_msg_count NUMBER;
1654: l_msg_data VARCHAR2(200);
1655:
1656: BEGIN

Line 1700: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN

1696: end if;
1697:
1698: --DBMS_OUTPUT.put_line( 'After log MTL Txn Warnings ...' );
1699:
1700: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN
1701: l_curr_warning_flag := FND_API.G_TRUE;
1702: END IF;
1703:
1704: -- First, we process the material transaction lines for all the WIP

Line 1701: l_curr_warning_flag := FND_API.G_TRUE;

1697:
1698: --DBMS_OUTPUT.put_line( 'After log MTL Txn Warnings ...' );
1699:
1700: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN
1701: l_curr_warning_flag := FND_API.G_TRUE;
1702: END IF;
1703:
1704: -- First, we process the material transaction lines for all the WIP
1705: -- jobs. Getting the table for all the lines.

Line 1744: p_commit => FND_API.G_FALSE,

1740:
1741: -- Filter out all the bad data and populate 'Charges' table
1742: -- and MLE table with valid set of data.
1743: CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines( p_api_version => 1.0,
1744: p_commit => FND_API.G_FALSE,
1745: p_init_msg_list => FND_API.G_FALSE,
1746: p_validation_level => p_validation_level,
1747: x_return_status => l_return_status,
1748: x_msg_count => l_msg_count,

Line 1745: p_init_msg_list => FND_API.G_FALSE,

1741: -- Filter out all the bad data and populate 'Charges' table
1742: -- and MLE table with valid set of data.
1743: CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines( p_api_version => 1.0,
1744: p_commit => FND_API.G_FALSE,
1745: p_init_msg_list => FND_API.G_FALSE,
1746: p_validation_level => p_validation_level,
1747: x_return_status => l_return_status,
1748: x_msg_count => l_msg_count,
1749: x_msg_data => l_msg_data,

Line 1776: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN

1772:
1773: --DBMS_OUTPUT.put_line( 'after getting the valid MTL data '
1774: -- || x_valid_MLE_lines_tbl.COUNT );
1775:
1776: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN
1777: l_curr_warning_flag := FND_API.G_TRUE;
1778: END IF;
1779:
1780: -- Throw an error if the API returned an error.

Line 1777: l_curr_warning_flag := FND_API.G_TRUE;

1773: --DBMS_OUTPUT.put_line( 'after getting the valid MTL data '
1774: -- || x_valid_MLE_lines_tbl.COUNT );
1775:
1776: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN
1777: l_curr_warning_flag := FND_API.G_TRUE;
1778: END IF;
1779:
1780: -- Throw an error if the API returned an error.
1781: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1781: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1777: l_curr_warning_flag := FND_API.G_TRUE;
1778: END IF;
1779:
1780: -- Throw an error if the API returned an error.
1781: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1782: RAISE FND_API.G_EXC_ERROR;
1783: END IF;
1784:
1785: if (lc_stat_level >= lc_debug_level) then

Line 1782: RAISE FND_API.G_EXC_ERROR;

1778: END IF;
1779:
1780: -- Throw an error if the API returned an error.
1781: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1782: RAISE FND_API.G_EXC_ERROR;
1783: END IF;
1784:
1785: if (lc_stat_level >= lc_debug_level) then
1786: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1824: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN

1820: || 'x_curr_warning_flag = ' || x_curr_warning_flag);
1821: end if;
1822:
1823: --DBMS_OUTPUT.put_line( 'After Log_WIP_Resource_Txn_warnings ...' );
1824: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN
1825: l_curr_warning_flag := FND_API.G_TRUE;
1826: END IF;
1827:
1828: -- Now, we process the WIP transaction lines (for resources) for all

Line 1825: l_curr_warning_flag := FND_API.G_TRUE;

1821: end if;
1822:
1823: --DBMS_OUTPUT.put_line( 'After Log_WIP_Resource_Txn_warnings ...' );
1824: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN
1825: l_curr_warning_flag := FND_API.G_TRUE;
1826: END IF;
1827:
1828: -- Now, we process the WIP transaction lines (for resources) for all
1829: -- the WIP jobs. Getting the table for all the lines.

Line 1870: p_commit => FND_API.G_FALSE,

1866:
1867: -- Filter out all the bad data and populate 'Charges' table
1868: -- and MLE table with valid set of data.
1869: CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines( p_api_version => 1.0,
1870: p_commit => FND_API.G_FALSE,
1871: p_init_msg_list => FND_API.G_FALSE,
1872: p_validation_level => p_validation_level,
1873: x_return_status => l_return_status,
1874: x_msg_count => l_msg_count,

Line 1871: p_init_msg_list => FND_API.G_FALSE,

1867: -- Filter out all the bad data and populate 'Charges' table
1868: -- and MLE table with valid set of data.
1869: CSD_CHARGE_LINE_UTIL.Convert_To_Charge_Lines( p_api_version => 1.0,
1870: p_commit => FND_API.G_FALSE,
1871: p_init_msg_list => FND_API.G_FALSE,
1872: p_validation_level => p_validation_level,
1873: x_return_status => l_return_status,
1874: x_msg_count => l_msg_count,
1875: x_msg_data => l_msg_data,

Line 1902: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN

1898:
1899: --DBMS_OUTPUT.put_line( 'after getting the valid RES lines '
1900: -- || x_valid_MLE_lines_tbl.COUNT );
1901:
1902: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN
1903: l_curr_warning_flag := FND_API.G_TRUE;
1904: END IF;
1905:
1906: -- Throw an error if the API returned an error.

Line 1903: l_curr_warning_flag := FND_API.G_TRUE;

1899: --DBMS_OUTPUT.put_line( 'after getting the valid RES lines '
1900: -- || x_valid_MLE_lines_tbl.COUNT );
1901:
1902: IF ( x_curr_warning_flag <> FND_API.G_FALSE ) THEN
1903: l_curr_warning_flag := FND_API.G_TRUE;
1904: END IF;
1905:
1906: -- Throw an error if the API returned an error.
1907: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1907: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1903: l_curr_warning_flag := FND_API.G_TRUE;
1904: END IF;
1905:
1906: -- Throw an error if the API returned an error.
1907: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:
1911: if (lc_stat_level >= lc_debug_level) then

Line 1908: RAISE FND_API.G_EXC_ERROR;

1904: END IF;
1905:
1906: -- Throw an error if the API returned an error.
1907: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:
1911: if (lc_stat_level >= lc_debug_level) then
1912: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1922: IF ( l_curr_warning_flag <> FND_API.G_FALSE ) THEN

1918: --DBMS_OUTPUT.put_line( 'before call to fnd save msgs' );
1919:
1920: -- Log all the warnings that may have been added to
1921: -- the message stack earlier.
1922: IF ( l_curr_warning_flag <> FND_API.G_FALSE ) THEN
1923: x_warning_flag := l_curr_warning_flag;
1924:
1925: if (lc_stat_level >= lc_debug_level) then
1926: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1936: -- p_commit => FND_API.G_TRUE,

1932: 'Calling procedure CSD_GEN_ERRMSGS_PVT.save_fnd_msgs.');
1933: end if;
1934:
1935: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
1936: -- p_commit => FND_API.G_TRUE,
1937: -- p_init_msg_list => FND_API.G_FALSE,
1938: -- p_validation_level => p_validation_level,
1939: p_module_code => G_MSG_MODULE_CODE_ACT,
1940: p_source_entity_id1 => p_repair_line_id,

Line 1937: -- p_init_msg_list => FND_API.G_FALSE,

1933: end if;
1934:
1935: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
1936: -- p_commit => FND_API.G_TRUE,
1937: -- p_init_msg_list => FND_API.G_FALSE,
1938: -- p_validation_level => p_validation_level,
1939: p_module_code => G_MSG_MODULE_CODE_ACT,
1940: p_source_entity_id1 => p_repair_line_id,
1941: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_WIP,

Line 1954: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1950: end if;
1951:
1952: --DBMS_OUTPUT.put_line( 'before call to generic save msgs' );
1953:
1954: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1955: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
1956: RAISE GENERIC_MSG_SAVE_FAILED;
1957: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1958: END IF;

Line 1957: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1953:
1954: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1955: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
1956: RAISE GENERIC_MSG_SAVE_FAILED;
1957: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1958: END IF;
1959: END IF;
1960:
1961: --DBMS_OUTPUT.put_line( 'after generic msgs. Before mle to actuals' );

Line 2029: p_commit => FND_API.G_FALSE,

2025: x_charge_lines_tbl( i ).ship_to_account_id := l_ship_to_account_id;
2026: x_charge_lines_tbl( i ).ship_to_org_id := l_ship_to_party_site_id;
2027:
2028: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines( p_api_version => 1.0,
2029: p_commit => FND_API.G_FALSE,
2030: p_init_msg_list => FND_API.G_FALSE,
2031: p_validation_level => 0,
2032: px_CSD_ACTUAL_LINES_REC => l_actual_lines_tbl( i ),
2033: px_CHARGES_REC => x_charge_lines_tbl( i ),

Line 2030: p_init_msg_list => FND_API.G_FALSE,

2026: x_charge_lines_tbl( i ).ship_to_org_id := l_ship_to_party_site_id;
2027:
2028: CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines( p_api_version => 1.0,
2029: p_commit => FND_API.G_FALSE,
2030: p_init_msg_list => FND_API.G_FALSE,
2031: p_validation_level => 0,
2032: px_CSD_ACTUAL_LINES_REC => l_actual_lines_tbl( i ),
2033: px_CHARGES_REC => x_charge_lines_tbl( i ),
2034: x_return_status => l_return_status,

Line 2038: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2034: x_return_status => l_return_status,
2035: x_msg_count => l_msg_count,
2036: x_msg_data => l_msg_data );
2037:
2038: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2039: if (lc_proc_level >= lc_debug_level) then
2040: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2041: 'Unable to create repair actual lines for count = ' || i);
2042: end if;

Line 2044: RAISE FND_API.G_EXC_ERROR;

2040: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2041: 'Unable to create repair actual lines for count = ' || i);
2042: end if;
2043: --DBMS_OUTPUT.put_line( 'Unable to create repair actual lines' );
2044: RAISE FND_API.G_EXC_ERROR;
2045: END IF;
2046: END LOOP;
2047:
2048: if (lc_proc_level >= lc_debug_level) then

Line 2054: IF ( l_curr_warning_flag <> FND_API.G_FALSE ) THEN

2050: 'Returned from procedure CSD_REPAIR_ACTUAL_LINES_PVT.create_repair_actual_lines'
2051: || ' for all actual lines. l_actuals_count = ' || l_actuals_count);
2052: end if;
2053:
2054: IF ( l_curr_warning_flag <> FND_API.G_FALSE ) THEN
2055: l_message := 'CSD_ACT_WIP_IMPORT_W_WARN';
2056: -- Debrief lines import for the WIP Job $JOB_NAME completed with warnings. $ACTUAL_LINE_COUNT new repair actual line(s) were created for the job.
2057: if (lc_stat_level >= lc_debug_level) then
2058: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 2093: -- p_commit => FND_API.G_TRUE,

2089: 'Calling procedure CSD_GEN_ERRMSGS_PVT.save_fnd_msgs.');
2090: end if;
2091:
2092: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
2093: -- p_commit => FND_API.G_TRUE,
2094: -- p_init_msg_list => FND_API.G_FALSE,
2095: -- p_validation_level => p_validation_level,
2096: p_module_code => G_MSG_MODULE_CODE_ACT,
2097: p_source_entity_id1 => p_repair_line_id,

Line 2094: -- p_init_msg_list => FND_API.G_FALSE,

2090: end if;
2091:
2092: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
2093: -- p_commit => FND_API.G_TRUE,
2094: -- p_init_msg_list => FND_API.G_FALSE,
2095: -- p_validation_level => p_validation_level,
2096: p_module_code => G_MSG_MODULE_CODE_ACT,
2097: p_source_entity_id1 => p_repair_line_id,
2098: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_WIP,

Line 2109: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2105: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2106: 'Returning from procedure CSD_GEN_ERRMSGS_PVT.save_fnd_msgs.');
2107: end if;
2108:
2109: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2110: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
2111: RAISE GENERIC_MSG_SAVE_FAILED;
2112: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2113: END IF;

Line 2112: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2108:
2109: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2110: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
2111: RAISE GENERIC_MSG_SAVE_FAILED;
2112: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2113: END IF;
2114:
2115:
2116: EXCEPTION

Line 2122: WHEN FND_API.G_EXC_ERROR THEN

2118: -- do not consider it be a fatal error. We do not stop
2119: -- the process but continue with the next WIP job. We
2120: -- just log messages in the generic utlity as ERROR.
2121:
2122: WHEN FND_API.G_EXC_ERROR THEN
2123: -- x_return_status := FND_API.G_RET_STS_ERROR;
2124: x_warning_flag := FND_API.G_TRUE;
2125: ROLLBACK TO curr_wip_job_sp;
2126:

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

2119: -- the process but continue with the next WIP job. We
2120: -- just log messages in the generic utlity as ERROR.
2121:
2122: WHEN FND_API.G_EXC_ERROR THEN
2123: -- x_return_status := FND_API.G_RET_STS_ERROR;
2124: x_warning_flag := FND_API.G_TRUE;
2125: ROLLBACK TO curr_wip_job_sp;
2126:
2127: -- Add an ERROR message.

Line 2124: x_warning_flag := FND_API.G_TRUE;

2120: -- just log messages in the generic utlity as ERROR.
2121:
2122: WHEN FND_API.G_EXC_ERROR THEN
2123: -- x_return_status := FND_API.G_RET_STS_ERROR;
2124: x_warning_flag := FND_API.G_TRUE;
2125: ROLLBACK TO curr_wip_job_sp;
2126:
2127: -- Add an ERROR message.
2128: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_ERROR');

Line 2135: -- p_commit => FND_API.G_TRUE,

2131: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2132:
2133: -- Save the messages using generic utility.
2134: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
2135: -- p_commit => FND_API.G_TRUE,
2136: -- p_init_msg_list => FND_API.G_FALSE,
2137: -- p_validation_level => p_validation_level,
2138: p_module_code => G_MSG_MODULE_CODE_ACT,
2139: p_source_entity_id1 => p_repair_line_id,

Line 2136: -- p_init_msg_list => FND_API.G_FALSE,

2132:
2133: -- Save the messages using generic utility.
2134: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
2135: -- p_commit => FND_API.G_TRUE,
2136: -- p_init_msg_list => FND_API.G_FALSE,
2137: -- p_validation_level => p_validation_level,
2138: p_module_code => G_MSG_MODULE_CODE_ACT,
2139: p_source_entity_id1 => p_repair_line_id,
2140: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_WIP,

Line 2146: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2142: x_return_status => l_return_status,
2143: x_msg_count => l_msg_count,
2144: x_msg_data => l_msg_data );
2145:
2146: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2147: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
2148: RAISE GENERIC_MSG_SAVE_FAILED;
2149: END IF;
2150:

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

2164: -- Catch the exception outside, in the outermost loop.
2165: RAISE GENERIC_MSG_SAVE_FAILED;
2166:
2167: WHEN OTHERS THEN
2168: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2169:
2170: ROLLBACK TO curr_wip_job_sp;
2171: x_warning_flag := FND_API.G_TRUE;
2172:

Line 2171: x_warning_flag := FND_API.G_TRUE;

2167: WHEN OTHERS THEN
2168: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2169:
2170: ROLLBACK TO curr_wip_job_sp;
2171: x_warning_flag := FND_API.G_TRUE;
2172:
2173: if (lc_proc_level >= lc_debug_level) then
2174: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2175: 'Encountered an OTHERS error while creating a repair actual lines ' ||

Line 2202: -- p_commit => FND_API.G_TRUE,

2198: 'Calling CSD_GEN_ERRMSGS_PVT.save_fnd_msgs in WHEN OTHERS THEN');
2199: end if;
2200:
2201: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
2202: -- p_commit => FND_API.G_TRUE,
2203: -- p_init_msg_list => FND_API.G_FALSE,
2204: -- p_validation_level => p_validation_level,
2205: p_module_code => G_MSG_MODULE_CODE_ACT,
2206: p_source_entity_id1 => p_repair_line_id,

Line 2203: -- p_init_msg_list => FND_API.G_FALSE,

2199: end if;
2200:
2201: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,
2202: -- p_commit => FND_API.G_TRUE,
2203: -- p_init_msg_list => FND_API.G_FALSE,
2204: -- p_validation_level => p_validation_level,
2205: p_module_code => G_MSG_MODULE_CODE_ACT,
2206: p_source_entity_id1 => p_repair_line_id,
2207: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_WIP,

Line 2218: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2214: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2215: 'Returned from CSD_GEN_ERRMSGS_PVT.save_fnd_msgs in WHEN OTHERS THEN');
2216: end if;
2217:
2218: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2219: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
2220: RAISE GENERIC_MSG_SAVE_FAILED;
2221: END IF;
2222: /*

Line 2235: x_warning_flag := FND_API.G_TRUE;

2231: 'End LOOP c_eligible_WIP_Jobs');
2232: end if;
2233:
2234: IF( l_wip_count <= 0 ) THEN
2235: x_warning_flag := FND_API.G_TRUE;
2236: -- FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_INELIGIBLE');
2237: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_NO_INELIGIBLE_WIP');
2238: -- No eligible WIP jobs found for import
2239: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);

Line 2250: -- p_commit => FND_API.G_TRUE,

2246: end if;
2247:
2248: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs(
2249: p_api_version => 1.0,
2250: -- p_commit => FND_API.G_TRUE,
2251: -- p_init_msg_list => FND_API.G_FALSE,
2252: -- p_validation_level => p_validation_level,
2253: p_module_code => G_MSG_MODULE_CODE_ACT,
2254: p_source_entity_id1 => p_repair_line_id,

Line 2251: -- p_init_msg_list => FND_API.G_FALSE,

2247:
2248: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs(
2249: p_api_version => 1.0,
2250: -- p_commit => FND_API.G_TRUE,
2251: -- p_init_msg_list => FND_API.G_FALSE,
2252: -- p_validation_level => p_validation_level,
2253: p_module_code => G_MSG_MODULE_CODE_ACT,
2254: p_source_entity_id1 => p_repair_line_id,
2255: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_WIP,

Line 2268: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2264: end if;
2265:
2266: -- If we are unable to log messages then we
2267: -- throw an error.
2268: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2269: if (lc_proc_level >= lc_debug_level) then
2270: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2271: 'Unable to save messages using the generic logging utility.');
2272: end if;

Line 2276: RAISE FND_API.G_EXC_ERROR;

2272: end if;
2273: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
2274: -- Unable to save messages using the generic logging utility.
2275: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2276: RAISE FND_API.G_EXC_ERROR;
2277: END IF;
2278:
2279: END IF;
2280:

Line 2287: IF FND_API.To_Boolean( p_commit ) THEN

2283: -- End API Body
2284: --
2285:
2286: -- Standard check of p_commit.
2287: IF FND_API.To_Boolean( p_commit ) THEN
2288: COMMIT WORK;
2289: END IF;
2290:
2291: -- logging

Line 2306: WHEN FND_API.G_EXC_ERROR THEN

2302: p_data => x_msg_data );
2303: */
2304:
2305: EXCEPTION
2306: WHEN FND_API.G_EXC_ERROR THEN
2307: x_return_status := FND_API.G_RET_STS_ERROR;
2308: ROLLBACK TO Import_actuals_wip_sp;
2309: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2310: p_data => x_msg_data );

Line 2307: x_return_status := FND_API.G_RET_STS_ERROR;

2303: */
2304:
2305: EXCEPTION
2306: WHEN FND_API.G_EXC_ERROR THEN
2307: x_return_status := FND_API.G_RET_STS_ERROR;
2308: ROLLBACK TO Import_actuals_wip_sp;
2309: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2310: p_data => x_msg_data );
2311:

Line 2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2314: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2315: 'EXC_ERROR['||x_msg_data||']');
2316: END IF;
2317:
2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2320: ROLLBACK TO Import_actuals_wip_sp;
2321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2322: p_data => x_msg_data );

Line 2319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2315: 'EXC_ERROR['||x_msg_data||']');
2316: END IF;
2317:
2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2320: ROLLBACK TO Import_actuals_wip_sp;
2321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2322: p_data => x_msg_data );
2323:

Line 2332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2328: END IF;
2329:
2330: WHEN GENERIC_MSG_SAVE_FAILED THEN
2331: ROLLBACK TO Import_actuals_wip_sp;
2332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2333:
2334: -- save message in debug log
2335: IF (lc_excep_level >= lc_debug_level) THEN
2336: FND_LOG.STRING(lc_excep_level, lc_mod_name,

Line 2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2344: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2345: p_data => x_msg_data );
2346:
2347: WHEN OTHERS THEN
2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: ROLLBACK TO Import_actuals_wip_sp;
2350: --DBMS_OUTPUT.put_line( ' SQLCODE = '
2351: -- || SQLCODE );
2352: --DBMS_OUTPUT.put_line( ' SQLERRM = '

Line 2516: IF NOT FND_API.Compatible_API_Call (lc_api_version,

2512: -- Standard start of API Savepoint
2513: Savepoint Import_Actuals_Estimate_sp;
2514:
2515: -- Standard call to check for call compatibility.
2516: IF NOT FND_API.Compatible_API_Call (lc_api_version,
2517: p_api_version,
2518: lc_api_name ,
2519: G_PKG_NAME )
2520: THEN

Line 2521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2517: p_api_version,
2518: lc_api_name ,
2519: G_PKG_NAME )
2520: THEN
2521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2522: END IF;
2523:
2524: -- Initialize message list if p_init_msg_list is set to TRUE.
2525: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2525: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2522: END IF;
2523:
2524: -- Initialize message list if p_init_msg_list is set to TRUE.
2525: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2526: FND_MSG_PUB.initialize;
2527: END IF;
2528:
2529: -- logging

Line 2551: x_return_status := FND_API.G_RET_STS_SUCCESS;

2547: 'p_repair_actual_id: ' || p_repair_actual_id);
2548: end if;
2549:
2550: -- Initialize API return status to success
2551: x_return_status := FND_API.G_RET_STS_SUCCESS;
2552:
2553: --
2554: -- Begin API Body
2555: --

Line 2558: x_warning_flag := FND_API.G_FALSE;

2554: -- Begin API Body
2555: --
2556:
2557: -- Initialzing the warning flag.
2558: x_warning_flag := FND_API.G_FALSE;
2559:
2560: -- Validate mandatory input parameters.
2561: if (lc_proc_level >= lc_debug_level) then
2562: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 2584: -- p_commit => FND_API.G_TRUE,

2580: 'Calling CSD_GEN_ERRMSGS_PVT.purge_entity_msgs');
2581: end if;
2582: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs(
2583: p_api_version => 1.0,
2584: -- p_commit => FND_API.G_TRUE,
2585: -- p_init_msg_list => FND_API.G_FALSE,
2586: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2587: p_module_code => G_MSG_MODULE_CODE_ACT,
2588: p_source_entity_id1 => p_repair_line_id,

Line 2585: -- p_init_msg_list => FND_API.G_FALSE,

2581: end if;
2582: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs(
2583: p_api_version => 1.0,
2584: -- p_commit => FND_API.G_TRUE,
2585: -- p_init_msg_list => FND_API.G_FALSE,
2586: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2587: p_module_code => G_MSG_MODULE_CODE_ACT,
2588: p_source_entity_id1 => p_repair_line_id,
2589: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_ESTIMATE,

Line 2586: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2582: CSD_GEN_ERRMSGS_PVT.purge_entity_msgs(
2583: p_api_version => 1.0,
2584: -- p_commit => FND_API.G_TRUE,
2585: -- p_init_msg_list => FND_API.G_FALSE,
2586: -- p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2587: p_module_code => G_MSG_MODULE_CODE_ACT,
2588: p_source_entity_id1 => p_repair_line_id,
2589: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_ESTIMATE,
2590: p_source_entity_id2 => NULL, -- Since we want to delete all messages.

Line 2602: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2598: end if;
2599:
2600: -- Stall the process if we were unable to purge
2601: -- the older messages.
2602: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2603: RAISE FND_API.G_EXC_ERROR;
2604: END IF;
2605:
2606: -- swai: bug 7119695

Line 2603: RAISE FND_API.G_EXC_ERROR;

2599:
2600: -- Stall the process if we were unable to purge
2601: -- the older messages.
2602: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2603: RAISE FND_API.G_EXC_ERROR;
2604: END IF;
2605:
2606: -- swai: bug 7119695
2607: Get_Default_Third_Party_Info (p_repair_line_id => p_repair_line_id,

Line 2645: p_commit => FND_API.G_FALSE,

2641: end if;
2642: CS_Charge_Details_PUB.copy_estimate(
2643: p_api_version => 1.0,
2644: p_init_msg_list => p_init_msg_list,
2645: p_commit => FND_API.G_FALSE,
2646: p_transaction_control => FND_API.G_TRUE,
2647: p_estimate_detail_id => estimate_line_rec.estimate_detail_id,
2648: x_estimate_detail_id => l_estimate_detail_id,
2649: x_return_status => x_return_status,

Line 2646: p_transaction_control => FND_API.G_TRUE,

2642: CS_Charge_Details_PUB.copy_estimate(
2643: p_api_version => 1.0,
2644: p_init_msg_list => p_init_msg_list,
2645: p_commit => FND_API.G_FALSE,
2646: p_transaction_control => FND_API.G_TRUE,
2647: p_estimate_detail_id => estimate_line_rec.estimate_detail_id,
2648: x_estimate_detail_id => l_estimate_detail_id,
2649: x_return_status => x_return_status,
2650: x_msg_count => x_msg_count,

Line 2669: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2665: -- Throw an error if the API returned an error.
2666: -- We do not stall the process if we find an error in
2667: -- copying the charge line. We continue processing of
2668: -- other lines. We just skip the current row.
2669: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2670: RAISE FND_API.G_EXC_ERROR;
2671: END IF;
2672:
2673: IF (l_estimate_detail_id IS NULL) THEN

Line 2670: RAISE FND_API.G_EXC_ERROR;

2666: -- We do not stall the process if we find an error in
2667: -- copying the charge line. We continue processing of
2668: -- other lines. We just skip the current row.
2669: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2670: RAISE FND_API.G_EXC_ERROR;
2671: END IF;
2672:
2673: IF (l_estimate_detail_id IS NULL) THEN
2674: if (lc_proc_level >= lc_debug_level) then

Line 2680: RAISE FND_API.G_EXC_ERROR;

2676: 'Unable to copy the Estimate charge line into Actual charge line. Charges API returned NULL for the Estimate Detail identifier.');
2677: end if;
2678: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_COPY_CHRG_LINE_FAIL');
2679: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682:
2683: EXCEPTION
2684: WHEN FND_API.G_EXC_ERROR THEN

Line 2684: WHEN FND_API.G_EXC_ERROR THEN

2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;
2682:
2683: EXCEPTION
2684: WHEN FND_API.G_EXC_ERROR THEN
2685: l_skip_curr_row := TRUE;
2686:
2687: WHEN OTHERS THEN
2688: l_skip_curr_row := TRUE;

Line 2809: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2805: -- Throw an error if the API returned an error.
2806: -- We do not stall the process if we find an error in
2807: -- copying the charge line. We continue processing of
2808: -- other lines. We just skip the current row.
2809: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2810: RAISE FND_API.G_EXC_ERROR;
2811: END IF;
2812:
2813: IF (l_curr_actual_line_rec.repair_actual_line_id IS NULL) THEN

Line 2810: RAISE FND_API.G_EXC_ERROR;

2806: -- We do not stall the process if we find an error in
2807: -- copying the charge line. We continue processing of
2808: -- other lines. We just skip the current row.
2809: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2810: RAISE FND_API.G_EXC_ERROR;
2811: END IF;
2812:
2813: IF (l_curr_actual_line_rec.repair_actual_line_id IS NULL) THEN
2814: if (lc_proc_level >= lc_debug_level) then

Line 2820: RAISE FND_API.G_EXC_ERROR;

2816: 'Unable to create a repair actual line. Create API returned NULL for the repair actual line identifier.');
2817: end if;
2818: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_NULL_ACTUAL_ID');
2819: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2820: RAISE FND_API.G_EXC_ERROR;
2821: END IF;
2822:
2823: EXCEPTION
2824: WHEN FND_API.G_EXC_ERROR THEN

Line 2824: WHEN FND_API.G_EXC_ERROR THEN

2820: RAISE FND_API.G_EXC_ERROR;
2821: END IF;
2822:
2823: EXCEPTION
2824: WHEN FND_API.G_EXC_ERROR THEN
2825: l_skip_curr_row := TRUE;
2826: if (lc_proc_level >= lc_debug_level) then
2827: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2828: 'Encountered an EXEC error while creating a repair actual line.');

Line 2880: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2876: -- Throw an error if the API returned an error.
2877: -- We do not stall the process if we find an error in
2878: -- copying the charge line. We continue processing of
2879: -- other lines. We just skip the current row.
2880: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: EXCEPTION

Line 2881: RAISE FND_API.G_EXC_ERROR;

2877: -- We do not stall the process if we find an error in
2878: -- copying the charge line. We continue processing of
2879: -- other lines. We just skip the current row.
2880: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: EXCEPTION
2885: WHEN FND_API.G_EXC_ERROR THEN

Line 2885: WHEN FND_API.G_EXC_ERROR THEN

2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: EXCEPTION
2885: WHEN FND_API.G_EXC_ERROR THEN
2886: l_skip_curr_row := TRUE;
2887: if (lc_proc_level >= lc_debug_level) then
2888: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2889: 'Encountered an EXEC error while updating a repair actual line with billing information.');

Line 2917: x_warning_flag := FND_API.G_TRUE;

2913:
2914: -- we rollback any updates/inserts for the current
2915: -- record and set the warning flag to TRUE.
2916: ROLLBACK TO current_actual_line_sp;
2917: x_warning_flag := FND_API.G_TRUE;
2918:
2919: -- Increment the failed count.
2920: l_est_line_failed_count := l_est_line_failed_count + 1;
2921:

Line 2929: -- p_commit => FND_API.G_TRUE,

2925: 'Calling CSD_GEN_ERRMSGS_PVT.save_fnd_msgs');
2926: end if;
2927: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs(
2928: p_api_version => 1.0,
2929: -- p_commit => FND_API.G_TRUE,
2930: -- p_init_msg_list => FND_API.G_FALSE,
2931: -- p_validation_level => p_validation_level,
2932: p_module_code => G_MSG_MODULE_CODE_ACT,
2933: p_source_entity_id1 => p_repair_line_id,

Line 2930: -- p_init_msg_list => FND_API.G_FALSE,

2926: end if;
2927: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs(
2928: p_api_version => 1.0,
2929: -- p_commit => FND_API.G_TRUE,
2930: -- p_init_msg_list => FND_API.G_FALSE,
2931: -- p_validation_level => p_validation_level,
2932: p_module_code => G_MSG_MODULE_CODE_ACT,
2933: p_source_entity_id1 => p_repair_line_id,
2934: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_ESTIMATE,

Line 2945: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2941: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2942: 'Returned from CSD_GEN_ERRMSGS_PVT.save_fnd_msgs');
2943: end if;
2944:
2945: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2946: if (lc_proc_level >= lc_debug_level) then
2947: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2948: 'Unable to save messages using the generic logging utility.');
2949: end if;

Line 2952: RAISE FND_API.G_EXC_ERROR;

2948: 'Unable to save messages using the generic logging utility.');
2949: end if;
2950: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
2951: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2952: RAISE FND_API.G_EXC_ERROR;
2953: END IF;
2954:
2955: END IF;
2956:

Line 2959: x_warning_flag := FND_API.G_TRUE;

2955: END IF;
2956:
2957: END LOOP;
2958:
2959: x_warning_flag := FND_API.G_TRUE;
2960:
2961: -- If no eligible estimate lines found for import.
2962: IF( l_est_line_total_count <= 0 ) THEN
2963: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_INELIGIBLE');

Line 2983: -- p_commit => FND_API.G_TRUE,

2979: end if;
2980:
2981: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs(
2982: p_api_version => 1.0,
2983: -- p_commit => FND_API.G_TRUE,
2984: -- p_init_msg_list => FND_API.G_FALSE,
2985: -- p_validation_level => p_validation_level,
2986: p_module_code => G_MSG_MODULE_CODE_ACT,
2987: p_source_entity_id1 => p_repair_line_id,

Line 2984: -- p_init_msg_list => FND_API.G_FALSE,

2980:
2981: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs(
2982: p_api_version => 1.0,
2983: -- p_commit => FND_API.G_TRUE,
2984: -- p_init_msg_list => FND_API.G_FALSE,
2985: -- p_validation_level => p_validation_level,
2986: p_module_code => G_MSG_MODULE_CODE_ACT,
2987: p_source_entity_id1 => p_repair_line_id,
2988: p_source_entity_type_code => G_ACTUAL_MSG_ENTITY_ESTIMATE,

Line 3001: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2997: end if;
2998:
2999: -- If we are unable to log messages then we
3000: -- throw an error.
3001: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3002: if (lc_proc_level >= lc_debug_level) then
3003: FND_LOG.STRING(lc_proc_level, lc_mod_name,
3004: 'Unable to save messages using the generic logging utility.');
3005: end if;

Line 3009: RAISE FND_API.G_EXC_ERROR;

3005: end if;
3006: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
3007: -- Unable to save messages using the generic logging utility.
3008: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
3009: RAISE FND_API.G_EXC_ERROR;
3010: END IF;
3011:
3012: -- Standard check of p_commit.
3013: IF FND_API.To_Boolean( p_commit ) THEN

Line 3013: IF FND_API.To_Boolean( p_commit ) THEN

3009: RAISE FND_API.G_EXC_ERROR;
3010: END IF;
3011:
3012: -- Standard check of p_commit.
3013: IF FND_API.To_Boolean( p_commit ) THEN
3014: COMMIT WORK;
3015: END IF;
3016:
3017: -- logging

Line 3025: WHEN FND_API.G_EXC_ERROR THEN

3021: end if;
3022:
3023: EXCEPTION
3024:
3025: WHEN FND_API.G_EXC_ERROR THEN
3026: x_return_status := FND_API.G_RET_STS_ERROR ;
3027: ROLLBACK TO Import_Actuals_Estimate_sp;
3028: FND_MSG_PUB.Count_And_Get
3029: (p_count => x_msg_count,

Line 3026: x_return_status := FND_API.G_RET_STS_ERROR ;

3022:
3023: EXCEPTION
3024:
3025: WHEN FND_API.G_EXC_ERROR THEN
3026: x_return_status := FND_API.G_RET_STS_ERROR ;
3027: ROLLBACK TO Import_Actuals_Estimate_sp;
3028: FND_MSG_PUB.Count_And_Get
3029: (p_count => x_msg_count,
3030: p_data => x_msg_data );

Line 3037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3033: IF (lc_excep_level >= lc_debug_level) THEN
3034: FND_LOG.STRING(lc_excep_level, lc_mod_name,
3035: 'EXC_ERROR['||x_msg_data||']');
3036: END IF;
3037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3039: ROLLBACK TO Import_Actuals_Estimate_sp;
3040: FND_MSG_PUB.Count_And_Get
3041: ( p_count => x_msg_count,

Line 3038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3034: FND_LOG.STRING(lc_excep_level, lc_mod_name,
3035: 'EXC_ERROR['||x_msg_data||']');
3036: END IF;
3037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3039: ROLLBACK TO Import_Actuals_Estimate_sp;
3040: FND_MSG_PUB.Count_And_Get
3041: ( p_count => x_msg_count,
3042: p_data => x_msg_data );

Line 3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3046: 'EXC_UNEXPECTED_ERROR['||x_msg_data||']');
3047: END IF;
3048:
3049: WHEN OTHERS THEN
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3051: ROLLBACK TO Import_Actuals_Estimate_sp;
3052: IF FND_MSG_PUB.Check_Msg_Level
3053: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3054: THEN