DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on GMD_SAMPLES_GRP

Line 526: IF GMD_SAMPLES_GRP.sampling_event_exist(

522: -- find sampling event with matching spec vr id.
523: -- BUT do not call this if api call wants to create new sampling event - bug 16523872
524:
525: IF nvl(p_create_new_sample_group,'N') <> 'Y' THEN -- 16523872
526: IF GMD_SAMPLES_GRP.sampling_event_exist(
527: p_sample => l_qc_samples_rec,
528: x_sampling_event_id => l_sampling_events.sampling_event_id,
529: p_spec_vr_id => l_spec_vr_id
530: ) THEN

Line 543: IF NOT GMD_SAMPLES_GRP.sampling_event_exist_wo_spec

539: --dbms_output.put_line('b4 sampling_event_exist_wo_spec');
540:
541: -- Try and find a sampling event without a spec
542: IF nvl(p_create_new_sample_group,'N') <> 'Y' THEN -- 16523872
543: IF NOT GMD_SAMPLES_GRP.sampling_event_exist_wo_spec
544: ( p_sample => l_qc_samples_rec,
545: x_sampling_event_id => l_sampling_events.sampling_event_id
546: ) THEN
547:

Line 905: GMD_SAMPLES_GRP.create_inv_txn

901: RAISE FND_API.G_EXC_ERROR;
902: END IF; -- end bug
903:
904:
905: GMD_SAMPLES_GRP.create_inv_txn
906: ( p_sample => l_qc_samples_out_rec,
907: p_user_name => l_user_id,
908: x_return_status => l_return_status,
909: x_message_count => l_msg_count,

Line 961: GMD_SAMPLES_GRP.create_wip_txn

957: CLOSE Cur_batch_status;
958:
959: IF l_batch_status <> 4 then
960:
961: GMD_SAMPLES_GRP.create_wip_txn
962: ( p_sample => l_qc_samples_out_rec,
963: x_return_status => l_return_status,
964: x_message_count => l_msg_count,
965: x_message_data => l_msg_data

Line 973: GMD_SAMPLES_GRP.post_wip_txn

969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:
972:
973: GMD_SAMPLES_GRP.post_wip_txn
974: ( p_batch_id => l_qc_samples_out_rec.batch_id,
975: x_return_status => l_return_status
976: );
977:

Line 987: GMD_SAMPLES_GRP.create_inv_txn

983: -- added create_inv_txn to decrease the inventory which was increased by create_wip_txn/post_wip_txn
984:
985: --dbms_output.put_line('create inv trans after wip');
986:
987: GMD_SAMPLES_GRP.create_inv_txn
988: ( p_sample => l_qc_samples_out_rec,
989: p_user_name => p_user_name,
990: x_return_status => l_return_status,
991: x_message_count => l_msg_count,

Line 1581: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;

1577: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
1578: l_sample_rec GMD_SAMPLES%ROWTYPE;
1579: l_return_status VARCHAR2(1);
1580:
1581: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;
1582:
1583: BEGIN
1584:
1585: -- Assign API local Variables;

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

1606:
1607: l_sample_display.organization_id := p_sample_rec.organization_id;
1608: l_sample_display.inventory_item_id := p_sample_rec.inventory_item_id;
1609:
1610: gmd_samples_grp.get_item_values(p_sample_display => l_sample_display);
1611:
1612: -- test for whether an item was found
1613: IF l_sample_display.item_number IS NULL THEN
1614: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_NOT_FOUND');

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

3344:
3345: -- Now Call Group Layer Validate Samples API
3346: -- To perform business logic validation.
3347:
3348: --dbms_output.put_line('b4 GMD_SAMPLES_GRP.validate_sample');
3349:
3350:
3351: GMD_SAMPLES_GRP.validate_sample(
3352: p_sample => l_sample_rec,

Line 3351: GMD_SAMPLES_GRP.validate_sample(

3347:
3348: --dbms_output.put_line('b4 GMD_SAMPLES_GRP.validate_sample');
3349:
3350:
3351: GMD_SAMPLES_GRP.validate_sample(
3352: p_sample => l_sample_rec,
3353: p_called_from => 'PUBLIC',
3354: p_operation => 'INSERT',
3355: x_return_status => l_return_status

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

3354: p_operation => 'INSERT',
3355: x_return_status => l_return_status
3356: );
3357:
3358: --dbms_output.put_line('after GMD_SAMPLES_GRP.validate_sample');
3359:
3360:
3361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3362: -- Message is alrady logged by check_for_null procedure