[Home] [Help]
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;
149: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_RESOURCE_NO_ITEM');
150: -- 'The billing item is not defined for the Resource $RESOURCE_CODE'.
151: FND_MESSAGE.set_token( 'RESOURCE_CODE', i_rec.RESOURCE_CODE );
152: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
153: END LOOP;
147: 'The billing item is not defined for the Resource = ' || i_rec.RESOURCE_CODE);
148: end if;
149: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_RESOURCE_NO_ITEM');
150: -- 'The billing item is not defined for the Resource $RESOURCE_CODE'.
151: FND_MESSAGE.set_token( 'RESOURCE_CODE', i_rec.RESOURCE_CODE );
152: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
153: END LOOP;
154:
155: 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.');
180: end if;
181: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_ITEM_NOT_SRV_ORG');
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
179: || 'Validation Organization. It is defined only in the WIP organization.');
180: end if;
181: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_ITEM_NOT_SRV_ORG');
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
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;
191: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_ITEM_NO_BILLING_TYPE');
192: -- '''Billing type'' is not defined for the item $ITEM_NAME.
193: FND_MESSAGE.set_token( 'ITEM_NAME', i_rec.WIP_ITEM_NAME );
194: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
195: END IF;
189: 'Billing type is not defined for the item ' || i_rec.WIP_ITEM_NAME);
190: end if;
191: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_ITEM_NO_BILLING_TYPE');
192: -- '''Billing type'' is not defined for the item $ITEM_NAME.
193: FND_MESSAGE.set_token( 'ITEM_NAME', i_rec.WIP_ITEM_NAME );
194: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
195: END IF;
196: END IF;
197:
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;
218: FND_MESSAGE.set_name( 'CSD', 'CSD_CHRG_NO_ITEM_SAR');
219: -- Unable to determine service activity billing type for the item $ITEM.
220: FND_MESSAGE.set_token( 'ITEM', i_rec.DEPOT_ITEM_NAME);
221: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
222: END IF;
216: 'Unable to determine service activity billing type for the item ' || i_rec.DEPOT_ITEM_NAME);
217: end if;
218: FND_MESSAGE.set_name( 'CSD', 'CSD_CHRG_NO_ITEM_SAR');
219: -- Unable to determine service activity billing type for the item $ITEM.
220: FND_MESSAGE.set_token( 'ITEM', i_rec.DEPOT_ITEM_NAME);
221: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
222: END IF;
223: END LOOP;
224:
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 );
392: ELSIF (i_rec.BILLING_TYPE IS NULL) THEN
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 );
392: ELSIF (i_rec.BILLING_TYPE IS NULL) THEN
393: if (lc_stat_level >= lc_debug_level) then
394: FND_LOG.STRING(lc_stat_level, lc_mod_name,
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 );
402: END IF;
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 );
402: END IF;
403: END IF;
404: END LOOP;
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;
424: FND_MESSAGE.set_name( 'CSD', 'CSD_CHRG_NO_ITEM_SAR');
425: -- Unable to determine service activity billing type for the item $ITEM.
426: FND_MESSAGE.set_token( 'ITEM', i_rec.DEPOT_ITEM_NAME);
427: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
428: END IF;
422: 'Unable to determine service activity billing type for the item ' || i_rec.DEPOT_ITEM_NAME);
423: end if;
424: FND_MESSAGE.set_name( 'CSD', 'CSD_CHRG_NO_ITEM_SAR');
425: -- Unable to determine service activity billing type for the item $ITEM.
426: FND_MESSAGE.set_token( 'ITEM', i_rec.DEPOT_ITEM_NAME);
427: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_WARNING_MSG );
428: END IF;
429: END LOOP;
430:
673: if (lc_stat_level >= lc_debug_level) then
674: FND_LOG.STRING(lc_stat_level, lc_mod_name,
675: 'Task debrief lines have more than one distinct currencies.');
676: end if;
677: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_MULTI_CURR_TASK');
678: -- Task debrief lines cannot be imported into actuals for
679: -- the repair order. All charge lines, that were created
680: -- via task debrief, must have the same currency as the
681: -- repair order currency. It was found that, one or more
866: if (lc_proc_level >= lc_debug_level) then
867: FND_LOG.STRING(lc_proc_level, lc_mod_name,
868: 'Unable to create a repair actual line. Create API returned NULL for the repair actual line identifier.');
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;
886: FND_LOG.STRING(lc_excep_level, lc_mod_name,
887: 'Encountered an OTHERS error while creating a repair actual line.');
888: end if;
889: l_skip_curr_row := TRUE;
890: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_ERROR_ACTUAL_LINE');
891: -- Encountered an unknown error while creating a repair actual line. SQLCODE = $SQLCODE , SQLERRM = $SQLERRM
892: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
893: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
894: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
888: end if;
889: l_skip_curr_row := TRUE;
890: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_ERROR_ACTUAL_LINE');
891: -- Encountered an unknown error while creating a repair actual line. SQLCODE = $SQLCODE , SQLERRM = $SQLERRM
892: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
893: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
894: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
895:
896: END;
889: l_skip_curr_row := TRUE;
890: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_ERROR_ACTUAL_LINE');
891: -- Encountered an unknown error while creating a repair actual line. SQLCODE = $SQLCODE , SQLERRM = $SQLERRM
892: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
893: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
894: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
895:
896: END;
897:
948: if (lc_proc_level >= lc_debug_level) then
949: FND_LOG.STRING(lc_proc_level, lc_mod_name,
950: 'Encountered OTHERS error while updating a repair actual line with billing information.');
951: end if;
952: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
953: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
954: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
955: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
956:
949: FND_LOG.STRING(lc_proc_level, lc_mod_name,
950: 'Encountered OTHERS error while updating a repair actual line with billing information.');
951: end if;
952: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
953: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
954: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
955: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
956:
957: END;
950: 'Encountered OTHERS error while updating a repair actual line with billing information.');
951: end if;
952: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
953: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
954: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
955: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
956:
957: END;
958:
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;
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;
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');
1015: -- No eligible Task debrief lines found for import into Actuals.
1016: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
1017: ELSE -- Attempt to import task debrief lines was made.
1018:
1015: -- No eligible Task debrief lines found for import into Actuals.
1016: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
1017: ELSE -- Attempt to import task debrief lines was made.
1018:
1019: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');
1020: -- Import of Task debrief lines into Actuals has completed. Failed to import
1021: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
1022: FND_MESSAGE.set_token('FAILED_COUNT', l_import_line_failed_count);
1023: FND_MESSAGE.set_token('PASS_COUNT',(l_import_line_total_count - l_import_line_failed_count));
1018:
1019: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');
1020: -- Import of Task debrief lines into Actuals has completed. Failed to import
1021: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
1022: FND_MESSAGE.set_token('FAILED_COUNT', l_import_line_failed_count);
1023: FND_MESSAGE.set_token('PASS_COUNT',(l_import_line_total_count - l_import_line_failed_count));
1024: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
1025: END IF;
1026:
1019: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');
1020: -- Import of Task debrief lines into Actuals has completed. Failed to import
1021: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
1022: FND_MESSAGE.set_token('FAILED_COUNT', l_import_line_failed_count);
1023: FND_MESSAGE.set_token('PASS_COUNT',(l_import_line_total_count - l_import_line_failed_count));
1024: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
1025: END IF;
1026:
1027: if (lc_proc_level >= lc_debug_level) 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;
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;
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;
1105: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_TASK_IMPORT');
1106: -- Unknown generic error encountered while importing Task debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
1107: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
1108: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
1109: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1103: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,lc_api_name );
1104: END IF;
1105: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_TASK_IMPORT');
1106: -- Unknown generic error encountered while importing Task debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
1107: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
1108: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
1109: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1110: FND_MSG_PUB.Count_And_Get
1111: (p_count => x_msg_count,
1104: END IF;
1105: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_TASK_IMPORT');
1106: -- Unknown generic error encountered while importing Task debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
1107: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
1108: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
1109: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1110: FND_MSG_PUB.Count_And_Get
1111: (p_count => x_msg_count,
1112: p_data => x_msg_data );
1509: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1510: 'Unable to determine default price list for the repair order.');
1511: end if;
1512: -- Unable to determine default pricelist
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;
1561: 'The WIP job ' || inelgible_WIP_rec.JOB_NAME || 'is shared across Repair Orders'
1562: || '. It is not imported');
1563: END IF;
1564: -- Add an INFO message indicating whether the job will not be imported.
1565: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_INELIGIBLE_WIP');
1566: -- The WIP job $JOB_NAME is submitted for more than one repair order.
1567: -- The actual lines, for a WIP job that is shared across repair orders,
1568: -- can not be imported.
1569: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );
1565: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_INELIGIBLE_WIP');
1566: -- The WIP job $JOB_NAME is submitted for more than one repair order.
1567: -- The actual lines, for a WIP job that is shared across repair orders,
1568: -- can not be imported.
1569: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );
1570: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
1571:
1572: if (lc_proc_level >= lc_debug_level) then
1573: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2070: END IF;
2071:
2072: -- Add an INFO message indicating whether the jobs has any warnings.
2073: -- Also mention the number of actual lines created.
2074: FND_MESSAGE.SET_NAME( 'CSD', l_message );
2075: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2076: FND_MESSAGE.set_token( 'ACTUAL_LINE_COUNT', l_actuals_count );
2077: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
2078:
2071:
2072: -- Add an INFO message indicating whether the jobs has any warnings.
2073: -- Also mention the number of actual lines created.
2074: FND_MESSAGE.SET_NAME( 'CSD', l_message );
2075: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2076: FND_MESSAGE.set_token( 'ACTUAL_LINE_COUNT', l_actuals_count );
2077: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
2078:
2079: -- The reasons the following code appears twice in the procedure are -
2072: -- Add an INFO message indicating whether the jobs has any warnings.
2073: -- Also mention the number of actual lines created.
2074: FND_MESSAGE.SET_NAME( 'CSD', l_message );
2075: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2076: FND_MESSAGE.set_token( 'ACTUAL_LINE_COUNT', l_actuals_count );
2077: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
2078:
2079: -- The reasons the following code appears twice in the procedure are -
2080: -- 1. We want to log warnings even if there is error in creating
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');
2129: -- An error encountered while importing WIP debrief lines into Actuals for the WIP entity - $JOB_NAME. The lines for the WIP Job will not be imported into actuals.
2130: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2131: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2132:
2126:
2127: -- Add an ERROR message.
2128: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_ERROR');
2129: -- An error encountered while importing WIP debrief lines into Actuals for the WIP entity - $JOB_NAME. The lines for the WIP Job will not be imported into actuals.
2130: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
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,
2185: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2186: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2187: END IF;
2188:
2189: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');
2190: -- Unknown error encountered while importing WIP debrief lines to Actuals for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2191: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2192: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2193: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2187: END IF;
2188:
2189: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');
2190: -- Unknown error encountered while importing WIP debrief lines to Actuals for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2191: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2192: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2193: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2194: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2195:
2188:
2189: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');
2190: -- Unknown error encountered while importing WIP debrief lines to Actuals for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2191: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2192: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2193: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2194: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2195:
2196: if (lc_proc_level >= lc_debug_level) then
2189: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');
2190: -- Unknown error encountered while importing WIP debrief lines to Actuals for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2191: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2192: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2193: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2194: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2195:
2196: if (lc_proc_level >= lc_debug_level) then
2197: FND_LOG.STRING(lc_proc_level, lc_mod_name,
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);
2240: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
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);
2240: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
2241: -- FND_MSG_PUB.add;
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;
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;
2336: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2337: 'GENERIC_MSG_SAVE_FAILED. SQL Message['||x_msg_data||']');
2338: END IF;
2339:
2340: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
2341: -- Unable to save messages using the generic logging utility.
2342: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2343:
2344: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2361: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2362: 'WHEN OTHERS THEN. SQL Message['||SQLERRM||']');
2363: END IF;
2364:
2365: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_OTHERS');
2366: -- Unknown error encountered while importing WIP debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
2367: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2368: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2369: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2363: END IF;
2364:
2365: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_OTHERS');
2366: -- Unknown error encountered while importing WIP debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
2367: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2368: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2369: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2371: p_data => x_msg_data );
2364:
2365: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_OTHERS');
2366: -- Unknown error encountered while importing WIP debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
2367: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2368: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2369: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2370: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2371: p_data => x_msg_data );
2372: END Import_Actuals_From_Wip;
2674: if (lc_proc_level >= lc_debug_level) then
2675: FND_LOG.STRING(lc_proc_level, lc_mod_name,
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:
2689: if (lc_proc_level >= lc_debug_level) then
2690: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2691: 'Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = ' || SQLCODE || ', SQLERRM = ' || SQLERRM );
2692: end if;
2693: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
2694: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2695: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2696: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2697: END;
2690: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2691: 'Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = ' || SQLCODE || ', SQLERRM = ' || SQLERRM );
2692: end if;
2693: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
2694: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2695: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2696: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2697: END;
2698:
2691: 'Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = ' || SQLCODE || ', SQLERRM = ' || SQLERRM );
2692: end if;
2693: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
2694: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2695: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2696: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2697: END;
2698:
2699: IF NOT l_skip_curr_row THEN
2814: if (lc_proc_level >= lc_debug_level) then
2815: FND_LOG.STRING(lc_proc_level, lc_mod_name,
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:
2833: if (lc_proc_level >= lc_debug_level) then
2834: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2835: 'Encountered OTHERS error while creating a repair actual line.');
2836: end if;
2837: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2838: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2839: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2840: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2841:
2834: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2835: 'Encountered OTHERS error while creating a repair actual line.');
2836: end if;
2837: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2838: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2839: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2840: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2841:
2842: END;
2835: 'Encountered OTHERS error while creating a repair actual line.');
2836: end if;
2837: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2838: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2839: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2840: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2841:
2842: END;
2843:
2894: if (lc_proc_level >= lc_debug_level) then
2895: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2896: 'Encountered OTHERS error while updating a repair actual line with billing information.');
2897: end if;
2898: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2899: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2900: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2901: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2902:
2895: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2896: 'Encountered OTHERS error while updating a repair actual line with billing information.');
2897: end if;
2898: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2899: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2900: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2901: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2902:
2903: END;
2896: 'Encountered OTHERS error while updating a repair actual line with billing information.');
2897: end if;
2898: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2899: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2900: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2901: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2902:
2903: END;
2904: -- end swai: bug 7119695
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;
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:
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');
2964: -- No eligible Estimate lines found for import into Actuals.
2965: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
2966: ELSE -- Attempt to import estimate lines was made.
2967:
2964: -- No eligible Estimate lines found for import into Actuals.
2965: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
2966: ELSE -- Attempt to import estimate lines was made.
2967:
2968: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');
2969: -- Import of Estimate lines into Actuals has completed. Failed to import
2970: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
2971: FND_MESSAGE.set_token('FAILED_COUNT', l_est_line_failed_count);
2972: FND_MESSAGE.set_token('PASS_COUNT',(l_est_line_total_count - l_est_line_failed_count));
2967:
2968: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');
2969: -- Import of Estimate lines into Actuals has completed. Failed to import
2970: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
2971: FND_MESSAGE.set_token('FAILED_COUNT', l_est_line_failed_count);
2972: FND_MESSAGE.set_token('PASS_COUNT',(l_est_line_total_count - l_est_line_failed_count));
2973: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
2974: END IF;
2975:
2968: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');
2969: -- Import of Estimate lines into Actuals has completed. Failed to import
2970: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
2971: FND_MESSAGE.set_token('FAILED_COUNT', l_est_line_failed_count);
2972: FND_MESSAGE.set_token('PASS_COUNT',(l_est_line_total_count - l_est_line_failed_count));
2973: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
2974: END IF;
2975:
2976: if (lc_proc_level >= lc_debug_level) 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;
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;
3055: FND_MSG_PUB.Add_Exc_Msg
3056: (G_PKG_NAME ,
3057: lc_api_name );
3058: END IF;
3059: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
3060: -- Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
3061: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
3062: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3063: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
3057: lc_api_name );
3058: END IF;
3059: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
3060: -- Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
3061: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
3062: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3063: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
3064: FND_MSG_PUB.Count_And_Get
3065: (p_count => x_msg_count,
3058: END IF;
3059: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
3060: -- Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
3061: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
3062: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3063: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
3064: FND_MSG_PUB.Count_And_Get
3065: (p_count => x_msg_count,
3066: p_data => x_msg_data );