DBA Data[Home] [Help]

APPS.CSP_AUTO_ASLMSL_PVT dependencies on FND_MESSAGE

Line 329: fnd_message.set_name('CSP','CSP_ASL_MSG');

325: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
326: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
327: End If;
328: -- End If;
329: fnd_message.set_name('CSP','CSP_ASL_MSG');
330: fnd_message.set_token('VALUE','calculate_forecast');
331: fnd_msg_pub.add;
332: Add_Err_Msg;
333: -- Calculate New Product Planning

Line 330: fnd_message.set_token('VALUE','calculate_forecast');

326: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
327: End If;
328: -- End If;
329: fnd_message.set_name('CSP','CSP_ASL_MSG');
330: fnd_message.set_token('VALUE','calculate_forecast');
331: fnd_msg_pub.add;
332: Add_Err_Msg;
333: -- Calculate New Product Planning
334: -- Re-establish Savepoint

Line 348: fnd_message.set_name('CSP','CSP_ASL_MSG');

344: X_Msg_Data => X_Msg_Data );
345: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
346: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
347: End If;
348: fnd_message.set_name('CSP','CSP_ASL_MSG');
349: fnd_message.set_token('VALUE','calculate_new_product_planning');
350: fnd_msg_pub.add;
351: Add_Err_Msg;
352: -- Calculate Product Norm

Line 349: fnd_message.set_token('VALUE','calculate_new_product_planning');

345: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
346: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
347: End If;
348: fnd_message.set_name('CSP','CSP_ASL_MSG');
349: fnd_message.set_token('VALUE','calculate_new_product_planning');
350: fnd_msg_pub.add;
351: Add_Err_Msg;
352: -- Calculate Product Norm
353: If l_pnorm_count > 0 Then

Line 369: fnd_message.set_name('CSP','CSP_ASL_MSG');

365: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
366: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
367: End If;
368: End If;
369: fnd_message.set_name('CSP','CSP_ASL_MSG');
370: fnd_message.set_token('VALUE','calculate_product_norm');
371: fnd_msg_pub.add;
372: Add_Err_Msg;
373: -- Calculate Territory Norm

Line 370: fnd_message.set_token('VALUE','calculate_product_norm');

366: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
367: End If;
368: End If;
369: fnd_message.set_name('CSP','CSP_ASL_MSG');
370: fnd_message.set_token('VALUE','calculate_product_norm');
371: fnd_msg_pub.add;
372: Add_Err_Msg;
373: -- Calculate Territory Norm
374: If l_tnorm_count > 0 Then

Line 390: fnd_message.set_name('CSP','CSP_ASL_MSG');

386: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
387: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
388: End If;
389: End If;
390: fnd_message.set_name('CSP','CSP_ASL_MSG');
391: fnd_message.set_token('VALUE','calculate_territory_norm');
392: fnd_msg_pub.add;
393: Add_Err_Msg;
394: -- Re-establish Savepoint

Line 391: fnd_message.set_token('VALUE','calculate_territory_norm');

387: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
388: End If;
389: End If;
390: fnd_message.set_name('CSP','CSP_ASL_MSG');
391: fnd_message.set_token('VALUE','calculate_territory_norm');
392: fnd_msg_pub.add;
393: Add_Err_Msg;
394: -- Re-establish Savepoint
395: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 446: fnd_message.set_name('CSP','CSP_ASL_MSG');

442: And cic.cost_type_id = mp.primary_cost_method
443: and (mis.min_minmax_quantity > 0 OR mis.max_minmax_quantity > 0) ;
444:
445: COMMIT;
446: fnd_message.set_name('CSP','CSP_ASL_MSG');
447: fnd_message.set_token('VALUE','Stock List Update');
448: fnd_msg_pub.add;
449: Add_Err_Msg;
450:

Line 447: fnd_message.set_token('VALUE','Stock List Update');

443: and (mis.min_minmax_quantity > 0 OR mis.max_minmax_quantity > 0) ;
444:
445: COMMIT;
446: fnd_message.set_name('CSP','CSP_ASL_MSG');
447: fnd_message.set_token('VALUE','Stock List Update');
448: fnd_msg_pub.add;
449: Add_Err_Msg;
450:
451: -- Re-establish Savepoint

Line 504: fnd_message.set_name('CSP','CSP_ASL_MSG');

500: and (msi.min_minmax_quantity > 0 OR msi.max_minmax_quantity > 0) ;
501:
502: COMMIT;
503:
504: fnd_message.set_name('CSP','CSP_ASL_MSG');
505: fnd_message.set_token('VALUE','Insert Usage Headers Update');
506: fnd_msg_pub.add;
507: Add_Err_Msg;
508: -- Re-establish Savepoint

Line 505: fnd_message.set_token('VALUE','Insert Usage Headers Update');

501:
502: COMMIT;
503:
504: fnd_message.set_name('CSP','CSP_ASL_MSG');
505: fnd_message.set_token('VALUE','Insert Usage Headers Update');
506: fnd_msg_pub.add;
507: Add_Err_Msg;
508: -- Re-establish Savepoint
509: SAVEPOINT GENERATE_RECOMMENDATIONS_PVT;

Line 618: fnd_message.set_name('CSP','CSP_ASL_MSG');

614: nvl(msi.preprocessing_lead_time,0) + nvl(msi.processing_lead_time,0) + nvl(msi.postprocessing_lead_time,0), nvl(msib.preprocessing_lead_time,0) + nvl(msib.full_lead_time,0) + nvl(msib.postprocessing_lead_time,0)),
615: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) ;
616:
617: COMMIT;
618: fnd_message.set_name('CSP','CSP_ASL_MSG');
619: fnd_message.set_token('VALUE','Insert Usage Headers Update2');
620: fnd_msg_pub.add;
621: Add_Err_Msg;
622:

Line 619: fnd_message.set_token('VALUE','Insert Usage Headers Update2');

615: nvl(misi.preprocessing_lead_time,0) + nvl(misi.processing_lead_time,0) + nvl(misi.postprocessing_lead_time,0))) ;
616:
617: COMMIT;
618: fnd_message.set_name('CSP','CSP_ASL_MSG');
619: fnd_message.set_token('VALUE','Insert Usage Headers Update2');
620: fnd_msg_pub.add;
621: Add_Err_Msg;
622:
623: -- Re-establish Savepoint

Line 638: fnd_message.set_name('CSP','CSP_ASL_MSG');

634: and mic.category_set_id = cpp.category_set_id
635: and mic.category_id = nvl(cpp.category_id,mic.category_id));
636:
637: COMMIT;
638: fnd_message.set_name('CSP','CSP_ASL_MSG');
639: fnd_message.set_token('VALUE','Excluded Items');
640: fnd_msg_pub.add;
641: Add_Err_Msg;
642:

Line 639: fnd_message.set_token('VALUE','Excluded Items');

635: and mic.category_id = nvl(cpp.category_id,mic.category_id));
636:
637: COMMIT;
638: fnd_message.set_name('CSP','CSP_ASL_MSG');
639: fnd_message.set_token('VALUE','Excluded Items');
640: fnd_msg_pub.add;
641: Add_Err_Msg;
642:
643: -- Re-establish Savepoint

Line 676: fnd_message.set_name('CSP','CSP_ASL_MSG');

672: WHERE usg_headers.header_data_type = 1
673: and usg_headers.process_status = 'O';
674:
675: COMMIT;
676: fnd_message.set_name('CSP','CSP_ASL_MSG');
677: fnd_message.set_token('VALUE','Min Max');
678: fnd_msg_pub.add;
679: Add_Err_Msg;
680:

Line 677: fnd_message.set_token('VALUE','Min Max');

673: and usg_headers.process_status = 'O';
674:
675: COMMIT;
676: fnd_message.set_name('CSP','CSP_ASL_MSG');
677: fnd_message.set_token('VALUE','Min Max');
678: fnd_msg_pub.add;
679: Add_Err_Msg;
680:
681: -- Re-establish Savepoint

Line 712: fnd_message.set_name('CSP','CSP_ASL_MSG');

708: WHERE usg_headers.header_data_type = 4
709: and usg_headers.process_status = 'O';
710:
711: COMMIT;
712: fnd_message.set_name('CSP','CSP_ASL_MSG');
713: fnd_message.set_token('VALUE','Min Max');
714: fnd_msg_pub.add;
715: Add_Err_Msg;
716:

Line 713: fnd_message.set_token('VALUE','Min Max');

709: and usg_headers.process_status = 'O';
710:
711: COMMIT;
712: fnd_message.set_name('CSP','CSP_ASL_MSG');
713: fnd_message.set_token('VALUE','Min Max');
714: fnd_msg_pub.add;
715: Add_Err_Msg;
716:
717: -- Re-establish Savepoint

Line 776: fnd_message.set_name('CSP','CSP_ASL_MSG');

772: a.forecast_periods)
773: where cuh.header_data_type = 1
774: and process_status = 'O';
775: COMMIT;
776: fnd_message.set_name('CSP','CSP_ASL_MSG');
777: fnd_message.set_token('VALUE','Tracking signal');
778: fnd_msg_pub.add;
779: Add_Err_Msg;
780:

Line 777: fnd_message.set_token('VALUE','Tracking signal');

773: where cuh.header_data_type = 1
774: and process_status = 'O';
775: COMMIT;
776: fnd_message.set_name('CSP','CSP_ASL_MSG');
777: fnd_message.set_token('VALUE','Tracking signal');
778: fnd_msg_pub.add;
779: Add_Err_Msg;
780:
781: -- Re-establish Savepoint

Line 832: fnd_message.set_name('CSP','CSP_ASL_MSG');

828: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
829: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
830: End If;
831:
832: fnd_message.set_name('CSP','CSP_ASL_MSG');
833: fnd_message.set_token('VALUE','Apply Business Rules');
834: fnd_msg_pub.add;
835: Add_Err_Msg;
836: end if;

Line 833: fnd_message.set_token('VALUE','Apply Business Rules');

829: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
830: End If;
831:
832: fnd_message.set_name('CSP','CSP_ASL_MSG');
833: fnd_message.set_token('VALUE','Apply Business Rules');
834: fnd_msg_pub.add;
835: Add_Err_Msg;
836: end if;
837: --

Line 886: fnd_message.set_name('CSP','CSP_ASL_MSG');

882: l_sqlcode := SQLCODE;
883: l_sqlerrm := SQLERRM;
884: retcode := 2;
885: errbuf := SQLERRM;
886: fnd_message.set_name('CSP','CSP_ASL_MSG');
887: fnd_message.set_token('VALUE',l_sqlcode || ' ' || l_sqlerrm);
888: fnd_msg_pub.add;
889: Add_Err_Msg;
890: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 887: fnd_message.set_token('VALUE',l_sqlcode || ' ' || l_sqlerrm);

883: l_sqlerrm := SQLERRM;
884: retcode := 2;
885: errbuf := SQLERRM;
886: fnd_message.set_name('CSP','CSP_ASL_MSG');
887: fnd_message.set_token('VALUE',l_sqlcode || ' ' || l_sqlerrm);
888: fnd_msg_pub.add;
889: Add_Err_Msg;
890: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
891: P_API_NAME => L_API_NAME