DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on FND_MESSAGE

Line 149: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_RESOURCE_NO_ITEM');

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;

Line 151: FND_MESSAGE.set_token( 'RESOURCE_CODE', i_rec.RESOURCE_CODE );

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

Line 181: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_ITEM_NOT_SRV_ORG');

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

Line 183: FND_MESSAGE.set_token( 'ITEM_NAME', i_rec.WIP_ITEM_NAME );

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

Line 191: FND_MESSAGE.set_name( 'CSD', 'CSD_ACT_ITEM_NO_BILLING_TYPE');

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;

Line 193: FND_MESSAGE.set_token( 'ITEM_NAME', i_rec.WIP_ITEM_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;
196: END IF;
197:

Line 218: FND_MESSAGE.set_name( 'CSD', 'CSD_CHRG_NO_ITEM_SAR');

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;

Line 220: FND_MESSAGE.set_token( 'ITEM', i_rec.DEPOT_ITEM_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;
223: END LOOP;
224:

Line 388: FND_MESSAGE.set_name('CSD','CSD_ACT_ITEM_NOT_SRV_ORG');

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

Line 390: FND_MESSAGE.set_token('ITEM_NAME', i_rec.WIP_ITEM_NAME);

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,

Line 398: FND_MESSAGE.set_name('CSD','CSD_ACT_ITEM_NO_BILLING_TYPE');

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;

Line 400: FND_MESSAGE.set_token('ITEM_NAME', 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;
403: END IF;
404: END LOOP;

Line 424: FND_MESSAGE.set_name( 'CSD', 'CSD_CHRG_NO_ITEM_SAR');

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;

Line 426: FND_MESSAGE.set_token( 'ITEM', i_rec.DEPOT_ITEM_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;
429: END LOOP;
430:

Line 686: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_MULTI_CURR_TASK');

682: if (lc_stat_level >= lc_debug_level) then
683: FND_LOG.STRING(lc_stat_level, lc_mod_name,
684: 'Task debrief lines have more than one distinct currencies.');
685: end if;
686: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_MULTI_CURR_TASK');
687: -- Task debrief lines cannot be imported into actuals for
688: -- the repair order. All charge lines, that were created
689: -- via task debrief, must have the same currency as the
690: -- repair order currency. It was found that, one or more

Line 879: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_NULL_ACTUAL_ID');

875: if (lc_proc_level >= lc_debug_level) then
876: FND_LOG.STRING(lc_proc_level, lc_mod_name,
877: 'Unable to create a repair actual line. Create API returned NULL for the repair actual line identifier.');
878: end if;
879: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_NULL_ACTUAL_ID');
880: -- 'Unable to create a repair actual line. Create API returned NULL for the repair actual line identifier.
881: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;

Line 899: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_ERROR_ACTUAL_LINE');

895: FND_LOG.STRING(lc_excep_level, lc_mod_name,
896: 'Encountered an OTHERS error while creating a repair actual line.');
897: end if;
898: l_skip_curr_row := TRUE;
899: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_ERROR_ACTUAL_LINE');
900: -- Encountered an unknown error while creating a repair actual line. SQLCODE = $SQLCODE , SQLERRM = $SQLERRM
901: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
902: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
903: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);

Line 901: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

897: end if;
898: l_skip_curr_row := TRUE;
899: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_ERROR_ACTUAL_LINE');
900: -- Encountered an unknown error while creating a repair actual line. SQLCODE = $SQLCODE , SQLERRM = $SQLERRM
901: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
902: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
903: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
904:
905: END;

Line 902: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

898: l_skip_curr_row := TRUE;
899: FND_MESSAGE.SET_NAME('CSD','CSD_ACT_ERROR_ACTUAL_LINE');
900: -- Encountered an unknown error while creating a repair actual line. SQLCODE = $SQLCODE , SQLERRM = $SQLERRM
901: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
902: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
903: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
904:
905: END;
906:

Line 974: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');

970: if (lc_proc_level >= lc_debug_level) then
971: FND_LOG.STRING(lc_proc_level, lc_mod_name,
972: 'Encountered OTHERS error while updating a repair actual line with billing information.');
973: end if;
974: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
975: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
976: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
977: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
978:

Line 975: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

971: FND_LOG.STRING(lc_proc_level, lc_mod_name,
972: 'Encountered OTHERS error while updating a repair actual line with billing information.');
973: end if;
974: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
975: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
976: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
977: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
978:
979: END;

Line 976: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

972: 'Encountered OTHERS error while updating a repair actual line with billing information.');
973: end if;
974: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
975: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
976: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
977: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
978:
979: END;
980:

Line 1022: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');

1018: if (lc_proc_level >= lc_debug_level) then
1019: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1020: 'Unable to save messages using the generic logging utility.');
1021: end if;
1022: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
1023: -- Unable to save messages using the generic logging utility.
1024: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;

Line 1036: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_INELIGIBLE');

1032: x_warning_flag := FND_API.G_TRUE;
1033:
1034: -- If no eligible task debrief lines found for import.
1035: IF( l_import_line_total_count <= 0 ) THEN
1036: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_INELIGIBLE');
1037: -- No eligible Task debrief lines found for import into Actuals.
1038: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
1039: ELSE -- Attempt to import task debrief lines was made.
1040:

Line 1041: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');

1037: -- No eligible Task debrief lines found for import into Actuals.
1038: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
1039: ELSE -- Attempt to import task debrief lines was made.
1040:
1041: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');
1042: -- Import of Task debrief lines into Actuals has completed. Failed to import
1043: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
1044: FND_MESSAGE.set_token('FAILED_COUNT', l_import_line_failed_count);
1045: FND_MESSAGE.set_token('PASS_COUNT',(l_import_line_total_count - l_import_line_failed_count));

Line 1044: FND_MESSAGE.set_token('FAILED_COUNT', l_import_line_failed_count);

1040:
1041: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');
1042: -- Import of Task debrief lines into Actuals has completed. Failed to import
1043: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
1044: FND_MESSAGE.set_token('FAILED_COUNT', l_import_line_failed_count);
1045: FND_MESSAGE.set_token('PASS_COUNT',(l_import_line_total_count - l_import_line_failed_count));
1046: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
1047: END IF;
1048:

Line 1045: FND_MESSAGE.set_token('PASS_COUNT',(l_import_line_total_count - l_import_line_failed_count));

1041: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');
1042: -- Import of Task debrief lines into Actuals has completed. Failed to import
1043: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
1044: FND_MESSAGE.set_token('FAILED_COUNT', l_import_line_failed_count);
1045: FND_MESSAGE.set_token('PASS_COUNT',(l_import_line_total_count - l_import_line_failed_count));
1046: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
1047: END IF;
1048:
1049: if (lc_proc_level >= lc_debug_level) then

Line 1079: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');

1075: if (lc_proc_level >= lc_debug_level) then
1076: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1077: 'Unable to save messages using the generic logging utility.');
1078: end if;
1079: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
1080: -- Unable to save messages using the generic logging utility.
1081: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;

Line 1127: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_TASK_IMPORT');

1123: ROLLBACK TO Import_Actuals_Task_sp;
1124: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1125: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,lc_api_name );
1126: END IF;
1127: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_TASK_IMPORT');
1128: -- Unknown generic error encountered while importing Task debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
1129: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
1130: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
1131: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);

Line 1129: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

1125: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,lc_api_name );
1126: END IF;
1127: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_TASK_IMPORT');
1128: -- Unknown generic error encountered while importing Task debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
1129: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
1130: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
1131: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1132: FND_MSG_PUB.Count_And_Get
1133: (p_count => x_msg_count,

Line 1130: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

1126: END IF;
1127: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_TASK_IMPORT');
1128: -- Unknown generic error encountered while importing Task debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
1129: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
1130: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
1131: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
1132: FND_MSG_PUB.Count_And_Get
1133: (p_count => x_msg_count,
1134: p_data => x_msg_data );

Line 1570: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_DEFAULT_PL_IMPORT');

1566: FND_LOG.STRING(lc_proc_level, lc_mod_name,
1567: 'Unable to determine default price list for the repair order.');
1568: end if;
1569: -- Unable to determine default pricelist
1570: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_DEFAULT_PL_IMPORT');
1571: -- Unable to determine default price list for the repair order.
1572: -- A default price list must be selected for the repair order to import actual lines.
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;

Line 1622: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_INELIGIBLE_WIP');

1618: 'The WIP job ' || inelgible_WIP_rec.JOB_NAME || 'is shared across Repair Orders'
1619: || '. It is not imported');
1620: END IF;
1621: -- Add an INFO message indicating whether the job will not be imported.
1622: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_INELIGIBLE_WIP');
1623: -- The WIP job $JOB_NAME is submitted for more than one repair order.
1624: -- The actual lines, for a WIP job that is shared across repair orders,
1625: -- can not be imported.
1626: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );

Line 1626: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );

1622: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_INELIGIBLE_WIP');
1623: -- The WIP job $JOB_NAME is submitted for more than one repair order.
1624: -- The actual lines, for a WIP job that is shared across repair orders,
1625: -- can not be imported.
1626: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );
1627: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
1628:
1629: if (lc_proc_level >= lc_debug_level) then
1630: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 2165: FND_MESSAGE.SET_NAME( 'CSD', l_message );

2161: END IF;
2162:
2163: -- Add an INFO message indicating whether the jobs has any warnings.
2164: -- Also mention the number of actual lines created.
2165: FND_MESSAGE.SET_NAME( 'CSD', l_message );
2166: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2167: FND_MESSAGE.set_token( 'ACTUAL_LINE_COUNT', l_actuals_count );
2168: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
2169:

Line 2166: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );

2162:
2163: -- Add an INFO message indicating whether the jobs has any warnings.
2164: -- Also mention the number of actual lines created.
2165: FND_MESSAGE.SET_NAME( 'CSD', l_message );
2166: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2167: FND_MESSAGE.set_token( 'ACTUAL_LINE_COUNT', l_actuals_count );
2168: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
2169:
2170: -- The reasons the following code appears twice in the procedure are -

Line 2167: FND_MESSAGE.set_token( 'ACTUAL_LINE_COUNT', l_actuals_count );

2163: -- Add an INFO message indicating whether the jobs has any warnings.
2164: -- Also mention the number of actual lines created.
2165: FND_MESSAGE.SET_NAME( 'CSD', l_message );
2166: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2167: FND_MESSAGE.set_token( 'ACTUAL_LINE_COUNT', l_actuals_count );
2168: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
2169:
2170: -- The reasons the following code appears twice in the procedure are -
2171: -- 1. We want to log warnings even if there is error in creating

Line 2219: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_ERROR');

2215: x_warning_flag := FND_API.G_TRUE;
2216: ROLLBACK TO curr_wip_job_sp;
2217:
2218: -- Add an ERROR message.
2219: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_ERROR');
2220: -- 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.
2221: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2222: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2223:

Line 2221: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );

2217:
2218: -- Add an ERROR message.
2219: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_ERROR');
2220: -- 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.
2221: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2222: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2223:
2224: -- Save the messages using generic utility.
2225: CSD_GEN_ERRMSGS_PVT.save_fnd_msgs( p_api_version => 1.0,

Line 2280: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');

2276: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2278: END IF;
2279:
2280: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');
2281: -- Unknown error encountered while importing WIP debrief lines to Actuals for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2282: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2283: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2284: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );

Line 2282: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

2278: END IF;
2279:
2280: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');
2281: -- Unknown error encountered while importing WIP debrief lines to Actuals for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2282: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2283: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2284: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2285: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2286:

Line 2283: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

2279:
2280: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');
2281: -- Unknown error encountered while importing WIP debrief lines to Actuals for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2282: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2283: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2284: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2285: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2286:
2287: if (lc_proc_level >= lc_debug_level) then

Line 2284: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );

2280: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMP_JOB_ERR');
2281: -- Unknown error encountered while importing WIP debrief lines to Actuals for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
2282: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2283: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2284: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
2285: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2286:
2287: if (lc_proc_level >= lc_debug_level) then
2288: FND_LOG.STRING(lc_proc_level, lc_mod_name,

Line 2327: -- FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_INELIGIBLE');

2323: end if;
2324:
2325: IF( l_wip_count <= 0 ) THEN
2326: x_warning_flag := FND_API.G_TRUE;
2327: -- FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_INELIGIBLE');
2328: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_NO_INELIGIBLE_WIP');
2329: -- No eligible WIP jobs found for import
2330: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
2331: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);

Line 2328: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_NO_INELIGIBLE_WIP');

2324:
2325: IF( l_wip_count <= 0 ) THEN
2326: x_warning_flag := FND_API.G_TRUE;
2327: -- FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_INELIGIBLE');
2328: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_NO_INELIGIBLE_WIP');
2329: -- No eligible WIP jobs found for import
2330: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
2331: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
2332: -- FND_MSG_PUB.add;

Line 2364: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');

2360: if (lc_proc_level >= lc_debug_level) then
2361: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2362: 'Unable to save messages using the generic logging utility.');
2363: end if;
2364: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
2365: -- Unable to save messages using the generic logging utility.
2366: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2367: RAISE FND_API.G_EXC_ERROR;
2368: END IF;

Line 2431: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');

2427: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2428: 'GENERIC_MSG_SAVE_FAILED. SQL Message['||x_msg_data||']');
2429: END IF;
2430:
2431: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
2432: -- Unable to save messages using the generic logging utility.
2433: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2434:
2435: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 2456: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_OTHERS');

2452: FND_LOG.STRING(lc_excep_level, lc_mod_name,
2453: 'WHEN OTHERS THEN. SQL Message['||SQLERRM||']');
2454: END IF;
2455:
2456: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_OTHERS');
2457: -- Unknown error encountered while importing WIP debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
2458: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2459: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2460: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);

Line 2458: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

2454: END IF;
2455:
2456: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_OTHERS');
2457: -- Unknown error encountered while importing WIP debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
2458: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2459: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2460: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2462: p_data => x_msg_data );

Line 2459: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

2455:
2456: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_WIP_IMPORT_OTHERS');
2457: -- Unknown error encountered while importing WIP debrief lines to Actuals. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
2458: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2459: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2460: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2462: p_data => x_msg_data );
2463: END Import_Actuals_From_Wip;

Line 2774: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_COPY_CHRG_LINE_FAIL');

2770: if (lc_proc_level >= lc_debug_level) then
2771: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2772: 'Unable to copy the Estimate charge line into Actual charge line. Charges API returned NULL for the Estimate Detail identifier.');
2773: end if;
2774: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_COPY_CHRG_LINE_FAIL');
2775: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2776: RAISE FND_API.G_EXC_ERROR;
2777: END IF;
2778:

Line 2789: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');

2785: if (lc_proc_level >= lc_debug_level) then
2786: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2787: 'Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = ' || SQLCODE || ', SQLERRM = ' || SQLERRM );
2788: end if;
2789: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
2790: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2791: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2792: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2793: END;

Line 2790: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

2786: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2787: 'Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = ' || SQLCODE || ', SQLERRM = ' || SQLERRM );
2788: end if;
2789: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
2790: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2791: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2792: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2793: END;
2794:

Line 2791: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

2787: 'Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = ' || SQLCODE || ', SQLERRM = ' || SQLERRM );
2788: end if;
2789: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
2790: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2791: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2792: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2793: END;
2794:
2795: IF NOT l_skip_curr_row THEN

Line 2914: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_NULL_ACTUAL_ID');

2910: if (lc_proc_level >= lc_debug_level) then
2911: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2912: 'Unable to create a repair actual line. Create API returned NULL for the repair actual line identifier.');
2913: end if;
2914: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_NULL_ACTUAL_ID');
2915: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2918:

Line 2933: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');

2929: if (lc_proc_level >= lc_debug_level) then
2930: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2931: 'Encountered OTHERS error while creating a repair actual line.');
2932: end if;
2933: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2934: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2935: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2936: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2937:

Line 2934: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

2930: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2931: 'Encountered OTHERS error while creating a repair actual line.');
2932: end if;
2933: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2934: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2935: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2936: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2937:
2938: END;

Line 2935: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

2931: 'Encountered OTHERS error while creating a repair actual line.');
2932: end if;
2933: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_ERROR_ACTUAL_LINE');
2934: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
2935: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
2936: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2937:
2938: END;
2939:

Line 2993: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');

2989: if (lc_proc_level >= lc_debug_level) then
2990: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2991: 'Unable to save messages using the generic logging utility.');
2992: end if;
2993: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
2994: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997:

Line 3006: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_INELIGIBLE');

3002: x_warning_flag := FND_API.G_TRUE;
3003:
3004: -- If no eligible estimate lines found for import.
3005: IF( l_est_line_total_count <= 0 ) THEN
3006: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_INELIGIBLE');
3007: -- No eligible Estimate lines found for import into Actuals.
3008: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
3009: ELSE -- Attempt to import estimate lines was made.
3010:

Line 3011: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');

3007: -- No eligible Estimate lines found for import into Actuals.
3008: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
3009: ELSE -- Attempt to import estimate lines was made.
3010:
3011: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');
3012: -- Import of Estimate lines into Actuals has completed. Failed to import
3013: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
3014: FND_MESSAGE.set_token('FAILED_COUNT', l_est_line_failed_count);
3015: FND_MESSAGE.set_token('PASS_COUNT',(l_est_line_total_count - l_est_line_failed_count));

Line 3014: FND_MESSAGE.set_token('FAILED_COUNT', l_est_line_failed_count);

3010:
3011: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');
3012: -- Import of Estimate lines into Actuals has completed. Failed to import
3013: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
3014: FND_MESSAGE.set_token('FAILED_COUNT', l_est_line_failed_count);
3015: FND_MESSAGE.set_token('PASS_COUNT',(l_est_line_total_count - l_est_line_failed_count));
3016: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
3017: END IF;
3018:

Line 3015: FND_MESSAGE.set_token('PASS_COUNT',(l_est_line_total_count - l_est_line_failed_count));

3011: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');
3012: -- Import of Estimate lines into Actuals has completed. Failed to import
3013: -- FAILED_COUNT lines. PASS_COUNT lines were imported successfully.
3014: FND_MESSAGE.set_token('FAILED_COUNT', l_est_line_failed_count);
3015: FND_MESSAGE.set_token('PASS_COUNT',(l_est_line_total_count - l_est_line_failed_count));
3016: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
3017: END IF;
3018:
3019: if (lc_proc_level >= lc_debug_level) then

Line 3049: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');

3045: if (lc_proc_level >= lc_debug_level) then
3046: FND_LOG.STRING(lc_proc_level, lc_mod_name,
3047: 'Unable to save messages using the generic logging utility.');
3048: end if;
3049: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GENERIC_SAVE_FAILED');
3050: -- Unable to save messages using the generic logging utility.
3051: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
3052: RAISE FND_API.G_EXC_ERROR;
3053: END IF;

Line 3102: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');

3098: FND_MSG_PUB.Add_Exc_Msg
3099: (G_PKG_NAME ,
3100: lc_api_name );
3101: END IF;
3102: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
3103: -- Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
3104: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
3105: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3106: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);

Line 3104: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

3100: lc_api_name );
3101: END IF;
3102: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
3103: -- Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
3104: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
3105: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3106: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
3107: FND_MSG_PUB.Count_And_Get
3108: (p_count => x_msg_count,

Line 3105: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

3101: END IF;
3102: FND_MESSAGE.SET_NAME('CSD', 'CSD_ACT_EST_IMPORT_ERR');
3103: -- Encountered an unknown error while copying an estimate charge line to an actual charge line. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
3104: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
3105: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
3106: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
3107: FND_MSG_PUB.Count_And_Get
3108: (p_count => x_msg_count,
3109: p_data => x_msg_data );