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 253: FND_MSG_PUB.Initialize;

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

Line 270: FND_MSG_PUB.Initialize;

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

Line 273: FND_MSG_PUB.Add;

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

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

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

Line 568: FND_MSG_PUB.Initialize;

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

Line 576: FND_MSG_PUB.Add;

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

Line 603: FND_MSG_PUB.Initialize;

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

Line 612: FND_MSG_PUB.Add;

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

Line 641: FND_MSG_PUB.Initialize;

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

Line 650: FND_MSG_PUB.Add;

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

Line 675: FND_MSG_PUB.Initialize;

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

Line 684: FND_MSG_PUB.Add;

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

Line 710: FND_MSG_PUB.Initialize;

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

Line 719: FND_MSG_PUB.Add;

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

Line 745: FND_MSG_PUB.Initialize;

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

Line 751: FND_MSG_PUB.Add;

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

Line 790: FND_MSG_PUB.Initialize;

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

Line 795: FND_MSG_PUB.Add;

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

Line 880: FND_MSG_PUB.Initialize;

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

Line 889: FND_MSG_PUB.Add;

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

Line 915: FND_MSG_PUB.Initialize;

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

Line 924: FND_MSG_PUB.Add;

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

Line 952: FND_MSG_PUB.Initialize;

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

Line 961: FND_MSG_PUB.Add;

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

Line 990: FND_MSG_PUB.Initialize;

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

Line 999: FND_MSG_PUB.Add;

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

Line 1028: FND_MSG_PUB.Initialize;

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

Line 1037: FND_MSG_PUB.Add;

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

Line 1066: FND_MSG_PUB.Initialize;

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

Line 1073: FND_MSG_PUB.Add;

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

Line 1140: FND_MSG_PUB.Initialize;

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

Line 1149: FND_MSG_PUB.Add;

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

Line 1244: FND_MSG_PUB.add;

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

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

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

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

1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318:
1319: IF p_submit_restriction_message IS NOT NULL THEN
1320:
1321: FND_MSG_PUB.get(p_encoded => 'F',
1322: p_data=>lx_msg_data,
1323: p_msg_index_out=> l_msg_index_out);
1324:
1325: -- Recording the message for concurrent program output.

Line 1403: FND_MSG_PUB.add;

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

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

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

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

1468:
1469:
1470:
1471: IF x_return_status <> 'S' THEN
1472: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1473: FOR i in 1..FND_MSG_PUB.Count_Msg
1474: LOOP
1475: FND_MSG_PUB.Get(p_msg_index => i,
1476: p_encoded => 'F',

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

1469:
1470:
1471: IF x_return_status <> 'S' THEN
1472: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1473: FOR i in 1..FND_MSG_PUB.Count_Msg
1474: LOOP
1475: FND_MSG_PUB.Get(p_msg_index => i,
1476: p_encoded => 'F',
1477: p_data => x_msg_data,

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

1471: IF x_return_status <> 'S' THEN
1472: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1473: FOR i in 1..FND_MSG_PUB.Count_Msg
1474: LOOP
1475: FND_MSG_PUB.Get(p_msg_index => i,
1476: p_encoded => 'F',
1477: p_data => x_msg_data,
1478: p_msg_index_out => l_msg_index_out );
1479:

Line 1500: FND_MSG_PUB.add;

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

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

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

Line 1585: FND_MSG_PUB.Initialize;

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

Line 1587: FND_MSG_PUB.Add;

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

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

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

Line 1612: FND_MSG_PUB.Initialize;

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

Line 1614: FND_MSG_PUB.Add;

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

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

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

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

1645:
1646: null; --If count is zero, no records.
1647: END IF;
1648: ELSIF x_return_status = 'U' THEN
1649: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1650: FOR i in 1..FND_MSG_PUB.Count_Msg
1651: LOOP
1652: FND_MSG_PUB.Get(p_msg_index => i,
1653: p_encoded => 'F',

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

1646: null; --If count is zero, no records.
1647: END IF;
1648: ELSIF x_return_status = 'U' THEN
1649: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1650: FOR i in 1..FND_MSG_PUB.Count_Msg
1651: LOOP
1652: FND_MSG_PUB.Get(p_msg_index => i,
1653: p_encoded => 'F',
1654: p_data => x_msg_data,

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

1648: ELSIF x_return_status = 'U' THEN
1649: IF (FND_MSG_PUB.Count_Msg > 0) THEN
1650: FOR i in 1..FND_MSG_PUB.Count_Msg
1651: LOOP
1652: FND_MSG_PUB.Get(p_msg_index => i,
1653: p_encoded => 'F',
1654: p_data => x_msg_data,
1655: p_msg_index_out => l_msg_index_out );
1656:

Line 1678: FND_MSG_PUB.add;

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

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

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