eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on FND_MSG_PUB

Line 251: FND_MSG_PUB.Initialize;

247: END IF;
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE
250: IF FND_API.To_Boolean(p_init_msg_list) THEN
251: FND_MSG_PUB.Initialize;
252: END IF;
253:
254: l_auto_submit_mode := fnd_profile.value('CS_CHG_AUTO_SUBMIT_MODE');
255: l_check_debrief_status := fnd_profile.value('CS_CHG_CHECK_DEBRIEF_STATUS'); --new enh

Line 268: FND_MSG_PUB.Initialize;

264: -- Auto_Submit_Mode can contain one of the following values:
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;

Line 271: FND_MSG_PUB.Add;

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;
275:

Line 278: FND_MSG_PUB.get(p_encoded => 'F',

274: END IF;
275:
276: EXCEPTION
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: FND_MSG_PUB.get(p_encoded => 'F',
279: p_data=>x_msg_data,
280: p_msg_index_out=> l_msg_index_out);
281:
282: -- Recording exceptions in the log file.

Line 562: FND_MSG_PUB.Initialize;

558: or RestrulesTab(j).end_date_active IS NULL))) then
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);

Line 570: FND_MSG_PUB.Add;

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,
574: AutosubmitTab(i).estimate_detail_id,

Line 597: FND_MSG_PUB.Initialize;

593: (AutosubmitTAB(i).incident_date <= RestrulesTab(j).end_date_active
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);

Line 606: FND_MSG_PUB.Add;

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,
610: AutosubmitTAB(i).incident_number,

Line 635: FND_MSG_PUB.Initialize;

631: or RestrulesTab(j).end_date_active IS NULL) then
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);

Line 644: FND_MSG_PUB.Add;

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,
648: AutosubmitTAB(i).incident_number,

Line 669: FND_MSG_PUB.Initialize;

665: or RestrulesTab(j).start_date_active IS NULL) and
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);

Line 678: FND_MSG_PUB.Add;

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,
682: AutosubmitTAB(i).incident_number,

Line 704: FND_MSG_PUB.Initialize;

700: (AutosubmitTAB(i).incident_date <= RestrulesTab(j).end_date_active
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);

Line 713: FND_MSG_PUB.Add;

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,
717: AutosubmitTAB(i).incident_number,

Line 739: FND_MSG_PUB.Initialize;

735: or (RestrulesTab(j).start_date_active IS NULL)) and
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);

Line 745: FND_MSG_PUB.Add;

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,
749: AutosubmitTAB(i).incident_number,

Line 784: FND_MSG_PUB.Initialize;

780: l_chg_no_charge_flag = 'Y' and
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);

Line 789: FND_MSG_PUB.Add;

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);
793: FND_MESSAGE.SET_TOKEN('VALUE_AMOUNT', RestrulesTab(j).condition,TRUE);

Line 874: FND_MSG_PUB.Initialize;

870: or RestrulesTab(j).start_date_active IS NULL) and
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);

Line 883: FND_MSG_PUB.Add;

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,
887: ChgSrTotTAB(k).incident_number,

Line 909: FND_MSG_PUB.Initialize;

905: (chgSrTotTab(k).incident_date <= RestrulesTab(j).end_date_active
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);

Line 918: FND_MSG_PUB.Add;

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.
922: Update_Charge_Lines(ChgSrTotTAB(k).incident_id,

Line 946: FND_MSG_PUB.Initialize;

942: (chgSrTotTab(k).incident_date <= RestrulesTab(j).end_date_active
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);

Line 955: FND_MSG_PUB.Add;

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.
959: Update_Charge_Lines(ChgSrTotTAB(k).incident_id,

Line 984: FND_MSG_PUB.Initialize;

980: or RestrulesTab(j).end_date_active IS NULL)) then
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);

Line 993: FND_MSG_PUB.Add;

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.
997: Update_Charge_Lines(ChgSrTotTAB(k).incident_id,

Line 1022: FND_MSG_PUB.Initialize;

1018: (chgSrTotTab(k).incident_date <= RestrulesTab(j).end_date_active
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);

Line 1031: FND_MSG_PUB.Add;

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,
1035: ChgSrTotTAB(k).incident_number,

Line 1060: FND_MSG_PUB.Initialize;

1056: or RestrulesTab(j).end_date_active IS NULL)) then
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);

Line 1067: FND_MSG_PUB.Add;

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.
1071: Update_Charge_Lines(ChgSrTotTAB(k).incident_id,

Line 1134: FND_MSG_PUB.Initialize;

1130: (ChgEstActTotTAB(n).incident_date <= RestrulesTab(j).end_date_active
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);

Line 1143: FND_MSG_PUB.Add;

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.
1147: Update_Charge_Lines(ChgEstActTotTAB(n).incident_id,

Line 1238: FND_MSG_PUB.add;

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);
1242:

Line 1239: FND_MSG_PUB.get(p_encoded => 'F',

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);
1242:
1243: -- Recording exceptions in the log file.

Line 1311: FND_MSG_PUB.get(p_encoded => 'F',

1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308:
1309: IF p_submit_restriction_message IS NOT NULL THEN
1310:
1311: FND_MSG_PUB.get(p_encoded => 'F',
1312: p_data=>lx_msg_data,
1313: p_msg_index_out=> l_msg_index_out);
1314:
1315: -- Recording the message for concurrent program output.

Line 1384: FND_MSG_PUB.add;

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);
1388:

Line 1385: FND_MSG_PUB.get(p_encoded => 'F',

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);
1388:
1389: -- Recording exceptions in the log file.

Line 1453: IF (FND_MSG_PUB.Count_Msg > 0) THEN

1449:
1450:
1451:
1452: IF x_return_status <> 'S' THEN
1453: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1454: FOR i in 1..FND_MSG_PUB.Count_Msg
1455: LOOP
1456: FND_MSG_PUB.Get(p_msg_index => i,
1457: p_encoded => 'F',

Line 1454: FOR i in 1..FND_MSG_PUB.Count_Msg

1450:
1451:
1452: IF x_return_status <> 'S' THEN
1453: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1454: FOR i in 1..FND_MSG_PUB.Count_Msg
1455: LOOP
1456: FND_MSG_PUB.Get(p_msg_index => i,
1457: p_encoded => 'F',
1458: p_data => x_msg_data,

Line 1456: FND_MSG_PUB.Get(p_msg_index => i,

1452: IF x_return_status <> 'S' THEN
1453: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1454: FOR i in 1..FND_MSG_PUB.Count_Msg
1455: LOOP
1456: FND_MSG_PUB.Get(p_msg_index => i,
1457: p_encoded => 'F',
1458: p_data => x_msg_data,
1459: p_msg_index_out => l_msg_index_out );
1460:

Line 1481: FND_MSG_PUB.add;

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);
1485:

Line 1482: FND_MSG_PUB.get(p_encoded => 'F',

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);
1485:
1486: -- Recording exceptions in the log file.

Line 1566: FND_MSG_PUB.Initialize;

1562: FOR lv_temp IN 1..l_deb_status.COUNT LOOP
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',

Line 1568: FND_MSG_PUB.Add;

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,
1572: p_msg_index_out=> l_msg_index_out);

Line 1570: FND_MSG_PUB.get(p_encoded => 'F',

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,
1572: p_msg_index_out=> l_msg_index_out);
1573:
1574: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);

Line 1593: FND_MSG_PUB.Initialize;

1589: x_restriction_qualify_flag := 'Y';
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,

Line 1595: FND_MSG_PUB.Add;

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);
1599:

Line 1596: FND_MSG_PUB.get(p_encoded => 'F',

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);
1599:
1600: FND_FILE.put_line(FND_FILE.LOG,'Service Request Number:' || p_incident_number);

Line 1630: IF (FND_MSG_PUB.Count_Msg > 0) THEN

1626:
1627: null; --If count is zero, no records.
1628: END IF;
1629: ELSIF x_return_status = 'U' THEN
1630: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1631: FOR i in 1..FND_MSG_PUB.Count_Msg
1632: LOOP
1633: FND_MSG_PUB.Get(p_msg_index => i,
1634: p_encoded => 'F',

Line 1631: FOR i in 1..FND_MSG_PUB.Count_Msg

1627: null; --If count is zero, no records.
1628: END IF;
1629: ELSIF x_return_status = 'U' THEN
1630: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1631: FOR i in 1..FND_MSG_PUB.Count_Msg
1632: LOOP
1633: FND_MSG_PUB.Get(p_msg_index => i,
1634: p_encoded => 'F',
1635: p_data => x_msg_data,

Line 1633: FND_MSG_PUB.Get(p_msg_index => i,

1629: ELSIF x_return_status = 'U' THEN
1630: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1631: FOR i in 1..FND_MSG_PUB.Count_Msg
1632: LOOP
1633: FND_MSG_PUB.Get(p_msg_index => i,
1634: p_encoded => 'F',
1635: p_data => x_msg_data,
1636: p_msg_index_out => l_msg_index_out );
1637:

Line 1659: FND_MSG_PUB.add;

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);
1663:

Line 1660: FND_MSG_PUB.get(p_encoded => 'F',

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);
1663:
1664: -- Recording exceptions in the log file.