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

Line 53: ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab

49: U - Unexpected error
50: =============================================================================================*/
51: PROCEDURE fetch_all_resources (
52: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
53: ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab
54: ,x_return_status OUT NOCOPY VARCHAR2
55: ,p_active_trans IN NUMBER DEFAULT 0 -- B3425554
56: )
57: IS

Line 392: l_resource_tbl gme_common_pvt.resource_transactions_tab;

388: l_debug VARCHAR2 (2000);
389: l_prev_rec cur_get_prev_rec%ROWTYPE;
390: l_resource_rec gme_resource_txns_gtmp%ROWTYPE;
391: l_tran_rec gme_resource_txns%ROWTYPE;
392: l_resource_tbl gme_common_pvt.resource_transactions_tab;
393: l_trans_date DATE;
394: l_org_id NUMBER;
395: l_period_id INTEGER;
396:

Line 455: IF NOT gme_common_pvt.close_period_check_flexible

451:
452: IF (l_resource_rec.action_code = 'ADD') THEN
453: l_trans_date := l_tran_rec.trans_date;
454:
455: IF NOT gme_common_pvt.close_period_check_flexible
456: (p_org_id => l_org_id
457: ,p_trans_date => l_trans_date
458: ,x_trans_date => l_tran_rec.trans_date
459: ,x_period_id => l_period_id) THEN

Line 521: IF NOT gme_common_pvt.close_period_check_flexible

517: END IF;
518:
519: l_trans_date := l_prev_rec.trans_date;
520:
521: IF NOT gme_common_pvt.close_period_check_flexible
522: (p_org_id => l_org_id
523: ,p_trans_date => l_trans_date
524: ,x_trans_date => l_prev_rec.trans_date
525: ,x_period_id => l_period_id) THEN

Line 579: IF NOT gme_common_pvt.close_period_check_flexible

575: /* Post the actual transaction */
576: l_tran_rec.posted_ind := 0;
577: l_trans_date := l_tran_rec.trans_date;
578:
579: IF NOT gme_common_pvt.close_period_check_flexible
580: (p_org_id => l_org_id
581: ,p_trans_date => l_trans_date
582: ,x_trans_date => l_tran_rec.trans_date
583: ,x_period_id => l_period_id) THEN

Line 649: IF NOT gme_common_pvt.close_period_check_flexible

645:
646: l_tran_rec.reverse_id := l_tran_rec.poc_trans_id;
647: l_trans_date := l_tran_rec.trans_date;
648:
649: IF NOT gme_common_pvt.close_period_check_flexible
650: (p_org_id => l_org_id
651: ,p_trans_date => l_trans_date
652: ,x_trans_date => l_tran_rec.trans_date
653: ,x_period_id => l_period_id) THEN

Line 780: p_resource_rec.creation_date := gme_common_pvt.g_timestamp;

776: p_resource_rec.reason_code := p_tmp_rec.reason_code;
777: p_resource_rec.reason_id := p_tmp_rec.reason_id;
778: p_resource_rec.start_date := p_tmp_rec.start_date;
779: p_resource_rec.end_date := p_tmp_rec.end_date;
780: p_resource_rec.creation_date := gme_common_pvt.g_timestamp;
781: p_resource_rec.last_update_date := gme_common_pvt.g_timestamp;
782: p_resource_rec.created_by := gme_common_pvt.g_user_ident;
783: p_resource_rec.last_updated_by := gme_common_pvt.g_user_ident;
784: p_resource_rec.last_update_login := gme_common_pvt.g_login_id;

Line 781: p_resource_rec.last_update_date := gme_common_pvt.g_timestamp;

777: p_resource_rec.reason_id := p_tmp_rec.reason_id;
778: p_resource_rec.start_date := p_tmp_rec.start_date;
779: p_resource_rec.end_date := p_tmp_rec.end_date;
780: p_resource_rec.creation_date := gme_common_pvt.g_timestamp;
781: p_resource_rec.last_update_date := gme_common_pvt.g_timestamp;
782: p_resource_rec.created_by := gme_common_pvt.g_user_ident;
783: p_resource_rec.last_updated_by := gme_common_pvt.g_user_ident;
784: p_resource_rec.last_update_login := gme_common_pvt.g_login_id;
785: p_resource_rec.delete_mark := p_tmp_rec.delete_mark;

Line 782: p_resource_rec.created_by := gme_common_pvt.g_user_ident;

778: p_resource_rec.start_date := p_tmp_rec.start_date;
779: p_resource_rec.end_date := p_tmp_rec.end_date;
780: p_resource_rec.creation_date := gme_common_pvt.g_timestamp;
781: p_resource_rec.last_update_date := gme_common_pvt.g_timestamp;
782: p_resource_rec.created_by := gme_common_pvt.g_user_ident;
783: p_resource_rec.last_updated_by := gme_common_pvt.g_user_ident;
784: p_resource_rec.last_update_login := gme_common_pvt.g_login_id;
785: p_resource_rec.delete_mark := p_tmp_rec.delete_mark;
786: p_resource_rec.text_code := p_tmp_rec.text_code;

Line 783: p_resource_rec.last_updated_by := gme_common_pvt.g_user_ident;

779: p_resource_rec.end_date := p_tmp_rec.end_date;
780: p_resource_rec.creation_date := gme_common_pvt.g_timestamp;
781: p_resource_rec.last_update_date := gme_common_pvt.g_timestamp;
782: p_resource_rec.created_by := gme_common_pvt.g_user_ident;
783: p_resource_rec.last_updated_by := gme_common_pvt.g_user_ident;
784: p_resource_rec.last_update_login := gme_common_pvt.g_login_id;
785: p_resource_rec.delete_mark := p_tmp_rec.delete_mark;
786: p_resource_rec.text_code := p_tmp_rec.text_code;
787: p_resource_rec.sequence_dependent_ind

Line 784: p_resource_rec.last_update_login := gme_common_pvt.g_login_id;

780: p_resource_rec.creation_date := gme_common_pvt.g_timestamp;
781: p_resource_rec.last_update_date := gme_common_pvt.g_timestamp;
782: p_resource_rec.created_by := gme_common_pvt.g_user_ident;
783: p_resource_rec.last_updated_by := gme_common_pvt.g_user_ident;
784: p_resource_rec.last_update_login := gme_common_pvt.g_login_id;
785: p_resource_rec.delete_mark := p_tmp_rec.delete_mark;
786: p_resource_rec.text_code := p_tmp_rec.text_code;
787: p_resource_rec.sequence_dependent_ind
788: := p_tmp_rec.sequence_dependent_ind;

Line 868: ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab

864: =============================================================================================*/
865: PROCEDURE fetch_active_resources (
866: p_resource_rec IN gme_resource_txns_gtmp%ROWTYPE
867: ,p_calling_mode IN VARCHAR2 DEFAULT NULL --bug#5609683
868: ,x_resource_tbl OUT NOCOPY gme_common_pvt.resource_transactions_tab
869: ,x_return_status OUT NOCOPY VARCHAR2)
870: IS
871: TYPE query_ref IS REF CURSOR;
872:

Line 1011: l_resource_tbl gme_common_pvt.resource_transactions_tab;

1007: l_batch_step gme_batch_steps%ROWTYPE;
1008: l_step_activity gme_batch_step_activities%ROWTYPE;
1009: l_step_resources gme_batch_step_resources%ROWTYPE;
1010: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1011: l_resource_tbl gme_common_pvt.resource_transactions_tab;
1012: l_return_status VARCHAR2 (1);
1013: l_rsrc_usage NUMBER;
1014: l_rsrc_count NUMBER;
1015: l_tot_usage NUMBER;

Line 1175: gme_common_pvt.set_timestamp;

1171:
1172: /* Since this procedure is called from the forms
1173: and there is no public layer for this we can call
1174: set_timestamp here */
1175: gme_common_pvt.set_timestamp;
1176:
1177: IF p_action_code = 'INSERT' THEN
1178: -- Shikha Nagar - added check to prevent second instance of primary rsrc from getting inserted
1179: -- for an activity

Line 1283: x_step_resources_rec.last_updated_by := gme_common_pvt.g_user_ident;

1279: (p_batch_step_resources => x_step_resources_rec) ) THEN
1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282:
1283: x_step_resources_rec.last_updated_by := gme_common_pvt.g_user_ident;
1284: x_step_resources_rec.last_update_date := gme_common_pvt.g_timestamp;
1285: END IF;
1286:
1287: /*Bug#5231180 resource insertion and deletion might result in the max step capacity

Line 1284: x_step_resources_rec.last_update_date := gme_common_pvt.g_timestamp;

1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282:
1283: x_step_resources_rec.last_updated_by := gme_common_pvt.g_user_ident;
1284: x_step_resources_rec.last_update_date := gme_common_pvt.g_timestamp;
1285: END IF;
1286:
1287: /*Bug#5231180 resource insertion and deletion might result in the max step capacity
1288: if the resource is capacity constrained then we need to recalculate charges

Line 1291: gme_common_pvt.g_setup_done :=

1287: /*Bug#5231180 resource insertion and deletion might result in the max step capacity
1288: if the resource is capacity constrained then we need to recalculate charges
1289: if the resource is not capacity constrained then there is no need to recalculate charges */
1290: /*Bug#6607524 Changed the hard coded 1381 to the batch header's organization id*/
1291: gme_common_pvt.g_setup_done :=
1292: gme_common_pvt.setup (p_org_id => l_batch_header.ORGANIZATION_ID --1381
1293: ,p_org_code => NULL);
1294:
1295: IF NOT gme_common_pvt.g_setup_done THEN

Line 1292: gme_common_pvt.setup (p_org_id => l_batch_header.ORGANIZATION_ID --1381

1288: if the resource is capacity constrained then we need to recalculate charges
1289: if the resource is not capacity constrained then there is no need to recalculate charges */
1290: /*Bug#6607524 Changed the hard coded 1381 to the batch header's organization id*/
1291: gme_common_pvt.g_setup_done :=
1292: gme_common_pvt.setup (p_org_id => l_batch_header.ORGANIZATION_ID --1381
1293: ,p_org_code => NULL);
1294:
1295: IF NOT gme_common_pvt.g_setup_done THEN
1296: RAISE fnd_api.g_exc_error;

Line 1295: IF NOT gme_common_pvt.g_setup_done THEN

1291: gme_common_pvt.g_setup_done :=
1292: gme_common_pvt.setup (p_org_id => l_batch_header.ORGANIZATION_ID --1381
1293: ,p_org_code => NULL);
1294:
1295: IF NOT gme_common_pvt.g_setup_done THEN
1296: RAISE fnd_api.g_exc_error;
1297: END IF;
1298:
1299: OPEN cur_get_rsrc(x_step_resources_rec.resources);

Line 1309: ,PRECISION => gme_common_pvt.g_precision

1305:
1306: IF l_exists = 1 THEN /*capacity constrained resource */
1307: IF l_rsrc_rec.capacity_um <> l_batch_step.step_qty_um THEN
1308: l_temp_qty := inv_convert.inv_um_convert(item_id => 0
1309: ,PRECISION => gme_common_pvt.g_precision
1310: ,from_quantity => l_rsrc_rec.max_capacity
1311: ,from_unit => l_rsrc_rec.capacity_um
1312: ,to_unit => l_batch_step.step_qty_um
1313: ,from_name => NULL

Line 1413: gme_common_pvt.log_message ('GME_START_DATE_REQD');

1409: x_return_status := fnd_api.g_ret_sts_success;
1410:
1411: IF ( p_batch_step_rec.step_status = 1
1412: AND p_step_resources_rec.plan_start_date IS NULL) THEN
1413: gme_common_pvt.log_message ('GME_START_DATE_REQD');
1414: RAISE fnd_api.g_exc_error;
1415: END IF;
1416:
1417: IF p_batch_step_rec.step_status = 1

Line 1419: gme_common_pvt.log_message ('GME_PLAN_RSRC_REQD');

1415: END IF;
1416:
1417: IF p_batch_step_rec.step_status = 1
1418: AND p_step_resources_rec.plan_rsrc_usage IS NULL THEN
1419: gme_common_pvt.log_message ('GME_PLAN_RSRC_REQD');
1420: RAISE fnd_api.g_exc_error;
1421: END IF;
1422:
1423: IF ( p_batch_step_rec.step_status = 1

Line 1425: gme_common_pvt.log_message ('GME_RSRC_QTY_REQD');

1421: END IF;
1422:
1423: IF ( p_batch_step_rec.step_status = 1
1424: AND p_step_resources_rec.plan_rsrc_qty IS NULL) THEN
1425: gme_common_pvt.log_message ('GME_RSRC_QTY_REQD');
1426: RAISE fnd_api.g_exc_error;
1427: END IF;
1428:
1429: IF ( p_batch_step_rec.step_status = 1

Line 1431: gme_common_pvt.log_message ('GME_RSRC_COUNT_REQD');

1427: END IF;
1428:
1429: IF ( p_batch_step_rec.step_status = 1
1430: AND p_step_resources_rec.plan_rsrc_count IS NULL) THEN
1431: gme_common_pvt.log_message ('GME_RSRC_COUNT_REQD');
1432: RAISE fnd_api.g_exc_error;
1433: END IF;
1434:
1435: IF ( p_batch_step_rec.step_status > 2

Line 1437: gme_common_pvt.log_message ('GME_RSRC_QTY_REQD');

1433: END IF;
1434:
1435: IF ( p_batch_step_rec.step_status > 2
1436: AND p_step_resources_rec.actual_rsrc_qty IS NULL) THEN
1437: gme_common_pvt.log_message ('GME_RSRC_QTY_REQD');
1438: RAISE fnd_api.g_exc_error;
1439: END IF;
1440:
1441: IF ( p_batch_step_rec.step_status > 2

Line 1443: gme_common_pvt.log_message ('GME_RSRC_COUNT_REQD');

1439: END IF;
1440:
1441: IF ( p_batch_step_rec.step_status > 2
1442: AND p_step_resources_rec.actual_rsrc_count IS NULL) THEN
1443: gme_common_pvt.log_message ('GME_RSRC_COUNT_REQD');
1444: RAISE fnd_api.g_exc_error;
1445: END IF;
1446:
1447: /* Let us check for the validitiy of the plan and actual dates */

Line 1452: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1448: IF p_step_resources_rec.plan_start_date IS NOT NULL
1449: AND p_step_resources_rec.plan_cmplt_date IS NOT NULL THEN
1450: IF p_step_resources_rec.plan_start_date >
1451: p_step_resources_rec.plan_cmplt_date THEN
1452: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1453: RAISE fnd_api.g_exc_error;
1454: END IF;
1455: END IF;
1456:

Line 1461: gme_common_pvt.log_message ('PM_BADSTARTDATE');

1457: IF p_step_resources_rec.actual_start_date IS NOT NULL
1458: AND p_step_resources_rec.actual_cmplt_date IS NOT NULL THEN
1459: IF p_step_resources_rec.actual_start_date >
1460: p_step_resources_rec.actual_cmplt_date THEN
1461: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1462: RAISE fnd_api.g_exc_error;
1463: END IF;
1464: END IF;
1465:

Line 1471: gme_common_pvt.log_message

1467: AND ( p_step_resources_rec.plan_start_date <
1468: p_step_activity_rec.plan_start_date
1469: OR p_step_resources_rec.plan_start_date >
1470: p_step_activity_rec.plan_cmplt_date) THEN
1471: gme_common_pvt.log_message
1472: ('GME_RSRC_PLAN_DATE'
1473: ,'START_DATE'
1474: ,fnd_date.date_to_displaydt (p_step_activity_rec.plan_start_date)
1475: ,'END_DATE'

Line 1483: gme_common_pvt.log_message

1479:
1480: IF p_step_resources_rec.plan_cmplt_date IS NOT NULL
1481: AND p_step_resources_rec.plan_cmplt_date >
1482: p_step_activity_rec.plan_cmplt_date THEN
1483: gme_common_pvt.log_message
1484: ('GME_RSRC_PLAN_DATE'
1485: ,'START_DATE'
1486: ,fnd_date.date_to_displaydt (p_step_activity_rec.plan_start_date)
1487: ,'END_DATE'

Line 1497: gme_common_pvt.log_message

1493: AND ( p_step_resources_rec.actual_start_date <
1494: p_step_activity_rec.actual_start_date
1495: OR p_step_resources_rec.actual_start_date >
1496: p_step_activity_rec.actual_cmplt_date) THEN
1497: gme_common_pvt.log_message
1498: ('GME_RSRC_ACTUAL_DATE'
1499: ,'START_DATE'
1500: ,fnd_date.date_to_displaydt (p_step_activity_rec.actual_start_date)
1501: ,'END_DATE'

Line 1511: gme_common_pvt.log_message

1507:
1508: IF p_step_resources_rec.actual_cmplt_date IS NOT NULL
1509: AND p_step_resources_rec.actual_cmplt_date >
1510: p_step_activity_rec.actual_cmplt_date THEN
1511: gme_common_pvt.log_message
1512: ('GME_RSRC_ACTUAL_DATE'
1513: ,'START_DATE'
1514: ,fnd_date.date_to_displaydt (p_step_activity_rec.actual_start_date)
1515: ,'END_DATE'

Line 2075: IF NOT gme_common_pvt.get_batchstep_rsrc (

2071: /* Initially let us assign the return status to success */
2072: x_return_status := fnd_api.g_ret_sts_success;
2073:
2074: l_batch_step_rsrc_rec_in.batchstep_resource_id := p_batchstep_rsrc_id;
2075: IF NOT gme_common_pvt.get_batchstep_rsrc (
2076: p_batchstep_rsrc_rec => l_batch_step_rsrc_rec_in
2077: ,p_org_code => p_org_code
2078: ,p_batch_no => p_batch_no
2079: ,p_batchstep_no => p_batchstep_no

Line 2095: gme_common_pvt.log_message ('GME_RSRCID_NOT_FOUND'

2091: FETCH cur_get_batch_details
2092: INTO l_batch_id, l_resource;
2093:
2094: IF cur_get_batch_details%NOTFOUND THEN
2095: gme_common_pvt.log_message ('GME_RSRCID_NOT_FOUND'
2096: ,'BATCHSTEP_RSRC_ID'
2097: ,l_line_id);
2098: RAISE rsrcid_not_found;
2099: END IF;

Line 2115: gme_common_pvt.log_message ('INPUT_PARMS_MISS'

2111: OR p_batch_no IS NULL
2112: OR p_batchstep_no IS NULL
2113: OR p_activity IS NULL
2114: OR p_resource IS NULL) THEN
2115: gme_common_pvt.log_message ('INPUT_PARMS_MISS'
2116: ,'PROC'
2117: , l_api_name || '.' || g_pkg_name);
2118: RAISE fnd_api.g_exc_error;
2119: ELSE

Line 2127: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');

2123: FETCH cur_get_batch_id
2124: INTO l_batch_id;
2125:
2126: IF cur_get_batch_id%NOTFOUND THEN
2127: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
2128: RAISE batch_not_found;
2129: END IF;
2130:
2131: CLOSE cur_get_batch_id;

Line 2140: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND'

2136: FETCH cur_get_batchstep_id
2137: INTO l_batchstep_id;
2138:
2139: IF cur_get_batchstep_id%NOTFOUND THEN
2140: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND'
2141: ,'STEP_ID'
2142: ,p_batchstep_no);
2143: RAISE batchstep_not_found;
2144: END IF;

Line 2155: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND'

2151: FETCH cur_get_activity_id
2152: INTO l_activity_id;
2153:
2154: IF cur_get_activity_id%NOTFOUND THEN
2155: gme_common_pvt.log_message ('GME_STEP_ACTIVITY_NOT_FOUND'
2156: ,'ACTIVITY'
2157: ,p_activity
2158: ,'STEP_NO'
2159: ,p_batchstep_no);

Line 2172: gme_common_pvt.log_message ('GME_RSRC_NOT_FOUND'

2168: FETCH cur_fetch_resource_dtl
2169: INTO l_line_id, l_resource;
2170:
2171: IF cur_fetch_resource_dtl%NOTFOUND THEN
2172: gme_common_pvt.log_message ('GME_RSRC_NOT_FOUND'
2173: ,'RESOURCE'
2174: ,p_resource
2175: ,'ACTIVITY'
2176: ,p_activity);

Line 2190: gme_common_pvt.log_message ('INPUT_PARMS_MISS'

2186: /* V. Ajay Kumar BUG#3041697 Removed the check for reason code */
2187: IF ( (p_trans_date IS NULL AND p_called_from <> 5)
2188: OR ( (p_start_date IS NULL) AND (p_batchstep_rsrc_id <> -1) )
2189: OR ( (p_end_date IS NULL) AND (p_usage <> 0) ) ) THEN
2190: gme_common_pvt.log_message ('INPUT_PARMS_MISS'
2191: ,'PROC'
2192: , l_api_name || '.' || g_pkg_name);
2193: RAISE fnd_api.g_exc_error;
2194: END IF;

Line 2205: gme_common_pvt.log_message ('GME_RTXN_FOR_FPO_NT_ALWD');

2201: END IF;
2202:
2203: /* We cannot insert allocations for an FPO */
2204: IF l_batch_header.batch_type = 10 THEN
2205: gme_common_pvt.log_message ('GME_RTXN_FOR_FPO_NT_ALWD');
2206: RAISE rtxn_for_fpo_not_allowed;
2207: END IF;
2208:
2209: /* We cannot insert txns if the batch does not support txns*/

Line 2211: gme_common_pvt.log_message ('GME_RTXN_FOR_UPDINV_NT_ALWD');

2207: END IF;
2208:
2209: /* We cannot insert txns if the batch does not support txns*/
2210: IF l_batch_header.update_inventory_ind = 'N' THEN
2211: gme_common_pvt.log_message ('GME_RTXN_FOR_UPDINV_NT_ALWD');
2212: RAISE rtxn_for_updinv_not_allowed;
2213: END IF;
2214:
2215: IF p_usage IS NOT NULL THEN

Line 2217: gme_common_pvt.log_message ('GME_NEG_USAGE_NT_ALWD');

2213: END IF;
2214:
2215: IF p_usage IS NOT NULL THEN
2216: IF p_usage < 0 THEN
2217: gme_common_pvt.log_message ('GME_NEG_USAGE_NT_ALWD');
2218: RAISE neg_usage_not_allowed;
2219: END IF;
2220: END IF;
2221:

Line 2230: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');

2226:
2227: CLOSE cur_get_step_status;
2228:
2229: IF l_step_status NOT IN (2, 3) THEN
2230: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
2231: RAISE invalid_step_status;
2232: END IF;
2233:
2234: x_step_status := l_step_status;

Line 2238: gme_common_pvt.log_message ('GME_UPD_RSRC_NT_WRK_ASQCBTCH');

2234: x_step_status := l_step_status;
2235:
2236: IF (l_batch_header.automatic_step_calculation = 1) THEN
2237: IF p_called_from = 1 THEN
2238: gme_common_pvt.log_message ('GME_UPD_RSRC_NT_WRK_ASQCBTCH');
2239: RAISE asqc_update_rsrc_api_error;
2240: END IF;
2241:
2242: IF (l_step_status = 2) THEN

Line 2243: gme_common_pvt.log_message ('GME_INV_STEP_STATUS_ASQC');

2239: RAISE asqc_update_rsrc_api_error;
2240: END IF;
2241:
2242: IF (l_step_status = 2) THEN
2243: gme_common_pvt.log_message ('GME_INV_STEP_STATUS_ASQC');
2244: RAISE step_status_asqc_error;
2245: END IF;
2246:
2247: -- Shikha Nagar B2498487 Added code to prevent ending txn

Line 2252: gme_common_pvt.log_message ('GME_NT_END_ASQC_OVRD_TXN');

2248: -- for automatically generated ASQC txn
2249: IF ( p_called_from = 5
2250: AND l_step_status = 3
2251: AND l_overrided_protected_ind = 'N') THEN
2252: gme_common_pvt.log_message ('GME_NT_END_ASQC_OVRD_TXN');
2253: RAISE asqc_ovrd_end_txn_api_error;
2254: END IF;
2255: END IF; /* If ASQC is on */
2256: /* Lets validate the reason code passed in */

Line 2264: gme_common_pvt.log_message(p_product_code => 'INV'

2260: FETCH cur_validate_reason_id
2261: INTO x_reason_id;
2262: IF cur_validate_reason_id%NOTFOUND THEN
2263: CLOSE cur_validate_reason_id;
2264: gme_common_pvt.log_message(p_product_code => 'INV'
2265: ,p_message_code => 'INV_LOTC_REASONID_INVALID');
2266: RAISE FND_API.g_exc_error;
2267: END IF;
2268: CLOSE cur_validate_reason_id;

Line 2275: gme_common_pvt.log_message('GME_INVALID_REASON_NAME');

2271: FETCH cur_get_reason_id
2272: INTO x_reason_id;
2273: IF cur_get_reason_id%NOTFOUND THEN
2274: CLOSE cur_get_reason_id;
2275: gme_common_pvt.log_message('GME_INVALID_REASON_NAME');
2276: RAISE FND_API.g_exc_error;
2277: ELSE
2278: FETCH cur_get_reason_id
2279: INTO x_reason_id;

Line 2284: gme_common_pvt.log_message('GME_REASON_NAME_NOT_UNIQUE');

2280: IF cur_get_reason_id%NOTFOUND THEN
2281: CLOSE cur_get_reason_id;
2282: ELSE
2283: CLOSE cur_get_reason_id;
2284: gme_common_pvt.log_message('GME_REASON_NAME_NOT_UNIQUE');
2285: RAISE FND_API.g_exc_error;
2286: END IF;
2287: END IF;
2288: END IF; /* IF p_reason_name IS NOT NULL */

Line 2298: gme_common_pvt.log_message ('GME_INVALID_INSTANCE_ID'

2294: FETCH cur_validate_instance_id
2295: INTO l_dummy;
2296:
2297: IF cur_validate_instance_id%NOTFOUND THEN
2298: gme_common_pvt.log_message ('GME_INVALID_INSTANCE_ID'
2299: ,'INSTANCE_ID'
2300: ,p_instance_id);
2301:
2302: CLOSE cur_validate_instance_id;

Line 2317: gme_common_pvt.log_message ('GME_INVALID_INSTANCE_NO'

2313: FETCH cur_get_instance_id
2314: INTO l_instance_id;
2315:
2316: IF cur_get_instance_id%NOTFOUND THEN
2317: gme_common_pvt.log_message ('GME_INVALID_INSTANCE_NO'
2318: ,'INSTANCE_NO'
2319: ,p_instance_no);
2320:
2321: CLOSE cur_get_instance_id;

Line 2340: gme_common_pvt.log_message ('GME_BAD_TRANS_DATE');

2336: CLOSE cur_get_rsrc_actual_dates;
2337:
2338: -- Validate trans_date
2339: IF p_trans_date < l_rsrc_actual_start_date THEN
2340: gme_common_pvt.log_message ('GME_BAD_TRANS_DATE');
2341: RAISE invalid_date;
2342: ELSIF p_trans_date > gme_common_pvt.g_timestamp THEN
2343: gme_common_pvt.log_message ('GME_BAD_TRANS_SYS_DATE');
2344: RAISE invalid_date;

Line 2342: ELSIF p_trans_date > gme_common_pvt.g_timestamp THEN

2338: -- Validate trans_date
2339: IF p_trans_date < l_rsrc_actual_start_date THEN
2340: gme_common_pvt.log_message ('GME_BAD_TRANS_DATE');
2341: RAISE invalid_date;
2342: ELSIF p_trans_date > gme_common_pvt.g_timestamp THEN
2343: gme_common_pvt.log_message ('GME_BAD_TRANS_SYS_DATE');
2344: RAISE invalid_date;
2345: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2346: IF p_trans_date > l_rsrc_actual_cmplt_date THEN

Line 2343: gme_common_pvt.log_message ('GME_BAD_TRANS_SYS_DATE');

2339: IF p_trans_date < l_rsrc_actual_start_date THEN
2340: gme_common_pvt.log_message ('GME_BAD_TRANS_DATE');
2341: RAISE invalid_date;
2342: ELSIF p_trans_date > gme_common_pvt.g_timestamp THEN
2343: gme_common_pvt.log_message ('GME_BAD_TRANS_SYS_DATE');
2344: RAISE invalid_date;
2345: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2346: IF p_trans_date > l_rsrc_actual_cmplt_date THEN
2347: gme_common_pvt.log_message ('GME_BAD_TRANS_CMPLT_DATE');

Line 2347: gme_common_pvt.log_message ('GME_BAD_TRANS_CMPLT_DATE');

2343: gme_common_pvt.log_message ('GME_BAD_TRANS_SYS_DATE');
2344: RAISE invalid_date;
2345: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2346: IF p_trans_date > l_rsrc_actual_cmplt_date THEN
2347: gme_common_pvt.log_message ('GME_BAD_TRANS_CMPLT_DATE');
2348: RAISE invalid_date;
2349: END IF;
2350: ELSIF p_start_date IS NOT NULL THEN
2351: IF p_trans_date < p_start_date THEN

Line 2352: gme_common_pvt.log_message ('GME_BAD_TRANS_STRT_DATE');

2348: RAISE invalid_date;
2349: END IF;
2350: ELSIF p_start_date IS NOT NULL THEN
2351: IF p_trans_date < p_start_date THEN
2352: gme_common_pvt.log_message ('GME_BAD_TRANS_STRT_DATE');
2353: RAISE invalid_date;
2354: END IF;
2355: ELSIF p_end_date IS NOT NULL THEN
2356: IF p_trans_date > p_end_date THEN

Line 2357: gme_common_pvt.log_message ('GME_BAD_TRANS_END_DATE');

2353: RAISE invalid_date;
2354: END IF;
2355: ELSIF p_end_date IS NOT NULL THEN
2356: IF p_trans_date > p_end_date THEN
2357: gme_common_pvt.log_message ('GME_BAD_TRANS_END_DATE');
2358: RAISE invalid_date;
2359: END IF;
2360: END IF;
2361:

Line 2374: -- gme_common_pvt.log_message('GME_DATE_IN_CLSD_PRD','TRANS_DATE',p_trans_date);

2370: p_retry_flag => 1,
2371: x_tran_rec => l_tran_rec)
2372: THEN
2373: --Bug3315440
2374: -- gme_common_pvt.log_message('GME_DATE_IN_CLSD_PRD','TRANS_DATE',p_trans_date);
2375: gme_common_pvt.log_message('GME_DATE_IN_CLSD_PRD','TRANS_DATE',fnd_date.date_to_displayDT(p_trans_date));
2376: RAISE close_period_err;
2377: END IF;
2378: */

Line 2375: gme_common_pvt.log_message('GME_DATE_IN_CLSD_PRD','TRANS_DATE',fnd_date.date_to_displayDT(p_trans_date));

2371: x_tran_rec => l_tran_rec)
2372: THEN
2373: --Bug3315440
2374: -- gme_common_pvt.log_message('GME_DATE_IN_CLSD_PRD','TRANS_DATE',p_trans_date);
2375: gme_common_pvt.log_message('GME_DATE_IN_CLSD_PRD','TRANS_DATE',fnd_date.date_to_displayDT(p_trans_date));
2376: RAISE close_period_err;
2377: END IF;
2378: */
2379:

Line 2396: IF NOT gme_common_pvt.close_period_check_flexible

2392: END IF;
2393: x_trans_date := l_tran_rec_out.trans_date;
2394: --Rishi Varma 02-09-2004 B3856541 end
2395: */
2396: IF NOT gme_common_pvt.close_period_check_flexible
2397: (p_org_id => l_batch_step_rsrc_rec.organization_id
2398: ,p_trans_date => p_trans_date
2399: ,x_trans_date => x_trans_date
2400: ,x_period_id => l_period_id) THEN

Line 2408: gme_common_pvt.log_message ('GME_BAD_START_DATE');

2404: /* end */
2405:
2406: -- Validate start_date
2407: IF p_start_date < l_rsrc_actual_start_date THEN
2408: gme_common_pvt.log_message ('GME_BAD_START_DATE');
2409: RAISE invalid_date;
2410: ELSIF p_start_date > gme_common_pvt.g_timestamp THEN
2411: gme_common_pvt.log_message ('GME_BAD_START_END_DATE');
2412: RAISE invalid_date;

Line 2410: ELSIF p_start_date > gme_common_pvt.g_timestamp THEN

2406: -- Validate start_date
2407: IF p_start_date < l_rsrc_actual_start_date THEN
2408: gme_common_pvt.log_message ('GME_BAD_START_DATE');
2409: RAISE invalid_date;
2410: ELSIF p_start_date > gme_common_pvt.g_timestamp THEN
2411: gme_common_pvt.log_message ('GME_BAD_START_END_DATE');
2412: RAISE invalid_date;
2413: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2414: IF p_start_date > l_rsrc_actual_cmplt_date THEN

Line 2411: gme_common_pvt.log_message ('GME_BAD_START_END_DATE');

2407: IF p_start_date < l_rsrc_actual_start_date THEN
2408: gme_common_pvt.log_message ('GME_BAD_START_DATE');
2409: RAISE invalid_date;
2410: ELSIF p_start_date > gme_common_pvt.g_timestamp THEN
2411: gme_common_pvt.log_message ('GME_BAD_START_END_DATE');
2412: RAISE invalid_date;
2413: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2414: IF p_start_date > l_rsrc_actual_cmplt_date THEN
2415: gme_common_pvt.log_message ('GME_BAD_START_CMPLT_DATE');

Line 2415: gme_common_pvt.log_message ('GME_BAD_START_CMPLT_DATE');

2411: gme_common_pvt.log_message ('GME_BAD_START_END_DATE');
2412: RAISE invalid_date;
2413: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2414: IF p_start_date > l_rsrc_actual_cmplt_date THEN
2415: gme_common_pvt.log_message ('GME_BAD_START_CMPLT_DATE');
2416: RAISE invalid_date;
2417: END IF;
2418: END IF;
2419:

Line 2422: gme_common_pvt.log_message ('PM_BADENDDATE');

2418: END IF;
2419:
2420: -- Validate END DATE
2421: IF p_end_date < p_start_date THEN
2422: gme_common_pvt.log_message ('PM_BADENDDATE');
2423: RAISE invalid_date;
2424: ELSIF p_end_date > gme_common_pvt.g_timestamp THEN
2425: gme_common_pvt.log_message ('GME_BAD_END_DATE');
2426: RAISE invalid_date;

Line 2424: ELSIF p_end_date > gme_common_pvt.g_timestamp THEN

2420: -- Validate END DATE
2421: IF p_end_date < p_start_date THEN
2422: gme_common_pvt.log_message ('PM_BADENDDATE');
2423: RAISE invalid_date;
2424: ELSIF p_end_date > gme_common_pvt.g_timestamp THEN
2425: gme_common_pvt.log_message ('GME_BAD_END_DATE');
2426: RAISE invalid_date;
2427: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2428: IF p_end_date > l_rsrc_actual_cmplt_date THEN

Line 2425: gme_common_pvt.log_message ('GME_BAD_END_DATE');

2421: IF p_end_date < p_start_date THEN
2422: gme_common_pvt.log_message ('PM_BADENDDATE');
2423: RAISE invalid_date;
2424: ELSIF p_end_date > gme_common_pvt.g_timestamp THEN
2425: gme_common_pvt.log_message ('GME_BAD_END_DATE');
2426: RAISE invalid_date;
2427: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2428: IF p_end_date > l_rsrc_actual_cmplt_date THEN
2429: gme_common_pvt.log_message ('GME_BAD_END_CMPLT_DATE');

Line 2429: gme_common_pvt.log_message ('GME_BAD_END_CMPLT_DATE');

2425: gme_common_pvt.log_message ('GME_BAD_END_DATE');
2426: RAISE invalid_date;
2427: ELSIF l_rsrc_actual_cmplt_date IS NOT NULL THEN
2428: IF p_end_date > l_rsrc_actual_cmplt_date THEN
2429: gme_common_pvt.log_message ('GME_BAD_END_CMPLT_DATE');
2430: RAISE invalid_date;
2431: END IF;
2432: END IF;
2433:

Line 2510: l_resource_tbl gme_common_pvt.resource_transactions_tab;

2506: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ACTUAL_RSRC_USAGE';
2507: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
2508: l_batch_header gme_batch_header%ROWTYPE;
2509: l_step_resources gme_batch_step_resources%ROWTYPE;
2510: l_resource_tbl gme_common_pvt.resource_transactions_tab;
2511: l_line_id NUMBER;
2512: l_instance_id NUMBER;
2513: l_reason_id NUMBER;
2514: l_inv_trans_count NUMBER;

Line 2548: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

2544: x_return_status := fnd_api.g_ret_sts_success;
2545:
2546: /*siva commented following IF condition to allow insertion of flexfileds
2547: without validation when p_validate_flexfields is FALSE */
2548: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN
2549: /*Validate Flexfields using the new procedure gme_api_validate_flex_fld_pvt.validate_rsrc_txn_flex */
2550: gme_validate_flex_fld_pvt.validate_rsrc_txn_flex
2551: (p_resource_txn_rec => p_rsrc_txn_rec
2552: ,x_resource_txn_rec => x_rsrc_txn_rec

Line 2647: l_rsrc_txn_rec.event_id := gme_common_pvt.g_transaction_header_id;

2643: l_rsrc_txn_rec.doc_type := 'PROD';
2644: l_rsrc_txn_rec.line_type := 0;
2645: l_rsrc_txn_rec.organization_id := l_batch_header.organization_id;
2646: l_rsrc_txn_rec.orgn_code := NULL;
2647: l_rsrc_txn_rec.event_id := gme_common_pvt.g_transaction_header_id;
2648: l_rsrc_txn_rec.line_id := l_line_id;
2649: l_rsrc_txn_rec.resources := l_resources;
2650: l_rsrc_txn_rec.resource_usage := p_rsrc_txn_rec.resource_usage;
2651: l_rsrc_txn_rec.trans_um := l_usage_uom;

Line 2676: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

2672: END IF;
2673:
2674: l_rsrc_txn_rec.sequence_dependent_ind := 0;
2675: --siva copying flex-fields
2676: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN
2677: l_rsrc_txn_rec.attribute_category := x_rsrc_txn_rec.attribute_category;
2678: l_rsrc_txn_rec.attribute1 := x_rsrc_txn_rec.attribute1;
2679: l_rsrc_txn_rec.attribute2 := x_rsrc_txn_rec.attribute2;
2680: l_rsrc_txn_rec.attribute3 := x_rsrc_txn_rec.attribute3;

Line 2804: l_resource_tbl gme_common_pvt.resource_transactions_tab;

2800: := 'insert_incr_actual_rsrc_txn';
2801: l_resource_txns gme_resource_txns%ROWTYPE;
2802: l_batch_header gme_batch_header%ROWTYPE;
2803: l_step_resources gme_batch_step_resources%ROWTYPE;
2804: l_resource_tbl gme_common_pvt.resource_transactions_tab;
2805: l_step_status NUMBER;
2806: l_activity_id NUMBER;
2807: l_inv_trans_count NUMBER;
2808: l_rsrc_trans_count NUMBER;

Line 2847: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

2843: x_return_status := fnd_api.g_ret_sts_success;
2844:
2845: /*siva commented following IF condition to allow insertion of flexfileds
2846: without validation when p_validate_flexfields is FALSE */
2847: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN
2848: /*Validate Flexfields using the new procedure gme_api_validate_flex_fld_pvt.validate_rsrc_txn_flex */
2849: gme_validate_flex_fld_pvt.validate_rsrc_txn_flex
2850: (p_resource_txn_rec => p_rsrc_txn_rec
2851: ,x_resource_txn_rec => x_rsrc_txn_rec

Line 2918: l_rsrc_txn_rec.event_id := gme_common_pvt.g_transaction_header_id;

2914: l_rsrc_txn_rec.doc_type := 'PROD';
2915: l_rsrc_txn_rec.line_type := 0;
2916: l_rsrc_txn_rec.organization_id := l_batch_header.organization_id;
2917: l_rsrc_txn_rec.line_id := l_line_id;
2918: l_rsrc_txn_rec.event_id := gme_common_pvt.g_transaction_header_id;
2919: l_rsrc_txn_rec.resources := l_resources;
2920: l_rsrc_txn_rec.resource_usage := p_rsrc_txn_rec.resource_usage;
2921: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
2922: l_rsrc_txn_rec.trans_date := l_trans_date;

Line 3057: l_resource_tbl gme_common_pvt.resource_transactions_tab;

3053: := 'insert_timed_actual_rsrc_txn';
3054: l_resource_txns gme_resource_txns%ROWTYPE;
3055: l_batch_header gme_batch_header%ROWTYPE;
3056: l_step_resources gme_batch_step_resources%ROWTYPE;
3057: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3058: l_line_id NUMBER;
3059: l_inv_trans_count NUMBER;
3060: l_rsrc_trans_count NUMBER;
3061: l_step_status NUMBER;

Line 3102: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

3098: x_return_status := fnd_api.g_ret_sts_success;
3099:
3100: /*siva commented following IF condition to allow insertion of flexfileds
3101: without validation when p_validate_flexfields is FALSE */
3102: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN
3103: /*Validate Flexfields using the new procedure gme_api_validate_flex_fld_pvt.validate_rsrc_txn_flex */
3104: gme_validate_flex_fld_pvt.validate_rsrc_txn_flex
3105: (p_resource_txn_rec => p_rsrc_txn_rec
3106: ,x_resource_txn_rec => x_rsrc_txn_rec

Line 3164: ,user_id => gme_common_pvt.g_user_ident);

3160: l_usage_time :=
3161: (p_rsrc_txn_rec.end_date - p_rsrc_txn_rec.start_date) * 24;
3162: l_hour_um :=
3163: fnd_profile.value_specific (NAME => 'BOM:HOUR_UOM_CODE'
3164: ,user_id => gme_common_pvt.g_user_ident);
3165:
3166: IF (l_hour_um IS NULL) THEN
3167: gme_common_pvt.log_message ('GME_API_UNABLE_TO_GET_CONSTANT'
3168: ,'CONSTANT_NAME'

Line 3167: gme_common_pvt.log_message ('GME_API_UNABLE_TO_GET_CONSTANT'

3163: fnd_profile.value_specific (NAME => 'BOM:HOUR_UOM_CODE'
3164: ,user_id => gme_common_pvt.g_user_ident);
3165:
3166: IF (l_hour_um IS NULL) THEN
3167: gme_common_pvt.log_message ('GME_API_UNABLE_TO_GET_CONSTANT'
3168: ,'CONSTANT_NAME'
3169: ,'BOM:HOUR_UOM_CODE');
3170: RAISE missing_profile_option;
3171: END IF;

Line 3192: gme_common_pvt.log_message ('GME_RSRC_USG_NT_CNV_SYUOM'

3188: ,from_name => NULL
3189: ,to_name => NULL);
3190:
3191: IF (l_txn_usage = -99999) THEN
3192: gme_common_pvt.log_message ('GME_RSRC_USG_NT_CNV_SYUOM'
3193: ,'SY_UOM'
3194: ,l_hour_um
3195: ,'RSRC_USG_UOM'
3196: ,l_usage_uom);

Line 3214: l_rsrc_txn_rec.event_id := gme_common_pvt.g_transaction_header_id;

3210: l_rsrc_txn_rec.line_type := 0;
3211: l_rsrc_txn_rec.organization_id := l_batch_header.organization_id;
3212: l_rsrc_txn_rec.orgn_code := NULL;
3213: l_rsrc_txn_rec.line_id := l_line_id;
3214: l_rsrc_txn_rec.event_id := gme_common_pvt.g_transaction_header_id;
3215: l_rsrc_txn_rec.resources := l_resources;
3216: l_rsrc_txn_rec.resource_usage := l_txn_usage;
3217: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
3218: l_rsrc_txn_rec.trans_date := l_trans_date;

Line 3378: -- IF gme_common_pvt.g_flex_validate_prof = 1 THEN

3374: x_return_status := fnd_api.g_ret_sts_success;
3375:
3376: /*siva commented following IF condition to allow insertion of flexfileds
3377: without validation when p_validate_flexfields is FALSE */
3378: -- IF gme_common_pvt.g_flex_validate_prof = 1 THEN
3379: --Validate Flexfields using the new procedure
3380: gme_validate_flex_fld_pvt.validate_rsrc_txn_flex
3381: (p_resource_txn_rec => p_rsrc_txn_rec
3382: ,x_resource_txn_rec => x_rsrc_txn_rec

Line 3452: l_rsrc_txn_rec.event_id := gme_common_pvt.g_transaction_header_id;

3448: l_rsrc_txn_rec.line_type := 0;
3449: l_rsrc_txn_rec.organization_id := l_batch_header.organization_id;
3450: l_rsrc_txn_rec.orgn_code := NULL;
3451: l_rsrc_txn_rec.line_id := l_line_id;
3452: l_rsrc_txn_rec.event_id := gme_common_pvt.g_transaction_header_id;
3453: l_rsrc_txn_rec.resources := l_resources;
3454: l_rsrc_txn_rec.resource_usage := 0;
3455: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
3456:

Line 3552: l_resource_tbl gme_common_pvt.resource_transactions_tab;

3548: l_api_name CONSTANT VARCHAR2 (30) := 'end_cmplt_actual_rsrc_txn';
3549: l_resource_txns gme_resource_txns%ROWTYPE;
3550: l_batch_header gme_batch_header%ROWTYPE;
3551: l_step_resources gme_batch_step_resources%ROWTYPE;
3552: l_resource_tbl gme_common_pvt.resource_transactions_tab;
3553: --Begin Bug# 3479669
3554: l_tran_rec gme_resource_txns%ROWTYPE;
3555: --End Bug# 3479669
3556: l_step_status NUMBER;

Line 3611: gme_common_pvt.log_message ('GME_INV_POC_TRANS_ID'

3607: FETCH cur_validate_poc_trans_id
3608: INTO l_dummy;
3609:
3610: IF cur_validate_poc_trans_id%NOTFOUND THEN
3611: gme_common_pvt.log_message ('GME_INV_POC_TRANS_ID'
3612: ,'POC_TRANS_ID'
3613: ,p_rsrc_txn_rec.poc_trans_id);
3614: RAISE invalid_poc_trans_id;
3615: END IF;

Line 3621: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

3617: CLOSE cur_validate_poc_trans_id;
3618:
3619: /*siva commented following IF condition to allow insertion of flexfileds
3620: without validation when p_validate_flexfields is FALSE */
3621: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN
3622: /* Validate Flexfields using the new procedure */
3623: gme_validate_flex_fld_pvt.validate_rsrc_txn_flex
3624: (p_resource_txn_rec => p_rsrc_txn_rec
3625: ,x_resource_txn_rec => x_rsrc_txn_rec

Line 3643: gme_common_pvt.log_message ('GME_INVALID_TXN_FOR_END');

3639: IF ( (l_rsrc_txn_rec.resource_usage <> 0)
3640: OR (l_rsrc_txn_rec.start_date <> l_rsrc_txn_rec.end_date)
3641: OR (l_rsrc_txn_rec.completed_ind <> 1)
3642: OR (l_rsrc_txn_rec.delete_mark <> 0) ) THEN
3643: gme_common_pvt.log_message ('GME_INVALID_TXN_FOR_END');
3644: RAISE invalid_txn_for_end;
3645: END IF;
3646:
3647: /* V. Ajay Kumar Bug 3041705. Multiplied the difference of

Line 3653: gme_common_pvt.log_message ('PM_BADENDDATE');

3649: l_usage_time :=
3650: (p_rsrc_txn_rec.end_date - l_rsrc_txn_rec.start_date) * 24;
3651:
3652: IF l_usage_time < 0 THEN
3653: gme_common_pvt.log_message ('PM_BADENDDATE');
3654: RAISE expected_error;
3655: END IF;
3656:
3657: l_hour_um :=

Line 3659: ,user_id => gme_common_pvt.g_user_ident);

3655: END IF;
3656:
3657: l_hour_um :=
3658: fnd_profile.value_specific (NAME => 'BOM:HOUR_UOM_CODE'
3659: ,user_id => gme_common_pvt.g_user_ident);
3660:
3661: IF (l_hour_um IS NULL) THEN
3662: gme_common_pvt.log_message ('GME_API_UNABLE_TO_GET_CONSTANT'
3663: ,'CONSTANT_NAME'

Line 3662: gme_common_pvt.log_message ('GME_API_UNABLE_TO_GET_CONSTANT'

3658: fnd_profile.value_specific (NAME => 'BOM:HOUR_UOM_CODE'
3659: ,user_id => gme_common_pvt.g_user_ident);
3660:
3661: IF (l_hour_um IS NULL) THEN
3662: gme_common_pvt.log_message ('GME_API_UNABLE_TO_GET_CONSTANT'
3663: ,'CONSTANT_NAME'
3664: ,'BOM:HOUR_UOM_CODE');
3665: RAISE missing_profile_option;
3666: END IF;

Line 3680: gme_common_pvt.log_message ('GME_RSRC_USG_NT_CNV_SYUOM'

3676: ,from_name => NULL
3677: ,to_name => NULL);
3678:
3679: IF (l_txn_usage = -99999) THEN
3680: gme_common_pvt.log_message ('GME_RSRC_USG_NT_CNV_SYUOM'
3681: ,'SY_UOM'
3682: ,l_hour_um
3683: ,'RSRC_USG_UOM'
3684: ,l_rsrc_txn_rec.trans_qty_um);

Line 3772: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

3768: l_rsrc_txn_rec.end_date := p_rsrc_txn_rec.end_date;
3769: l_rsrc_txn_rec.instance_id := x_instance_id;
3770:
3771: --siva copying flex field values
3772: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN
3773: l_rsrc_txn_rec.attribute_category := x_rsrc_txn_rec.attribute_category;
3774: l_rsrc_txn_rec.attribute1 := x_rsrc_txn_rec.attribute1;
3775: l_rsrc_txn_rec.attribute2 := x_rsrc_txn_rec.attribute2;
3776: l_rsrc_txn_rec.attribute3 := x_rsrc_txn_rec.attribute3;