APPS.GMD_QMSMC dependencies on FND_MESSAGE

Line 916: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');

912: -- FETCH sample_plan_freq_per into l_frequency_per ;
913: -- CLOSE sample_plan_freq_per ;
914: --END IF;
915:
916: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
917: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
918: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);

Line 917: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);

913: -- CLOSE sample_plan_freq_per ;
914: --END IF;
915:
916: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
917: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
918: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM

Line 918: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);

914: --END IF;
915:
916: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
917: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
918: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM
922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);

Line 919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);

915:
916: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
917: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
918: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM
922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
923: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);

Line 920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);

916: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
917: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
918: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM
922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
923: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
924: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);

Line 921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM

917: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
918: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM
922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
923: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
924: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
925: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);

Line 922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);

918: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM
922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
923: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
924: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
925: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
926:

Line 923: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);

919: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM
922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
923: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
924: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
925: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
926:
927: /* Check to see if auto sample creation is enabled and auto docu numbering for the Org*/

Line 924: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);

920: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM
922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
923: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
924: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
925: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
926:
927: /* Check to see if auto sample creation is enabled and auto docu numbering for the Org*/
928: IF ((l_auto_sample = 'Y') and (l_doc_number = 2))THEN

Line 925: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);

921: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670 It is SAMPLE_UOM and not SAMPLE_QTY_UOM
922: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
923: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
924: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
925: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
926:
927: /* Check to see if auto sample creation is enabled and auto docu numbering for the Org*/
928: IF ((l_auto_sample = 'Y') and (l_doc_number = 2))THEN
929:

Line 1081: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',

1077: END IF;
1078: CLOSE get_reg_sample_num;
1079:
1080: IF (lrsample_name IS not NULL) THEN
1081: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',
1082: frsample_name || '-' ||lrsample_name);
1083: ELSE
1084: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
1085: END IF;

Line 1084: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);

1080: IF (lrsample_name IS not NULL) THEN
1081: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',
1082: frsample_name || '-' ||lrsample_name);
1083: ELSE
1084: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
1085: END IF;
1086:
1087: IF (lasample_name IS not NULL) THEN
1088: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',

Line 1088: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',

1084: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
1085: END IF;
1086:
1087: IF (lasample_name IS not NULL) THEN
1088: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',
1089: fasample_name || '-' ||lasample_name);
1090: ELSE
1091: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
1092: END IF;

Line 1091: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);

1087: IF (lasample_name IS not NULL) THEN
1088: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',
1089: fasample_name || '-' ||lasample_name);
1090: ELSE
1091: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
1092: END IF;
1093:
1094: IF (lsample_name IS not NULL) THEN
1095: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',

Line 1095: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',

1091: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
1092: END IF;
1093:
1094: IF (lsample_name IS not NULL) THEN
1095: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',
1096: fsample_name || '-' ||lsample_name);
1097: ELSE
1098: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
1099: END IF;

Line 1098: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);

1094: IF (lsample_name IS not NULL) THEN
1095: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',
1096: fsample_name || '-' ||lsample_name);
1097: ELSE
1098: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
1099: END IF;
1100:
1101: --l_sample_plan := FND_MESSAGE.GET(); RLNAGARA B4905670 Commented this line
1102:

Line 1101: --l_sample_plan := FND_MESSAGE.GET(); RLNAGARA B4905670 Commented this line

1097: ELSE
1098: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
1099: END IF;
1100:
1101: --l_sample_plan := FND_MESSAGE.GET(); RLNAGARA B4905670 Commented this line
1102:
1103: ELSE -- IF ((l_auto_sample <> 'Y') or (l_doc_number <> 2))
1104:
1105: /* Sampling Event Successfully Created. Set Form Attribute to the sampling event */

Line 1120: l_sample_plan := FND_MESSAGE.GET();

1116: END IF; -- IF ((l_auto_sample = 'Y') and (l_doc_number = 2))
1117:
1118: -- Bug 3625651 : populate the workflow attribute with
1119: -- the sampling plan information
1120: l_sample_plan := FND_MESSAGE.GET();
1121:
1122: ELSE -- l_sample_plan_exists <> 1
1123: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
1124: l_sample_plan := FND_MESSAGE.GET();

Line 1123: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');

1119: -- the sampling plan information
1120: l_sample_plan := FND_MESSAGE.GET();
1121:
1122: ELSE -- l_sample_plan_exists <> 1
1123: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
1124: l_sample_plan := FND_MESSAGE.GET();
1125: l_sample_count := 1; -- just in case
1126:
1127: /* Sampling Event Successfully Created. Set Form Attribute

Line 1124: l_sample_plan := FND_MESSAGE.GET();

1120: l_sample_plan := FND_MESSAGE.GET();
1121:
1122: ELSE -- l_sample_plan_exists <> 1
1123: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
1124: l_sample_plan := FND_MESSAGE.GET();
1125: l_sample_count := 1; -- just in case
1126:
1127: /* Sampling Event Successfully Created. Set Form Attribute
1128: to the sampling event */

Line 1340: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');

1336: FETCH sample_plan_freq_per into l_frequency_per ;
1337: CLOSE sample_plan_freq_per ;
1338: END IF;
1339:
1340: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
1341: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
1342: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);

Line 1341: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);

1337: CLOSE sample_plan_freq_per ;
1338: END IF;
1339:
1340: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
1341: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
1342: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670

Line 1342: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);

1338: END IF;
1339:
1340: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
1341: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
1342: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);

Line 1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);

1339:
1340: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
1341: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
1342: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
1347: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);

Line 1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);

1340: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
1341: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
1342: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
1347: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
1348: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);

Line 1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670

1341: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
1342: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
1347: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
1348: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
1349: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);

Line 1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);

1342: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
1347: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
1348: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
1349: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
1350:

Line 1347: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);

1343: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
1347: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
1348: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
1349: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
1350:
1351: l_sample_plan_exists := 1;

Line 1348: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);

1344: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
1347: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
1348: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
1349: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
1350:
1351: l_sample_plan_exists := 1;
1352:

Line 1349: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);

1345: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
1346: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
1347: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
1348: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
1349: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
1350:
1351: l_sample_plan_exists := 1;
1352:
1353: /* Check to see if auto sample creation is enabled */

Line 1464: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',

1460: END IF;
1461: CLOSE get_reg_sample_num;
1462:
1463: IF (lrsample_name is not NULL) THEN
1464: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',
1465: frsample_name || '-' ||lrsample_name);
1466: ELSE
1467: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
1468: END IF;

Line 1467: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);

1463: IF (lrsample_name is not NULL) THEN
1464: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',
1465: frsample_name || '-' ||lrsample_name);
1466: ELSE
1467: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
1468: END IF;
1469:
1470: IF (lasample_name is not NULL) THEN
1471: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',

Line 1471: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',

1467: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
1468: END IF;
1469:
1470: IF (lasample_name is not NULL) THEN
1471: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',
1472: fasample_name || '-' ||lasample_name);
1473: ELSE
1474: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
1475: END IF;

Line 1474: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);

1470: IF (lasample_name is not NULL) THEN
1471: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',
1472: fasample_name || '-' ||lasample_name);
1473: ELSE
1474: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
1475: END IF;
1476:
1477: IF (lsample_name is not NULL) THEN
1478: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',

Line 1478: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',

1474: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
1475: END IF;
1476:
1477: IF (lsample_name is not NULL) THEN
1478: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',
1479: fsample_name || '-' ||lsample_name);
1480: ELSE
1481: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
1482: END IF;

Line 1481: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);

1477: IF (lsample_name is not NULL) THEN
1478: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',
1479: fsample_name || '-' ||lsample_name);
1480: ELSE
1481: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
1482: END IF;
1483:
1484: ELSE
1485: /* Sampling Event Successfully Created. Set Form Attribute

Line 1499: l_sample_plan := FND_MESSAGE.GET();

1495: l_form := 'GMDQSMPL_EDIT_F:SAMPLING_EVENT_ID="'|| l_sampling_events.sampling_event_id||'" WF_SAMPLE="Y"';
1496: END IF;
1497: -- bug 4165704: not sure why this is here so I took it out?
1498: --RLNAGARA Uncommented the below line as this is necessary here because we have to show this message in the notification.
1499: l_sample_plan := FND_MESSAGE.GET();
1500: ELSE
1501: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
1502: l_sample_plan := FND_MESSAGE.GET();
1503: l_sample_count := 1; -- incase there is no sample plan used

Line 1501: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');

1497: -- bug 4165704: not sure why this is here so I took it out?
1498: --RLNAGARA Uncommented the below line as this is necessary here because we have to show this message in the notification.
1499: l_sample_plan := FND_MESSAGE.GET();
1500: ELSE
1501: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
1502: l_sample_plan := FND_MESSAGE.GET();
1503: l_sample_count := 1; -- incase there is no sample plan used
1504:
1505: /* Sampling Event Successfully Created. Set Form Attribute

Line 1502: l_sample_plan := FND_MESSAGE.GET();

1498: --RLNAGARA Uncommented the below line as this is necessary here because we have to show this message in the notification.
1499: l_sample_plan := FND_MESSAGE.GET();
1500: ELSE
1501: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
1502: l_sample_plan := FND_MESSAGE.GET();
1503: l_sample_count := 1; -- incase there is no sample plan used
1504:
1505: /* Sampling Event Successfully Created. Set Form Attribute
1506: to the sampling event */

Line 2404: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');

2400: END IF;
2401:
2402: -- Bug 4165704: took out reference to wip_sample_plan cursor and put in l_sample_plan_exists
2403: IF l_sample_plan_exists = 1 THEN
2404: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
2405: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
2406: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);

Line 2405: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);

2401:
2402: -- Bug 4165704: took out reference to wip_sample_plan cursor and put in l_sample_plan_exists
2403: IF l_sample_plan_exists = 1 THEN
2404: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
2405: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
2406: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);

Line 2406: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);

2402: -- Bug 4165704: took out reference to wip_sample_plan cursor and put in l_sample_plan_exists
2403: IF l_sample_plan_exists = 1 THEN
2404: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
2405: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
2406: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);

Line 2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670

2403: IF l_sample_plan_exists = 1 THEN
2404: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
2405: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
2406: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);

Line 2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);

2404: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_INFO');
2405: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
2406: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);

Line 2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);

2405: FND_MESSAGE.SET_TOKEN('SAMPLE_NO', l_sample_count);
2406: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
2413: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);

Line 2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);

2406: FND_MESSAGE.SET_TOKEN('SAMPLE_QTY', l_sample_qty);
2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
2413: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2414: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);

Line 2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);

2407: FND_MESSAGE.SET_TOKEN('SAMPLE_UOM', l_sample_qty_uom); --RLNAGARA B4905670
2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
2413: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2414: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
2415: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);

Line 2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);

2408: FND_MESSAGE.SET_TOKEN('FREQ_CNT',l_frequency_count);
2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
2413: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2414: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
2415: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
2416:

Line 2413: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);

2409: FND_MESSAGE.SET_TOKEN('ASAMPLE_NO', l_archive_cnt_req);
2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
2413: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2414: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
2415: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
2416:
2417: --RLNAGARA Bug 5910300 start

Line 2414: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);

2410: FND_MESSAGE.SET_TOKEN('ASAMPLE_QTY', l_archive_qty);
2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
2413: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2414: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
2415: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
2416:
2417: --RLNAGARA Bug 5910300 start
2418: IF (l_frequency_type = 'F') THEN

Line 2415: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);

2411: FND_MESSAGE.SET_TOKEN('RSAMPLE_NO', l_reserve_cnt_req);
2412: FND_MESSAGE.SET_TOKEN('RSAMPLE_QTY', l_reserve_qty);
2413: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2414: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
2415: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
2416:
2417: --RLNAGARA Bug 5910300 start
2418: IF (l_frequency_type = 'F') THEN
2419: UPDATE GMD_WIP_SPEC_VRS

Line 2441: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);

2437: FETCH wip_sample_plan_freq_per into l_frequency_per ;
2438: CLOSE wip_sample_plan_freq_per ;
2439: END IF;
2440:
2441: FND_MESSAGE.SET_TOKEN('FREQ_PER',l_frequency_per);
2442:
2443: /* Check to see if auto sample creation is enabled */
2444: IF ((l_auto_sample = 'Y') and (l_doc_number = 2)) THEN
2445: GMD_AUTO_SAMPLE_PKG.create_samples(l_sampling_events,

Line 2504: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',

2500: END IF;
2501: CLOSE get_reg_sample_num;
2502:
2503: IF (lrsample_name is not NULL) THEN
2504: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',
2505: frsample_name || '-' ||lrsample_name);
2506: ELSE
2507: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2508: END IF ;

Line 2507: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);

2503: IF (lrsample_name is not NULL) THEN
2504: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES',
2505: frsample_name || '-' ||lrsample_name);
2506: ELSE
2507: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2508: END IF ;
2509:
2510: IF (lasample_name is not NULL) THEN
2511: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',

Line 2511: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',

2507: FND_MESSAGE.SET_TOKEN('RESERVE_SAMPLES', frsample_name);
2508: END IF ;
2509:
2510: IF (lasample_name is not NULL) THEN
2511: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',
2512: fasample_name || '-' ||lasample_name);
2513: ELSE
2514: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
2515: END IF ;

Line 2514: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);

2510: IF (lasample_name is not NULL) THEN
2511: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES',
2512: fasample_name || '-' ||lasample_name);
2513: ELSE
2514: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
2515: END IF ;
2516:
2517: IF (lsample_name is not NULL) THEN
2518: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',

Line 2518: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',

2514: FND_MESSAGE.SET_TOKEN('ARCHIVE_SAMPLES', fasample_name);
2515: END IF ;
2516:
2517: IF (lsample_name is not NULL) THEN
2518: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',
2519: fsample_name || '-' ||lsample_name);
2520: ELSE
2521: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
2522: END IF ;

Line 2521: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);

2517: IF (lsample_name is not NULL) THEN
2518: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES',
2519: fsample_name || '-' ||lsample_name);
2520: ELSE
2521: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
2522: END IF ;
2523:
2524: ELSE
2525: /* Sampling Event Successfully Created. Set Form Attribute

Line 2537: l_sample_plan := FND_MESSAGE.GET();

2533:
2534: --l_form := 'GMDQSMPL_EDIT_F:SAMPLING_EVENT_ID="'|| l_sampling_events.sampling_event_id||'"';
2535: l_form := 'GMDQSMPL_EDIT_F:SAMPLING_EVENT_ID="'|| l_sampling_events.sampling_event_id||'" WF_SAMPLE="Y"';
2536: END IF ;
2537: l_sample_plan := FND_MESSAGE.GET();
2538:
2539: ELSE
2540: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
2541: l_sample_plan := FND_MESSAGE.GET();

Line 2540: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');

2536: END IF ;
2537: l_sample_plan := FND_MESSAGE.GET();
2538:
2539: ELSE
2540: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
2541: l_sample_plan := FND_MESSAGE.GET();
2542:
2543: l_sample_count := 1; -- just in case
2544: --RLNAGARA B5389806 Only passing sampling_event_id is not enough to create samples.

Line 2541: l_sample_plan := FND_MESSAGE.GET();

2537: l_sample_plan := FND_MESSAGE.GET();
2538:
2539: ELSE
2540: FND_MESSAGE.SET_NAME('GMD','GMD_SAMPLE_PLAN_NONE');
2541: l_sample_plan := FND_MESSAGE.GET();
2542:
2543: l_sample_count := 1; -- just in case
2544: --RLNAGARA B5389806 Only passing sampling_event_id is not enough to create samples.
2545: --Here we need to pass another parameter called WF_SAMPLE which informs that the sample