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.GMD_COMMON_VAL dependencies on FND_MSG_PUB

Line 248: FND_MSG_PUB.initialize;

244: l_api_name, G_PKG_NAME) THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF FND_API.to_Boolean(p_init_msg_list) THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: IF (p_customer_id IS NOT NULL OR p_customer_no IS NOT NULL) THEN

Line 282: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

278:
279: /* no standard check of p_commit because no insert/update/delete */
280:
281: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
282: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
283:
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: X_return_code := SQLCODE;

Line 288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: X_return_code := SQLCODE;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: X_return_code := SQLCODE;
292:

Line 294: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: X_return_code := SQLCODE;
292:
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
295:
296: WHEN OTHERS THEN
297: X_return_code := SQLCODE;
298: x_return_status := FND_API.G_RET_STS_ERROR;

Line 299: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

295:
296: WHEN OTHERS THEN
297: X_return_code := SQLCODE;
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
300:
301: END customer_exists;
302:
303:

Line 382: FND_MSG_PUB.initialize;

378: l_api_name, G_PKG_NAME) THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: IF FND_API.to_Boolean(p_init_msg_list) THEN
382: FND_MSG_PUB.initialize;
383: END IF;
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385:
386:

Line 394: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

390:
391: /* no standard check of p_commit because no insert/update/delete */
392:
393: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
394: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
395:
396: EXCEPTION
397: WHEN FND_API.G_EXC_ERROR THEN
398: X_return_code := SQLCODE;

Line 400: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

396: EXCEPTION
397: WHEN FND_API.G_EXC_ERROR THEN
398: X_return_code := SQLCODE;
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
401:
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: X_return_code := SQLCODE;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 405: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

401:
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: X_return_code := SQLCODE;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
406:
407: WHEN OTHERS THEN
408: X_return_code := SQLCODE;
409: x_return_status := FND_API.G_RET_STS_ERROR;

Line 411: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

407: WHEN OTHERS THEN
408: X_return_code := SQLCODE;
409: x_return_status := FND_API.G_RET_STS_ERROR;
410:
411: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
412:
413: END action_code;
414:
415: /* ========================================================= */

Line 449: FND_MSG_PUB.Add;

445: FETCH Status_cur INTO l_status_code, l_meaning, l_description;
446: IF (Status_cur%NOTFOUND) THEN
447: x_return_status := 'E';
448: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_STATUS_CODE');
449: FND_MSG_PUB.Add;
450: Else
451: x_return_status := 'S';
452: Meaning := l_meaning;
453: Description := l_description;

Line 625: FND_MSG_PUB.initialize;

621: gmd_debug.log_initialize('CalcProcessLoss');
622: END IF;
623: /* Initialize the return status and the message list*/
624: x_return_status := 'S';
625: FND_MSG_PUB.initialize;
626:
627: /* get the values from the record that is input */
628: l_qty := process_loss.qty;
629: l_recipe_id := process_loss.recipe_id;

Line 676: FND_MSG_PUB.Add;

672: l_routing_class := NULL;
673: /* TPL cannot be calculated */
674: x_return_status := 'E';
675: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_CLS');
676: FND_MSG_PUB.Add;
677: END IF;
678: CLOSE Rout_hdr_cur;
679: IF (l_debug = 'Y') THEN
680: gmd_debug.put_line(' Rout Class:'||l_routing_class ||'Rout Qty:'||l_routing_qty ||' Planned Loss:'||l_routing_planned_loss);

Line 689: FND_MSG_PUB.Add;

685: IF (Rout_cls_cur%NOTFOUND) THEN
686: l_routing_uom := NULL;
687: x_return_status := 'E';
688: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_UOM');
689: FND_MSG_PUB.Add;
690: END IF;
691: CLOSE Rout_cls_cur;
692: IF (l_debug = 'Y') THEN
693: gmd_debug.put_line(' Routing UOM : '||l_routing_uom);

Line 714: FND_MSG_PUB.Add;

710:
711: IF (NVL(l_routing_qty,0) < 0) THEN
712: x_return_status := 'E';
713: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_UOM');
714: FND_MSG_PUB.Add;
715: END IF;
716:
717: OPEN process_loss_cur(l_routing_class,l_routing_qty);
718: FETCH process_loss_cur INTO l_routing_theo_loss;

Line 724: FND_MSG_PUB.Add;

720: /* Theo process loss has not been defined. */
721: l_routing_theo_loss := NULL;
722: x_return_status := 'E';
723: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');
724: FND_MSG_PUB.Add;
725: END IF;
726: CLOSE process_loss_cur;
727: IF (l_debug = 'Y') THEN
728: gmd_debug.put_line(' Routing Theoretical Loss:'||l_routing_theo_loss);

Line 790: FND_MSG_PUB.Add;

786: fetch process_loss_cur INTO l_recipe_theo_loss;
787: IF (process_loss_cur%NOTFOUND) THEN
788: x_return_status := 'E';
789: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');
790: FND_MSG_PUB.Add;
791: l_recipe_theo_loss := NULL;
792: l_recipe_pp_loss := NULL;
793: ELSE
794: /* After applying the routing loss proration */

Line 885: FND_MSG_PUB.Add;

881: fetch process_loss_cur INTO x_recipe_theo_loss;
882: IF (process_loss_cur%NOTFOUND) THEN
883: x_return_status := 'E';
884: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');
885: FND_MSG_PUB.Add;
886: x_recipe_theo_loss := NULL;
887: x_process_loss := NULL;
888: ELSE
889: /* After applying the routing loss proration */

Line 946: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

942: x_process_loss := l_routing_theo_loss;
943: END IF;
944:
945: /* return the message count and data */
946: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
947: P_data => x_msg_data);
948:
949: EXCEPTION
950: WHEN FND_API.g_exc_error THEN

Line 956: FND_MSG_PUB.ADD;

952: When Others then
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
955: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
958: P_data => x_msg_data);
959: END Calculate_Process_loss;
960:

Line 957: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
955: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
958: P_data => x_msg_data);
959: END Calculate_Process_loss;
960:
961:

Line 1073: FND_MSG_PUB.Add;

1069:
1070: /* If the x_uom is yet NULL then its an error */
1071: IF (x_uom IS NULL) Then
1072: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');
1073: FND_MSG_PUB.Add;
1074: x_return_status := 'E';
1075: END IF;
1076:
1077: /* Bug 1683702 - Thomas Daniel */

Line 1125: FND_MSG_PUB.Add;

1121: IF l_temp_qty < 0 THEN
1122: x_ingredient_qty := NULL;
1123: x_return_status := 'Q';
1124: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CALC_TOQ');
1125: FND_MSG_PUB.Add;
1126: Exit;
1127: ELSE
1128: X_ingredient_qty := X_ingredient_qty + l_temp_qty;
1129: END IF;

Line 1148: FND_MSG_PUB.Add;

1144: IF l_temp_qty < 0 THEN
1145: x_product_qty := NULL;
1146: x_return_status := 'Q';
1147: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CALC_TOQ');
1148: FND_MSG_PUB.Add;
1149: Exit;
1150: ELSE
1151: x_product_qty := x_product_qty + l_temp_qty;
1152: END IF;

Line 1156: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

1152: END IF;
1153: END IF;
1154: END LOOP;
1155:
1156: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1157: P_data => x_msg_data);
1158:
1159: EXCEPTION
1160: WHEN FND_API.g_exc_error THEN

Line 1166: FND_MSG_PUB.ADD;

1162: WHEN Others THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1165: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1166: FND_MSG_PUB.ADD;
1167: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1168: P_data => x_msg_data);
1169:
1170: END Calculate_Total_Qty;

Line 1167: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1165: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1166: FND_MSG_PUB.ADD;
1167: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1168: P_data => x_msg_data);
1169:
1170: END Calculate_Total_Qty;
1171:

Line 1260: FND_MSG_PUB.INITIALIZE;

1256: /*not setup, though the product conversions have been setup */
1257: IF l_product_qty > 0 THEN
1258: l_recipe_qty := l_product_qty;
1259: ELSE
1260: FND_MSG_PUB.INITIALIZE;
1261: FND_MESSAGE.SET_NAME ('GMD', 'GMD_ERR_CALC_ROUT_FACT');
1262: FND_MSG_PUB.add;
1263: x_return_status := 'W';
1264: RETURN 1;

Line 1262: FND_MSG_PUB.add;

1258: l_recipe_qty := l_product_qty;
1259: ELSE
1260: FND_MSG_PUB.INITIALIZE;
1261: FND_MESSAGE.SET_NAME ('GMD', 'GMD_ERR_CALC_ROUT_FACT');
1262: FND_MSG_PUB.add;
1263: x_return_status := 'W';
1264: RETURN 1;
1265: END IF;
1266: END IF;

Line 1543: FND_MSG_PUB.Add;

1539: IF (l_max_capacity < 0) THEN
1540: /* Set a message in our stack : the capacity conv has not occurred */
1541: x_return_status := 'E';
1542: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CONV_CAPACITY_UOM');
1543: FND_MSG_PUB.Add;
1544: END IF; /* when max cap is < 0 */
1545:
1546: /* Get the step qty : */
1547: /* If the max capacity is yet -ve its becoz none of the capcity uom where */

Line 2387: fnd_msg_pub.ADD;

2383: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2384: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2385: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2386: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2387: fnd_msg_pub.ADD;
2388: X_return_status := FND_API.g_ret_sts_error;
2389: RAISE VALIDATION_FAIL;
2390: END IF;
2391: CLOSE Cur_formula_own;

Line 2402: fnd_msg_pub.ADD;

2398: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2399: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2400: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2401: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2402: fnd_msg_pub.ADD;
2403: X_return_status := FND_API.g_ret_sts_error;
2404: RAISE VALIDATION_FAIL;
2405: END IF;
2406: CLOSE Cur_formula_own_revision;

Line 2419: fnd_msg_pub.ADD;

2415: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2416: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2417: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2418: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2419: fnd_msg_pub.ADD;
2420: X_return_status := FND_API.g_ret_sts_error;
2421: RAISE VALIDATION_FAIL;
2422: END IF;
2423: CLOSE Cur_recipe_own;

Line 2434: fnd_msg_pub.ADD;

2430: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2431: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2432: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2433: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2434: fnd_msg_pub.ADD;
2435: X_return_status := FND_API.g_ret_sts_error;
2436: RAISE VALIDATION_FAIL;
2437: END IF;
2438: CLOSE Cur_recipe_own_revision;

Line 2450: fnd_msg_pub.ADD;

2446: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2447: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2448: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2449: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2450: fnd_msg_pub.ADD;
2451: X_return_status := FND_API.g_ret_sts_error;
2452: RAISE VALIDATION_FAIL;
2453: END IF;
2454: CLOSE Cur_recipe_override;

Line 2465: fnd_msg_pub.ADD;

2461: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2462: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2463: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2464: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2465: fnd_msg_pub.ADD;
2466: X_return_status := FND_API.g_ret_sts_error;
2467: RAISE VALIDATION_FAIL;
2468: END IF;
2469: CLOSE Cur_recipe_override_revision;

Line 2479: fnd_msg_pub.ADD;

2475: FND_MESSAGE.set_name('GMD','GMD_VALIDITY_OWNER_ORG_NOT_ACC');
2476: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2477: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2478: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2479: fnd_msg_pub.ADD;
2480: X_return_status := FND_API.g_ret_sts_error;
2481: RAISE VALIDATION_FAIL;
2482: END IF;
2483: CLOSE Cur_recipe_validity;

Line 2494: fnd_msg_pub.ADD;

2490: FND_MESSAGE.set_name('GMD','GMD_REV_VALIDITY_ORG_NOT_ACC');
2491: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2492: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2493: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2494: fnd_msg_pub.ADD;
2495: X_return_status := FND_API.g_ret_sts_error;
2496: RAISE VALIDATION_FAIL;
2497: END IF;
2498: CLOSE Cur_recipe_validity_revision;

Line 2608: FND_MSG_PUB.initialize;

2604:
2605: BEGIN
2606:
2607: x_return_status := FND_API.G_RET_STS_SUCCESS;
2608: FND_MSG_PUB.initialize;
2609:
2610: -- Check ORganization Parameters
2611: OPEN Cur_get_formula_org;
2612: FETCH Cur_get_formula_org INTO p_orgn_id;

Line 2701: fnd_msg_pub.ADD;

2697: IF l_temp_qty < 0
2698: THEN
2699: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2700: fnd_message.set_token('UOM',l_conv_uom);
2701: fnd_msg_pub.ADD;
2702: RAISE CANNOT_CONVERT;
2703: END IF;
2704: ELSE
2705: l_temp_qty := l_material_tab (i).qty;

Line 2760: fnd_msg_pub.ADD;

2756: IF l_prod_prop_qty > 0 THEN
2757: /* Check whether Percentages have been enterd for all Proportional Products. */
2758: IF temp_prod_tbl1 (i).prod_percent IS NULL THEN
2759: fnd_message.set_name ('GMD', 'GMD_ENTER_PERCENTAGE_YES');
2760: fnd_msg_pub.ADD;
2761: RAISE CANNOT_CONVERT;
2762: END IF;
2763: l_prod_ratio := temp_prod_tbl1 (i).prod_percent / 100;
2764: ELSE

Line 2794: fnd_msg_pub.ADD;

2790: THEN
2791: x_return_status := 'Q';
2792: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2793: fnd_message.set_token('UOM',l_conv_uom);
2794: fnd_msg_pub.ADD;
2795: EXIT;
2796: END IF;
2797: ELSE
2798: l_temp_qty := l_one_prodqty;

Line 2819: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2815: SET total_output_qty = lhdrqty
2816: WHERE formula_id = p_formula_id;
2817: /* Get the message count from the Message stack */
2818: END IF;
2819: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2820: p_data => x_msg_data);
2821: EXCEPTION
2822: WHEN CANNOT_CONVERT THEN
2823: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2824: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2820: p_data => x_msg_data);
2821: EXCEPTION
2822: WHEN CANNOT_CONVERT THEN
2823: x_return_status := fnd_api.g_ret_sts_unexp_error;
2824: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2825: p_data => x_msg_data);
2826: END Calculate_Total_Product_Qty ;
2827:
2828: