[Home] [Help]
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
156: FND_LOG.STRING(lc_stat_level, lc_mod_name,
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
188: FND_LOG.STRING(lc_stat_level, lc_mod_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:
198: END LOOP;
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:
225: if (lc_stat_level >= lc_debug_level) then
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,
395: 'Billing type is not defined for the item ' || i_rec.WIP_ITEM_NAME);
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;
405:
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:
431: if (lc_stat_level >= lc_debug_level) then
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
605: if (lc_proc_level >= lc_debug_level) then
680: -- via task debrief, must have the same currency as the
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
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;
875:
876: EXCEPTION
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:
898: -- swai: bug 7122368 - 3rd party billing, need to set account info
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:
959: IF l_skip_curr_row THEN
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;
1005:
1006: END IF;
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:
1019: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');
1020: -- Import of Task debrief lines into Actuals has completed. Failed to import
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
1028: 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;
1062:
1063: -- Standard check of p_commit.
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 );
1081:
1082: -- save message in debug log
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 );
1093:
1094: -- save message in debug log
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;
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.
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;
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);
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 );
1113: -- save message in debug log
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 );
1113: -- save message in debug log
1114: IF (lc_excep_level >= lc_debug_level) THEN
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
1361: if (lc_proc_level >= lc_debug_level) then
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;
1518: END IF;
1519:
1520: --DBMS_OUTPUT.put_line( 'The price list is available ' );
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,
1574: 'Calling CSD_GEN_ERRMSGS_PVT.save_fnd_msgs');
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
2081: -- repair actual line. That's why the previous call is placed
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,
2135: -- p_commit => FND_API.G_TRUE,
2148: RAISE GENERIC_MSG_SAVE_FAILED;
2149: END IF;
2150:
2151: /*
2152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2153: p_data => x_msg_data);
2154: */
2155:
2156: WHEN GENERIC_MSG_SAVE_FAILED THEN
2181: -- || SQLCODE );
2182: --DBMS_OUTPUT.put_line( ' SQLERRM = '
2183: -- || SQLERRM );
2184:
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');
2182: --DBMS_OUTPUT.put_line( ' SQLERRM = '
2183: -- || SQLERRM );
2184:
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.
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,
2198: 'Calling CSD_GEN_ERRMSGS_PVT.save_fnd_msgs in WHEN OTHERS THEN');
2219: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
2220: RAISE GENERIC_MSG_SAVE_FAILED;
2221: END IF;
2222: /*
2223: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2224: p_data => x_msg_data );
2225: */
2226: END;
2227: END LOOP; -- for cursor c_eligible_WIP_Jobs
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;
2242:
2243: if (lc_proc_level >= lc_debug_level) then
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;
2242:
2243: if (lc_proc_level >= lc_debug_level) then
2244: FND_LOG.STRING(lc_proc_level, lc_mod_name,
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;
2242:
2243: if (lc_proc_level >= lc_debug_level) then
2244: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2245: 'Calling procedure CSD_GEN_ERRMSGS_PVT.save_fnd_msgs');
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;
2278:
2279: END IF;
2296:
2297: -- Standard call to get message count and IF count is get message info.
2298:
2299: /*
2300: FND_MSG_PUB.Count_And_Get
2301: (p_count => x_msg_count,
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 );
2311:
2312: -- save message in debug log
2313: IF (lc_excep_level >= lc_debug_level) THEN
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:
2324: -- save message in debug log
2325: IF (lc_excep_level >= lc_debug_level) THEN
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,
2345: p_data => x_msg_data );
2346:
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,
2345: p_data => x_msg_data );
2346:
2347: WHEN OTHERS THEN
2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2351: -- || SQLCODE );
2352: --DBMS_OUTPUT.put_line( ' SQLERRM = '
2353: -- || SQLERRM );
2354:
2355: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2356: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2357: END IF;
2358:
2359: -- save message in debug log
2352: --DBMS_OUTPUT.put_line( ' SQLERRM = '
2353: -- || SQLERRM );
2354:
2355: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2356: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2357: END IF;
2358:
2359: -- save message in debug log
2360: IF (lc_excep_level >= lc_debug_level) THEN
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;
2373:
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;
2373:
2374: /*--------------------------------------------------------------------*/
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
2530: 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:
2683: EXCEPTION
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
2700:
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:
2823: EXCEPTION
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:
2844: -- swai: bug 7119695 - 3rd party billing, need to set account info
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
2905:
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:
2955: END IF;
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:
2968: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');
2969: -- Import of Estimate lines into Actuals has completed. Failed to import
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
2977: 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;
3011:
3012: -- Standard check of p_commit.
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 );
3031:
3032: -- save message in debug log
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 );
3043: -- save message in debug log
3044: IF (lc_excep_level >= lc_debug_level) THEN
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
3055: FND_MSG_PUB.Add_Exc_Msg
3056: (G_PKG_NAME ,
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
3055: FND_MSG_PUB.Add_Exc_Msg
3056: (G_PKG_NAME ,
3057: lc_api_name );
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
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');
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 );
3067: -- save message in debug log
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 );
3067: -- save message in debug log
3068: IF (lc_excep_level >= lc_debug_level) THEN