[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
606: END IF;
607:
608: -- Initialize message list if p_init_msg_list is set to TRUE.
609: IF FND_API.to_Boolean( p_init_msg_list ) THEN
610: FND_MSG_PUB.initialize;
611: END IF;
612:
613: -- logging
614: if (lc_proc_level >= lc_debug_level) then
689: -- via task debrief, must have the same currency as the
690: -- repair order currency. It was found that, one or more
691: -- charge line(s) are in a currency different than the
692: -- repair order currency.
693: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696:
697: -- Before we start the process of copying the
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;
884:
885: EXCEPTION
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:
907: -- swai: bug 7122368 - 3rd party billing, need to set account info
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:
981: IF l_skip_curr_row THEN
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;
1027:
1028: END IF;
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:
1041: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_TASK_SUMMARY');
1042: -- Import of Task debrief lines into Actuals has completed. Failed to import
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
1050: 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;
1084:
1085: -- Standard check of p_commit.
1096: EXCEPTION
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: x_return_status := FND_API.G_RET_STS_ERROR ;
1099: ROLLBACK TO Import_Actuals_Task_sp;
1100: FND_MSG_PUB.Count_And_Get
1101: (p_count => x_msg_count,
1102: p_data => x_msg_data );
1103:
1104: -- save message in debug log
1108: END IF;
1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1111: ROLLBACK TO Import_Actuals_Task_sp;
1112: FND_MSG_PUB.Count_And_Get
1113: ( p_count => x_msg_count,
1114: p_data => x_msg_data );
1115:
1116: -- save message in debug log
1120: END IF;
1121: WHEN OTHERS THEN
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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.
1121: WHEN OTHERS THEN
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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);
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 );
1135: -- save message in debug log
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 );
1135: -- save message in debug log
1136: IF (lc_excep_level >= lc_debug_level) THEN
1410: END IF;
1411:
1412: -- Initialize message list if p_init_msg_list is set to TRUE.
1413: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1414: FND_MSG_PUB.initialize;
1415: END IF;
1416:
1417: -- logging
1418: if (lc_proc_level >= lc_debug_level) then
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;
1575: END IF;
1576:
1577: --DBMS_OUTPUT.put_line( 'The price list is available ' );
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,
1631: 'Calling CSD_GEN_ERRMSGS_PVT.save_fnd_msgs');
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
2172: -- repair actual line. That's why the previous call is placed
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,
2226: -- p_commit => FND_API.G_TRUE,
2239: RAISE GENERIC_MSG_SAVE_FAILED;
2240: END IF;
2241:
2242: /*
2243: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2244: p_data => x_msg_data);
2245: */
2246:
2247: WHEN GENERIC_MSG_SAVE_FAILED THEN
2272: -- || SQLCODE );
2273: --DBMS_OUTPUT.put_line( ' SQLERRM = '
2274: -- || SQLERRM );
2275:
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');
2273: --DBMS_OUTPUT.put_line( ' SQLERRM = '
2274: -- || SQLERRM );
2275:
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.
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,
2289: 'Calling CSD_GEN_ERRMSGS_PVT.save_fnd_msgs in WHEN OTHERS THEN');
2310: --DBMS_OUTPUT.put_line( 'Unable to save FND msgs' );
2311: RAISE GENERIC_MSG_SAVE_FAILED;
2312: END IF;
2313: /*
2314: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2315: p_data => x_msg_data );
2316: */
2317: END;
2318: END LOOP; -- for cursor c_eligible_WIP_Jobs
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;
2333:
2334: if (lc_proc_level >= lc_debug_level) then
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;
2333:
2334: if (lc_proc_level >= lc_debug_level) then
2335: FND_LOG.STRING(lc_proc_level, lc_mod_name,
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;
2333:
2334: if (lc_proc_level >= lc_debug_level) then
2335: FND_LOG.STRING(lc_proc_level, lc_mod_name,
2336: 'Calling procedure CSD_GEN_ERRMSGS_PVT.save_fnd_msgs');
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;
2369:
2370: END IF;
2387:
2388: -- Standard call to get message count and IF count is get message info.
2389:
2390: /*
2391: FND_MSG_PUB.Count_And_Get
2392: (p_count => x_msg_count,
2393: p_data => x_msg_data );
2394: */
2395:
2396: EXCEPTION
2397: WHEN FND_API.G_EXC_ERROR THEN
2398: x_return_status := FND_API.G_RET_STS_ERROR;
2399: ROLLBACK TO Import_actuals_wip_sp;
2400: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2401: p_data => x_msg_data );
2402:
2403: -- save message in debug log
2404: IF (lc_excep_level >= lc_debug_level) THEN
2408:
2409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411: ROLLBACK TO Import_actuals_wip_sp;
2412: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2413: p_data => x_msg_data );
2414:
2415: -- save message in debug log
2416: IF (lc_excep_level >= lc_debug_level) THEN
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,
2436: p_data => x_msg_data );
2437:
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,
2436: p_data => x_msg_data );
2437:
2438: WHEN OTHERS THEN
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2442: -- || SQLCODE );
2443: --DBMS_OUTPUT.put_line( ' SQLERRM = '
2444: -- || SQLERRM );
2445:
2446: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2448: END IF;
2449:
2450: -- save message in debug log
2443: --DBMS_OUTPUT.put_line( ' SQLERRM = '
2444: -- || SQLERRM );
2445:
2446: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
2448: END IF;
2449:
2450: -- save message in debug log
2451: IF (lc_excep_level >= lc_debug_level) THEN
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;
2464:
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;
2464:
2465: /*--------------------------------------------------------------------*/
2614: END IF;
2615:
2616: -- Initialize message list if p_init_msg_list is set to TRUE.
2617: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2618: FND_MSG_PUB.initialize;
2619: END IF;
2620:
2621: -- logging
2622: 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:
2779: EXCEPTION
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
2796:
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:
2919: EXCEPTION
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:
2940: --bug#13627518 --bug#14014723
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:
2998: END IF;
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:
3011: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_ACT_EST_SUMMARY');
3012: -- Import of Estimate lines into Actuals has completed. Failed to import
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
3020: 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;
3054:
3055: -- Standard check of p_commit.
3067:
3068: WHEN FND_API.G_EXC_ERROR THEN
3069: x_return_status := FND_API.G_RET_STS_ERROR ;
3070: ROLLBACK TO Import_Actuals_Estimate_sp;
3071: FND_MSG_PUB.Count_And_Get
3072: (p_count => x_msg_count,
3073: p_data => x_msg_data );
3074:
3075: -- save message in debug log
3079: END IF;
3080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3082: ROLLBACK TO Import_Actuals_Estimate_sp;
3083: FND_MSG_PUB.Count_And_Get
3084: ( p_count => x_msg_count,
3085: p_data => x_msg_data );
3086: -- save message in debug log
3087: IF (lc_excep_level >= lc_debug_level) THEN
3091:
3092: WHEN OTHERS THEN
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3094: ROLLBACK TO Import_Actuals_Estimate_sp;
3095: IF FND_MSG_PUB.Check_Msg_Level
3096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3097: THEN
3098: FND_MSG_PUB.Add_Exc_Msg
3099: (G_PKG_NAME ,
3092: WHEN OTHERS THEN
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3094: ROLLBACK TO Import_Actuals_Estimate_sp;
3095: IF FND_MSG_PUB.Check_Msg_Level
3096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3097: THEN
3098: FND_MSG_PUB.Add_Exc_Msg
3099: (G_PKG_NAME ,
3100: lc_api_name );
3094: ROLLBACK TO Import_Actuals_Estimate_sp;
3095: IF FND_MSG_PUB.Check_Msg_Level
3096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3097: THEN
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');
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 );
3110: -- save message in debug log
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 );
3110: -- save message in debug log
3111: IF (lc_excep_level >= lc_debug_level) THEN