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

Line 57: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

53: WHEN OTHERS THEN
54: IF g_debug <= gme_debug.g_log_unexpected THEN
55: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
56: END IF;
57: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: END get_pending_lot;
60:
61: PROCEDURE relieve_pending_lot

Line 139: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

135: WHEN OTHERS THEN
136: IF g_debug <= gme_debug.g_log_unexpected THEN
137: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
138: END IF;
139: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: END relieve_pending_lot;
142:
143: PROCEDURE create_product_lot

Line 333: fnd_msg_pub.ADD;

329: IF l_shelf_life_code = 4 THEN
330: IF p_expiration_date IS NULL THEN /* user-defined */
331: FND_MESSAGE.SET_NAME('INV','INV_NULL_EXPIRATION_DATE_EXP');
332: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
333: fnd_msg_pub.ADD;
334: RAISE error_null_exp_dt;
335: ELSE
336: l_in_lot_rec.expiration_date := p_expiration_date;
337: END IF;

Line 385: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

381: NULL;
382: WHEN error_not_prod OR error_lot_create OR error_gen_lot_no_create OR error_null_lots OR error_null_exp_dt THEN
383: x_return_status := fnd_api.g_ret_sts_error;
384: WHEN OTHERS THEN
385: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
386: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
387: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
388: END IF;
389: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

426: WHEN OTHERS THEN
427: IF g_debug <= gme_debug.g_log_unexpected THEN
428: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
429: END IF;
430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: END create_pending_product_lot;
433:
434: PROCEDURE update_pending_product_lot

Line 473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

469: WHEN OTHERS THEN
470: IF g_debug <= gme_debug.g_log_unexpected THEN
471: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
472: END IF;
473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: END update_pending_product_lot;
476:
477: PROCEDURE delete_pending_product_lot

Line 508: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

504: WHEN OTHERS THEN
505: IF g_debug <= gme_debug.g_log_unexpected THEN
506: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
507: END IF;
508: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: END delete_pending_product_lot;
511:
512: --Bug#5078853 created the following over loaded procedure

Line 559: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

555: WHEN OTHERS THEN
556: IF g_debug <= gme_debug.g_log_unexpected THEN
557: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
558: END IF;
559: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: END delete_pending_product_lot;
562:
563: PROCEDURE validate_material_for_create

Line 596: fnd_msg_pub.ADD;

592:
593: IF l_item_rec.lot_control_code = 1 THEN
594: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');
595: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
596: fnd_msg_pub.ADD;
597: RAISE error_not_lot_control;
598: END IF;
599:
600: IF p_batch_header_rec.update_inventory_ind = 'N' THEN

Line 623: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

619: WHEN OTHERS THEN
620: IF g_debug <= gme_debug.g_log_unexpected THEN
621: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
622: END IF;
623: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: END validate_material_for_create;
626:
627: FUNCTION get_last_sequence

Line 661: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

657: WHEN OTHERS THEN
658: IF g_debug <= gme_debug.g_log_unexpected THEN
659: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
660: END IF;
661: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: END get_last_sequence;
664:
665: PROCEDURE validate_record_for_create

Line 845: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

841: WHEN OTHERS THEN
842: IF g_debug <= gme_debug.g_log_unexpected THEN
843: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
844: END IF;
845: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: END validate_record_for_create;
848:
849: PROCEDURE validate_material_for_update

Line 872: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

868: WHEN OTHERS THEN
869: IF g_debug <= gme_debug.g_log_unexpected THEN
870: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
871: END IF;
872: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: END validate_material_for_update;
875:
876: PROCEDURE validate_record_for_update

Line 1088: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1084: WHEN OTHERS THEN
1085: IF g_debug <= gme_debug.g_log_unexpected THEN
1086: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1087: END IF;
1088: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090: END validate_record_for_update;
1091:
1092: PROCEDURE validate_material_for_delete

Line 1115: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1111: WHEN OTHERS THEN
1112: IF g_debug <= gme_debug.g_log_unexpected THEN
1113: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1114: END IF;
1115: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: END validate_material_for_delete;
1118:
1119: PROCEDURE validate_record_for_delete

Line 1165: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1161: WHEN OTHERS THEN
1162: IF g_debug <= gme_debug.g_log_unexpected THEN
1163: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1164: END IF;
1165: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: END validate_record_for_delete;
1168:
1169: -- Call this procedure at the record level because fields besides lot number are required

Line 1312: fnd_msg_pub.ADD;

1308: RETURN FALSE;
1309: WHEN error_um_conv THEN
1310: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1311: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1312: fnd_msg_pub.ADD;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: RETURN FALSE;
1315: WHEN OTHERS THEN
1316: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1319: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1315: WHEN OTHERS THEN
1316: IF g_debug <= gme_debug.g_log_unexpected THEN
1317: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1318: END IF;
1319: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321: RETURN FALSE;
1322: END validate_quantities;
1323:

Line 1360: fnd_msg_pub.ADD;

1356: l_return := TRUE;
1357: ELSE
1358: FND_MESSAGE.SET_NAME('INV','INV_LOT_NOT_EXISTS');
1359: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1360: fnd_msg_pub.ADD;
1361: l_return := FALSE;
1362: END IF;
1363:
1364: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1375: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1371: WHEN OTHERS THEN
1372: IF g_debug <= gme_debug.g_log_unexpected THEN
1373: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1374: END IF;
1375: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: RETURN FALSE;
1378: END validate_lot_number;
1379:

Line 1437: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1433: WHEN OTHERS THEN
1434: IF g_debug <= gme_debug.g_log_unexpected THEN
1435: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1436: END IF;
1437: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: RETURN FALSE;
1440: END validate_sequence;
1441:

Line 1484: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1480: WHEN OTHERS THEN
1481: IF g_debug <= gme_debug.g_log_unexpected THEN
1482: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1483: END IF;
1484: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1486: RETURN FALSE;
1487: END validate_revision;
1488:

Line 1521: fnd_msg_pub.ADD;

1517:
1518: IF l_is_reason = 0 THEN
1519: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');
1520: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1521: fnd_msg_pub.ADD;
1522: l_return := FALSE;
1523: ELSE
1524: l_return := TRUE;
1525: END IF;

Line 1537: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1533: WHEN OTHERS THEN
1534: IF g_debug <= gme_debug.g_log_unexpected THEN
1535: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1536: END IF;
1537: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1539: RETURN FALSE;
1540: END validate_reason_id;
1541:

Line 1584: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1580: WHEN OTHERS THEN
1581: IF g_debug <= gme_debug.g_log_unexpected THEN
1582: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1583: END IF;
1584: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1585: RETURN FALSE;
1586: END pending_product_lot_exist;
1587:
1588: -- nsinghi bug#5689035. Added this procedure.

Line 1635: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1631: || ' Error is '
1632: || SQLERRM);
1633: END IF;
1634:
1635: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1636: x_return_status := fnd_api.g_ret_sts_unexp_error;
1637: END get_pnd_prod_lot_qty;
1638:
1639: END gme_pending_product_lots_pvt;