APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on FND_MESSAGE

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

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

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

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

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

565:
566:
567:
568: FND_MSG_PUB.Initialize;
569: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
570: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
571: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
572: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
573: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

566:
567:
568: FND_MSG_PUB.Initialize;
569: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
570: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
571: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
572: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
573: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
574: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

567:
568: FND_MSG_PUB.Initialize;
569: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
570: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
571: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
572: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
573: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
574: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
575: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

568: FND_MSG_PUB.Initialize;
569: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
570: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
571: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
572: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
573: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
574: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
575: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
576: FND_MSG_PUB.Add;

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

569: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
570: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
571: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
572: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
573: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
574: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
575: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
576: FND_MSG_PUB.Add;
577:

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

570: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
571: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
572: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
573: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
574: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
575: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
576: FND_MSG_PUB.Add;
577:
578: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

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

571: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
572: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
573: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
574: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
575: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
576: FND_MSG_PUB.Add;
577:
578: Update_Charge_Lines(AutosubmitTAB(i).incident_id,
579: AutosubmitTAB(i).incident_number,

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

600: or RestrulesTab(j).end_date_active IS NULL))) then
601:
602:
603: FND_MSG_PUB.Initialize;
604: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
605: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
606: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
607: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
608: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

601:
602:
603: FND_MSG_PUB.Initialize;
604: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
605: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
606: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
607: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
608: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
609: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

602:
603: FND_MSG_PUB.Initialize;
604: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
605: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
606: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
607: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
608: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
609: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
610: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

603: FND_MSG_PUB.Initialize;
604: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
605: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
606: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
607: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
608: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
609: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
610: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
611: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

604: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
605: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
606: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
607: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
608: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
609: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
610: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
611: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
612: FND_MSG_PUB.Add;

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

605: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
606: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
607: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
608: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
609: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
610: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
611: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
612: FND_MSG_PUB.Add;
613:

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

606: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
607: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
608: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
609: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
610: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
611: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
612: FND_MSG_PUB.Add;
613:
614: -- Call Update_Charge_Lines.

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

607: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
608: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
609: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
610: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
611: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
612: FND_MSG_PUB.Add;
613:
614: -- Call Update_Charge_Lines.
615: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

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

638:
639: -- dbms_output.put_line('After Restriction Condition ' || RestrulesTab(j).condition);
640:
641: FND_MSG_PUB.Initialize;
642: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
643: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
644: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
645: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
646: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

639: -- dbms_output.put_line('After Restriction Condition ' || RestrulesTab(j).condition);
640:
641: FND_MSG_PUB.Initialize;
642: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
643: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
644: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
645: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
646: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
647: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

640:
641: FND_MSG_PUB.Initialize;
642: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
643: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
644: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
645: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
646: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
647: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
648: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

641: FND_MSG_PUB.Initialize;
642: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
643: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
644: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
645: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
646: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
647: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
648: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
649: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

642: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
643: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
644: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
645: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
646: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
647: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
648: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
649: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
650: FND_MSG_PUB.Add;

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

643: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
644: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
645: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
646: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
647: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
648: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
649: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
650: FND_MSG_PUB.Add;
651:

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

644: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
645: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
646: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
647: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
648: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
649: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
650: FND_MSG_PUB.Add;
651:
652: -- Call Update_Charge_Lines.

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

645: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
646: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
647: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
648: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
649: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
650: FND_MSG_PUB.Add;
651:
652: -- Call Update_Charge_Lines.
653: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

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

672: (AutosubmitTAB(i).incident_date <= RestrulesTab(j).end_date_active
673: or RestrulesTab(j).end_date_active IS NULL))) then
674:
675: FND_MSG_PUB.Initialize;
676: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
677: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
678: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
679: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
680: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

673: or RestrulesTab(j).end_date_active IS NULL))) then
674:
675: FND_MSG_PUB.Initialize;
676: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
677: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
678: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
679: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
680: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
681: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

674:
675: FND_MSG_PUB.Initialize;
676: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
677: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
678: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
679: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
680: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
681: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
682: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

675: FND_MSG_PUB.Initialize;
676: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
677: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
678: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
679: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
680: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
681: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
682: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
683: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

676: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
677: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
678: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
679: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
680: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
681: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
682: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
683: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
684: FND_MSG_PUB.Add;

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

677: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
678: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
679: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
680: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
681: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
682: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
683: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
684: FND_MSG_PUB.Add;
685:

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

678: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
679: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
680: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
681: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
682: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
683: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
684: FND_MSG_PUB.Add;
685:
686: -- Call Update_Charge_Lines.

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

679: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
680: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
681: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
682: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
683: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
684: FND_MSG_PUB.Add;
685:
686: -- Call Update_Charge_Lines.
687: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

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

707: or RestrulesTab(j).end_date_active IS NULL))) then
708:
709:
710: FND_MSG_PUB.Initialize;
711: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
712: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
713: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
714: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
715: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

708:
709:
710: FND_MSG_PUB.Initialize;
711: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
712: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
713: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
714: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
715: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
716: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

709:
710: FND_MSG_PUB.Initialize;
711: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
712: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
713: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
714: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
715: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
716: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
717: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

710: FND_MSG_PUB.Initialize;
711: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
712: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
713: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
714: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
715: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
716: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
717: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
718: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

711: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LINE_AMT_RESTRICTION');
712: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
713: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
714: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
715: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
716: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
717: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
718: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
719: FND_MSG_PUB.Add;

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

712: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
713: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
714: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
715: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
716: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
717: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
718: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
719: FND_MSG_PUB.Add;
720:

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

713: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
714: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
715: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
716: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
717: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
718: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
719: FND_MSG_PUB.Add;
720:
721: -- Call Update_Charge_Lines.

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

714: -- FND_MESSAGE.SET_TOKEN('SR', chgSrTotTAB(k).incident_number, TRUE);
715: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
716: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
717: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
718: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
719: FND_MSG_PUB.Add;
720:
721: -- Call Update_Charge_Lines.
722: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

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

742: ((RestrulesTab(j).end_date_active IS NULL) or
743: (AutosubmitTAB(i).incident_date <= RestrulesTab(j).end_date_active)) then
744:
745: FND_MSG_PUB.Initialize;
746: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
747: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
748: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
749: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
750: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);

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

743: (AutosubmitTAB(i).incident_date <= RestrulesTab(j).end_date_active)) then
744:
745: FND_MSG_PUB.Initialize;
746: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
747: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
748: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
749: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
750: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);
751: FND_MSG_PUB.Add;

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

744:
745: FND_MSG_PUB.Initialize;
746: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
747: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
748: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
749: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
750: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);
751: FND_MSG_PUB.Add;
752:

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

745: FND_MSG_PUB.Initialize;
746: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
747: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
748: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
749: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
750: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);
751: FND_MSG_PUB.Add;
752:
753: -- Call Update_Charge_Lines.

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

746: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_BILL_TO_CT_RESTRICTION');
747: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_ID',AutosubmitTAB(i).bill_to_party_id);
748: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
749: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
750: FND_MESSAGE.SET_TOKEN('BILL_TO_CUSTOMER_NAME', AutosubmitTAB(i).party_name);
751: FND_MSG_PUB.Add;
752:
753: -- Call Update_Charge_Lines.
754: Update_Charge_Lines(AutosubmitTAB(i).incident_id,

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

787: l_txn_no_charge_flag = 'N')) then
788:
789:
790: FND_MSG_PUB.Initialize;
791: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_AMT_OVERIDE_RESTRICTION');
792: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
793: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
794: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
795: FND_MSG_PUB.Add;

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

788:
789:
790: FND_MSG_PUB.Initialize;
791: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_AMT_OVERIDE_RESTRICTION');
792: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
793: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
794: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
795: FND_MSG_PUB.Add;
796: -- Need to verify if these are required.

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

789:
790: FND_MSG_PUB.Initialize;
791: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_AMT_OVERIDE_RESTRICTION');
792: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',AutosubmitTAB(i).currency_code);
793: FND_MESSAGE.SET_TOKEN('AFTER_WARRANTY_COST',AutosubmitTAB(i).after_warranty_cost);
794: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
795: FND_MSG_PUB.Add;
796: -- Need to verify if these are required.
797: -- Confirmed with krasimir that this is not required.

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

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

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

794: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
795: FND_MSG_PUB.Add;
796: -- Need to verify if these are required.
797: -- Confirmed with krasimir that this is not required.
798: /* FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition,TRUE);
799: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).condition,TRUE);
800: FND_MESSAGE.SET_TOKEN('CURRENCY', AutosubmitTAB(i).party_name,TRUE); */
801:
802:

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

795: FND_MSG_PUB.Add;
796: -- Need to verify if these are required.
797: -- Confirmed with krasimir that this is not required.
798: /* FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition,TRUE);
799: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).condition,TRUE);
800: FND_MESSAGE.SET_TOKEN('CURRENCY', AutosubmitTAB(i).party_name,TRUE); */
801:
802:
803: -- Call Update_Charge_Lines.

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

796: -- Need to verify if these are required.
797: -- Confirmed with krasimir that this is not required.
798: /* FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition,TRUE);
799: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).condition,TRUE);
800: FND_MESSAGE.SET_TOKEN('CURRENCY', AutosubmitTAB(i).party_name,TRUE); */
801:
802:
803: -- Call Update_Charge_Lines.
804:

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

877: (chgSrTotTab(k).incident_date <= RestrulesTab(j).end_date_active
878: or RestrulesTab(j).end_date_active IS NULL)) then
879:
880: FND_MSG_PUB.Initialize;
881: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
882: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
883: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
884: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
885: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

878: or RestrulesTab(j).end_date_active IS NULL)) then
879:
880: FND_MSG_PUB.Initialize;
881: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
882: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
883: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
884: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
885: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
886: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

879:
880: FND_MSG_PUB.Initialize;
881: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
882: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
883: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
884: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
885: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
886: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
887: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

880: FND_MSG_PUB.Initialize;
881: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
882: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
883: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
884: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
885: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
886: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
887: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
888: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

881: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
882: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
883: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
884: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
885: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
886: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
887: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
888: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
889: FND_MSG_PUB.Add;

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

882: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
883: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
884: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
885: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
886: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
887: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
888: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
889: FND_MSG_PUB.Add;
890:

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

883: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
884: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
885: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
886: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
887: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
888: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
889: FND_MSG_PUB.Add;
890:
891: -- Call Update_Charge_Lines.

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

884: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
885: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
886: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
887: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
888: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
889: FND_MSG_PUB.Add;
890:
891: -- Call Update_Charge_Lines.
892: Update_Charge_Lines(ChgSrTotTAB(k).incident_id,

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

912: or RestrulesTab(j).end_date_active IS NULL)) then
913:
914:
915: FND_MSG_PUB.Initialize;
916: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
917: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
918: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
919: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
920: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

913:
914:
915: FND_MSG_PUB.Initialize;
916: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
917: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
918: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
919: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
920: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
921: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

914:
915: FND_MSG_PUB.Initialize;
916: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
917: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
918: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
919: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
920: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
921: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
922: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

915: FND_MSG_PUB.Initialize;
916: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
917: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
918: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
919: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
920: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
921: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
922: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
923: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

916: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
917: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
918: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
919: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
920: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
921: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
922: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
923: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
924: FND_MSG_PUB.Add;

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

917: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
918: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
919: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
920: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
921: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
922: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
923: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
924: FND_MSG_PUB.Add;
925:

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

918: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
919: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
920: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
921: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
922: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
923: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
924: FND_MSG_PUB.Add;
925:
926:

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

919: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
920: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
921: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
922: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
923: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
924: FND_MSG_PUB.Add;
925:
926:
927: -- Call Update_Charge_Lines.

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

949: or RestrulesTab(j).end_date_active IS NULL)) then
950:
951:
952: FND_MSG_PUB.Initialize;
953: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
954: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
955: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
956: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
957: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

950:
951:
952: FND_MSG_PUB.Initialize;
953: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
954: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
955: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
956: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
957: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
958: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

951:
952: FND_MSG_PUB.Initialize;
953: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
954: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
955: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
956: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
957: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
958: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
959: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

952: FND_MSG_PUB.Initialize;
953: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
954: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
955: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
956: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
957: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
958: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
959: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
960: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

953: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
954: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
955: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
956: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
957: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
958: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
959: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
960: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
961: FND_MSG_PUB.Add;

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

954: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
955: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
956: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
957: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
958: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
959: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
960: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
961: FND_MSG_PUB.Add;
962:

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

955: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
956: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
957: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
958: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
959: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
960: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
961: FND_MSG_PUB.Add;
962:
963:

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

956: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
957: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
958: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
959: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
960: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
961: FND_MSG_PUB.Add;
962:
963:
964: -- Call Update_Charge_Lines.

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

987:
988:
989:
990: FND_MSG_PUB.Initialize;
991: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
992: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
993: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
994: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
995: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

988:
989:
990: FND_MSG_PUB.Initialize;
991: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
992: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
993: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
994: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
995: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
996: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

989:
990: FND_MSG_PUB.Initialize;
991: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
992: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
993: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
994: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
995: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
996: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
997: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

990: FND_MSG_PUB.Initialize;
991: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
992: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
993: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
994: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
995: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
996: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
997: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
998: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

991: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
992: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
993: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
994: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
995: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
996: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
997: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
998: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
999: FND_MSG_PUB.Add;

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

992: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
993: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
994: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
995: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
996: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
997: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
998: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
999: FND_MSG_PUB.Add;
1000:

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

993: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
994: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
995: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
996: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
997: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
998: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
999: FND_MSG_PUB.Add;
1000:
1001:

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

994: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
995: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
996: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
997: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
998: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
999: FND_MSG_PUB.Add;
1000:
1001:
1002: -- Call Update_Charge_Lines.

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

1025: or RestrulesTab(j).end_date_active IS NULL)) then
1026:
1027:
1028: FND_MSG_PUB.Initialize;
1029: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1030: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1031: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1032: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1033: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

1026:
1027:
1028: FND_MSG_PUB.Initialize;
1029: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1030: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1031: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1032: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1033: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1034: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

1027:
1028: FND_MSG_PUB.Initialize;
1029: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1030: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1031: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1032: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1033: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1034: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1035: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

1028: FND_MSG_PUB.Initialize;
1029: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1030: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1031: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1032: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1033: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1034: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1035: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1036: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);

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

1029: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TOTAL_CHRG_RESTRICTION');
1030: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1031: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1032: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1033: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1034: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1035: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1036: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
1037: FND_MSG_PUB.Add;

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

1030: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',chgSrTotTAB(k).currency_code);
1031: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1032: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1033: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1034: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1035: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1036: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
1037: FND_MSG_PUB.Add;
1038:

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

1031: FND_MESSAGE.SET_TOKEN('TOTAL_AMOUNT',chgSrTotTAB(k).Total_Charges);
1032: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1033: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1034: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1035: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1036: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
1037: FND_MSG_PUB.Add;
1038:
1039: -- Call Update_Charge_Lines.

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

1032: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', chgSrTotTAB(k).incident_number);
1033: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1034: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1035: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1036: FND_MESSAGE.SET_TOKEN('CURRENCY', RestrulesTab(j).currency_code);
1037: FND_MSG_PUB.Add;
1038:
1039: -- Call Update_Charge_Lines.
1040: Update_Charge_Lines(ChgSrTotTAB(k).incident_id,

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

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

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

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

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

1066: FND_MSG_PUB.Initialize;
1067: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_SR_TYPE_RESTRICTION');
1068: -- Need to verify, if we need to show status in the message.
1069: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);
1070: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1071: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1072: FND_MESSAGE.SET_TOKEN('INCIDENT_TYPE', chgSrTotTAB(k).incident_type);
1073: FND_MSG_PUB.Add;
1074:

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

1067: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_SR_TYPE_RESTRICTION');
1068: -- Need to verify, if we need to show status in the message.
1069: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);
1070: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1071: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1072: FND_MESSAGE.SET_TOKEN('INCIDENT_TYPE', chgSrTotTAB(k).incident_type);
1073: FND_MSG_PUB.Add;
1074:
1075:

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

1068: -- Need to verify, if we need to show status in the message.
1069: -- FND_MESSAGE.SET_TOKEN('STATUS',chgSrTotTAB(k).currency_code, TRUE);
1070: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1071: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1072: FND_MESSAGE.SET_TOKEN('INCIDENT_TYPE', chgSrTotTAB(k).incident_type);
1073: FND_MSG_PUB.Add;
1074:
1075:
1076: -- Call Update_Charge_Lines.

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

1137: or RestrulesTab(j).end_date_active IS NULL)) then
1138:
1139:
1140: FND_MSG_PUB.Initialize;
1141: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1142: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1143: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1144: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1145: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);

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

1138:
1139:
1140: FND_MSG_PUB.Initialize;
1141: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1142: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1143: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1144: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1145: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1146: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);

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

1139:
1140: FND_MSG_PUB.Initialize;
1141: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1142: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1143: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1144: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1145: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1146: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1147: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);

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

1140: FND_MSG_PUB.Initialize;
1141: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1142: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1143: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1144: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1145: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1146: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1147: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1148: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);

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

1141: FND_MESSAGE.SET_NAME('CS','CS_CHG_A_EXCEED_ET_RESTRICTION');
1142: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1143: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1144: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1145: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1146: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1147: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1148: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1149: FND_MSG_PUB.Add;

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

1142: FND_MESSAGE.SET_TOKEN('ACTUALS',ChgEstActTotTAB(n).Actuals);
1143: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1144: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1145: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1146: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1147: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1148: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1149: FND_MSG_PUB.Add;
1150:

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

1143: FND_MESSAGE.SET_TOKEN('ESTIMATES',ChgEstActTotTAB(n).Estimates);
1144: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1145: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1146: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1147: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1148: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1149: FND_MSG_PUB.Add;
1150:
1151:

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

1144: FND_MESSAGE.SET_TOKEN('INCIDENT_NUMBER', ChgEstActTotTAB(n).incident_number);
1145: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE', ChgEstActTotTAB(n).currency_code);
1146: FND_MESSAGE.SET_TOKEN('RESTRICTION_TYPE', RestrulesTab(j).restriction_type);
1147: FND_MESSAGE.SET_TOKEN('CONDITION', RestrulesTab(j).condition);
1148: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).value_amount);
1149: FND_MSG_PUB.Add;
1150:
1151:
1152: -- Call Update_Charge_Lines.

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

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

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

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

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

1238: ELSE
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1241: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');
1242: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1243: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1244: FND_MSG_PUB.add;
1245: FND_MSG_PUB.get(p_encoded => 'F',
1246: p_data=>x_msg_data,

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

1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1241: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');
1242: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1243: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1244: FND_MSG_PUB.add;
1245: FND_MSG_PUB.get(p_encoded => 'F',
1246: p_data=>x_msg_data,
1247: p_msg_index_out=> l_msg_index_out);

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

1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1399: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1400: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1401: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1402: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1403: FND_MSG_PUB.add;

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

1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1399: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1400: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1401: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1402: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1403: FND_MSG_PUB.add;
1404: FND_MSG_PUB.get(p_encoded => 'F',

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

1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1399: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1400: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1401: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1402: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1403: FND_MSG_PUB.add;
1404: FND_MSG_PUB.get(p_encoded => 'F',
1405: p_data=>x_msg_data,

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

1398: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1399: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1400: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1401: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1402: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1403: FND_MSG_PUB.add;
1404: FND_MSG_PUB.get(p_encoded => 'F',
1405: p_data=>x_msg_data,
1406: p_msg_index_out=> l_msg_index_out);

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

1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1495: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1496: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1497: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1498: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1499: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1500: FND_MSG_PUB.add;

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

1493: WHEN OTHERS THEN
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1495: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1496: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1497: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1498: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1499: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1500: FND_MSG_PUB.add;
1501: FND_MSG_PUB.get(p_encoded => 'F',

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

1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1495: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1496: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1497: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1498: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1499: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1500: FND_MSG_PUB.add;
1501: FND_MSG_PUB.get(p_encoded => 'F',
1502: p_data=>x_msg_data,

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

1495: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1496: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1497: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1498: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1499: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1500: FND_MSG_PUB.add;
1501: FND_MSG_PUB.get(p_encoded => 'F',
1502: p_data=>x_msg_data,
1503: p_msg_index_out=> l_msg_index_out);

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

1582:
1583: IF l_deb_status(lv_index).debrief_status = 'P' THEN
1584:
1585: FND_MSG_PUB.Initialize;
1586: FND_MESSAGE.SET_NAME( 'CS','CS_CHG_DEBRIEF_PENDING');
1587: FND_MSG_PUB.Add;
1588:
1589: FND_MSG_PUB.get(p_encoded => 'F',
1590: p_data=>l_msg_data,

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

1609:
1610:
1611: ELSIF l_deb_status(lv_index).debrief_status = 'E' THEN
1612: FND_MSG_PUB.Initialize;
1613: FND_MESSAGE.SET_NAME( 'CS','CS_CHG_DEBRIEF_ERRORS');
1614: FND_MSG_PUB.Add;
1615: FND_MSG_PUB.get(p_encoded => 'F',
1616: p_data=>l_msg_data,
1617: p_msg_index_out=> l_msg_index_out);

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

1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1673: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1674: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1675: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1676: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1677: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1678: FND_MSG_PUB.add;

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

1671: WHEN OTHERS THEN
1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1673: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1674: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1675: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1676: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1677: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1678: FND_MSG_PUB.add;
1679: FND_MSG_PUB.get(p_encoded => 'F',

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

1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1673: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1674: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1675: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1676: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1677: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1678: FND_MSG_PUB.add;
1679: FND_MSG_PUB.get(p_encoded => 'F',
1680: p_data=>x_msg_data,

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

1673: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1674: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1675: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1676: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1677: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1678: FND_MSG_PUB.add;
1679: FND_MSG_PUB.get(p_encoded => 'F',
1680: p_data=>x_msg_data,
1681: p_msg_index_out=> l_msg_index_out);