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.AHL_MM_MTL_MGT_PVT dependencies on FND_MESSAGE

Line 214: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');

210: X_MTL_AVL_SCHLD_TBL(I).AVAILABLE_QUANTITY := P_X_MATERIAL_AVL_TBL(I).QUANTITY_AVAILABLE;
211: X_MTL_AVL_SCHLD_TBL(I).AVL_SCH_DATE := P_X_MATERIAL_AVL_TBL(I).SCHEDULED_DATE;
212: X_MTL_AVL_SCHLD_TBL(I).ERROR_CODE := P_X_MATERIAL_AVL_TBL(I).ERROR_CODE;
213: IF(P_X_MATERIAL_AVL_TBL(I).QUANTITY = 0 ) THEN
214: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');
215: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
216: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
217: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');

Line 215: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);

211: X_MTL_AVL_SCHLD_TBL(I).AVL_SCH_DATE := P_X_MATERIAL_AVL_TBL(I).SCHEDULED_DATE;
212: X_MTL_AVL_SCHLD_TBL(I).ERROR_CODE := P_X_MATERIAL_AVL_TBL(I).ERROR_CODE;
213: IF(P_X_MATERIAL_AVL_TBL(I).QUANTITY = 0 ) THEN
214: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');
215: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
216: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
217: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
219: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);

Line 216: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();

212: X_MTL_AVL_SCHLD_TBL(I).ERROR_CODE := P_X_MATERIAL_AVL_TBL(I).ERROR_CODE;
213: IF(P_X_MATERIAL_AVL_TBL(I).QUANTITY = 0 ) THEN
214: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');
215: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
216: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
217: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
219: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
220: FND_MESSAGE.SET_TOKEN('ATP_MSG', P_X_MATERIAL_AVL_TBL(I).ERROR_MESSAGE);

Line 218: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');

214: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');
215: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
216: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
217: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
219: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
220: FND_MESSAGE.SET_TOKEN('ATP_MSG', P_X_MATERIAL_AVL_TBL(I).ERROR_MESSAGE);
221: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
222: END IF;

Line 219: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);

215: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
216: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
217: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
219: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
220: FND_MESSAGE.SET_TOKEN('ATP_MSG', P_X_MATERIAL_AVL_TBL(I).ERROR_MESSAGE);
221: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
222: END IF;
223: END LOOP;

Line 220: FND_MESSAGE.SET_TOKEN('ATP_MSG', P_X_MATERIAL_AVL_TBL(I).ERROR_MESSAGE);

216: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
217: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
219: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
220: FND_MESSAGE.SET_TOKEN('ATP_MSG', P_X_MATERIAL_AVL_TBL(I).ERROR_MESSAGE);
221: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
222: END IF;
223: END LOOP;
224:

Line 221: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();

217: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
218: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
219: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM);
220: FND_MESSAGE.SET_TOKEN('ATP_MSG', P_X_MATERIAL_AVL_TBL(I).ERROR_MESSAGE);
221: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
222: END IF;
223: END LOOP;
224:
225: EXCEPTION

Line 363: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');

359:
360: X_MTL_AVL_SCHLD_TBL(I).ERROR_CODE := P_X_MATERIAL_AVL_TBL(I).ERROR_CODE;
361:
362: IF (P_X_MATERIAL_AVL_TBL(I).SCHEDULED_DATE IS NULL) THEN
363: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');
364: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);
365: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
366: X_MTL_AVL_SCHLD_TBL(I).ERROR_CODE := -1;
367: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN

Line 364: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);

360: X_MTL_AVL_SCHLD_TBL(I).ERROR_CODE := P_X_MATERIAL_AVL_TBL(I).ERROR_CODE;
361:
362: IF (P_X_MATERIAL_AVL_TBL(I).SCHEDULED_DATE IS NULL) THEN
363: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');
364: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);
365: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
366: X_MTL_AVL_SCHLD_TBL(I).ERROR_CODE := -1;
367: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
368: OPEN ERROR_MESSAGE_CUR(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE);

Line 365: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();

361:
362: IF (P_X_MATERIAL_AVL_TBL(I).SCHEDULED_DATE IS NULL) THEN
363: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_QTY_ERR');
364: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);
365: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
366: X_MTL_AVL_SCHLD_TBL(I).ERROR_CODE := -1;
367: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
368: OPEN ERROR_MESSAGE_CUR(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE);
369: FETCH ERROR_MESSAGE_CUR INTO ERROR_MESSAGE_REC;

Line 371: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');

367: ELSIF(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE <> 0) THEN
368: OPEN ERROR_MESSAGE_CUR(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE);
369: FETCH ERROR_MESSAGE_CUR INTO ERROR_MESSAGE_REC;
370: CLOSE ERROR_MESSAGE_CUR;
371: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
372: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);
373: FND_MESSAGE.SET_TOKEN('ATP_MSG', ERROR_MESSAGE_REC.MEANING);
374: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
375: ERROR_MESSAGE_REC.MEANING := NULL;

Line 372: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);

368: OPEN ERROR_MESSAGE_CUR(P_X_MATERIAL_AVL_TBL(I).ERROR_CODE);
369: FETCH ERROR_MESSAGE_CUR INTO ERROR_MESSAGE_REC;
370: CLOSE ERROR_MESSAGE_CUR;
371: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
372: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);
373: FND_MESSAGE.SET_TOKEN('ATP_MSG', ERROR_MESSAGE_REC.MEANING);
374: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
375: ERROR_MESSAGE_REC.MEANING := NULL;
376: END IF;

Line 373: FND_MESSAGE.SET_TOKEN('ATP_MSG', ERROR_MESSAGE_REC.MEANING);

369: FETCH ERROR_MESSAGE_CUR INTO ERROR_MESSAGE_REC;
370: CLOSE ERROR_MESSAGE_CUR;
371: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
372: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);
373: FND_MESSAGE.SET_TOKEN('ATP_MSG', ERROR_MESSAGE_REC.MEANING);
374: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
375: ERROR_MESSAGE_REC.MEANING := NULL;
376: END IF;
377:

Line 374: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();

370: CLOSE ERROR_MESSAGE_CUR;
371: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
372: FND_MESSAGE.SET_TOKEN('ITEM_NAME', P_X_MATERIAL_AVL_TBL(I).ITEM_DESCRIPTION);
373: FND_MESSAGE.SET_TOKEN('ATP_MSG', ERROR_MESSAGE_REC.MEANING);
374: X_MTL_AVL_SCHLD_TBL(I).ERROR_MESSAGE := FND_MESSAGE.GET();
375: ERROR_MESSAGE_REC.MEANING := NULL;
376: END IF;
377:
378: END LOOP;

Line 756: FND_MESSAGE.set_name('AHL','AHL_MM_NO_MO_AOG');

752: FND_LOG.string(l_log_statement, L_DEBUG,
753: 'The demand is not AOG');
754: END IF;
755:
756: FND_MESSAGE.set_name('AHL','AHL_MM_NO_MO_AOG');
757: FND_MSG_PUB.add;
758: RAISE FND_API.G_EXC_ERROR;
759: END IF;
760:

Line 768: FND_MESSAGE.set_name('AHL','AHL_MM_NO_LOCATOR');

764: FND_LOG.string(l_log_statement, L_DEBUG,
765: 'Visit Locator is not defined to create move order');
766: END IF;
767:
768: FND_MESSAGE.set_name('AHL','AHL_MM_NO_LOCATOR');
769: FND_MSG_PUB.add;
770: RAISE FND_API.G_EXC_ERROR;
771: END IF;
772:

Line 777: FND_MESSAGE.set_name('AHL','AHL_MM_SAME_LOCATOR');

773: --Throw error if supply and demand locators are same
774: FOR i in p_supply_tbl_type.FIRST .. p_supply_tbl_type.LAST
775: LOOP
776: IF (p_supply_tbl_type(i).Supply_Locator_Id = l_dmd_loc_id) THEN
777: FND_MESSAGE.set_name('AHL','AHL_MM_SAME_LOCATOR');
778: FND_MSG_PUB.add;
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781: END LOOP;

Line 1594: fnd_message.set_name('AHL','AHL_MM_AOG_FLAG_WF_SUB'); -- sukhwsin-pending to correct message.

1590: --Call Notification API based upon contructed table.
1591: FOR k IN l_wo_dtl_tab.FIRST..l_wo_dtl_tab.LAST
1592: LOOP
1593:
1594: fnd_message.set_name('AHL','AHL_MM_AOG_FLAG_WF_SUB'); -- sukhwsin-pending to correct message.
1595: fnd_message.set_token('WORKORDER',l_wo_dtl_tab(k).workorder_name);
1596: l_subject := fnd_message.get;
1597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1598: fnd_log.string

Line 1595: fnd_message.set_token('WORKORDER',l_wo_dtl_tab(k).workorder_name);

1591: FOR k IN l_wo_dtl_tab.FIRST..l_wo_dtl_tab.LAST
1592: LOOP
1593:
1594: fnd_message.set_name('AHL','AHL_MM_AOG_FLAG_WF_SUB'); -- sukhwsin-pending to correct message.
1595: fnd_message.set_token('WORKORDER',l_wo_dtl_tab(k).workorder_name);
1596: l_subject := fnd_message.get;
1597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1598: fnd_log.string
1599: (

Line 1596: l_subject := fnd_message.get;

1592: LOOP
1593:
1594: fnd_message.set_name('AHL','AHL_MM_AOG_FLAG_WF_SUB'); -- sukhwsin-pending to correct message.
1595: fnd_message.set_token('WORKORDER',l_wo_dtl_tab(k).workorder_name);
1596: l_subject := fnd_message.get;
1597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1598: fnd_log.string
1599: (
1600: fnd_log.level_procedure,

Line 1910: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_INVLD_ITEM_FOR_ISO');

1906: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
1907: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME , ' INVALID_ITEM_TYPE EXCEPTION - Invalid Item Type');
1908: END IF;
1909:
1910: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_INVLD_ITEM_FOR_ISO');
1911: fnd_message.set_token('ITEM_NAME',L_INVENTORY_ITEM );
1912: FND_MSG_PUB.ADD;
1913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1914: P_DATA => X_MSG_DATA,

Line 1911: fnd_message.set_token('ITEM_NAME',L_INVENTORY_ITEM );

1907: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME , ' INVALID_ITEM_TYPE EXCEPTION - Invalid Item Type');
1908: END IF;
1909:
1910: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_INVLD_ITEM_FOR_ISO');
1911: fnd_message.set_token('ITEM_NAME',L_INVENTORY_ITEM );
1912: FND_MSG_PUB.ADD;
1913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1914: P_DATA => X_MSG_DATA,
1915: p_encoded => fnd_api.g_false);

Line 2516: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');

2512: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, ' L_ERROR_MESSAGE: '|| L_ERROR_MESSAGE);
2513: END IF;
2514:
2515: L_MM_TXN_INTERFACE_S_CURVAL := AHL_MM_TXN_INTERFACE_S.CURRVAL;
2516: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2517: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2518: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2519: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2520: L_ERROR_MESSAGE := L_ERROR_MESSAGE || ' ' || FND_MESSAGE.GET();

Line 2517: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );

2513: END IF;
2514:
2515: L_MM_TXN_INTERFACE_S_CURVAL := AHL_MM_TXN_INTERFACE_S.CURRVAL;
2516: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2517: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2518: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2519: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2520: L_ERROR_MESSAGE := L_ERROR_MESSAGE || ' ' || FND_MESSAGE.GET();
2521:

Line 2518: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );

2514:
2515: L_MM_TXN_INTERFACE_S_CURVAL := AHL_MM_TXN_INTERFACE_S.CURRVAL;
2516: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2517: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2518: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2519: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2520: L_ERROR_MESSAGE := L_ERROR_MESSAGE || ' ' || FND_MESSAGE.GET();
2521:
2522: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN

Line 2519: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );

2515: L_MM_TXN_INTERFACE_S_CURVAL := AHL_MM_TXN_INTERFACE_S.CURRVAL;
2516: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2517: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2518: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2519: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2520: L_ERROR_MESSAGE := L_ERROR_MESSAGE || ' ' || FND_MESSAGE.GET();
2521:
2522: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2523: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, ' L_ERROR_MESSAGE: '|| L_ERROR_MESSAGE);

Line 2520: L_ERROR_MESSAGE := L_ERROR_MESSAGE || ' ' || FND_MESSAGE.GET();

2516: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2517: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2518: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2519: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2520: L_ERROR_MESSAGE := L_ERROR_MESSAGE || ' ' || FND_MESSAGE.GET();
2521:
2522: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2523: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, ' L_ERROR_MESSAGE: '|| L_ERROR_MESSAGE);
2524: end if;

Line 2550: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_NO_CUST_ASSOC');

2546: WHEN NO_CUST_ASSOC THEN
2547: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2548: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_CUST_ASSOC block, Internal customer not defined or not associated to internal location');
2549: END IF;
2550: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_NO_CUST_ASSOC');
2551: FND_MSG_PUB.ADD;
2552: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2553: P_DATA => X_MSG_DATA,
2554: P_ENCODED => FND_API.G_FALSE);

Line 2561: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_SHIPPING_NETWORK');

2557: WHEN NO_SHIPPING_NETWORK THEN
2558: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2559: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_SHIPPING_NETWORK block, Shipping network not defined for the org.');
2560: END IF;
2561: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_SHIPPING_NETWORK');
2562: FND_MSG_PUB.ADD;
2563: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2564: P_DATA => X_MSG_DATA,
2565: P_ENCODED => FND_API.G_FALSE);

Line 2572: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_ISO_ENABLED_NETWORK');

2568: WHEN NO_ISO_ENABLED_NETWORK THEN
2569: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2570: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'NO_ISO_ENABLED_NETWORK block, Internal Order Enabled flag not selected');
2571: END IF;
2572: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_ISO_ENABLED_NETWORK');
2573: FND_MSG_PUB.ADD;
2574: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2575: P_DATA => X_MSG_DATA,
2576: P_ENCODED => FND_API.G_FALSE);

Line 2583: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_CREATION_ERR');

2579: WHEN CREATE_IR_EXC THEN
2580: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2581: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'CREATE_IR_EXC block, add error message AHL_MM_IR_CREATION_ERR');
2582: END IF;
2583: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_CREATION_ERR');
2584: FND_MSG_PUB.ADD;
2585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2586: P_DATA => X_MSG_DATA,
2587: p_encoded => fnd_api.g_false);

Line 2595: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_ISO_CREATION_ERR');

2591: WHEN CREATE_ISO_EXC THEN
2592: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2593: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'CREATE_ISO_EXC block, add error message AHL_MM_ISO_CREATION_ERR');
2594: END IF;
2595: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_ISO_CREATION_ERR');
2596: FND_MSG_PUB.ADD;
2597: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2598: P_DATA => X_MSG_DATA,
2599: p_encoded => fnd_api.g_false);

Line 2608: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_RSRV_ERR');

2604: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2605: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'CREATE_IR_RSRV_EXC, For IR Reservation Created, X_REQUISITION_NUM = ' || X_REQUISITION_NUM
2606: || ', X_INT_ORDER_NUM for int req = ' || X_INT_ORDER_NUM || ', X_RESERVATION_ID for int req = ' || X_RESERVATION_ID);
2607: END IF;
2608: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_RSRV_ERR');
2609: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2610: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2611: FND_MSG_PUB.ADD;
2612: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2609: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );

2605: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'CREATE_IR_RSRV_EXC, For IR Reservation Created, X_REQUISITION_NUM = ' || X_REQUISITION_NUM
2606: || ', X_INT_ORDER_NUM for int req = ' || X_INT_ORDER_NUM || ', X_RESERVATION_ID for int req = ' || X_RESERVATION_ID);
2607: END IF;
2608: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_RSRV_ERR');
2609: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2610: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2611: FND_MSG_PUB.ADD;
2612: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2613: P_DATA => X_MSG_DATA,

Line 2610: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );

2606: || ', X_INT_ORDER_NUM for int req = ' || X_INT_ORDER_NUM || ', X_RESERVATION_ID for int req = ' || X_RESERVATION_ID);
2607: END IF;
2608: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_RSRV_ERR');
2609: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2610: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2611: FND_MSG_PUB.ADD;
2612: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2613: P_DATA => X_MSG_DATA,
2614: p_encoded => fnd_api.g_false);

Line 2623: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');

2619: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2620: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'PICK_REL_EXC, For IR Reservation Created, X_REQUISITION_NUM = ' || X_REQUISITION_NUM
2621: || ', X_INT_ORDER_NUM for int req = ' || X_INT_ORDER_NUM || ', X_RESERVATION_ID for int req = ' || X_RESERVATION_ID);
2622: END IF;
2623: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2624: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2625: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2626: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2627: FND_MSG_PUB.ADD;

Line 2624: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );

2620: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'PICK_REL_EXC, For IR Reservation Created, X_REQUISITION_NUM = ' || X_REQUISITION_NUM
2621: || ', X_INT_ORDER_NUM for int req = ' || X_INT_ORDER_NUM || ', X_RESERVATION_ID for int req = ' || X_RESERVATION_ID);
2622: END IF;
2623: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2624: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2625: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2626: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2627: FND_MSG_PUB.ADD;
2628: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 2625: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );

2621: || ', X_INT_ORDER_NUM for int req = ' || X_INT_ORDER_NUM || ', X_RESERVATION_ID for int req = ' || X_RESERVATION_ID);
2622: END IF;
2623: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2624: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2625: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2626: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2627: FND_MSG_PUB.ADD;
2628: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2629: P_DATA => X_MSG_DATA,

Line 2626: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );

2622: END IF;
2623: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_FAIL');
2624: FND_MESSAGE.SET_TOKEN('REQ_NUM',X_REQUISITION_NUM );
2625: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2626: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2627: FND_MSG_PUB.ADD;
2628: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2629: P_DATA => X_MSG_DATA,
2630: p_encoded => fnd_api.g_false);

Line 2635: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_UNKNOWN_ERR');

2631: X_RETURN_STATUS := G_RET_STS_ERROR;
2632: --rollback to PERFORM_PICK_RELEASE;
2633:
2634: when OTHERS then
2635: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_UNKNOWN_ERR');
2636: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
2637: X_RETURN_STATUS := G_RET_STS_ERROR;
2638: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2639: P_DATA => X_MSG_DATA,

Line 3638: FND_MESSAGE.SET_NAME('AHL', 'AHL_PICKING_RULE_ID_INV');

3634: WHEN INVALID_PICK_RULE THEN
3635: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3636: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In INVALID_PICK_RULE exception');
3637: end if;
3638: FND_MESSAGE.SET_NAME('AHL', 'AHL_PICKING_RULE_ID_INV');
3639: fnd_message.set_token('PICKING_RULE_ID',l_picking_rule_id );
3640: FND_MSG_PUB.ADD;
3641: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3642: p_data => x_msg_data,

Line 3639: fnd_message.set_token('PICKING_RULE_ID',l_picking_rule_id );

3635: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3636: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In INVALID_PICK_RULE exception');
3637: end if;
3638: FND_MESSAGE.SET_NAME('AHL', 'AHL_PICKING_RULE_ID_INV');
3639: fnd_message.set_token('PICKING_RULE_ID',l_picking_rule_id );
3640: FND_MSG_PUB.ADD;
3641: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3642: p_data => x_msg_data,
3643: p_encoded => fnd_api.g_false);

Line 3650: FND_MESSAGE.SET_NAME('AHL', 'AHL_INVLD_DELIVERY_DETAILS');

3646: WHEN INVALID_DELIVERY_DETAIL THEN
3647: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3648: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In INVALID_DELIVERY_DETAIL exception');
3649: end if;
3650: FND_MESSAGE.SET_NAME('AHL', 'AHL_INVLD_DELIVERY_DETAILS');
3651: FND_MSG_PUB.ADD;
3652: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3653: p_data => x_msg_data,
3654: p_encoded => fnd_api.g_false);

Line 3661: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_CRT_BTCH_FAIL');

3657: WHEN CREATE_BATCH THEN
3658: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3659: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In create_batch exception');
3660: end if;
3661: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_CRT_BTCH_FAIL');
3662: FND_MSG_PUB.ADD;
3663: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3664: p_data => x_msg_data,
3665: p_encoded => fnd_api.g_false);

Line 3672: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_REL_BTCH_FAIL');

3668: WHEN RELEASE_BATCH THEN
3669: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3670: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In release_batch exception');
3671: end if;
3672: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_REL_BTCH_FAIL');
3673: fnd_msg_pub.add;
3674: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3675: P_DATA => X_MSG_DATA,
3676: p_encoded => fnd_api.g_false);

Line 3683: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_ALOC_FAIL');

3679: WHEN ALLOCATION_ERROR THEN
3680: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
3681: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In allocation_error exception');
3682: END IF;
3683: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_ALOC_FAIL');
3684: fnd_msg_pub.add;
3685: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3686: P_DATA => X_MSG_DATA,
3687: p_encoded => fnd_api.g_false);

Line 3928: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

3924: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3925: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
3926: WHERE SCHEDULED_MATERIAL_ID = P_AOG_TBL(I).SCHEDULE_MATERIAL_ID AND OBJECT_VERSION_NUMBER = P_AOG_TBL(I).ASM_OBJECT_VERSION_NUMBER;
3927: IF SQL%ROWCOUNT=0 THEN
3928: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
3929: FND_MSG_PUB.ADD;
3930: RAISE FND_API.G_EXC_ERROR;
3931: END IF;
3932: END IF;

Line 4140: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');

4136: IF (p_x_mtltfr_tbl IS NULL)
4137: THEN
4138: G_DEBUG_LINE_NUM := 17;
4139: x_return_status := FND_API.G_RET_STS_ERROR;
4140: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_ERROR;
4143: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4144: THEN

Line 4147: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');

4143: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4144: THEN
4145: G_DEBUG_LINE_NUM := 19;
4146: x_return_status := FND_API.G_RET_STS_ERROR;
4147: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4148: FND_MSG_PUB.ADD;
4149: RAISE FND_API.G_EXC_ERROR;
4150: END IF;
4151:

Line 4319: --FND_MESSAGE.Set_Name('AHL','AHL_MM_RES_MSG');

4315: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4316: IF (l_log_statement >= l_log_current_level) THEN
4317: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION completed successfully.');
4318: END IF;
4319: --FND_MESSAGE.Set_Name('AHL','AHL_MM_RES_MSG');
4320: --FND_MESSAGE.Set_Token('MSG','Material transfer is completed and reservation made');
4321: --FND_MSG_PUB.ADD;
4322: --FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Number of reservations = ' || l_reservation_id_tbl.COUNT);
4323: IF(l_reservation_id_tbl.COUNT > 0) THEN

Line 4320: --FND_MESSAGE.Set_Token('MSG','Material transfer is completed and reservation made');

4316: IF (l_log_statement >= l_log_current_level) THEN
4317: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION completed successfully.');
4318: END IF;
4319: --FND_MESSAGE.Set_Name('AHL','AHL_MM_RES_MSG');
4320: --FND_MESSAGE.Set_Token('MSG','Material transfer is completed and reservation made');
4321: --FND_MSG_PUB.ADD;
4322: --FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Number of reservations = ' || l_reservation_id_tbl.COUNT);
4323: IF(l_reservation_id_tbl.COUNT > 0) THEN
4324: FOR i IN l_reservation_id_tbl.FIRST..l_reservation_id_tbl.LAST LOOP

Line 4493: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');

4489: IF (p_x_mtltfr_tbl IS NULL)
4490: THEN
4491: G_DEBUG_LINE_NUM := 107;
4492: x_return_status := FND_API.G_RET_STS_ERROR;
4493: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4497: THEN

Line 4500: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');

4496: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4497: THEN
4498: G_DEBUG_LINE_NUM := 109;
4499: x_return_status := FND_API.G_RET_STS_ERROR;
4500: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4501: FND_MSG_PUB.ADD;
4502: RAISE FND_API.G_EXC_ERROR;
4503: END IF;
4504:

Line 4700: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');

4696: IF(Transaction_Error_Cur%FOUND AND (l_error_code IS NOT NULL OR trim(l_error_code) = '')) THEN
4697: IF (l_log_statement >= l_log_current_level) THEN
4698: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Error in transaction['||l_error_code||':'||l_error_msg||']');
4699: END IF;
4700: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
4701: FND_MESSAGE.Set_Token('MSG',l_error_msg);
4702: FND_MESSAGE.Set_Token('CODE',l_error_code);
4703: FND_MESSAGE.Set_Token('ITEM',l_item);
4704: FND_MESSAGE.Set_Token('SER',l_serial);

Line 4701: FND_MESSAGE.Set_Token('MSG',l_error_msg);

4697: IF (l_log_statement >= l_log_current_level) THEN
4698: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Error in transaction['||l_error_code||':'||l_error_msg||']');
4699: END IF;
4700: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
4701: FND_MESSAGE.Set_Token('MSG',l_error_msg);
4702: FND_MESSAGE.Set_Token('CODE',l_error_code);
4703: FND_MESSAGE.Set_Token('ITEM',l_item);
4704: FND_MESSAGE.Set_Token('SER',l_serial);
4705: FND_MSG_PUB.ADD;

Line 4702: FND_MESSAGE.Set_Token('CODE',l_error_code);

4698: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Error in transaction['||l_error_code||':'||l_error_msg||']');
4699: END IF;
4700: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
4701: FND_MESSAGE.Set_Token('MSG',l_error_msg);
4702: FND_MESSAGE.Set_Token('CODE',l_error_code);
4703: FND_MESSAGE.Set_Token('ITEM',l_item);
4704: FND_MESSAGE.Set_Token('SER',l_serial);
4705: FND_MSG_PUB.ADD;
4706: l_error := true;

Line 4703: FND_MESSAGE.Set_Token('ITEM',l_item);

4699: END IF;
4700: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
4701: FND_MESSAGE.Set_Token('MSG',l_error_msg);
4702: FND_MESSAGE.Set_Token('CODE',l_error_code);
4703: FND_MESSAGE.Set_Token('ITEM',l_item);
4704: FND_MESSAGE.Set_Token('SER',l_serial);
4705: FND_MSG_PUB.ADD;
4706: l_error := true;
4707: END IF;

Line 4704: FND_MESSAGE.Set_Token('SER',l_serial);

4700: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
4701: FND_MESSAGE.Set_Token('MSG',l_error_msg);
4702: FND_MESSAGE.Set_Token('CODE',l_error_code);
4703: FND_MESSAGE.Set_Token('ITEM',l_item);
4704: FND_MESSAGE.Set_Token('SER',l_serial);
4705: FND_MSG_PUB.ADD;
4706: l_error := true;
4707: END IF;
4708: CLOSE Transaction_Error_Cur;

Line 5129: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');

5125: IF (l_log_exception >= l_log_current_level) THEN
5126: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':Exception in Insert_Material');
5127: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM -'||SQLERRM);
5128: END IF;
5129: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
5130: FND_MESSAGE.Set_Token('MSG',SQLERRM);
5131: FND_MESSAGE.Set_Token('ITEM',p_x_mtltfr_rec.inventory_item_id);
5132: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5133: FND_MSG_PUB.ADD;

Line 5130: FND_MESSAGE.Set_Token('MSG',SQLERRM);

5126: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':Exception in Insert_Material');
5127: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM -'||SQLERRM);
5128: END IF;
5129: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
5130: FND_MESSAGE.Set_Token('MSG',SQLERRM);
5131: FND_MESSAGE.Set_Token('ITEM',p_x_mtltfr_rec.inventory_item_id);
5132: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5133: FND_MSG_PUB.ADD;
5134: RAISE FND_API.G_EXC_ERROR;

Line 5131: FND_MESSAGE.Set_Token('ITEM',p_x_mtltfr_rec.inventory_item_id);

5127: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM -'||SQLERRM);
5128: END IF;
5129: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
5130: FND_MESSAGE.Set_Token('MSG',SQLERRM);
5131: FND_MESSAGE.Set_Token('ITEM',p_x_mtltfr_rec.inventory_item_id);
5132: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5133: FND_MSG_PUB.ADD;
5134: RAISE FND_API.G_EXC_ERROR;
5135: END Insert_Material;

Line 5132: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);

5128: END IF;
5129: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTLTFR_ERROR');
5130: FND_MESSAGE.Set_Token('MSG',SQLERRM);
5131: FND_MESSAGE.Set_Token('ITEM',p_x_mtltfr_rec.inventory_item_id);
5132: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5133: FND_MSG_PUB.ADD;
5134: RAISE FND_API.G_EXC_ERROR;
5135: END Insert_Material;
5136: ------------------------------------------------------------------------------------------------------------

Line 5277: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');

5273: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Validating quantity '||p_x_mtltfr_rec.quantity);
5274: END IF;
5275: -- Quantity validation
5276: IF(NVL(p_x_mtltfr_rec.quantity,0) <= 0) THEN
5277: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');
5278: FND_MESSAGE.Set_Token('QUANTITY',p_x_mtltfr_rec.quantity);
5279: FND_MSG_PUB.ADD;
5280: x_return_status := FND_API.G_RET_STS_ERROR;
5281: END IF;

Line 5278: FND_MESSAGE.Set_Token('QUANTITY',p_x_mtltfr_rec.quantity);

5274: END IF;
5275: -- Quantity validation
5276: IF(NVL(p_x_mtltfr_rec.quantity,0) <= 0) THEN
5277: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');
5278: FND_MESSAGE.Set_Token('QUANTITY',p_x_mtltfr_rec.quantity);
5279: FND_MSG_PUB.ADD;
5280: x_return_status := FND_API.G_RET_STS_ERROR;
5281: END IF;
5282: G_DEBUG_LINE_NUM := 320;

Line 5302: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');

5298: IF(ITEM_VALID_CUR_DEST%NOTFOUND) THEN
5299: IF (l_log_statement >= l_log_current_level) THEN
5300: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item/Destination Org combination is invalid');
5301: END IF;
5302: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
5303: FND_MESSAGE.Set_Token('FIELD',NVL(l_concatenated_segments, p_x_mtltfr_rec.Inventory_Item_Id));
5304: FND_MSG_PUB.ADD;
5305: x_return_status := FND_API.G_RET_STS_ERROR;
5306: END IF;

Line 5303: FND_MESSAGE.Set_Token('FIELD',NVL(l_concatenated_segments, p_x_mtltfr_rec.Inventory_Item_Id));

5299: IF (l_log_statement >= l_log_current_level) THEN
5300: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item/Destination Org combination is invalid');
5301: END IF;
5302: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
5303: FND_MESSAGE.Set_Token('FIELD',NVL(l_concatenated_segments, p_x_mtltfr_rec.Inventory_Item_Id));
5304: FND_MSG_PUB.ADD;
5305: x_return_status := FND_API.G_RET_STS_ERROR;
5306: END IF;
5307: CLOSE ITEM_VALID_CUR_DEST;

Line 5317: FND_MESSAGE.Set_Name('AHL','AHL_MM_SOURCE_ORG_NULL');

5313: IF p_x_mtltfr_rec.source_org_id IS NULL THEN
5314: IF (l_log_statement >= l_log_current_level) THEN
5315: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Source Org is null');
5316: END IF;
5317: FND_MESSAGE.Set_Name('AHL','AHL_MM_SOURCE_ORG_NULL');
5318: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);
5319: FND_MSG_PUB.ADD;
5320: x_return_status := FND_API.G_RET_STS_ERROR;
5321: END IF;

Line 5318: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);

5314: IF (l_log_statement >= l_log_current_level) THEN
5315: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Source Org is null');
5316: END IF;
5317: FND_MESSAGE.Set_Name('AHL','AHL_MM_SOURCE_ORG_NULL');
5318: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);
5319: FND_MSG_PUB.ADD;
5320: x_return_status := FND_API.G_RET_STS_ERROR;
5321: END IF;
5322: IF p_x_mtltfr_rec.dest_org_id IS NULL THEN

Line 5327: FND_MESSAGE.Set_Name('AHL','AHL_MM_DEST_ORG_NULL');

5323: G_DEBUG_LINE_NUM := 350;
5324: IF (l_log_statement >= l_log_current_level) THEN
5325: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Destination Org is null');
5326: END IF;
5327: FND_MESSAGE.Set_Name('AHL','AHL_MM_DEST_ORG_NULL');
5328: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);
5329: FND_MSG_PUB.ADD;
5330: x_return_status := FND_API.G_RET_STS_ERROR;
5331: END IF;

Line 5328: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);

5324: IF (l_log_statement >= l_log_current_level) THEN
5325: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Destination Org is null');
5326: END IF;
5327: FND_MESSAGE.Set_Name('AHL','AHL_MM_DEST_ORG_NULL');
5328: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);
5329: FND_MSG_PUB.ADD;
5330: x_return_status := FND_API.G_RET_STS_ERROR;
5331: END IF;
5332: END IF;

Line 5342: FND_MESSAGE.Set_Name('AHL','AHL_CMP_ITEM_NULL');

5338: G_DEBUG_LINE_NUM := 360;
5339: IF (l_log_statement >= l_log_current_level) THEN
5340: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is null');
5341: END IF;
5342: FND_MESSAGE.Set_Name('AHL','AHL_CMP_ITEM_NULL');
5343: FND_MSG_PUB.ADD;
5344: x_return_status := FND_API.G_RET_STS_ERROR;
5345: END IF;
5346:

Line 5357: FND_MESSAGE.Set_Name('AHL','AHL_MM_SERIAL_NULL');

5353: G_DEBUG_LINE_NUM := 380;
5354: IF (l_log_statement >= l_log_current_level) THEN
5355: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item serial is NULL. Can not be transfered');
5356: END IF;
5357: FND_MESSAGE.Set_Name('AHL','AHL_MM_SERIAL_NULL');
5358: FND_MSG_PUB.ADD;
5359: x_return_status := FND_API.G_RET_STS_ERROR;
5360: ELSE
5361: IF (p_x_mtltfr_rec.Serial_Number IS NOT NULL AND l_serial_Control_dest = 1) THEN

Line 5366: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');

5362: G_DEBUG_LINE_NUM := 390;
5363: IF (l_log_statement >= l_log_current_level) THEN
5364: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is not serialized in destination org. Can not be transfered');
5365: END IF;
5366: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
5367: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5368: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
5369: FND_MSG_PUB.ADD;
5370: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5367: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);

5363: IF (l_log_statement >= l_log_current_level) THEN
5364: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is not serialized in destination org. Can not be transfered');
5365: END IF;
5366: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
5367: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5368: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
5369: FND_MSG_PUB.ADD;
5370: x_return_status := FND_API.G_RET_STS_ERROR;
5371: END IF;

Line 5368: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);

5364: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is not serialized in destination org. Can not be transfered');
5365: END IF;
5366: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
5367: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5368: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
5369: FND_MSG_PUB.ADD;
5370: x_return_status := FND_API.G_RET_STS_ERROR;
5371: END IF;
5372: END IF;

Line 5382: FND_MESSAGE.Set_Name('AHL','AHL_MM_LOT_BASED_ITEM');

5378: G_DEBUG_LINE_NUM := 400;
5379: IF (l_log_statement >= l_log_current_level) THEN
5380: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is lot controlled in destination org. Can not be transfered');
5381: END IF;
5382: FND_MESSAGE.Set_Name('AHL','AHL_MM_LOT_BASED_ITEM');
5383: FND_MSG_PUB.ADD;
5384: x_return_status := FND_API.G_RET_STS_ERROR;
5385: END IF;
5386: -- Visit Locator validation

Line 5395: FND_MESSAGE.Set_Name('AHL','AHL_MM_NULL_VISIT_LOCATOR');

5391: IF (p_x_mtltfr_rec.dest_locator_id IS NULL) THEN
5392: IF (l_log_statement >= l_log_current_level) THEN
5393: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Visit locator is null');
5394: END IF;
5395: FND_MESSAGE.Set_Name('AHL','AHL_MM_NULL_VISIT_LOCATOR');
5396: FND_MSG_PUB.ADD;
5397: x_return_status := FND_API.G_RET_STS_ERROR;
5398: ELSE
5399: --Locator Validation for destination

Line 5406: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');

5402: IF (LOCATOR_VALID_CUR%NOTFOUND) THEN
5403: IF (l_log_statement >= l_log_current_level) THEN
5404: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Invalid destination locator');
5405: END IF;
5406: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5407: FND_MESSAGE.Set_Token('ORG',NVL(l_dest_organization_name, p_x_mtltfr_rec.dest_org_id));
5408: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5409: FND_MSG_PUB.ADD;
5410: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5407: FND_MESSAGE.Set_Token('ORG',NVL(l_dest_organization_name, p_x_mtltfr_rec.dest_org_id));

5403: IF (l_log_statement >= l_log_current_level) THEN
5404: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Invalid destination locator');
5405: END IF;
5406: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5407: FND_MESSAGE.Set_Token('ORG',NVL(l_dest_organization_name, p_x_mtltfr_rec.dest_org_id));
5408: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5409: FND_MSG_PUB.ADD;
5410: x_return_status := FND_API.G_RET_STS_ERROR;
5411: END IF;

Line 5408: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);

5404: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Invalid destination locator');
5405: END IF;
5406: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5407: FND_MESSAGE.Set_Token('ORG',NVL(l_dest_organization_name, p_x_mtltfr_rec.dest_org_id));
5408: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5409: FND_MSG_PUB.ADD;
5410: x_return_status := FND_API.G_RET_STS_ERROR;
5411: END IF;
5412: CLOSE LOCATOR_VALID_CUR;

Line 5421: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');

5417: IF (LOCATOR_VALID_CUR%NOTFOUND) THEN
5418: IF (l_log_statement >= l_log_current_level) THEN
5419: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Invalid source locator');
5420: END IF;
5421: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5422: FND_MESSAGE.Set_Token('ORG',NVL(l_src_organization_name,p_x_mtltfr_rec.source_org_id));
5423: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5424: FND_MSG_PUB.ADD;
5425: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5422: FND_MESSAGE.Set_Token('ORG',NVL(l_src_organization_name,p_x_mtltfr_rec.source_org_id));

5418: IF (l_log_statement >= l_log_current_level) THEN
5419: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Invalid source locator');
5420: END IF;
5421: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5422: FND_MESSAGE.Set_Token('ORG',NVL(l_src_organization_name,p_x_mtltfr_rec.source_org_id));
5423: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5424: FND_MSG_PUB.ADD;
5425: x_return_status := FND_API.G_RET_STS_ERROR;
5426: END IF;

Line 5423: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);

5419: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Invalid source locator');
5420: END IF;
5421: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5422: FND_MESSAGE.Set_Token('ORG',NVL(l_src_organization_name,p_x_mtltfr_rec.source_org_id));
5423: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5424: FND_MSG_PUB.ADD;
5425: x_return_status := FND_API.G_RET_STS_ERROR;
5426: END IF;
5427: CLOSE LOCATOR_VALID_CUR;

Line 5439: FND_MESSAGE.Set_Name('AHL','AHL_MM_EXIST_RES');

5435: IF (RESERVATION_VALID_CUR%FOUND) THEN
5436: IF (l_log_statement >= l_log_current_level) THEN
5437: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Reservation already exists on the serial');
5438: END IF;
5439: FND_MESSAGE.Set_Name('AHL','AHL_MM_EXIST_RES');
5440: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.serial_number);
5441: FND_MSG_PUB.ADD;
5442: x_return_status := FND_API.G_RET_STS_ERROR;
5443: END IF;

Line 5440: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.serial_number);

5436: IF (l_log_statement >= l_log_current_level) THEN
5437: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Reservation already exists on the serial');
5438: END IF;
5439: FND_MESSAGE.Set_Name('AHL','AHL_MM_EXIST_RES');
5440: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.serial_number);
5441: FND_MSG_PUB.ADD;
5442: x_return_status := FND_API.G_RET_STS_ERROR;
5443: END IF;
5444: CLOSE RESERVATION_VALID_CUR;

Line 5456: FND_MESSAGE.Set_Name('AHL','AHL_MM_NO_SHIP_NETWORK');

5452: IF (SHIPPING_NETWORK_CUR%NOTFOUND) THEN
5453: IF (l_log_statement >= l_log_current_level) THEN
5454: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'No shipping network between the organizations');
5455: END IF;
5456: FND_MESSAGE.Set_Name('AHL','AHL_MM_NO_SHIP_NETWORK');
5457: FND_MSG_PUB.ADD;
5458: x_return_status := FND_API.G_RET_STS_ERROR;
5459: END IF;
5460: CLOSE SHIPPING_NETWORK_CUR;

Line 5469: FND_MESSAGE.Set_Name('AHL','AHL_MM_INTERNAL_ORD_REQD');

5465: IF (SHIPPING_ATTRIB_CUR%FOUND) THEN
5466: IF (l_log_statement >= l_log_current_level) THEN
5467: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Internal Order required to transfer between the organizations');
5468: END IF;
5469: FND_MESSAGE.Set_Name('AHL','AHL_MM_INTERNAL_ORD_REQD');
5470: FND_MSG_PUB.ADD;
5471: x_return_status := FND_API.G_RET_STS_ERROR;
5472: END IF;
5473: CLOSE SHIPPING_ATTRIB_CUR;

Line 5823: --This API populates FND message stack in case of errors

5819: RETURN;
5820: END IF;
5821: ELSE
5822: --Only Primary item filter, validate through AHL_SB_RULES_PVT.Evaluate_Rules_For_Pos
5823: --This API populates FND message stack in case of errors
5824: AHL_SB_RULES_PVT.Evaluate_Rules_For_Pos(
5825: p_mc_header_id => l_mc_header_id,
5826: p_mc_pos_key => l_pos_key,
5827: p_inv_item_id => l_inventory_item_id,

Line 6332: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );

6328: FROM dual;
6329: OPEN Instance_Id_Cur;
6330: FETCH Instance_Id_Cur INTO l_instance_id;
6331: IF instance_id_cur%notfound THEN
6332: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
6333: FND_MSG_PUB.add;
6334: CLOSE Instance_Id_Cur;
6335: RAISE FND_API.G_EXC_ERROR;
6336: END IF;

Line 6358: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');

6354: MRP_ATP_PUB.CALL_ATP (L_SESSION_ID, L_ATP_TABLE, X_ATP_TABLE, X_ATP_SUPPLY_DEMAND, X_ATP_PERIOD, X_ATP_DETAILS, X_RETURN_STATUS, x_msg_data, X_MSG_COUNT);
6355: X_Inv_Mtl_Avl_Tbl(1).AVAILABLE_QUANTITY := X_ATP_TABLE.AVAILABLE_QUANTITY(1);
6356: X_Inv_Mtl_Avl_Tbl(1).ERROR_CODE := X_ATP_TABLE.ERROR_CODE(1);
6357: IF(X_ATP_TABLE.ERROR_CODE(1) <> 0) THEN
6358: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
6359: FND_MESSAGE.SET_TOKEN('ITEM_NAME', item_details.concatenated_segments);
6360: FOR mfg_err_msg IN mfg_err_msg_cur(X_ATP_TABLE.ERROR_CODE(1))
6361: LOOP
6362: l_error_msg := mfg_err_msg.Meaning;

Line 6359: FND_MESSAGE.SET_TOKEN('ITEM_NAME', item_details.concatenated_segments);

6355: X_Inv_Mtl_Avl_Tbl(1).AVAILABLE_QUANTITY := X_ATP_TABLE.AVAILABLE_QUANTITY(1);
6356: X_Inv_Mtl_Avl_Tbl(1).ERROR_CODE := X_ATP_TABLE.ERROR_CODE(1);
6357: IF(X_ATP_TABLE.ERROR_CODE(1) <> 0) THEN
6358: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');
6359: FND_MESSAGE.SET_TOKEN('ITEM_NAME', item_details.concatenated_segments);
6360: FOR mfg_err_msg IN mfg_err_msg_cur(X_ATP_TABLE.ERROR_CODE(1))
6361: LOOP
6362: l_error_msg := mfg_err_msg.Meaning;
6363: END LOOP;

Line 6364: FND_MESSAGE.SET_TOKEN('ATP_MSG', l_error_msg);

6360: FOR mfg_err_msg IN mfg_err_msg_cur(X_ATP_TABLE.ERROR_CODE(1))
6361: LOOP
6362: l_error_msg := mfg_err_msg.Meaning;
6363: END LOOP;
6364: FND_MESSAGE.SET_TOKEN('ATP_MSG', l_error_msg);
6365: X_Inv_Mtl_Avl_Tbl(1).ERROR_MESSAGE := FND_MESSAGE.GET();
6366: END IF;
6367: -- Standard call to get message count and if count is 1, get message info
6368: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

Line 6365: X_Inv_Mtl_Avl_Tbl(1).ERROR_MESSAGE := FND_MESSAGE.GET();

6361: LOOP
6362: l_error_msg := mfg_err_msg.Meaning;
6363: END LOOP;
6364: FND_MESSAGE.SET_TOKEN('ATP_MSG', l_error_msg);
6365: X_Inv_Mtl_Avl_Tbl(1).ERROR_MESSAGE := FND_MESSAGE.GET();
6366: END IF;
6367: -- Standard call to get message count and if count is 1, get message info
6368: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6369: -- Log API exit point