DBA Data[Home] [Help]

APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on FND_MESSAGE

Line 269: FND_MESSAGE.Set_Name('CS','CS_CHG_DEFINE_PROFILE_OPTION');

265: -- 'AS_AVAILABLE','WHEN_ALL_TASKS_FINAL', 'WHEN_SERVICE_REQUEST_FINAL'.
266: BEGIN
267: IF l_auto_submit_mode IS NULL THEN
268: FND_MSG_PUB.Initialize;
269: FND_MESSAGE.Set_Name('CS','CS_CHG_DEFINE_PROFILE_OPTION');
270: FND_MESSAGE.Set_Token('PROFILE_OPTION','CS_CHG_AUTO_SUBMIT_MODE');
271: FND_MSG_PUB.Add;
272: -- x_return_status := FND_API.G_RET_STS_ERROR;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 270: FND_MESSAGE.Set_Token('PROFILE_OPTION','CS_CHG_AUTO_SUBMIT_MODE');

266: BEGIN
267: IF l_auto_submit_mode IS NULL THEN
268: FND_MSG_PUB.Initialize;
269: FND_MESSAGE.Set_Name('CS','CS_CHG_DEFINE_PROFILE_OPTION');
270: FND_MESSAGE.Set_Token('PROFILE_OPTION','CS_CHG_AUTO_SUBMIT_MODE');
271: FND_MSG_PUB.Add;
272: -- x_return_status := FND_API.G_RET_STS_ERROR;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: END IF;

Line 563: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');

559:
560:
561:
562: FND_MSG_PUB.Initialize;
563: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
564: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
565: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
566: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
567: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 564: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);

560:
561:
562: FND_MSG_PUB.Initialize;
563: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
564: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
565: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
566: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
567: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
568: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 565: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);

561:
562: FND_MSG_PUB.Initialize;
563: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
564: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
565: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
566: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
567: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
568: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
569: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 566: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

562: FND_MSG_PUB.Initialize;
563: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
564: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
565: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
566: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
567: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
568: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
569: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
570: FND_MSG_PUB.Add;

Line 567: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

563: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
564: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
565: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
566: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
567: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
568: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
569: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
570: FND_MSG_PUB.Add;
571:

Line 568: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

564: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
565: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
566: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
567: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
568: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
569: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
570: FND_MSG_PUB.Add;
571:
572: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

Line 569: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

565: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
566: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
567: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
568: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
569: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
570: FND_MSG_PUB.Add;
571:
572: Update_Charge_Lines(AutosubmitTAB(i).incident_id,
573: AutosubmitTAB(i).incident_number,

Line 598: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');

594: or RestrulesTab(j).end_date_active IS NULL))) then
595:
596:
597: FND_MSG_PUB.Initialize;
598: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
599: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
600: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 599: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);

595:
596:
597: FND_MSG_PUB.Initialize;
598: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
599: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
600: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
603: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 600: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);

596:
597: FND_MSG_PUB.Initialize;
598: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
599: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
600: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
603: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
604: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);

597: FND_MSG_PUB.Initialize;
598: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
599: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
600: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
603: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
604: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
605: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

598: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
599: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
600: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
603: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
604: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
605: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
606: FND_MSG_PUB.Add;

Line 603: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

599: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
600: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
603: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
604: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
605: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
606: FND_MSG_PUB.Add;
607:

Line 604: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

600: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
603: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
604: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
605: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
606: FND_MSG_PUB.Add;
607:
608: -- Call Update_Charge_Lines.

Line 605: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

601: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
602: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
603: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
604: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
605: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
606: FND_MSG_PUB.Add;
607:
608: -- Call Update_Charge_Lines.
609: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

Line 636: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');

632:
633: -- dbms_output.put_line('After Restriction Condition ' || RestrulesTab(j).condition);
634:
635: FND_MSG_PUB.Initialize;
636: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
637: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
638: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 637: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);

633: -- dbms_output.put_line('After Restriction Condition ' || RestrulesTab(j).condition);
634:
635: FND_MSG_PUB.Initialize;
636: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
637: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
638: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
641: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 638: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);

634:
635: FND_MSG_PUB.Initialize;
636: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
637: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
638: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
641: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
642: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);

635: FND_MSG_PUB.Initialize;
636: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
637: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
638: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
641: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
642: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
643: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

636: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
637: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
638: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
641: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
642: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
643: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
644: FND_MSG_PUB.Add;

Line 641: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

637: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
638: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
641: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
642: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
643: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
644: FND_MSG_PUB.Add;
645:

Line 642: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

638: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
641: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
642: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
643: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
644: FND_MSG_PUB.Add;
645:
646: -- Call Update_Charge_Lines.

Line 643: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

639: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
640: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
641: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
642: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
643: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
644: FND_MSG_PUB.Add;
645:
646: -- Call Update_Charge_Lines.
647: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

Line 670: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');

666: (AutosubmitTAB(i).incident_date <= RestrulesTab(j).end_date_active
667: or RestrulesTab(j).end_date_active IS NULL))) then
668:
669: FND_MSG_PUB.Initialize;
670: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
671: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
672: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 671: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);

667: or RestrulesTab(j).end_date_active IS NULL))) then
668:
669: FND_MSG_PUB.Initialize;
670: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
671: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
672: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
675: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 672: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);

668:
669: FND_MSG_PUB.Initialize;
670: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
671: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
672: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
675: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
676: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);

669: FND_MSG_PUB.Initialize;
670: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
671: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
672: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
675: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
676: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
677: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

670: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
671: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
672: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
675: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
676: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
677: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
678: FND_MSG_PUB.Add;

Line 675: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

671: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
672: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
675: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
676: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
677: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
678: FND_MSG_PUB.Add;
679:

Line 676: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

672: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
675: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
676: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
677: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
678: FND_MSG_PUB.Add;
679:
680: -- Call Update_Charge_Lines.

Line 677: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

673: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
674: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
675: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
676: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
677: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
678: FND_MSG_PUB.Add;
679:
680: -- Call Update_Charge_Lines.
681: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

Line 705: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');

701: or RestrulesTab(j).end_date_active IS NULL))) then
702:
703:
704: FND_MSG_PUB.Initialize;
705: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
706: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
707: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 706: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);

702:
703:
704: FND_MSG_PUB.Initialize;
705: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
706: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
707: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
710: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 707: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);

703:
704: FND_MSG_PUB.Initialize;
705: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
706: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
707: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
710: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
711: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);

704: FND_MSG_PUB.Initialize;
705: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
706: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
707: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
710: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
711: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
712: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

705: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
706: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
707: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
710: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
711: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
712: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
713: FND_MSG_PUB.Add;

Line 710: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

706: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
707: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
710: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
711: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
712: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
713: FND_MSG_PUB.Add;
714:

Line 711: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

707: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
710: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
711: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
712: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
713: FND_MSG_PUB.Add;
714:
715: -- Call Update_Charge_Lines.

Line 712: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

708: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
709: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
710: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
711: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
712: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
713: FND_MSG_PUB.Add;
714:
715: -- Call Update_Charge_Lines.
716: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

Line 740: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');

736: ((RestrulesTab(j).end_date_active IS NULL) or
737: (AutosubmitTAB(i).incident_date <= RestrulesTab(j).end_date_active)) then
738:
739: FND_MSG_PUB.Initialize;
740: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
741: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
742: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
743: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
744: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);

Line 741: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);

737: (AutosubmitTAB(i).incident_date <= RestrulesTab(j).end_date_active)) then
738:
739: FND_MSG_PUB.Initialize;
740: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
741: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
742: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
743: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
744: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);
745: FND_MSG_PUB.Add;

Line 742: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

738:
739: FND_MSG_PUB.Initialize;
740: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
741: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
742: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
743: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
744: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);
745: FND_MSG_PUB.Add;
746:

Line 743: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

739: FND_MSG_PUB.Initialize;
740: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
741: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
742: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
743: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
744: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);
745: FND_MSG_PUB.Add;
746:
747: -- Call Update_Charge_Lines.

Line 744: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);

740: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
741: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
742: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
743: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
744: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);
745: FND_MSG_PUB.Add;
746:
747: -- Call Update_Charge_Lines.
748: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

Line 785: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_AMT_OVERIDE_RESTRICTION');

781: l_txn_no_charge_flag = 'N')) then
782:
783:
784: FND_MSG_PUB.Initialize;
785: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_AMT_OVERIDE_RESTRICTION');
786: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
787: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
788: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
789: FND_MSG_PUB.Add;

Line 786: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);

782:
783:
784: FND_MSG_PUB.Initialize;
785: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_AMT_OVERIDE_RESTRICTION');
786: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
787: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
788: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
789: FND_MSG_PUB.Add;
790: -- Need to verify if these are required.

Line 787: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);

783:
784: FND_MSG_PUB.Initialize;
785: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_AMT_OVERIDE_RESTRICTION');
786: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
787: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
788: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
789: FND_MSG_PUB.Add;
790: -- Need to verify if these are required.
791: -- Confirmed with krasimir that this is not required.

Line 788: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

784: FND_MSG_PUB.Initialize;
785: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_AMT_OVERIDE_RESTRICTION');
786: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
787: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
788: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
789: FND_MSG_PUB.Add;
790: -- Need to verify if these are required.
791: -- Confirmed with krasimir that this is not required.
792: /* FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition,TRUE);

Line 792: /* FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition,TRUE);

788: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
789: FND_MSG_PUB.Add;
790: -- Need to verify if these are required.
791: -- Confirmed with krasimir that this is not required.
792: /* FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition,TRUE);
793: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).condition,TRUE);
794: FND_MESSAGE.SET_TOKEN('CURRENCY', AutosubmitTAB(i).party_name,TRUE); */
795:
796:

Line 793: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).condition,TRUE);

789: FND_MSG_PUB.Add;
790: -- Need to verify if these are required.
791: -- Confirmed with krasimir that this is not required.
792: /* FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition,TRUE);
793: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).condition,TRUE);
794: FND_MESSAGE.SET_TOKEN('CURRENCY', AutosubmitTAB(i).party_name,TRUE); */
795:
796:
797: -- Call Update_Charge_Lines.

Line 794: FND_MESSAGE.SET_TOKEN('CURRENCY', AutosubmitTAB(i).party_name,TRUE); */

790: -- Need to verify if these are required.
791: -- Confirmed with krasimir that this is not required.
792: /* FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition,TRUE);
793: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).condition,TRUE);
794: FND_MESSAGE.SET_TOKEN('CURRENCY', AutosubmitTAB(i).party_name,TRUE); */
795:
796:
797: -- Call Update_Charge_Lines.
798:

Line 875: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');

871: (chgSrTotTab(k).incident_date <= RestrulesTab(j).end_date_active
872: or RestrulesTab(j).end_date_active IS NULL)) then
873:
874: FND_MSG_PUB.Initialize;
875: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
876: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
877: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 876: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);

872: or RestrulesTab(j).end_date_active IS NULL)) then
873:
874: FND_MSG_PUB.Initialize;
875: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
876: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
877: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
880: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 877: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);

873:
874: FND_MSG_PUB.Initialize;
875: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
876: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
877: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
880: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
881: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);

874: FND_MSG_PUB.Initialize;
875: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
876: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
877: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
880: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
881: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
882: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

875: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
876: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
877: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
880: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
881: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
882: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
883: FND_MSG_PUB.Add;

Line 880: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

876: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
877: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
880: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
881: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
882: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
883: FND_MSG_PUB.Add;
884:

Line 881: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

877: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
880: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
881: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
882: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
883: FND_MSG_PUB.Add;
884:
885: -- Call Update_Charge_Lines.

Line 882: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

878: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
879: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
880: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
881: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
882: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
883: FND_MSG_PUB.Add;
884:
885: -- Call Update_Charge_Lines.
886: Update_Charge_Lines(ChgSrTotTAB(k).incident_id,

Line 910: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');

906: or RestrulesTab(j).end_date_active IS NULL)) then
907:
908:
909: FND_MSG_PUB.Initialize;
910: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
911: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
912: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 911: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);

907:
908:
909: FND_MSG_PUB.Initialize;
910: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
911: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
912: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
915: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 912: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);

908:
909: FND_MSG_PUB.Initialize;
910: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
911: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
912: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
915: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
916: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);

909: FND_MSG_PUB.Initialize;
910: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
911: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
912: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
915: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
916: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
917: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

910: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
911: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
912: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
915: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
916: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
917: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
918: FND_MSG_PUB.Add;

Line 915: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

911: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
912: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
915: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
916: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
917: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
918: FND_MSG_PUB.Add;
919:

Line 916: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

912: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
915: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
916: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
917: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
918: FND_MSG_PUB.Add;
919:
920:

Line 917: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

913: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
914: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
915: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
916: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
917: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
918: FND_MSG_PUB.Add;
919:
920:
921: -- Call Update_Charge_Lines.

Line 947: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');

943: or RestrulesTab(j).end_date_active IS NULL)) then
944:
945:
946: FND_MSG_PUB.Initialize;
947: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
948: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
949: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 948: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);

944:
945:
946: FND_MSG_PUB.Initialize;
947: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
948: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
949: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
952: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 949: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);

945:
946: FND_MSG_PUB.Initialize;
947: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
948: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
949: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
952: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
953: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);

946: FND_MSG_PUB.Initialize;
947: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
948: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
949: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
952: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
953: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
954: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

947: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
948: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
949: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
952: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
953: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
954: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
955: FND_MSG_PUB.Add;

Line 952: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

948: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
949: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
952: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
953: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
954: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
955: FND_MSG_PUB.Add;
956:

Line 953: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

949: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
952: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
953: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
954: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
955: FND_MSG_PUB.Add;
956:
957:

Line 954: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

950: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
951: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
952: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
953: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
954: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
955: FND_MSG_PUB.Add;
956:
957:
958: -- Call Update_Charge_Lines.

Line 985: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');

981:
982:
983:
984: FND_MSG_PUB.Initialize;
985: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
986: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
987: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 986: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);

982:
983:
984: FND_MSG_PUB.Initialize;
985: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
986: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
987: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
990: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 987: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);

983:
984: FND_MSG_PUB.Initialize;
985: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
986: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
987: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
990: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
991: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);

984: FND_MSG_PUB.Initialize;
985: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
986: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
987: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
990: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
991: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
992: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

985: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
986: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
987: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
990: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
991: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
992: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
993: FND_MSG_PUB.Add;

Line 990: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

986: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
987: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
990: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
991: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
992: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
993: FND_MSG_PUB.Add;
994:

Line 991: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

987: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
990: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
991: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
992: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
993: FND_MSG_PUB.Add;
994:
995:

Line 992: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

988: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
989: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
990: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
991: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
992: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
993: FND_MSG_PUB.Add;
994:
995:
996: -- Call Update_Charge_Lines.

Line 1023: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');

1019: or RestrulesTab(j).end_date_active IS NULL)) then
1020:
1021:
1022: FND_MSG_PUB.Initialize;
1023: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1024: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1025: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 1024: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);

1020:
1021:
1022: FND_MSG_PUB.Initialize;
1023: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1024: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1025: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1028: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 1025: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);

1021:
1022: FND_MSG_PUB.Initialize;
1023: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1024: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1025: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1028: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1029: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);

1022: FND_MSG_PUB.Initialize;
1023: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1024: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1025: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1028: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1029: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1030: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

Line 1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

1023: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1024: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1025: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1028: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1029: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1030: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
1031: FND_MSG_PUB.Add;

Line 1028: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

1024: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1025: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1028: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1029: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1030: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
1031: FND_MSG_PUB.Add;
1032:

Line 1029: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

1025: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1028: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1029: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1030: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
1031: FND_MSG_PUB.Add;
1032:
1033: -- Call Update_Charge_Lines.

Line 1030: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

1026: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1027: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1028: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1029: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1030: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
1031: FND_MSG_PUB.Add;
1032:
1033: -- Call Update_Charge_Lines.
1034: Update_Charge_Lines(ChgSrTotTAB(k).incident_id,

Line 1061: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_SR_TYPE_RESTRICTION');

1057:
1058:
1059:
1060: FND_MSG_PUB.Initialize;
1061: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_SR_TYPE_RESTRICTION');
1062: -- Need to verify, if we need to show status in the message.
1063: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);
1064: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1065: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 1063: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);

1059:
1060: FND_MSG_PUB.Initialize;
1061: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_SR_TYPE_RESTRICTION');
1062: -- Need to verify, if we need to show status in the message.
1063: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);
1064: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1065: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1066: FND_MESSAGE.SET_TOKEN('INCIDENT_TYPE', chgSrTotTAB(k).incident_type);
1067: FND_MSG_PUB.Add;

Line 1064: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

1060: FND_MSG_PUB.Initialize;
1061: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_SR_TYPE_RESTRICTION');
1062: -- Need to verify, if we need to show status in the message.
1063: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);
1064: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1065: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1066: FND_MESSAGE.SET_TOKEN('INCIDENT_TYPE', chgSrTotTAB(k).incident_type);
1067: FND_MSG_PUB.Add;
1068:

Line 1065: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

1061: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_SR_TYPE_RESTRICTION');
1062: -- Need to verify, if we need to show status in the message.
1063: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);
1064: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1065: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1066: FND_MESSAGE.SET_TOKEN('INCIDENT_TYPE', chgSrTotTAB(k).incident_type);
1067: FND_MSG_PUB.Add;
1068:
1069:

Line 1066: FND_MESSAGE.SET_TOKEN('INCIDENT_TYPE', chgSrTotTAB(k).incident_type);

1062: -- Need to verify, if we need to show status in the message.
1063: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);
1064: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1065: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1066: FND_MESSAGE.SET_TOKEN('INCIDENT_TYPE', chgSrTotTAB(k).incident_type);
1067: FND_MSG_PUB.Add;
1068:
1069:
1070: -- Call Update_Charge_Lines.

Line 1135: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');

1131: or RestrulesTab(j).end_date_active IS NULL)) then
1132:
1133:
1134: FND_MSG_PUB.Initialize;
1135: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1136: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1137: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);

Line 1136: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);

1132:
1133:
1134: FND_MSG_PUB.Initialize;
1135: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1136: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1137: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1140: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

Line 1137: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);

1133:
1134: FND_MSG_PUB.Initialize;
1135: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1136: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1137: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1140: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1141: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

Line 1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);

1134: FND_MSG_PUB.Initialize;
1135: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1136: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1137: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1140: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1141: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1142: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

Line 1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);

1135: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1136: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1137: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1140: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1141: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1142: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1143: FND_MSG_PUB.Add;

Line 1140: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

1136: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1137: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1140: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1141: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1142: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1143: FND_MSG_PUB.Add;
1144:

Line 1141: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

1137: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1140: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1141: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1142: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1143: FND_MSG_PUB.Add;
1144:
1145:

Line 1142: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

1138: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1139: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1140: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1141: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1142: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1143: FND_MSG_PUB.Add;
1144:
1145:
1146: -- Call Update_Charge_Lines.

Line 1234: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');

1230: IF l_found = 'N' THEN
1231: FND_FILE.put_line(FND_FILE.LOG,'There are no eligible Charge lines available for submission to Order Management');
1232: ELSE
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1235: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');
1236: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1237: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1238: FND_MSG_PUB.add;

Line 1235: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');

1231: FND_FILE.put_line(FND_FILE.LOG,'There are no eligible Charge lines available for submission to Order Management');
1232: ELSE
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1235: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');
1236: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1237: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1238: FND_MSG_PUB.add;
1239: FND_MSG_PUB.get(p_encoded => 'F',

Line 1236: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

1232: ELSE
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1235: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');
1236: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1237: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1238: FND_MSG_PUB.add;
1239: FND_MSG_PUB.get(p_encoded => 'F',
1240: p_data=>x_msg_data,

Line 1237: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);

1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1235: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');
1236: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1237: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1238: FND_MSG_PUB.add;
1239: FND_MSG_PUB.get(p_encoded => 'F',
1240: p_data=>x_msg_data,
1241: p_msg_index_out=> l_msg_index_out);

Line 1380: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');

1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1380: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1381: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1382: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1383: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1384: FND_MSG_PUB.add;

Line 1381: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');

1377: WHEN OTHERS THEN
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1380: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1381: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1382: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1383: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1384: FND_MSG_PUB.add;
1385: FND_MSG_PUB.get(p_encoded => 'F',

Line 1382: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1380: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1381: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1382: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1383: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1384: FND_MSG_PUB.add;
1385: FND_MSG_PUB.get(p_encoded => 'F',
1386: p_data=>x_msg_data,

Line 1383: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);

1379: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1380: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1381: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1382: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1383: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1384: FND_MSG_PUB.add;
1385: FND_MSG_PUB.get(p_encoded => 'F',
1386: p_data=>x_msg_data,
1387: p_msg_index_out=> l_msg_index_out);

Line 1477: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');

1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1476: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1477: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1478: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1479: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1480: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1481: FND_MSG_PUB.add;

Line 1478: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');

1474: WHEN OTHERS THEN
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1476: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1477: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1478: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1479: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1480: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1481: FND_MSG_PUB.add;
1482: FND_MSG_PUB.get(p_encoded => 'F',

Line 1479: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1476: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1477: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1478: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1479: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1480: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1481: FND_MSG_PUB.add;
1482: FND_MSG_PUB.get(p_encoded => 'F',
1483: p_data=>x_msg_data,

Line 1480: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);

1476: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1477: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1478: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1479: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1480: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1481: FND_MSG_PUB.add;
1482: FND_MSG_PUB.get(p_encoded => 'F',
1483: p_data=>x_msg_data,
1484: p_msg_index_out=> l_msg_index_out);

Line 1567: FND_MESSAGE.SET_NAME( 'CS','CS_CHG_DEBRIEF_PENDING');

1563:
1564: IF l_deb_status(lv_index).debrief_status = 'P' THEN
1565:
1566: FND_MSG_PUB.Initialize;
1567: FND_MESSAGE.SET_NAME( 'CS','CS_CHG_DEBRIEF_PENDING');
1568: FND_MSG_PUB.Add;
1569:
1570: FND_MSG_PUB.get(p_encoded => 'F',
1571: p_data=>l_msg_data,

Line 1594: FND_MESSAGE.SET_NAME( 'CS','CS_CHG_DEBRIEF_ERRORS');

1590:
1591:
1592: ELSIF l_deb_status(lv_index).debrief_status = 'E' THEN
1593: FND_MSG_PUB.Initialize;
1594: FND_MESSAGE.SET_NAME( 'CS','CS_CHG_DEBRIEF_ERRORS');
1595: FND_MSG_PUB.Add;
1596: FND_MSG_PUB.get(p_encoded => 'F',
1597: p_data=>l_msg_data,
1598: p_msg_index_out=> l_msg_index_out);

Line 1655: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');

1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1655: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1656: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1657: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1658: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1659: FND_MSG_PUB.add;

Line 1656: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');

1652: WHEN OTHERS THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1655: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1656: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1657: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1658: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1659: FND_MSG_PUB.add;
1660: FND_MSG_PUB.get(p_encoded => 'F',

Line 1657: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1655: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1656: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1657: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1658: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1659: FND_MSG_PUB.add;
1660: FND_MSG_PUB.get(p_encoded => 'F',
1661: p_data=>x_msg_data,

Line 1658: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);

1654: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1655: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1656: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1657: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1658: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1659: FND_MSG_PUB.add;
1660: FND_MSG_PUB.get(p_encoded => 'F',
1661: p_data=>x_msg_data,
1662: p_msg_index_out=> l_msg_index_out);