DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on GMD_SAMPLES_GRP

Line 457: IF GMD_SAMPLES_GRP.sampling_event_exist(

453:
454: END IF; -- IF l_qc_samples_rec.source IN ('I','C','W','S') THEN
455:
456: -- find sampling event with matching spec vr id.
457: IF GMD_SAMPLES_GRP.sampling_event_exist(
458: p_sample => l_qc_samples_rec,
459: x_sampling_event_id => l_sampling_events.sampling_event_id,
460: p_spec_vr_id => l_spec_vr_id
461: ) THEN

Line 472: IF NOT GMD_SAMPLES_GRP.sampling_event_exist_wo_spec

468:
469: --dbms_output.put_line('b4 sampling_event_exist_wo_spec');
470:
471: -- Try and find a sampling event without a spec
472: IF NOT GMD_SAMPLES_GRP.sampling_event_exist_wo_spec
473: ( p_sample => l_qc_samples_rec,
474: x_sampling_event_id => l_sampling_events.sampling_event_id
475: ) THEN
476:

Line 821: GMD_SAMPLES_GRP.create_inv_txn

817: RAISE FND_API.G_EXC_ERROR;
818: END IF; -- end bug
819:
820:
821: GMD_SAMPLES_GRP.create_inv_txn
822: ( p_sample => l_qc_samples_out_rec,
823: p_user_name => l_user_id,
824: x_return_status => l_return_status,
825: x_message_count => l_msg_count,

Line 877: GMD_SAMPLES_GRP.create_wip_txn

873: CLOSE Cur_batch_status;
874:
875: IF l_batch_status <> 4 then
876:
877: GMD_SAMPLES_GRP.create_wip_txn
878: ( p_sample => l_qc_samples_out_rec,
879: x_return_status => l_return_status,
880: x_message_count => l_msg_count,
881: x_message_data => l_msg_data

Line 889: GMD_SAMPLES_GRP.post_wip_txn

885: RAISE FND_API.G_EXC_ERROR;
886: END IF;
887:
888:
889: GMD_SAMPLES_GRP.post_wip_txn
890: ( p_batch_id => l_qc_samples_out_rec.batch_id,
891: x_return_status => l_return_status
892: );
893:

Line 903: GMD_SAMPLES_GRP.create_inv_txn

899: -- added create_inv_txn to decrease the inventory which was increased by create_wip_txn/post_wip_txn
900:
901: --dbms_output.put_line('create inv trans after wip');
902:
903: GMD_SAMPLES_GRP.create_inv_txn
904: ( p_sample => l_qc_samples_out_rec,
905: p_user_name => p_user_name,
906: x_return_status => l_return_status,
907: x_message_count => l_msg_count,

Line 1497: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;

1493: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
1494: l_sample_rec GMD_SAMPLES%ROWTYPE;
1495: l_return_status VARCHAR2(1);
1496:
1497: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;
1498:
1499: BEGIN
1500:
1501: -- Assign API local Variables;

Line 1526: gmd_samples_grp.get_item_values(p_sample_display => l_sample_display);

1522:
1523: l_sample_display.organization_id := p_sample_rec.organization_id;
1524: l_sample_display.inventory_item_id := p_sample_rec.inventory_item_id;
1525:
1526: gmd_samples_grp.get_item_values(p_sample_display => l_sample_display);
1527:
1528: -- test for whether an item was found
1529: IF l_sample_display.item_number IS NULL THEN
1530: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_NOT_FOUND');

Line 3218: --dbms_output.put_line('b4 GMD_SAMPLES_GRP.validate_sample');

3214:
3215: -- Now Call Group Layer Validate Samples API
3216: -- To perform business logic validation.
3217:
3218: --dbms_output.put_line('b4 GMD_SAMPLES_GRP.validate_sample');
3219:
3220:
3221: GMD_SAMPLES_GRP.validate_sample(
3222: p_sample => l_sample_rec,

Line 3221: GMD_SAMPLES_GRP.validate_sample(

3217:
3218: --dbms_output.put_line('b4 GMD_SAMPLES_GRP.validate_sample');
3219:
3220:
3221: GMD_SAMPLES_GRP.validate_sample(
3222: p_sample => l_sample_rec,
3223: p_called_from => 'PUBLIC',
3224: p_operation => 'INSERT',
3225: x_return_status => l_return_status

Line 3228: --dbms_output.put_line('after GMD_SAMPLES_GRP.validate_sample');

3224: p_operation => 'INSERT',
3225: x_return_status => l_return_status
3226: );
3227:
3228: --dbms_output.put_line('after GMD_SAMPLES_GRP.validate_sample');
3229:
3230:
3231: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3232: -- Message is alrady logged by check_for_null procedure