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_BATCHSTEP_RSRC_PVT dependencies on FND_API

Line 137: x_return_status := fnd_api.g_ret_sts_success;

133: || ' **********************************');
134: END IF;
135:
136: /* Initially let us assign the return status to success */
137: x_return_status := fnd_api.g_ret_sts_success;
138:
139: IF p_org_code IS NULL THEN
140: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
141: ,'FIELD_NAME'

Line 285: x_return_status := fnd_api.g_ret_sts_error;

281: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
282: END IF;
283: EXCEPTION
284: WHEN batch_not_found OR batchstep_not_found OR input_param_missing THEN
285: x_return_status := fnd_api.g_ret_sts_error;
286: WHEN stepactivity_not_found OR resource_not_found THEN
287: x_return_status := fnd_api.g_ret_sts_error;
288: WHEN OTHERS THEN
289: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 287: x_return_status := fnd_api.g_ret_sts_error;

283: EXCEPTION
284: WHEN batch_not_found OR batchstep_not_found OR input_param_missing THEN
285: x_return_status := fnd_api.g_ret_sts_error;
286: WHEN stepactivity_not_found OR resource_not_found THEN
287: x_return_status := fnd_api.g_ret_sts_error;
288: WHEN OTHERS THEN
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
291: END validate_param;

Line 289: x_return_status := fnd_api.g_ret_sts_unexp_error;

285: x_return_status := fnd_api.g_ret_sts_error;
286: WHEN stepactivity_not_found OR resource_not_found THEN
287: x_return_status := fnd_api.g_ret_sts_error;
288: WHEN OTHERS THEN
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
291: END validate_param;
292:
293: /*===========================================================================================

Line 306: DEFAULT fnd_api.g_false

302: PROCEDURE validate_rsrc_param (
303: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
304: ,p_activity_id IN NUMBER
305: ,p_ignore_qty_below_cap IN VARCHAR2
306: DEFAULT fnd_api.g_false
307: ,p_validate_flexfield IN VARCHAR2
308: DEFAULT fnd_api.g_false
309: ,p_action IN VARCHAR2
310: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

Line 308: DEFAULT fnd_api.g_false

304: ,p_activity_id IN NUMBER
305: ,p_ignore_qty_below_cap IN VARCHAR2
306: DEFAULT fnd_api.g_false
307: ,p_validate_flexfield IN VARCHAR2
308: DEFAULT fnd_api.g_false
309: ,p_action IN VARCHAR2
310: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
311: ,x_step_status OUT NOCOPY NUMBER
312: ,x_return_status OUT NOCOPY VARCHAR2)

Line 402: x_return_status := fnd_api.g_ret_sts_success;

398: || p_action);
399: END IF;
400:
401: /* Initially let us assign the return status to success */
402: x_return_status := fnd_api.g_ret_sts_success;
403:
404: IF p_action = 'INSERT' THEN
405: /* Validations for Insert processing */
406: --check analysis code

Line 923: IF p_ignore_qty_below_cap = fnd_api.g_false THEN

919: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
920: ,'RESOURCE'
921: ,l_batchstep_resource_rec.resources);
922:
923: IF p_ignore_qty_below_cap = fnd_api.g_false THEN
924: RAISE process_qty_error;
925: END IF;
926: END IF;
927:

Line 973: IF p_batchstep_resource_rec.cost_analysis_code = fnd_api.g_miss_char THEN

969:
970: CLOSE cur_get_batch_asqc;
971:
972: /* Bug 3620264 - compare analysis code to G_MISS_CHAR instead of G_MISS_NUM */
973: IF p_batchstep_resource_rec.cost_analysis_code = fnd_api.g_miss_char THEN
974: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
975: ,'FIELD_NAME'
976: ,'COST_ANALYSIS_CODE');
977: RAISE input_param_missing;

Line 1002: IF p_batchstep_resource_rec.cost_cmpntcls_id = fnd_api.g_miss_num THEN

998: l_batchstep_resource_rec.cost_analysis_code :=
999: p_batchstep_resource_rec.cost_analysis_code;
1000: END IF;
1001:
1002: IF p_batchstep_resource_rec.cost_cmpntcls_id = fnd_api.g_miss_num THEN
1003: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1004: ,'FIELD_NAME'
1005: ,'COST_COMPONENT_CLASS_ID');
1006: RAISE input_param_missing;

Line 1032: IF p_batchstep_resource_rec.scale_type = fnd_api.g_miss_num THEN

1028: l_batchstep_resource_rec.cost_cmpntcls_id :=
1029: p_batchstep_resource_rec.cost_cmpntcls_id;
1030: END IF;
1031:
1032: IF p_batchstep_resource_rec.scale_type = fnd_api.g_miss_num THEN
1033: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1034: ,'FIELD_NAME'
1035: ,'scale_type');
1036: RAISE input_param_missing;

Line 1051: IF p_batchstep_resource_rec.prim_rsrc_ind = fnd_api.g_miss_num THEN

1047: l_batchstep_resource_rec.scale_type :=
1048: p_batchstep_resource_rec.scale_type;
1049: END IF;
1050:
1051: IF p_batchstep_resource_rec.prim_rsrc_ind = fnd_api.g_miss_num THEN
1052: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1053: ,'FIELD_NAME'
1054: ,'prim_rsrc_ind');
1055: RAISE input_param_missing;

Line 1071: IF p_batchstep_resource_rec.plan_rsrc_count = fnd_api.g_miss_num

1067: p_batchstep_resource_rec.prim_rsrc_ind;
1068: END IF;
1069:
1070: --Pawan Kumar added trunc to give only integer value to count
1071: IF p_batchstep_resource_rec.plan_rsrc_count = fnd_api.g_miss_num
1072: AND l_step_status = 1 THEN
1073: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1074: ,'FIELD_NAME'
1075: ,'plan_rsrc_cout');

Line 1105: fnd_api.g_miss_num

1101: END IF;
1102: END IF;
1103:
1104: IF p_batchstep_resource_rec.actual_rsrc_count =
1105: fnd_api.g_miss_num
1106: AND l_step_status = 3 THEN
1107: l_batchstep_resource_rec.actual_rsrc_count :=
1108: l_batchstep_resource_rec.plan_rsrc_count;
1109: ELSIF p_batchstep_resource_rec.actual_rsrc_count IS NOT NULL THEN

Line 1141: IF p_batchstep_resource_rec.plan_rsrc_usage = fnd_api.g_miss_num

1137: RAISE input_param_missing;
1138: END IF;
1139: END IF;
1140:
1141: IF p_batchstep_resource_rec.plan_rsrc_usage = fnd_api.g_miss_num
1142: AND l_step_status = 1 THEN
1143: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1144: ,'FIELD_NAME'
1145: ,'plan_rsrc_usage');

Line 1167: fnd_api.g_miss_num

1163: END IF;
1164: END IF;
1165:
1166: IF p_batchstep_resource_rec.actual_rsrc_usage =
1167: fnd_api.g_miss_num
1168: AND l_step_status = 3 THEN
1169: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1170: ,'FIELD_NAME'
1171: ,'actual_rsrc_usage');

Line 1210: IF p_batchstep_resource_rec.plan_rsrc_qty = fnd_api.g_miss_num

1206: ,'usage_uom');
1207: RAISE error_condition;
1208: END IF;
1209:
1210: IF p_batchstep_resource_rec.plan_rsrc_qty = fnd_api.g_miss_num
1211: AND l_step_status = 1 THEN
1212: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1213: ,'FIELD_NAME'
1214: ,'plan_rsrc_qty');

Line 1238: IF p_batchstep_resource_rec.actual_rsrc_qty = fnd_api.g_miss_num

1234: p_batchstep_resource_rec.plan_rsrc_qty;
1235: END IF;
1236: END IF;
1237:
1238: IF p_batchstep_resource_rec.actual_rsrc_qty = fnd_api.g_miss_num
1239: AND l_step_status = 3 THEN
1240: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1241: ,'FIELD_NAME'
1242: ,'actual_rsrc_qty');

Line 1372: fnd_api.g_miss_date THEN

1368: RAISE invalid_date;
1369: END IF;
1370:
1371: IF p_batchstep_resource_rec.actual_start_date =
1372: fnd_api.g_miss_date THEN
1373: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1374: ,'FIELD_NAME'
1375: ,'actual_start_date');
1376: RAISE input_param_missing;

Line 1395: fnd_api.g_miss_date THEN

1391: l_batchstep_resource_rec.actual_start_date :=
1392: p_batchstep_resource_rec.actual_start_date;
1393:
1394: IF p_batchstep_resource_rec.actual_cmplt_date =
1395: fnd_api.g_miss_date THEN
1396: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1397: ,'FIELD_NAME'
1398: ,'actual_cmplt_date');
1399: RAISE input_param_missing;

Line 1419: fnd_api.g_miss_date THEN

1415: p_batchstep_resource_rec.actual_cmplt_date;
1416: ELSE
1417: IF p_batchstep_resource_rec.actual_start_date IS NOT NULL THEN
1418: IF p_batchstep_resource_rec.actual_start_date =
1419: fnd_api.g_miss_date THEN
1420: gme_common_pvt.log_message
1421: ('GME_FIELD_VALUE_REQUIRED'
1422: ,'FIELD_NAME'
1423: ,'actual_start_date');

Line 1461: fnd_api.g_miss_date THEN

1457:
1458: IF ( p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
1459: AND l_step_status = 3) THEN
1460: IF p_batchstep_resource_rec.actual_cmplt_date =
1461: fnd_api.g_miss_date THEN
1462: gme_common_pvt.log_message
1463: ('GME_FIELD_VALUE_REQUIRED'
1464: ,'FIELD_NAME'
1465: ,'actual_cmplt_date');

Line 1524: IF p_ignore_qty_below_cap = fnd_api.g_false THEN

1520: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
1521: ,'RESOURCE'
1522: ,l_batchstep_resource_rec.resources);
1523:
1524: IF p_ignore_qty_below_cap = fnd_api.g_false THEN
1525: RAISE process_qty_error;
1526: END IF;
1527: END IF;
1528:

Line 1537: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1533: ,p_validate_flexfield => p_validate_flexfield
1534: ,x_batchstep_resource_rec => l_batchstep_resource_rec_out
1535: ,x_return_status => l_return_status);
1536:
1537: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1538: RAISE flex_consolidation_error;
1539: ELSE
1540: l_batchstep_resource_rec := l_batchstep_resource_rec_out;
1541: END IF;

Line 1553: IF p_validate_flexfield = fnd_api.g_true THEN

1549: || l_api_name
1550: || ' start flexfield validation ');
1551: END IF;
1552:
1553: IF p_validate_flexfield = fnd_api.g_true THEN
1554: gme_validate_flex_fld_pvt.validate_flex_step_resources
1555: (p_step_resources => l_batchstep_resource_rec
1556: ,x_step_resources => l_batchstep_resource_rec_out
1557: ,x_return_status => l_return_status);

Line 1559: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1555: (p_step_resources => l_batchstep_resource_rec
1556: ,x_step_resources => l_batchstep_resource_rec_out
1557: ,x_return_status => l_return_status);
1558:
1559: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1560: RAISE flex_validation_error;
1561: ELSE
1562: l_batchstep_resource_rec := l_batchstep_resource_rec_out;
1563: END IF;

Line 1577: WHEN fnd_api.g_exc_error THEN

1573: || ' at '
1574: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1575: END IF;
1576: EXCEPTION
1577: WHEN fnd_api.g_exc_error THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: WHEN invalid_step_status OR invalid_asqc OR invalid_activity_factor OR invalid_date OR date_outside_range OR invalid_action THEN
1580: x_return_status := fnd_api.g_ret_sts_error;
1581: WHEN cost_cmpnt_not_found OR analysis_code_not_found OR invalid_prim_rsrc_ind OR invalid_scale_type OR input_param_missing OR error_condition OR flex_validation_error OR flex_consolidation_error OR rsrc_fetch_error THEN

Line 1578: x_return_status := fnd_api.g_ret_sts_error;

1574: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1575: END IF;
1576: EXCEPTION
1577: WHEN fnd_api.g_exc_error THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: WHEN invalid_step_status OR invalid_asqc OR invalid_activity_factor OR invalid_date OR date_outside_range OR invalid_action THEN
1580: x_return_status := fnd_api.g_ret_sts_error;
1581: WHEN cost_cmpnt_not_found OR analysis_code_not_found OR invalid_prim_rsrc_ind OR invalid_scale_type OR input_param_missing OR error_condition OR flex_validation_error OR flex_consolidation_error OR rsrc_fetch_error THEN
1582: x_return_status := fnd_api.g_ret_sts_error;

Line 1580: x_return_status := fnd_api.g_ret_sts_error;

1576: EXCEPTION
1577: WHEN fnd_api.g_exc_error THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: WHEN invalid_step_status OR invalid_asqc OR invalid_activity_factor OR invalid_date OR date_outside_range OR invalid_action THEN
1580: x_return_status := fnd_api.g_ret_sts_error;
1581: WHEN cost_cmpnt_not_found OR analysis_code_not_found OR invalid_prim_rsrc_ind OR invalid_scale_type OR input_param_missing OR error_condition OR flex_validation_error OR flex_consolidation_error OR rsrc_fetch_error THEN
1582: x_return_status := fnd_api.g_ret_sts_error;
1583: WHEN OTHERS THEN
1584: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1582: x_return_status := fnd_api.g_ret_sts_error;

1578: x_return_status := fnd_api.g_ret_sts_error;
1579: WHEN invalid_step_status OR invalid_asqc OR invalid_activity_factor OR invalid_date OR date_outside_range OR invalid_action THEN
1580: x_return_status := fnd_api.g_ret_sts_error;
1581: WHEN cost_cmpnt_not_found OR analysis_code_not_found OR invalid_prim_rsrc_ind OR invalid_scale_type OR input_param_missing OR error_condition OR flex_validation_error OR flex_consolidation_error OR rsrc_fetch_error THEN
1582: x_return_status := fnd_api.g_ret_sts_error;
1583: WHEN OTHERS THEN
1584: x_return_status := fnd_api.g_ret_sts_unexp_error;
1585: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1586: END validate_rsrc_param;

Line 1584: x_return_status := fnd_api.g_ret_sts_unexp_error;

1580: x_return_status := fnd_api.g_ret_sts_error;
1581: WHEN cost_cmpnt_not_found OR analysis_code_not_found OR invalid_prim_rsrc_ind OR invalid_scale_type OR input_param_missing OR error_condition OR flex_validation_error OR flex_consolidation_error OR rsrc_fetch_error THEN
1582: x_return_status := fnd_api.g_ret_sts_error;
1583: WHEN OTHERS THEN
1584: x_return_status := fnd_api.g_ret_sts_unexp_error;
1585: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1586: END validate_rsrc_param;
1587:
1588: /*===========================================================================================

Line 1637: x_return_status := fnd_api.g_ret_sts_success;

1633: || l_api_name);
1634: END IF;
1635:
1636: /* Initially let us assign the return status to success */
1637: x_return_status := fnd_api.g_ret_sts_success;
1638: l_batchstep_resource_rec := p_batchstep_resource_rec;
1639:
1640: IF l_batchstep_resource_rec.offset_interval IS NULL THEN
1641: l_batchstep_resource_rec.offset_interval := 0;

Line 1732: x_return_status := fnd_api.g_ret_sts_error;

1728: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1729: END IF;
1730: EXCEPTION
1731: WHEN validation_failure OR rsrc_not_found OR rsrc_insert_failure OR error_condition THEN
1732: x_return_status := fnd_api.g_ret_sts_error;
1733: WHEN OTHERS THEN
1734: x_return_status := fnd_api.g_ret_sts_unexp_error;
1735: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1736: END insert_batchstep_rsrc;

Line 1734: x_return_status := fnd_api.g_ret_sts_unexp_error;

1730: EXCEPTION
1731: WHEN validation_failure OR rsrc_not_found OR rsrc_insert_failure OR error_condition THEN
1732: x_return_status := fnd_api.g_ret_sts_error;
1733: WHEN OTHERS THEN
1734: x_return_status := fnd_api.g_ret_sts_unexp_error;
1735: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1736: END insert_batchstep_rsrc;
1737:
1738: /*===========================================================================================

Line 1840: x_return_status := fnd_api.g_ret_sts_success;

1836: || l_api_name);
1837: END IF;
1838:
1839: /* Initially let us assign the return status to success */
1840: x_return_status := fnd_api.g_ret_sts_success;
1841: /* Get Batch step resource info */
1842: l_rsrc_id := p_batchstep_resource_rec.batchstep_resource_id;
1843:
1844: OPEN cur_get_step_dtl (l_rsrc_id);

Line 1967: x_return_status := fnd_api.g_ret_sts_error;

1963: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1964: END IF;
1965: EXCEPTION
1966: WHEN validation_failure OR analysis_code_not_found OR cost_cmpnt_not_found OR rsrc_fetch_error THEN
1967: x_return_status := fnd_api.g_ret_sts_error;
1968: WHEN rsrc_not_valid OR rsrc_update_failure OR input_param_missing THEN
1969: x_return_status := fnd_api.g_ret_sts_error;
1970: WHEN rsrc_not_found OR validate_param_failed OR invalid_action OR invalid_scale_type OR process_qty_error OR invalid_date OR date_outside_range OR invalid_prim_rsrc_ind OR no_change OR invalid_step_status OR error_condition THEN
1971: x_return_status := fnd_api.g_ret_sts_error;

Line 1969: x_return_status := fnd_api.g_ret_sts_error;

1965: EXCEPTION
1966: WHEN validation_failure OR analysis_code_not_found OR cost_cmpnt_not_found OR rsrc_fetch_error THEN
1967: x_return_status := fnd_api.g_ret_sts_error;
1968: WHEN rsrc_not_valid OR rsrc_update_failure OR input_param_missing THEN
1969: x_return_status := fnd_api.g_ret_sts_error;
1970: WHEN rsrc_not_found OR validate_param_failed OR invalid_action OR invalid_scale_type OR process_qty_error OR invalid_date OR date_outside_range OR invalid_prim_rsrc_ind OR no_change OR invalid_step_status OR error_condition THEN
1971: x_return_status := fnd_api.g_ret_sts_error;
1972: WHEN OTHERS THEN
1973: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1971: x_return_status := fnd_api.g_ret_sts_error;

1967: x_return_status := fnd_api.g_ret_sts_error;
1968: WHEN rsrc_not_valid OR rsrc_update_failure OR input_param_missing THEN
1969: x_return_status := fnd_api.g_ret_sts_error;
1970: WHEN rsrc_not_found OR validate_param_failed OR invalid_action OR invalid_scale_type OR process_qty_error OR invalid_date OR date_outside_range OR invalid_prim_rsrc_ind OR no_change OR invalid_step_status OR error_condition THEN
1971: x_return_status := fnd_api.g_ret_sts_error;
1972: WHEN OTHERS THEN
1973: x_return_status := fnd_api.g_ret_sts_unexp_error;
1974: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1975: END update_batchstep_rsrc;

Line 1973: x_return_status := fnd_api.g_ret_sts_unexp_error;

1969: x_return_status := fnd_api.g_ret_sts_error;
1970: WHEN rsrc_not_found OR validate_param_failed OR invalid_action OR invalid_scale_type OR process_qty_error OR invalid_date OR date_outside_range OR invalid_prim_rsrc_ind OR no_change OR invalid_step_status OR error_condition THEN
1971: x_return_status := fnd_api.g_ret_sts_error;
1972: WHEN OTHERS THEN
1973: x_return_status := fnd_api.g_ret_sts_unexp_error;
1974: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1975: END update_batchstep_rsrc;
1976:
1977: /*===========================================================================================

Line 2004: x_return_status := fnd_api.g_ret_sts_success;

2000: || l_api_name);
2001: END IF;
2002:
2003: /* Initially let us assign the return status to success */
2004: x_return_status := fnd_api.g_ret_sts_success;
2005: -- load temp table so that save_batch routine does resource txn consolidation
2006: l_batch_header.batch_id := p_batchstep_resource_rec.batch_id;
2007:
2008: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header

Line 2049: x_return_status := fnd_api.g_ret_sts_error;

2045: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
2046: END IF;
2047: EXCEPTION
2048: WHEN error_deleting_rsrc OR error_condition THEN
2049: x_return_status := fnd_api.g_ret_sts_error;
2050: WHEN OTHERS THEN
2051: x_return_status := fnd_api.g_ret_sts_unexp_error;
2052: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2053: END delete_batchstep_rsrc;

Line 2051: x_return_status := fnd_api.g_ret_sts_unexp_error;

2047: EXCEPTION
2048: WHEN error_deleting_rsrc OR error_condition THEN
2049: x_return_status := fnd_api.g_ret_sts_error;
2050: WHEN OTHERS THEN
2051: x_return_status := fnd_api.g_ret_sts_unexp_error;
2052: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2053: END delete_batchstep_rsrc;
2054:
2055: FUNCTION date_within_activity_dates (

Line 2183: DEFAULT fnd_api.g_false

2179: PROCEDURE consolidate_flexfields (
2180: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2181: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2182: ,p_validate_flexfield IN VARCHAR2
2183: DEFAULT fnd_api.g_false
2184: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2185: ,x_return_status OUT NOCOPY VARCHAR2)
2186: IS
2187: l_api_name CONSTANT VARCHAR2 (30) := 'consolidate_flexfields';

Line 2198: x_return_status := fnd_api.g_ret_sts_success;

2194: || l_api_name);
2195: END IF;
2196:
2197: /* Initially let us assign the return status to success */
2198: x_return_status := fnd_api.g_ret_sts_success;
2199: l_batchstep_resource_rec := p_old_batchstep_resource_rec;
2200:
2201: IF p_validate_flexfield = fnd_api.g_false THEN
2202: -- start with the old record

Line 2201: IF p_validate_flexfield = fnd_api.g_false THEN

2197: /* Initially let us assign the return status to success */
2198: x_return_status := fnd_api.g_ret_sts_success;
2199: l_batchstep_resource_rec := p_old_batchstep_resource_rec;
2200:
2201: IF p_validate_flexfield = fnd_api.g_false THEN
2202: -- start with the old record
2203: -- field values will be overwritten by data from the new record as appropriate
2204: -- Follow these rules when interpreting inputs from the new rec:
2205: -- NULL means update value not supplied so retain the original (old) value

Line 2210: fnd_api.g_miss_char THEN

2206: -- G_MISS_??? means update with a NULL value
2207: -- NOT NULL update with the supplied value
2208: IF p_new_batchstep_resource_rec.attribute_category IS NOT NULL THEN
2209: IF p_new_batchstep_resource_rec.attribute_category =
2210: fnd_api.g_miss_char THEN
2211: l_batchstep_resource_rec.attribute_category := NULL;
2212: ELSE
2213: l_batchstep_resource_rec.attribute_category :=
2214: p_new_batchstep_resource_rec.attribute_category;

Line 2219: IF p_new_batchstep_resource_rec.attribute1 = fnd_api.g_miss_char THEN

2215: END IF;
2216: END IF;
2217:
2218: IF p_new_batchstep_resource_rec.attribute1 IS NOT NULL THEN
2219: IF p_new_batchstep_resource_rec.attribute1 = fnd_api.g_miss_char THEN
2220: l_batchstep_resource_rec.attribute1 := NULL;
2221: ELSE
2222: l_batchstep_resource_rec.attribute1 :=
2223: p_new_batchstep_resource_rec.attribute1;

Line 2228: IF p_new_batchstep_resource_rec.attribute2 = fnd_api.g_miss_char THEN

2224: END IF;
2225: END IF;
2226:
2227: IF p_new_batchstep_resource_rec.attribute2 IS NOT NULL THEN
2228: IF p_new_batchstep_resource_rec.attribute2 = fnd_api.g_miss_char THEN
2229: l_batchstep_resource_rec.attribute2 := NULL;
2230: ELSE
2231: l_batchstep_resource_rec.attribute2 :=
2232: p_new_batchstep_resource_rec.attribute2;

Line 2237: IF p_new_batchstep_resource_rec.attribute3 = fnd_api.g_miss_char THEN

2233: END IF;
2234: END IF;
2235:
2236: IF p_new_batchstep_resource_rec.attribute3 IS NOT NULL THEN
2237: IF p_new_batchstep_resource_rec.attribute3 = fnd_api.g_miss_char THEN
2238: l_batchstep_resource_rec.attribute3 := NULL;
2239: ELSE
2240: l_batchstep_resource_rec.attribute3 :=
2241: p_new_batchstep_resource_rec.attribute3;

Line 2246: IF p_new_batchstep_resource_rec.attribute4 = fnd_api.g_miss_char THEN

2242: END IF;
2243: END IF;
2244:
2245: IF p_new_batchstep_resource_rec.attribute4 IS NOT NULL THEN
2246: IF p_new_batchstep_resource_rec.attribute4 = fnd_api.g_miss_char THEN
2247: l_batchstep_resource_rec.attribute4 := NULL;
2248: ELSE
2249: l_batchstep_resource_rec.attribute4 :=
2250: p_new_batchstep_resource_rec.attribute4;

Line 2255: IF p_new_batchstep_resource_rec.attribute5 = fnd_api.g_miss_char THEN

2251: END IF;
2252: END IF;
2253:
2254: IF p_new_batchstep_resource_rec.attribute5 IS NOT NULL THEN
2255: IF p_new_batchstep_resource_rec.attribute5 = fnd_api.g_miss_char THEN
2256: l_batchstep_resource_rec.attribute5 := NULL;
2257: ELSE
2258: l_batchstep_resource_rec.attribute5 :=
2259: p_new_batchstep_resource_rec.attribute5;

Line 2264: IF p_new_batchstep_resource_rec.attribute6 = fnd_api.g_miss_char THEN

2260: END IF;
2261: END IF;
2262:
2263: IF p_new_batchstep_resource_rec.attribute6 IS NOT NULL THEN
2264: IF p_new_batchstep_resource_rec.attribute6 = fnd_api.g_miss_char THEN
2265: l_batchstep_resource_rec.attribute6 := NULL;
2266: ELSE
2267: l_batchstep_resource_rec.attribute6 :=
2268: p_new_batchstep_resource_rec.attribute6;

Line 2273: IF p_new_batchstep_resource_rec.attribute7 = fnd_api.g_miss_char THEN

2269: END IF;
2270: END IF;
2271:
2272: IF p_new_batchstep_resource_rec.attribute7 IS NOT NULL THEN
2273: IF p_new_batchstep_resource_rec.attribute7 = fnd_api.g_miss_char THEN
2274: l_batchstep_resource_rec.attribute7 := NULL;
2275: ELSE
2276: l_batchstep_resource_rec.attribute7 :=
2277: p_new_batchstep_resource_rec.attribute7;

Line 2282: IF p_new_batchstep_resource_rec.attribute8 = fnd_api.g_miss_char THEN

2278: END IF;
2279: END IF;
2280:
2281: IF p_new_batchstep_resource_rec.attribute8 IS NOT NULL THEN
2282: IF p_new_batchstep_resource_rec.attribute8 = fnd_api.g_miss_char THEN
2283: l_batchstep_resource_rec.attribute8 := NULL;
2284: ELSE
2285: l_batchstep_resource_rec.attribute8 :=
2286: p_new_batchstep_resource_rec.attribute8;

Line 2291: IF p_new_batchstep_resource_rec.attribute9 = fnd_api.g_miss_char THEN

2287: END IF;
2288: END IF;
2289:
2290: IF p_new_batchstep_resource_rec.attribute9 IS NOT NULL THEN
2291: IF p_new_batchstep_resource_rec.attribute9 = fnd_api.g_miss_char THEN
2292: l_batchstep_resource_rec.attribute9 := NULL;
2293: ELSE
2294: l_batchstep_resource_rec.attribute9 :=
2295: p_new_batchstep_resource_rec.attribute9;

Line 2300: IF p_new_batchstep_resource_rec.attribute10 = fnd_api.g_miss_char THEN

2296: END IF;
2297: END IF;
2298:
2299: IF p_new_batchstep_resource_rec.attribute10 IS NOT NULL THEN
2300: IF p_new_batchstep_resource_rec.attribute10 = fnd_api.g_miss_char THEN
2301: l_batchstep_resource_rec.attribute10 := NULL;
2302: ELSE
2303: l_batchstep_resource_rec.attribute10 :=
2304: p_new_batchstep_resource_rec.attribute10;

Line 2309: IF p_new_batchstep_resource_rec.attribute11 = fnd_api.g_miss_char THEN

2305: END IF;
2306: END IF;
2307:
2308: IF p_new_batchstep_resource_rec.attribute11 IS NOT NULL THEN
2309: IF p_new_batchstep_resource_rec.attribute11 = fnd_api.g_miss_char THEN
2310: l_batchstep_resource_rec.attribute11 := NULL;
2311: ELSE
2312: l_batchstep_resource_rec.attribute11 :=
2313: p_new_batchstep_resource_rec.attribute11;

Line 2318: IF p_new_batchstep_resource_rec.attribute12 = fnd_api.g_miss_char THEN

2314: END IF;
2315: END IF;
2316:
2317: IF p_new_batchstep_resource_rec.attribute12 IS NOT NULL THEN
2318: IF p_new_batchstep_resource_rec.attribute12 = fnd_api.g_miss_char THEN
2319: l_batchstep_resource_rec.attribute12 := NULL;
2320: ELSE
2321: l_batchstep_resource_rec.attribute12 :=
2322: p_new_batchstep_resource_rec.attribute12;

Line 2327: IF p_new_batchstep_resource_rec.attribute13 = fnd_api.g_miss_char THEN

2323: END IF;
2324: END IF;
2325:
2326: IF p_new_batchstep_resource_rec.attribute13 IS NOT NULL THEN
2327: IF p_new_batchstep_resource_rec.attribute13 = fnd_api.g_miss_char THEN
2328: l_batchstep_resource_rec.attribute13 := NULL;
2329: ELSE
2330: l_batchstep_resource_rec.attribute13 :=
2331: p_new_batchstep_resource_rec.attribute13;

Line 2336: IF p_new_batchstep_resource_rec.attribute14 = fnd_api.g_miss_char THEN

2332: END IF;
2333: END IF;
2334:
2335: IF p_new_batchstep_resource_rec.attribute14 IS NOT NULL THEN
2336: IF p_new_batchstep_resource_rec.attribute14 = fnd_api.g_miss_char THEN
2337: l_batchstep_resource_rec.attribute14 := NULL;
2338: ELSE
2339: l_batchstep_resource_rec.attribute14 :=
2340: p_new_batchstep_resource_rec.attribute14;

Line 2345: IF p_new_batchstep_resource_rec.attribute15 = fnd_api.g_miss_char THEN

2341: END IF;
2342: END IF;
2343:
2344: IF p_new_batchstep_resource_rec.attribute15 IS NOT NULL THEN
2345: IF p_new_batchstep_resource_rec.attribute15 = fnd_api.g_miss_char THEN
2346: l_batchstep_resource_rec.attribute15 := NULL;
2347: ELSE
2348: l_batchstep_resource_rec.attribute15 :=
2349: p_new_batchstep_resource_rec.attribute15;

Line 2354: IF p_new_batchstep_resource_rec.attribute16 = fnd_api.g_miss_char THEN

2350: END IF;
2351: END IF;
2352:
2353: IF p_new_batchstep_resource_rec.attribute16 IS NOT NULL THEN
2354: IF p_new_batchstep_resource_rec.attribute16 = fnd_api.g_miss_char THEN
2355: l_batchstep_resource_rec.attribute16 := NULL;
2356: ELSE
2357: l_batchstep_resource_rec.attribute16 :=
2358: p_new_batchstep_resource_rec.attribute16;

Line 2363: IF p_new_batchstep_resource_rec.attribute17 = fnd_api.g_miss_char THEN

2359: END IF;
2360: END IF;
2361:
2362: IF p_new_batchstep_resource_rec.attribute17 IS NOT NULL THEN
2363: IF p_new_batchstep_resource_rec.attribute17 = fnd_api.g_miss_char THEN
2364: l_batchstep_resource_rec.attribute17 := NULL;
2365: ELSE
2366: l_batchstep_resource_rec.attribute17 :=
2367: p_new_batchstep_resource_rec.attribute17;

Line 2372: IF p_new_batchstep_resource_rec.attribute18 = fnd_api.g_miss_char THEN

2368: END IF;
2369: END IF;
2370:
2371: IF p_new_batchstep_resource_rec.attribute18 IS NOT NULL THEN
2372: IF p_new_batchstep_resource_rec.attribute18 = fnd_api.g_miss_char THEN
2373: l_batchstep_resource_rec.attribute18 := NULL;
2374: ELSE
2375: l_batchstep_resource_rec.attribute18 :=
2376: p_new_batchstep_resource_rec.attribute18;

Line 2381: IF p_new_batchstep_resource_rec.attribute19 = fnd_api.g_miss_char THEN

2377: END IF;
2378: END IF;
2379:
2380: IF p_new_batchstep_resource_rec.attribute19 IS NOT NULL THEN
2381: IF p_new_batchstep_resource_rec.attribute19 = fnd_api.g_miss_char THEN
2382: l_batchstep_resource_rec.attribute19 := NULL;
2383: ELSE
2384: l_batchstep_resource_rec.attribute19 :=
2385: p_new_batchstep_resource_rec.attribute19;

Line 2390: IF p_new_batchstep_resource_rec.attribute20 = fnd_api.g_miss_char THEN

2386: END IF;
2387: END IF;
2388:
2389: IF p_new_batchstep_resource_rec.attribute20 IS NOT NULL THEN
2390: IF p_new_batchstep_resource_rec.attribute20 = fnd_api.g_miss_char THEN
2391: l_batchstep_resource_rec.attribute20 := NULL;
2392: ELSE
2393: l_batchstep_resource_rec.attribute20 :=
2394: p_new_batchstep_resource_rec.attribute20;

Line 2399: IF p_new_batchstep_resource_rec.attribute21 = fnd_api.g_miss_char THEN

2395: END IF;
2396: END IF;
2397:
2398: IF p_new_batchstep_resource_rec.attribute21 IS NOT NULL THEN
2399: IF p_new_batchstep_resource_rec.attribute21 = fnd_api.g_miss_char THEN
2400: l_batchstep_resource_rec.attribute21 := NULL;
2401: ELSE
2402: l_batchstep_resource_rec.attribute21 :=
2403: p_new_batchstep_resource_rec.attribute21;

Line 2408: IF p_new_batchstep_resource_rec.attribute22 = fnd_api.g_miss_char THEN

2404: END IF;
2405: END IF;
2406:
2407: IF p_new_batchstep_resource_rec.attribute22 IS NOT NULL THEN
2408: IF p_new_batchstep_resource_rec.attribute22 = fnd_api.g_miss_char THEN
2409: l_batchstep_resource_rec.attribute22 := NULL;
2410: ELSE
2411: l_batchstep_resource_rec.attribute22 :=
2412: p_new_batchstep_resource_rec.attribute22;

Line 2417: IF p_new_batchstep_resource_rec.attribute23 = fnd_api.g_miss_char THEN

2413: END IF;
2414: END IF;
2415:
2416: IF p_new_batchstep_resource_rec.attribute23 IS NOT NULL THEN
2417: IF p_new_batchstep_resource_rec.attribute23 = fnd_api.g_miss_char THEN
2418: l_batchstep_resource_rec.attribute23 := NULL;
2419: ELSE
2420: l_batchstep_resource_rec.attribute23 :=
2421: p_new_batchstep_resource_rec.attribute23;

Line 2426: IF p_new_batchstep_resource_rec.attribute24 = fnd_api.g_miss_char THEN

2422: END IF;
2423: END IF;
2424:
2425: IF p_new_batchstep_resource_rec.attribute24 IS NOT NULL THEN
2426: IF p_new_batchstep_resource_rec.attribute24 = fnd_api.g_miss_char THEN
2427: l_batchstep_resource_rec.attribute24 := NULL;
2428: ELSE
2429: l_batchstep_resource_rec.attribute24 :=
2430: p_new_batchstep_resource_rec.attribute24;

Line 2435: IF p_new_batchstep_resource_rec.attribute25 = fnd_api.g_miss_char THEN

2431: END IF;
2432: END IF;
2433:
2434: IF p_new_batchstep_resource_rec.attribute25 IS NOT NULL THEN
2435: IF p_new_batchstep_resource_rec.attribute25 = fnd_api.g_miss_char THEN
2436: l_batchstep_resource_rec.attribute25 := NULL;
2437: ELSE
2438: l_batchstep_resource_rec.attribute25 :=
2439: p_new_batchstep_resource_rec.attribute25;

Line 2444: IF p_new_batchstep_resource_rec.attribute26 = fnd_api.g_miss_char THEN

2440: END IF;
2441: END IF;
2442:
2443: IF p_new_batchstep_resource_rec.attribute26 IS NOT NULL THEN
2444: IF p_new_batchstep_resource_rec.attribute26 = fnd_api.g_miss_char THEN
2445: l_batchstep_resource_rec.attribute26 := NULL;
2446: ELSE
2447: l_batchstep_resource_rec.attribute26 :=
2448: p_new_batchstep_resource_rec.attribute26;

Line 2453: IF p_new_batchstep_resource_rec.attribute27 = fnd_api.g_miss_char THEN

2449: END IF;
2450: END IF;
2451:
2452: IF p_new_batchstep_resource_rec.attribute27 IS NOT NULL THEN
2453: IF p_new_batchstep_resource_rec.attribute27 = fnd_api.g_miss_char THEN
2454: l_batchstep_resource_rec.attribute27 := NULL;
2455: ELSE
2456: l_batchstep_resource_rec.attribute27 :=
2457: p_new_batchstep_resource_rec.attribute27;

Line 2462: IF p_new_batchstep_resource_rec.attribute28 = fnd_api.g_miss_char THEN

2458: END IF;
2459: END IF;
2460:
2461: IF p_new_batchstep_resource_rec.attribute28 IS NOT NULL THEN
2462: IF p_new_batchstep_resource_rec.attribute28 = fnd_api.g_miss_char THEN
2463: l_batchstep_resource_rec.attribute28 := NULL;
2464: ELSE
2465: l_batchstep_resource_rec.attribute28 :=
2466: p_new_batchstep_resource_rec.attribute28;

Line 2471: IF p_new_batchstep_resource_rec.attribute29 = fnd_api.g_miss_char THEN

2467: END IF;
2468: END IF;
2469:
2470: IF p_new_batchstep_resource_rec.attribute29 IS NOT NULL THEN
2471: IF p_new_batchstep_resource_rec.attribute29 = fnd_api.g_miss_char THEN
2472: l_batchstep_resource_rec.attribute29 := NULL;
2473: ELSE
2474: l_batchstep_resource_rec.attribute29 :=
2475: p_new_batchstep_resource_rec.attribute29;

Line 2480: IF p_new_batchstep_resource_rec.attribute30 = fnd_api.g_miss_char THEN

2476: END IF;
2477: END IF;
2478:
2479: IF p_new_batchstep_resource_rec.attribute30 IS NOT NULL THEN
2480: IF p_new_batchstep_resource_rec.attribute30 = fnd_api.g_miss_char THEN
2481: l_batchstep_resource_rec.attribute30 := NULL;
2482: ELSE
2483: l_batchstep_resource_rec.attribute30 :=
2484: p_new_batchstep_resource_rec.attribute30;

Line 2565: x_return_status := fnd_api.g_ret_sts_unexp_error;

2561: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
2562: END IF;
2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: x_return_status := fnd_api.g_ret_sts_unexp_error;
2566: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2567: END consolidate_flexfields;
2568: END gme_batchstep_rsrc_pvt;