DBA Data[Home] [Help]

APPS.PJM_SCHED_INT_WF dependencies on FND_GLOBAL

Line 947: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

943: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ JOB CDATE EARLY');
944:
945: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY JOB CDATE EARLY');
946: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_wip.exception_days2));
947: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
948: ELSE
949: c_exception_subject:= c_exception_subject || ' / ' ||
950: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ JOB CDATE LATE');
951:

Line 954: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

950: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ JOB CDATE LATE');
951:
952: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY JOB CDATE LATE');
953: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_wip.exception_days2));
954: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
955: END IF;
956: END IF;
957:
958: PJM_SCHED_INT_WF_PRIV.launch_wip(c_item_type

Line 991: PJM_CONC.put_line(cu_wip%rowcount || ' exception(s) found.' || fnd_global.newline);

987: );
988:
989: END LOOP;
990:
991: PJM_CONC.put_line(cu_wip%rowcount || ' exception(s) found.' || fnd_global.newline);
992:
993: CLOSE cu_wip;
994: END IF;
995:

Line 1033: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1029: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ PROMISED DATE EARLY');
1030:
1031: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY PROMISED DATE EARLY');
1032: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_so.exception_days2));
1033: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1034: ELSE
1035: c_exception_subject:= c_exception_subject || ' / ' ||
1036: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ PROMISED DATE LATE');
1037:

Line 1040: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1036: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ PROMISED DATE LATE');
1037:
1038: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY PROMISED DATE LATE');
1039: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_so.exception_days2));
1040: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1041: END IF;
1042: END IF;
1043:
1044:

Line 1077: PJM_CONC.put_line(cu_so%rowcount || ' exception(s) found.' || fnd_global.newline);

1073:
1074:
1075: END LOOP;
1076:
1077: PJM_CONC.put_line(cu_so%rowcount || ' exception(s) found.' || fnd_global.newline);
1078:
1079: CLOSE cu_so;
1080: END IF;
1081:

Line 1119: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1115: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ FC EDATE EARLY');
1116:
1117: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY FC EDATE EARLY');
1118: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_forecast.exception_days2));
1119: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1120: ELSE
1121: c_exception_subject:= c_exception_subject || ' / ' ||
1122: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ FC EDATE LATE');
1123:

Line 1126: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1122: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ FC EDATE LATE');
1123:
1124: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY FC EDATE LATE');
1125: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_forecast.exception_days2));
1126: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1127: END IF;
1128: END IF;
1129:
1130: PJM_SCHED_INT_WF_PRIV.launch_forecast(c_item_type

Line 1161: PJM_CONC.put_line(cu_forecast%rowcount || ' exception(s) found.' || fnd_global.newline);

1157: );
1158:
1159: END LOOP;
1160:
1161: PJM_CONC.put_line(cu_forecast%rowcount || ' exception(s) found.' || fnd_global.newline);
1162:
1163: CLOSE cu_forecast;
1164: END IF;
1165:

Line 1225: PJM_CONC.put_line(cu_pr%rowcount || ' exception(s) found.' || fnd_global.newline);

1221: ,lr_pr.need_by_date
1222: );
1223: END LOOP;
1224:
1225: PJM_CONC.put_line(cu_pr%rowcount || ' exception(s) found.' || fnd_global.newline);
1226:
1227: CLOSE cu_pr;
1228: END IF;
1229:

Line 1280: PJM_CONC.put_line(cu_rfq%rowcount || ' exception(s) found.' || fnd_global.newline);

1276: );
1277:
1278: END LOOP;
1279:
1280: PJM_CONC.put_line(cu_rfq%rowcount || ' exception(s) found.' || fnd_global.newline);
1281:
1282: CLOSE cu_rfq;
1283: END IF;
1284:

Line 1312: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1308: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ EFF DATE EARLY');
1309:
1310: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY EFF DATE EARLY');
1311: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_quotation.exception_days2));
1312: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1313: END IF;
1314:
1315: PJM_SCHED_INT_WF_PRIV.launch_quotation(c_item_type
1316: ,c_requestor || '.QUOTE.' || to_char(lr_quotation.po_line_id)

Line 1345: PJM_CONC.put_line(cu_quotation%rowcount || ' exception(s) found.' || fnd_global.newline);

1341: );
1342:
1343: END LOOP;
1344:
1345: PJM_CONC.put_line(cu_quotation%rowcount || ' exception(s) found.' || fnd_global.newline);
1346:
1347: CLOSE cu_quotation;
1348: END IF;
1349:

Line 1387: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1383: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ SCHED EDATE EARLY');
1384:
1385: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY SCHED EDATE EARLY');
1386: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_mds.exception_days2));
1387: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1388: ELSE
1389: c_exception_subject:= c_exception_subject || ' / ' ||
1390: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ SCHED EDATE LATE');
1391:

Line 1394: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1390: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ SCHED EDATE LATE');
1391:
1392: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY SCHED EDATE LATE');
1393: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_mds.exception_days2));
1394: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1395: END IF;
1396: END IF;
1397:
1398: PJM_SCHED_INT_WF_PRIV.launch_mds(c_item_type

Line 1428: PJM_CONC.put_line(cu_mds%rowcount || ' exception(s) found.' || fnd_global.newline);

1424: );
1425:
1426: END LOOP;
1427:
1428: PJM_CONC.put_line(cu_mds%rowcount || ' exception(s) found.' || fnd_global.newline);
1429:
1430: CLOSE cu_mds;
1431: END IF;
1432:

Line 1470: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1466: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ SCHED EDATE EARLY');
1467:
1468: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY SCHED EDATE EARLY');
1469: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_mps.exception_days2));
1470: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1471: ELSE
1472: c_exception_subject:= c_exception_subject || ' / ' ||
1473: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ SCHED EDATE LATE');
1474:

Line 1477: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1473: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ SCHED EDATE LATE');
1474:
1475: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY SCHED EDATE LATE');
1476: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_mps.exception_days2));
1477: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1478: END IF;
1479: END IF;
1480:
1481: PJM_SCHED_INT_WF_PRIV.launch_mps(c_item_type

Line 1511: PJM_CONC.put_line(cu_mps%rowcount || ' exception(s) found.' || fnd_global.newline);

1507: );
1508:
1509: END LOOP;
1510:
1511: PJM_CONC.put_line(cu_mps%rowcount || ' exception(s) found.' || fnd_global.newline);
1512:
1513: CLOSE cu_mps;
1514: END IF;
1515:

Line 1553: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1549: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ NEEDBY DATE EARLY');
1550:
1551: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY NEEDBY DATE EARLY');
1552: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_po.exception_days2));
1553: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1554: ELSE
1555: c_exception_subject:= c_exception_subject || ' / ' ||
1556: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ NEEDBY DATE LATE');
1557:

Line 1560: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1556: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ NEEDBY DATE LATE');
1557:
1558: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY NEEDBY DATE LATE');
1559: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_po.exception_days2));
1560: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1561: END IF;
1562: END IF;
1563:
1564: PJM_SCHED_INT_WF_PRIV.launch_po (c_item_type

Line 1595: PJM_CONC.put_line(cu_po%rowcount || ' exception(s) found.' || fnd_global.newline);

1591: ,lr_po.need_by_date
1592: );
1593: END LOOP;
1594:
1595: PJM_CONC.put_line(cu_po%rowcount || ' exception(s) found.' || fnd_global.newline);
1596:
1597: CLOSE cu_po;
1598: END IF;
1599:

Line 1637: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1633: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ NEEDBY DATE EARLY');
1634:
1635: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY NEEDBY DATE EARLY');
1636: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_po_release.exception_days2));
1637: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1638: ELSE
1639: c_exception_subject:= c_exception_subject || ' / ' ||
1640: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ NEEDBY DATE LATE');
1641:

Line 1644: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;

1640: FND_MESSAGE.GET_STRING('PJM','SCHED-SUBJ NEEDBY DATE LATE');
1641:
1642: FND_MESSAGE.SET_NAME('PJM','SCHED-BODY NEEDBY DATE LATE');
1643: FND_MESSAGE.SET_TOKEN('NUM', abs(lr_po_release.exception_days2));
1644: c_exception_body := c_exception_body || fnd_global.newline || FND_MESSAGE.GET;
1645: END IF;
1646: END IF;
1647:
1648:

Line 1682: PJM_CONC.put_line(cu_po_release%rowcount || ' exception(s) found.' || fnd_global.newline);

1678: );
1679:
1680: END LOOP;
1681:
1682: PJM_CONC.put_line(cu_po_release%rowcount || ' exception(s) found.' || fnd_global.newline);
1683:
1684: CLOSE cu_po_release;
1685: END IF;
1686: