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 391: gme_common_pvt.log_message ('PM_NO_MATL_DTL');

387: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
388: gme_debug.put_line ('no fetch material_details');
389: END IF;
390:
391: gme_common_pvt.log_message ('PM_NO_MATL_DTL');
392: x_return_status := fnd_api.g_ret_sts_error;
393: WHEN batch_fetch_error THEN
394: x_return_status := fnd_api.g_ret_sts_error;
395: WHEN OTHERS THEN

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

720: gme_debug.put_line
721: ('problem generateing the pre_batch-header recs');
722: END IF;
723:
724: gme_common_pvt.log_message ('GEN_PRE_BATCH_HEADER_ERR');
725: x_return_status := fnd_api.g_ret_sts_error;
726: WHEN OTHERS THEN
727: x_return_status := fnd_api.g_ret_sts_unexp_error;
728: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'

Line 736: ,p_recipe_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab

732: --****************************************************************
733: --****************************************************************
734: PROCEDURE convert_fpo_to_batch (
735: p_generated_pre_batch_tab IN generated_pre_batch_tab
736: ,p_recipe_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab
737: ,p_pregen_fpo_row IN pregen_fpo_row
738: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
739: ,x_return_status OUT NOCOPY VARCHAR2
740: ,x_arr_rtn_sts OUT NOCOPY return_array_sts

Line 744: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab

740: ,x_arr_rtn_sts OUT NOCOPY return_array_sts
741: ,p_process_row IN NUMBER DEFAULT 0
742: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
743: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
744: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
745: ,p_fpo_validity_rule_id IN NUMBER --BUG#3185748 Sastry
746: )
747: IS
748: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_TO_BATCH';

Line 753: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;

749: dummy NUMBER;
750: l_generated_pre_batch_tab generated_pre_batch_tab;
751: l_pre_batch_row gme_batch_header%ROWTYPE;
752: l_in_pre_batch_row gme_batch_header%ROWTYPE;
753: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
754: l_pregen_fpo_row pregen_fpo_row;
755: l_exception_material_tbl gme_common_pvt.exceptions_tab;
756: l_return_status VARCHAR2 (1);
757: l_api_version NUMBER;

Line 755: l_exception_material_tbl gme_common_pvt.exceptions_tab;

751: l_pre_batch_row gme_batch_header%ROWTYPE;
752: l_in_pre_batch_row gme_batch_header%ROWTYPE;
753: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
754: l_pregen_fpo_row pregen_fpo_row;
755: l_exception_material_tbl gme_common_pvt.exceptions_tab;
756: l_return_status VARCHAR2 (1);
757: l_api_version NUMBER;
758: l_validation_level NUMBER := 100;
759: l_batch_size gme_material_details.plan_qty%TYPE;

Line 793: l_validation_level := gme_common_pvt.g_max_errors;

789: || l_api_name);
790: END IF;
791: x_return_status := fnd_api.g_ret_sts_success;
792: dummy := 0;
793: l_validation_level := gme_common_pvt.g_max_errors;
794: l_api_version := 2.0;
795: l_generated_pre_batch_tab := p_generated_pre_batch_tab;
796: l_recipe_validity_rule_tab := p_recipe_validity_rule_tab;
797: l_pregen_fpo_row := p_pregen_fpo_row;

Line 825: gme_common_pvt.g_error_count := 0;

821: END IF;
822: FOR i IN 1 .. p_generated_pre_batch_tab.COUNT LOOP
823: -- Bug 3185748 Added Begin .. End
824: BEGIN
825: gme_common_pvt.g_error_count := 0;
826: l_generated_pre_batch_tab (i).recipe_validity_rule_id :=
827: l_recipe_validity_rule_tab (i).recipe_validity_rule_id;
828: -- Populate header row with values of generated_pre_batch_tab row.
829: l_pre_batch_row := l_generated_pre_batch_tab (i);

Line 850: gme_common_pvt.log_message

846:
847: FETCH Get_validity_rule INTO l_inventory_item_id, l_item_um; -- KYH GME CONV
848:
849: IF get_validity_rule%NOTFOUND THEN
850: gme_common_pvt.log_message
851: ('GME_VALIDITY_RULE_RETRIEVE_ERR');
852:
853: CLOSE get_validity_rule;
854:

Line 866: IF NOT gme_common_pvt.validate_validity_rule

862: '.' ||
863: l_api_name ||
864: ' Invoke validate validity rule ');
865: END IF;
866: IF NOT gme_common_pvt.validate_validity_rule
867: (p_validity_rule_id => l_in_pre_batch_row.recipe_validity_rule_id
868: ,p_organization_id => l_in_pre_batch_row.organization_id
869: ,p_prim_product_id => l_inventory_item_id
870: ,p_qty => l_batch_size

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

934: IF l_return_status <> fnd_api.g_ret_sts_success THEN
935: x_arr_rtn_sts (i).return_status := l_return_status;
936:
937: -- Pawan Kumar ADDED code for bug 2398719
938: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN
939: RAISE batch_creation_failure;
940: ELSE
941: FOR j IN 1 .. l_exception_material_tbl.COUNT LOOP
942: x_exception_material_tbl (i) :=

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

1012: END IF;
1013: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1014: x_arr_rtn_sts (p_process_row).return_status := l_return_status;
1015:
1016: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN
1017: RAISE batch_creation_failure;
1018: END IF;
1019: END IF;
1020:

Line 1083: l_over_allocations gme_common_pvt.exceptions_tab;

1079: l_fpo_header_row gme_batch_header%ROWTYPE;
1080: l_prim_prod_row gme_material_details%ROWTYPE;
1081: l_pregen_fpo_row pregen_fpo_row;
1082: l_fpo_material_details_tab fpo_material_details_tab;
1083: l_over_allocations gme_common_pvt.exceptions_tab;
1084: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
1085: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1086: l_batch_header gme_batch_header%ROWTYPE;
1087: x_batch_header gme_batch_header%ROWTYPE;

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

1081: l_pregen_fpo_row pregen_fpo_row;
1082: l_fpo_material_details_tab fpo_material_details_tab;
1083: l_over_allocations gme_common_pvt.exceptions_tab;
1084: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
1085: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1086: l_batch_header gme_batch_header%ROWTYPE;
1087: x_batch_header gme_batch_header%ROWTYPE;
1088: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1089: l_resource_tab gme_common_pvt.resource_transactions_tab;

Line 1089: l_resource_tab gme_common_pvt.resource_transactions_tab;

1085: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1086: l_batch_header gme_batch_header%ROWTYPE;
1087: x_batch_header gme_batch_header%ROWTYPE;
1088: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1089: l_resource_tab gme_common_pvt.resource_transactions_tab;
1090: -- l_batch_type ic_tran_pnd.doc_type%TYPE;
1091: l_scale_factor NUMBER;
1092: l_primaries VARCHAR2 (8);
1093: l_batch_status gme_batch_header.batch_status%TYPE;

Line 1098: l_exception_material_tbl gme_common_pvt.exceptions_tab;

1094: l_mat_row_count NUMBER;
1095: l_rsc_row_count NUMBER;
1096: l_return_status VARCHAR2 (1);
1097: l_return BOOLEAN;
1098: l_exception_material_tbl gme_common_pvt.exceptions_tab;
1099: /*Exceptions */
1100: load_rsrc_trans_err EXCEPTION;
1101: gme_fetch_all_trans_err EXCEPTION;
1102: update_row_err EXCEPTION;

Line 1378: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab

1374: p_batch_header IN gme_batch_header%ROWTYPE
1375: ,p_batch_size IN NUMBER
1376: ,p_num_batches IN NUMBER
1377: ,p_validity_rule_id IN NUMBER
1378: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab
1379: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
1380: ,p_leadtime IN NUMBER
1381: ,p_batch_offset IN NUMBER
1382: ,p_offset_type IN NUMBER

Line 1416: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;

1412: l_in_pregen_fpo_row pregen_fpo_row;
1413: x_pregen_fpo_row pregen_fpo_row;
1414: l_generated_pre_batch_tab generated_pre_batch_tab;
1415: l_in_generated_pre_batch_tab generated_pre_batch_tab;
1416: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
1417: l_return_status VARCHAR2 (1);
1418: l_item_um VARCHAR2 (4);
1419: l_arr_rtn_sts return_array_sts;
1420: l_batch_range VARCHAR2 (2000);

Line 1421: l_exception_material_tbl gme_common_pvt.exceptions_tab;

1417: l_return_status VARCHAR2 (1);
1418: l_item_um VARCHAR2 (4);
1419: l_arr_rtn_sts return_array_sts;
1420: l_batch_range VARCHAR2 (2000);
1421: l_exception_material_tbl gme_common_pvt.exceptions_tab;
1422: /* Exception definitions */
1423: validation_failure EXCEPTION;
1424: fpo_retrieval_failure EXCEPTION;
1425: batch_generation_failure EXCEPTION;

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

1471: FETCH get_validity_rule
1472: INTO l_inventory_item_id, l_item_um;
1473:
1474: IF get_validity_rule%NOTFOUND THEN
1475: gme_common_pvt.log_message ('GME_VALIDITY_RULE_RETRIEVE_ERR');
1476:
1477: CLOSE get_validity_rule;
1478:
1479: RAISE validation_failure;

Line 1733: gme_common_pvt.log_message ('GME_FPO_TO_BATCHES_CREATED'

1729: END IF;
1730:
1731: -- Bug 3185748 Display proper message
1732: IF p_num_batches = l_generated_pre_batch_tab.COUNT THEN
1733: gme_common_pvt.log_message ('GME_FPO_TO_BATCHES_CREATED'
1734: ,'BATCHRANGE'
1735: ,l_batch_range);
1736: ELSE
1737: gme_common_pvt.log_message ('GME_NOT_ALL_BATCHES_CREATED'

Line 1737: gme_common_pvt.log_message ('GME_NOT_ALL_BATCHES_CREATED'

1733: gme_common_pvt.log_message ('GME_FPO_TO_BATCHES_CREATED'
1734: ,'BATCHRANGE'
1735: ,l_batch_range);
1736: ELSE
1737: gme_common_pvt.log_message ('GME_NOT_ALL_BATCHES_CREATED'
1738: ,'BATCHRANGE'
1739: ,l_batch_range);
1740: END IF;
1741: END IF;

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

1763:
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN insufficient_validity_rules THEN
1766: x_return_status := fnd_api.g_ret_sts_error;
1767: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1768: WHEN create_batch_failure THEN
1769: x_return_status := fnd_api.g_ret_sts_error;
1770: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
1771: x_return_status := fnd_api.g_ret_sts_error;