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_COA_DATA_OM_NEW dependencies on GMD_SPEC_MATCH_GRP

Line 1201: PrintLn('GMD_REQ_FIELD_MIS , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');

1197: PrintLn('End Procedure get_result_match_for_spec');
1198:
1199: EXCEPTION
1200: WHEN REQ_FIELDS_MISSING THEN
1201: PrintLn('GMD_REQ_FIELD_MIS , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1202: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1203: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1204: x_return_status := FND_API.G_RET_STS_ERROR ;
1205: WHEN INVALID_LOT THEN

Line 1202: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');

1198:
1199: EXCEPTION
1200: WHEN REQ_FIELDS_MISSING THEN
1201: PrintLn('GMD_REQ_FIELD_MIS , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1202: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1203: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1204: x_return_status := FND_API.G_RET_STS_ERROR ;
1205: WHEN INVALID_LOT THEN
1206: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);

Line 1211: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);

1207: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1208: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1209: x_return_status := FND_API.G_RET_STS_ERROR ;
1210: WHEN OTHERS THEN
1211: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1212: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1213: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1215: END get_result_match_for_spec ;

Line 1212: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1208: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1209: x_return_status := FND_API.G_RET_STS_ERROR ;
1210: WHEN OTHERS THEN
1211: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1212: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1213: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1215: END get_result_match_for_spec ;
1216:

Line 1286: p_customer_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;

1282: WHERE inventory_item_id = p_hdr_rec.inventory_item_id
1283: and lot_number = p_hdr_rec.lot_number
1284: and organization_id = p_hdr_rec.organization_id;
1285:
1286: p_customer_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;
1287: p_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;
1288: x_return_flag BOOLEAN;
1289: x_spec_id NUMBER;
1290: x_spec_vr_id NUMBER;

Line 1287: p_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;

1283: and lot_number = p_hdr_rec.lot_number
1284: and organization_id = p_hdr_rec.organization_id;
1285:
1286: p_customer_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;
1287: p_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;
1288: x_return_flag BOOLEAN;
1289: x_spec_id NUMBER;
1290: x_spec_vr_id NUMBER;
1291: l_return_status VARCHAR2(1000);

Line 1333: PrintLn('Calling GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC');

1329: PrintLn('p_customer_spec_rec.organization_id = '||p_customer_spec_rec.organization_id); --INVCONV
1330: PrintLn('p_customer_spec_rec.look_in_other_orgn = '||p_customer_spec_rec.look_in_other_orgn);
1331: PrintLn('p_customer_spec_rec.ship_to_site_id = '||p_customer_spec_rec.ship_to_site_id); --Bug 4166529 added.
1332:
1333: PrintLn('Calling GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC');
1334: x_return_flag := FALSE;
1335: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC(p_customer_spec_rec,
1336: x_spec_id,
1337: x_spec_vr_id,

Line 1335: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC(p_customer_spec_rec,

1331: PrintLn('p_customer_spec_rec.ship_to_site_id = '||p_customer_spec_rec.ship_to_site_id); --Bug 4166529 added.
1332:
1333: PrintLn('Calling GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC');
1334: x_return_flag := FALSE;
1335: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC(p_customer_spec_rec,
1336: x_spec_id,
1337: x_spec_vr_id,
1338: l_return_status,
1339: x_message_data);

Line 1342: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , Spec_id '||x_spec_id);

1338: l_return_status,
1339: x_message_data);
1340: IF x_return_flag THEN -- cust spec found
1341: PrintLn('CUSTOMER SPEC FOUND');
1342: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , Spec_id '||x_spec_id);
1343: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_spec_vr_id '||x_spec_vr_id);
1344: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , l_return_status '||l_return_status);
1345: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_message_data '||x_message_data);
1346: END IF;

Line 1343: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_spec_vr_id '||x_spec_vr_id);

1339: x_message_data);
1340: IF x_return_flag THEN -- cust spec found
1341: PrintLn('CUSTOMER SPEC FOUND');
1342: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , Spec_id '||x_spec_id);
1343: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_spec_vr_id '||x_spec_vr_id);
1344: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , l_return_status '||l_return_status);
1345: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_message_data '||x_message_data);
1346: END IF;
1347:

Line 1344: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , l_return_status '||l_return_status);

1340: IF x_return_flag THEN -- cust spec found
1341: PrintLn('CUSTOMER SPEC FOUND');
1342: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , Spec_id '||x_spec_id);
1343: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_spec_vr_id '||x_spec_vr_id);
1344: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , l_return_status '||l_return_status);
1345: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_message_data '||x_message_data);
1346: END IF;
1347:
1348: IF (x_return_flag = FALSE) THEN

Line 1345: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_message_data '||x_message_data);

1341: PrintLn('CUSTOMER SPEC FOUND');
1342: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , Spec_id '||x_spec_id);
1343: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_spec_vr_id '||x_spec_vr_id);
1344: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , l_return_status '||l_return_status);
1345: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , x_message_data '||x_message_data);
1346: END IF;
1347:
1348: IF (x_return_flag = FALSE) THEN
1349: PrintLn('CUSTOMER SPEC NOT FOUND');

Line 1369: PrintLn('Calling GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC');

1365: PrintLn('p_inventory_spec_rec.subinventory = '||p_inventory_spec_rec.subinventory); --INVCONV
1366: PrintLn('p_inventory_spec_rec.locator_id = '||p_inventory_spec_rec.locator_id); --INVCONV
1367: PrintLn('p_inventory_spec_rec.grade_code = '||p_inventory_spec_rec.grade_code); --INVCONV
1368: PrintLn('p_inventory_spec_rec.exact_match = '||p_inventory_spec_rec.exact_match); --INVCONV
1369: PrintLn('Calling GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC');
1370:
1371: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(p_inventory_spec_rec ,
1372: x_spec_id ,
1373: x_spec_vr_id,

Line 1371: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(p_inventory_spec_rec ,

1367: PrintLn('p_inventory_spec_rec.grade_code = '||p_inventory_spec_rec.grade_code); --INVCONV
1368: PrintLn('p_inventory_spec_rec.exact_match = '||p_inventory_spec_rec.exact_match); --INVCONV
1369: PrintLn('Calling GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC');
1370:
1371: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(p_inventory_spec_rec ,
1372: x_spec_id ,
1373: x_spec_vr_id,
1374: l_return_status,
1375: x_message_data);

Line 1378: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);

1374: l_return_status,
1375: x_message_data);
1376: IF x_return_flag THEN
1377: PrintLn('INVENTORY SPEC FOUND');
1378: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);
1379: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_spec_vr_id '||x_spec_vr_id);
1380: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);
1381: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);
1382: END IF;

Line 1379: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_spec_vr_id '||x_spec_vr_id);

1375: x_message_data);
1376: IF x_return_flag THEN
1377: PrintLn('INVENTORY SPEC FOUND');
1378: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);
1379: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_spec_vr_id '||x_spec_vr_id);
1380: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);
1381: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);
1382: END IF;
1383:

Line 1380: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);

1376: IF x_return_flag THEN
1377: PrintLn('INVENTORY SPEC FOUND');
1378: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);
1379: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_spec_vr_id '||x_spec_vr_id);
1380: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);
1381: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);
1382: END IF;
1383:
1384: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 1381: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);

1377: PrintLn('INVENTORY SPEC FOUND');
1378: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);
1379: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_spec_vr_id '||x_spec_vr_id);
1380: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);
1381: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);
1382: END IF;
1383:
1384: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1385: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);

Line 1385: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);

1381: PrintLn('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);
1382: END IF;
1383:
1384: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1385: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);
1386: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);
1387: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);
1388: log_msg('The parameters for inventory=>inventory_item_id, lot_number, subinventory '||
1389: p_inventory_spec_rec.inventory_item_id||' '||

Line 1386: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);

1382: END IF;
1383:
1384: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1385: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);
1386: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);
1387: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);
1388: log_msg('The parameters for inventory=>inventory_item_id, lot_number, subinventory '||
1389: p_inventory_spec_rec.inventory_item_id||' '||
1390: p_inventory_spec_rec.lot_number||' '||p_inventory_spec_rec.subinventory);

Line 1387: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);

1383:
1384: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1385: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);
1386: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , x_message_data '||x_message_data);
1387: log_msg('call_spec_match, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , l_return_status '||l_return_status);
1388: log_msg('The parameters for inventory=>inventory_item_id, lot_number, subinventory '||
1389: p_inventory_spec_rec.inventory_item_id||' '||
1390: p_inventory_spec_rec.lot_number||' '||p_inventory_spec_rec.subinventory);
1391: END IF;