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;
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;
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);
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);
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);
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;
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:
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,
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,
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);
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);
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);
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);
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;
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:
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.
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,
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);
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);
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);
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);
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;
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:
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.
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,
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);
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);
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);
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);
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;
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:
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.
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,
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);
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);
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);
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);
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;
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:
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.
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,
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);
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;
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:
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.
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,
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;
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.
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.
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);
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:
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.
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:
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);
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);
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);
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);
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;
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:
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.
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,
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);
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);
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);
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);
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;
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:
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:
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.
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);
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);
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);
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);
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;
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:
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:
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.
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);
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);
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);
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);
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;
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:
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:
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.
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);
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);
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);
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);
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;
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:
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.
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,
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);
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;
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:
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:
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.
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);
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);
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);
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);
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;
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:
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:
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.
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;
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',
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,
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);
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;
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',
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,
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);
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;
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',
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,
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);
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,
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);
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;
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',
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,
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);