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_CONVERT_FPO_PVT dependencies on GME_COMMON_PVT

Line 135: gme_common_pvt.log_message ('GME_NO_NULL_DATES');

131: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
132: END IF;
133: EXCEPTION
134: WHEN no_null_dates THEN
135: gme_common_pvt.log_message ('GME_NO_NULL_DATES');
136: x_return_status := fnd_api.g_ret_sts_error;
137: WHEN no_populate_both_dates THEN
138: gme_common_pvt.log_message ('GME_NO_POPULATE_BOTH_DATES');
139: x_return_status := fnd_api.g_ret_sts_error;

Line 138: gme_common_pvt.log_message ('GME_NO_POPULATE_BOTH_DATES');

134: WHEN no_null_dates THEN
135: gme_common_pvt.log_message ('GME_NO_NULL_DATES');
136: x_return_status := fnd_api.g_ret_sts_error;
137: WHEN no_populate_both_dates THEN
138: gme_common_pvt.log_message ('GME_NO_POPULATE_BOTH_DATES');
139: x_return_status := fnd_api.g_ret_sts_error;
140: WHEN invalid_batch_status THEN
141: gme_common_pvt.log_message ('GME_INV_FPO_STATUS');
142: x_return_status := fnd_api.g_ret_sts_error;

Line 141: gme_common_pvt.log_message ('GME_INV_FPO_STATUS');

137: WHEN no_populate_both_dates THEN
138: gme_common_pvt.log_message ('GME_NO_POPULATE_BOTH_DATES');
139: x_return_status := fnd_api.g_ret_sts_error;
140: WHEN invalid_batch_status THEN
141: gme_common_pvt.log_message ('GME_INV_FPO_STATUS');
142: x_return_status := fnd_api.g_ret_sts_error;
143: WHEN plan_qty_zero_err THEN
144: gme_common_pvt.log_message ('PM_GT_ZERO_ERR');
145: x_return_status := fnd_api.g_ret_sts_error;

Line 144: gme_common_pvt.log_message ('PM_GT_ZERO_ERR');

140: WHEN invalid_batch_status THEN
141: gme_common_pvt.log_message ('GME_INV_FPO_STATUS');
142: x_return_status := fnd_api.g_ret_sts_error;
143: WHEN plan_qty_zero_err THEN
144: gme_common_pvt.log_message ('PM_GT_ZERO_ERR');
145: x_return_status := fnd_api.g_ret_sts_error;
146: WHEN invalid_item_item_um THEN
147: gme_common_pvt.log_message ('GME_INVALID_ITEM_OR_ITEM_UM');
148: x_return_status := fnd_api.g_ret_sts_error;

Line 147: gme_common_pvt.log_message ('GME_INVALID_ITEM_OR_ITEM_UM');

143: WHEN plan_qty_zero_err THEN
144: gme_common_pvt.log_message ('PM_GT_ZERO_ERR');
145: x_return_status := fnd_api.g_ret_sts_error;
146: WHEN invalid_item_item_um THEN
147: gme_common_pvt.log_message ('GME_INVALID_ITEM_OR_ITEM_UM');
148: x_return_status := fnd_api.g_ret_sts_error;
149: WHEN no_batches THEN
150: gme_common_pvt.log_message ('PM_INV_NO_BATCHES');
151: x_return_status := fnd_api.g_ret_sts_error;

Line 150: gme_common_pvt.log_message ('PM_INV_NO_BATCHES');

146: WHEN invalid_item_item_um THEN
147: gme_common_pvt.log_message ('GME_INVALID_ITEM_OR_ITEM_UM');
148: x_return_status := fnd_api.g_ret_sts_error;
149: WHEN no_batches THEN
150: gme_common_pvt.log_message ('PM_INV_NO_BATCHES');
151: x_return_status := fnd_api.g_ret_sts_error;
152: WHEN neg_validity_rule_id THEN
153: gme_common_pvt.log_message ('GME_NO_NEG_VALIDITY_RULE_ID');
154: x_return_status := fnd_api.g_ret_sts_error;

Line 153: gme_common_pvt.log_message ('GME_NO_NEG_VALIDITY_RULE_ID');

149: WHEN no_batches THEN
150: gme_common_pvt.log_message ('PM_INV_NO_BATCHES');
151: x_return_status := fnd_api.g_ret_sts_error;
152: WHEN neg_validity_rule_id THEN
153: gme_common_pvt.log_message ('GME_NO_NEG_VALIDITY_RULE_ID');
154: x_return_status := fnd_api.g_ret_sts_error;
155: WHEN leadtime_err THEN
156: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
157: x_return_status := fnd_api.g_ret_sts_error;

Line 156: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');

152: WHEN neg_validity_rule_id THEN
153: gme_common_pvt.log_message ('GME_NO_NEG_VALIDITY_RULE_ID');
154: x_return_status := fnd_api.g_ret_sts_error;
155: WHEN leadtime_err THEN
156: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
157: x_return_status := fnd_api.g_ret_sts_error;
158: WHEN batch_offset_err THEN
159: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
160: x_return_status := fnd_api.g_ret_sts_error;

Line 159: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');

155: WHEN leadtime_err THEN
156: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
157: x_return_status := fnd_api.g_ret_sts_error;
158: WHEN batch_offset_err THEN
159: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
160: x_return_status := fnd_api.g_ret_sts_error;
161: WHEN offset_type_err THEN
162: gme_common_pvt.log_message ('PM_OFFSET_TYPE_ERR');
163: x_return_status := fnd_api.g_ret_sts_error;

Line 162: gme_common_pvt.log_message ('PM_OFFSET_TYPE_ERR');

158: WHEN batch_offset_err THEN
159: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
160: x_return_status := fnd_api.g_ret_sts_error;
161: WHEN offset_type_err THEN
162: gme_common_pvt.log_message ('PM_OFFSET_TYPE_ERR');
163: x_return_status := fnd_api.g_ret_sts_error;
164: WHEN OTHERS THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
166: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'validation');

Line 405: gme_common_pvt.log_message ('PM_NO_MATL_DTL');

401: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
402: gme_debug.put_line ('no fetch material_details');
403: END IF;
404:
405: gme_common_pvt.log_message ('PM_NO_MATL_DTL');
406: x_return_status := fnd_api.g_ret_sts_error;
407: WHEN batch_fetch_error THEN
408: x_return_status := fnd_api.g_ret_sts_error;
409: WHEN OTHERS THEN

Line 790: gme_common_pvt.log_message ('GEN_PRE_BATCH_HEADER_ERR');

786: gme_debug.put_line
787: ('problem generateing the pre_batch-header recs');
788: END IF;
789:
790: gme_common_pvt.log_message ('GEN_PRE_BATCH_HEADER_ERR');
791: x_return_status := fnd_api.g_ret_sts_error;
792: WHEN OTHERS THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'

Line 802: ,p_recipe_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab

798: --****************************************************************
799: --****************************************************************
800: PROCEDURE convert_fpo_to_batch (
801: p_generated_pre_batch_tab IN generated_pre_batch_tab
802: ,p_recipe_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab
803: ,p_pregen_fpo_row IN pregen_fpo_row
804: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
805: ,x_return_status OUT NOCOPY VARCHAR2
806: ,x_arr_rtn_sts OUT NOCOPY return_array_sts

Line 810: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab

806: ,x_arr_rtn_sts OUT NOCOPY return_array_sts
807: ,p_process_row IN NUMBER DEFAULT 0
808: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
809: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
810: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
811: ,p_fpo_validity_rule_id IN NUMBER --BUG#3185748 Sastry
812: )
813: IS
814: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_TO_BATCH';

Line 819: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;

815: dummy NUMBER;
816: l_generated_pre_batch_tab generated_pre_batch_tab;
817: l_pre_batch_row gme_batch_header%ROWTYPE;
818: l_in_pre_batch_row gme_batch_header%ROWTYPE;
819: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
820: l_pregen_fpo_row pregen_fpo_row;
821: l_exception_material_tbl gme_common_pvt.exceptions_tab;
822: l_return_status VARCHAR2 (1);
823: l_api_version NUMBER;

Line 821: l_exception_material_tbl gme_common_pvt.exceptions_tab;

817: l_pre_batch_row gme_batch_header%ROWTYPE;
818: l_in_pre_batch_row gme_batch_header%ROWTYPE;
819: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
820: l_pregen_fpo_row pregen_fpo_row;
821: l_exception_material_tbl gme_common_pvt.exceptions_tab;
822: l_return_status VARCHAR2 (1);
823: l_api_version NUMBER;
824: l_validation_level NUMBER := 100;
825: l_batch_size gme_material_details.plan_qty%TYPE;

Line 859: l_validation_level := gme_common_pvt.g_max_errors;

855: || l_api_name);
856: END IF;
857: x_return_status := fnd_api.g_ret_sts_success;
858: dummy := 0;
859: l_validation_level := gme_common_pvt.g_max_errors;
860: l_api_version := 2.0;
861: l_generated_pre_batch_tab := p_generated_pre_batch_tab;
862: l_recipe_validity_rule_tab := p_recipe_validity_rule_tab;
863: l_pregen_fpo_row := p_pregen_fpo_row;

Line 891: gme_common_pvt.g_error_count := 0;

887: END IF;
888: FOR i IN 1 .. p_generated_pre_batch_tab.COUNT LOOP
889: -- Bug 3185748 Added Begin .. End
890: BEGIN
891: gme_common_pvt.g_error_count := 0;
892: l_generated_pre_batch_tab (i).recipe_validity_rule_id :=
893: l_recipe_validity_rule_tab (i).recipe_validity_rule_id;
894: -- Populate header row with values of generated_pre_batch_tab row.
895: l_pre_batch_row := l_generated_pre_batch_tab (i);

Line 916: gme_common_pvt.log_message

912:
913: FETCH Get_validity_rule INTO l_inventory_item_id, l_item_um; -- KYH GME CONV
914:
915: IF get_validity_rule%NOTFOUND THEN
916: gme_common_pvt.log_message
917: ('GME_VALIDITY_RULE_RETRIEVE_ERR');
918:
919: CLOSE get_validity_rule;
920:

Line 932: IF NOT gme_common_pvt.validate_validity_rule

928: '.' ||
929: l_api_name ||
930: ' Invoke validate validity rule ');
931: END IF;
932: IF NOT gme_common_pvt.validate_validity_rule
933: (p_validity_rule_id => l_in_pre_batch_row.recipe_validity_rule_id
934: ,p_organization_id => l_in_pre_batch_row.organization_id
935: ,p_prim_product_id => l_inventory_item_id
936: ,p_qty => l_batch_size

Line 1004: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN

1000: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1001: x_arr_rtn_sts (i).return_status := l_return_status;
1002:
1003: -- Pawan Kumar ADDED code for bug 2398719
1004: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN
1005: RAISE batch_creation_failure;
1006: ELSE
1007: FOR j IN 1 .. l_exception_material_tbl.COUNT LOOP
1008: x_exception_material_tbl (i) :=

Line 1082: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN

1078: END IF;
1079: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1080: x_arr_rtn_sts (p_process_row).return_status := l_return_status;
1081:
1082: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN
1083: RAISE batch_creation_failure;
1084: END IF;
1085: END IF;
1086:

Line 1149: l_over_allocations gme_common_pvt.exceptions_tab;

1145: l_fpo_header_row gme_batch_header%ROWTYPE;
1146: l_prim_prod_row gme_material_details%ROWTYPE;
1147: l_pregen_fpo_row pregen_fpo_row;
1148: l_fpo_material_details_tab fpo_material_details_tab;
1149: l_over_allocations gme_common_pvt.exceptions_tab;
1150: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
1151: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1152: l_batch_header gme_batch_header%ROWTYPE;
1153: x_batch_header gme_batch_header%ROWTYPE;

Line 1151: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;

1147: l_pregen_fpo_row pregen_fpo_row;
1148: l_fpo_material_details_tab fpo_material_details_tab;
1149: l_over_allocations gme_common_pvt.exceptions_tab;
1150: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
1151: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1152: l_batch_header gme_batch_header%ROWTYPE;
1153: x_batch_header gme_batch_header%ROWTYPE;
1154: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1155: l_resource_tab gme_common_pvt.resource_transactions_tab;

Line 1155: l_resource_tab gme_common_pvt.resource_transactions_tab;

1151: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1152: l_batch_header gme_batch_header%ROWTYPE;
1153: x_batch_header gme_batch_header%ROWTYPE;
1154: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1155: l_resource_tab gme_common_pvt.resource_transactions_tab;
1156: -- l_batch_type ic_tran_pnd.doc_type%TYPE;
1157: l_scale_factor NUMBER;
1158: l_primaries VARCHAR2 (8);
1159: l_batch_status gme_batch_header.batch_status%TYPE;

Line 1164: l_exception_material_tbl gme_common_pvt.exceptions_tab;

1160: l_mat_row_count NUMBER;
1161: l_rsc_row_count NUMBER;
1162: l_return_status VARCHAR2 (1);
1163: l_return BOOLEAN;
1164: l_exception_material_tbl gme_common_pvt.exceptions_tab;
1165:
1166:
1167: /*Exceptions */
1168: load_rsrc_trans_err EXCEPTION;

Line 1481: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab

1477: p_batch_header IN gme_batch_header%ROWTYPE
1478: ,p_batch_size IN NUMBER
1479: ,p_num_batches IN NUMBER
1480: ,p_validity_rule_id IN NUMBER
1481: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab
1482: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
1483: ,p_leadtime IN NUMBER
1484: ,p_batch_offset IN NUMBER
1485: ,p_offset_type IN NUMBER

Line 1519: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;

1515: l_in_pregen_fpo_row pregen_fpo_row;
1516: x_pregen_fpo_row pregen_fpo_row;
1517: l_generated_pre_batch_tab generated_pre_batch_tab;
1518: l_in_generated_pre_batch_tab generated_pre_batch_tab;
1519: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
1520: l_return_status VARCHAR2 (1);
1521: l_item_um VARCHAR2 (4);
1522: l_arr_rtn_sts return_array_sts;
1523: l_batch_range VARCHAR2 (2000);

Line 1524: l_exception_material_tbl gme_common_pvt.exceptions_tab;

1520: l_return_status VARCHAR2 (1);
1521: l_item_um VARCHAR2 (4);
1522: l_arr_rtn_sts return_array_sts;
1523: l_batch_range VARCHAR2 (2000);
1524: l_exception_material_tbl gme_common_pvt.exceptions_tab;
1525: /* Exception definitions */
1526: validation_failure EXCEPTION;
1527: fpo_retrieval_failure EXCEPTION;
1528: batch_generation_failure EXCEPTION;

Line 1578: gme_common_pvt.log_message ('GME_VALIDITY_RULE_RETRIEVE_ERR');

1574: FETCH get_validity_rule
1575: INTO l_inventory_item_id, l_item_um;
1576:
1577: IF get_validity_rule%NOTFOUND THEN
1578: gme_common_pvt.log_message ('GME_VALIDITY_RULE_RETRIEVE_ERR');
1579:
1580: CLOSE get_validity_rule;
1581:
1582: RAISE validation_failure;

Line 1836: gme_common_pvt.log_message ('GME_FPO_TO_BATCHES_CREATED'

1832: END IF;
1833:
1834: -- Bug 3185748 Display proper message
1835: IF p_num_batches = l_generated_pre_batch_tab.COUNT THEN
1836: gme_common_pvt.log_message ('GME_FPO_TO_BATCHES_CREATED'
1837: ,'BATCHRANGE'
1838: ,l_batch_range);
1839: ELSE
1840: gme_common_pvt.log_message ('GME_NOT_ALL_BATCHES_CREATED'

Line 1840: gme_common_pvt.log_message ('GME_NOT_ALL_BATCHES_CREATED'

1836: gme_common_pvt.log_message ('GME_FPO_TO_BATCHES_CREATED'
1837: ,'BATCHRANGE'
1838: ,l_batch_range);
1839: ELSE
1840: gme_common_pvt.log_message ('GME_NOT_ALL_BATCHES_CREATED'
1841: ,'BATCHRANGE'
1842: ,l_batch_range);
1843: END IF;
1844: END IF;

Line 1870: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');

1866:
1867: x_return_status := fnd_api.g_ret_sts_error;
1868: WHEN insufficient_validity_rules THEN
1869: x_return_status := fnd_api.g_ret_sts_error;
1870: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1871: WHEN create_batch_failure THEN
1872: x_return_status := fnd_api.g_ret_sts_error;
1873: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
1874: x_return_status := fnd_api.g_ret_sts_error;