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 145: x_return_status := fnd_api.g_ret_sts_success;

141: || ' **********************************');
142: END IF;
143:
144: /* Initially let us assign the return status to success */
145: x_return_status := fnd_api.g_ret_sts_success;
146:
147: IF p_org_code IS NULL THEN
148: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
149: ,'FIELD_NAME'

Line 293: x_return_status := fnd_api.g_ret_sts_error;

289: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
290: END IF;
291: EXCEPTION
292: WHEN batch_not_found OR batchstep_not_found OR input_param_missing THEN
293: x_return_status := fnd_api.g_ret_sts_error;
294: WHEN stepactivity_not_found OR resource_not_found THEN
295: x_return_status := fnd_api.g_ret_sts_error;
296: WHEN OTHERS THEN
297: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 295: x_return_status := fnd_api.g_ret_sts_error;

291: EXCEPTION
292: WHEN batch_not_found OR batchstep_not_found OR input_param_missing THEN
293: x_return_status := fnd_api.g_ret_sts_error;
294: WHEN stepactivity_not_found OR resource_not_found THEN
295: x_return_status := fnd_api.g_ret_sts_error;
296: WHEN OTHERS THEN
297: x_return_status := fnd_api.g_ret_sts_unexp_error;
298: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
299: END validate_param;

Line 297: x_return_status := fnd_api.g_ret_sts_unexp_error;

293: x_return_status := fnd_api.g_ret_sts_error;
294: WHEN stepactivity_not_found OR resource_not_found THEN
295: x_return_status := fnd_api.g_ret_sts_error;
296: WHEN OTHERS THEN
297: x_return_status := fnd_api.g_ret_sts_unexp_error;
298: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
299: END validate_param;
300:
301: /*===========================================================================================

Line 318: DEFAULT fnd_api.g_false

314: PROCEDURE validate_rsrc_param (
315: p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
316: ,p_activity_id IN NUMBER
317: ,p_ignore_qty_below_cap IN VARCHAR2
318: DEFAULT fnd_api.g_false
319: ,p_validate_flexfield IN VARCHAR2
320: DEFAULT fnd_api.g_false
321: ,p_action IN VARCHAR2
322: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

Line 320: DEFAULT fnd_api.g_false

316: ,p_activity_id IN NUMBER
317: ,p_ignore_qty_below_cap IN VARCHAR2
318: DEFAULT fnd_api.g_false
319: ,p_validate_flexfield IN VARCHAR2
320: DEFAULT fnd_api.g_false
321: ,p_action IN VARCHAR2
322: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
323: ,x_step_status OUT NOCOPY NUMBER
324: ,x_return_status OUT NOCOPY VARCHAR2)

Line 414: x_return_status := fnd_api.g_ret_sts_success;

410: || p_action);
411: END IF;
412:
413: /* Initially let us assign the return status to success */
414: x_return_status := fnd_api.g_ret_sts_success;
415:
416: -- Bug 14037157 - Initialize activity id and execute cursor. Moved from inside INSERT IF statement.
417: l_activity_id := p_activity_id;
418:

Line 948: IF p_ignore_qty_below_cap = fnd_api.g_false THEN

944: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
945: ,'RESOURCE'
946: ,l_batchstep_resource_rec.resources);
947:
948: IF p_ignore_qty_below_cap = fnd_api.g_false THEN
949: RAISE process_qty_error;
950: END IF;
951: END IF;
952:

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

994:
995: CLOSE cur_get_batch_asqc;
996:
997: /* Bug 3620264 - compare analysis code to G_MISS_CHAR instead of G_MISS_NUM */
998: IF p_batchstep_resource_rec.cost_analysis_code = fnd_api.g_miss_char THEN
999: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1000: ,'FIELD_NAME'
1001: ,'COST_ANALYSIS_CODE');
1002: RAISE input_param_missing;

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

1023: l_batchstep_resource_rec.cost_analysis_code :=
1024: p_batchstep_resource_rec.cost_analysis_code;
1025: END IF;
1026:
1027: IF p_batchstep_resource_rec.cost_cmpntcls_id = fnd_api.g_miss_num THEN
1028: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1029: ,'FIELD_NAME'
1030: ,'COST_COMPONENT_CLASS_ID');
1031: RAISE input_param_missing;

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

1053: l_batchstep_resource_rec.cost_cmpntcls_id :=
1054: p_batchstep_resource_rec.cost_cmpntcls_id;
1055: END IF;
1056:
1057: IF p_batchstep_resource_rec.scale_type = fnd_api.g_miss_num THEN
1058: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1059: ,'FIELD_NAME'
1060: ,'scale_type');
1061: RAISE input_param_missing;

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

1072: l_batchstep_resource_rec.scale_type :=
1073: p_batchstep_resource_rec.scale_type;
1074: END IF;
1075:
1076: IF p_batchstep_resource_rec.prim_rsrc_ind = fnd_api.g_miss_num THEN
1077: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1078: ,'FIELD_NAME'
1079: ,'prim_rsrc_ind');
1080: RAISE input_param_missing;

Line 1096: IF p_batchstep_resource_rec.plan_rsrc_count = fnd_api.g_miss_num

1092: p_batchstep_resource_rec.prim_rsrc_ind;
1093: END IF;
1094:
1095: --Pawan Kumar added trunc to give only integer value to count
1096: IF p_batchstep_resource_rec.plan_rsrc_count = fnd_api.g_miss_num
1097: AND l_step_status = 1 THEN
1098: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1099: ,'FIELD_NAME'
1100: ,'plan_rsrc_cout');

Line 1130: fnd_api.g_miss_num

1126: END IF;
1127: END IF;
1128:
1129: IF p_batchstep_resource_rec.actual_rsrc_count =
1130: fnd_api.g_miss_num
1131: AND l_step_status = 3 THEN
1132: l_batchstep_resource_rec.actual_rsrc_count :=
1133: l_batchstep_resource_rec.plan_rsrc_count;
1134: ELSIF p_batchstep_resource_rec.actual_rsrc_count IS NOT NULL THEN

Line 1166: IF p_batchstep_resource_rec.plan_rsrc_usage = fnd_api.g_miss_num

1162: RAISE input_param_missing;
1163: END IF;
1164: END IF;
1165:
1166: IF p_batchstep_resource_rec.plan_rsrc_usage = fnd_api.g_miss_num
1167: AND l_step_status = 1 THEN
1168: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1169: ,'FIELD_NAME'
1170: ,'plan_rsrc_usage');

Line 1192: fnd_api.g_miss_num

1188: END IF;
1189: END IF;
1190:
1191: IF p_batchstep_resource_rec.actual_rsrc_usage =
1192: fnd_api.g_miss_num
1193: AND l_step_status = 3 THEN
1194: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1195: ,'FIELD_NAME'
1196: ,'actual_rsrc_usage');

Line 1235: IF p_batchstep_resource_rec.plan_rsrc_qty = fnd_api.g_miss_num

1231: ,'usage_uom');
1232: RAISE error_condition;
1233: END IF;
1234:
1235: IF p_batchstep_resource_rec.plan_rsrc_qty = fnd_api.g_miss_num
1236: AND l_step_status = 1 THEN
1237: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1238: ,'FIELD_NAME'
1239: ,'plan_rsrc_qty');

Line 1263: IF p_batchstep_resource_rec.actual_rsrc_qty = fnd_api.g_miss_num

1259: p_batchstep_resource_rec.plan_rsrc_qty;
1260: END IF;
1261: END IF;
1262:
1263: IF p_batchstep_resource_rec.actual_rsrc_qty = fnd_api.g_miss_num
1264: AND l_step_status = 3 THEN
1265: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1266: ,'FIELD_NAME'
1267: ,'actual_rsrc_qty');

Line 1397: fnd_api.g_miss_date THEN

1393: RAISE invalid_date;
1394: END IF;
1395:
1396: IF p_batchstep_resource_rec.actual_start_date =
1397: fnd_api.g_miss_date THEN
1398: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1399: ,'FIELD_NAME'
1400: ,'actual_start_date');
1401: RAISE input_param_missing;

Line 1420: fnd_api.g_miss_date THEN

1416: l_batchstep_resource_rec.actual_start_date :=
1417: p_batchstep_resource_rec.actual_start_date;
1418:
1419: IF p_batchstep_resource_rec.actual_cmplt_date =
1420: fnd_api.g_miss_date THEN
1421: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED'
1422: ,'FIELD_NAME'
1423: ,'actual_cmplt_date');
1424: RAISE input_param_missing;

Line 1444: fnd_api.g_miss_date THEN

1440: p_batchstep_resource_rec.actual_cmplt_date;
1441: ELSE
1442: IF p_batchstep_resource_rec.actual_start_date IS NOT NULL THEN
1443: IF p_batchstep_resource_rec.actual_start_date =
1444: fnd_api.g_miss_date THEN
1445: gme_common_pvt.log_message
1446: ('GME_FIELD_VALUE_REQUIRED'
1447: ,'FIELD_NAME'
1448: ,'actual_start_date');

Line 1486: fnd_api.g_miss_date THEN

1482:
1483: IF ( p_batchstep_resource_rec.actual_cmplt_date IS NOT NULL
1484: AND l_step_status = 3) THEN
1485: IF p_batchstep_resource_rec.actual_cmplt_date =
1486: fnd_api.g_miss_date THEN
1487: gme_common_pvt.log_message
1488: ('GME_FIELD_VALUE_REQUIRED'
1489: ,'FIELD_NAME'
1490: ,'actual_cmplt_date');

Line 1549: IF p_ignore_qty_below_cap = fnd_api.g_false THEN

1545: gme_common_pvt.log_message ('GME_RESOURCE_PROCESS_QUANTITY'
1546: ,'RESOURCE'
1547: ,l_batchstep_resource_rec.resources);
1548:
1549: IF p_ignore_qty_below_cap = fnd_api.g_false THEN
1550: RAISE process_qty_error;
1551: END IF;
1552: END IF;
1553:

Line 1562: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1558: ,p_validate_flexfield => p_validate_flexfield
1559: ,x_batchstep_resource_rec => l_batchstep_resource_rec_out
1560: ,x_return_status => l_return_status);
1561:
1562: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1563: RAISE flex_consolidation_error;
1564: ELSE
1565: l_batchstep_resource_rec := l_batchstep_resource_rec_out;
1566: END IF;

Line 1578: IF p_validate_flexfield = fnd_api.g_true THEN

1574: || l_api_name
1575: || ' start flexfield validation ');
1576: END IF;
1577:
1578: IF p_validate_flexfield = fnd_api.g_true THEN
1579: gme_validate_flex_fld_pvt.validate_flex_step_resources
1580: (p_step_resources => l_batchstep_resource_rec
1581: ,x_step_resources => l_batchstep_resource_rec_out
1582: ,x_return_status => l_return_status);

Line 1584: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1580: (p_step_resources => l_batchstep_resource_rec
1581: ,x_step_resources => l_batchstep_resource_rec_out
1582: ,x_return_status => l_return_status);
1583:
1584: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1585: RAISE flex_validation_error;
1586: ELSE
1587: l_batchstep_resource_rec := l_batchstep_resource_rec_out;
1588: END IF;

Line 1602: WHEN fnd_api.g_exc_error THEN

1598: || ' at '
1599: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1600: END IF;
1601: EXCEPTION
1602: WHEN fnd_api.g_exc_error THEN
1603: x_return_status := fnd_api.g_ret_sts_error;
1604: WHEN invalid_step_status OR invalid_asqc OR invalid_activity_factor OR invalid_date OR date_outside_range OR invalid_action THEN
1605: x_return_status := fnd_api.g_ret_sts_error;
1606: 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 1603: x_return_status := fnd_api.g_ret_sts_error;

1599: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1600: END IF;
1601: EXCEPTION
1602: WHEN fnd_api.g_exc_error THEN
1603: x_return_status := fnd_api.g_ret_sts_error;
1604: WHEN invalid_step_status OR invalid_asqc OR invalid_activity_factor OR invalid_date OR date_outside_range OR invalid_action THEN
1605: x_return_status := fnd_api.g_ret_sts_error;
1606: 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
1607: x_return_status := fnd_api.g_ret_sts_error;

Line 1605: x_return_status := fnd_api.g_ret_sts_error;

1601: EXCEPTION
1602: WHEN fnd_api.g_exc_error THEN
1603: x_return_status := fnd_api.g_ret_sts_error;
1604: WHEN invalid_step_status OR invalid_asqc OR invalid_activity_factor OR invalid_date OR date_outside_range OR invalid_action THEN
1605: x_return_status := fnd_api.g_ret_sts_error;
1606: 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
1607: x_return_status := fnd_api.g_ret_sts_error;
1608: WHEN OTHERS THEN
1609: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1607: x_return_status := fnd_api.g_ret_sts_error;

1603: x_return_status := fnd_api.g_ret_sts_error;
1604: WHEN invalid_step_status OR invalid_asqc OR invalid_activity_factor OR invalid_date OR date_outside_range OR invalid_action THEN
1605: x_return_status := fnd_api.g_ret_sts_error;
1606: 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
1607: x_return_status := fnd_api.g_ret_sts_error;
1608: WHEN OTHERS THEN
1609: x_return_status := fnd_api.g_ret_sts_unexp_error;
1610: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1611: END validate_rsrc_param;

Line 1609: x_return_status := fnd_api.g_ret_sts_unexp_error;

1605: x_return_status := fnd_api.g_ret_sts_error;
1606: 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
1607: x_return_status := fnd_api.g_ret_sts_error;
1608: WHEN OTHERS THEN
1609: x_return_status := fnd_api.g_ret_sts_unexp_error;
1610: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1611: END validate_rsrc_param;
1612:
1613: /*===========================================================================================

Line 1662: x_return_status := fnd_api.g_ret_sts_success;

1658: || l_api_name);
1659: END IF;
1660:
1661: /* Initially let us assign the return status to success */
1662: x_return_status := fnd_api.g_ret_sts_success;
1663: l_batchstep_resource_rec := p_batchstep_resource_rec;
1664:
1665: IF l_batchstep_resource_rec.offset_interval IS NULL THEN
1666: l_batchstep_resource_rec.offset_interval := 0;

Line 1757: x_return_status := fnd_api.g_ret_sts_error;

1753: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1754: END IF;
1755: EXCEPTION
1756: WHEN validation_failure OR rsrc_not_found OR rsrc_insert_failure OR error_condition THEN
1757: x_return_status := fnd_api.g_ret_sts_error;
1758: WHEN OTHERS THEN
1759: x_return_status := fnd_api.g_ret_sts_unexp_error;
1760: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1761: END insert_batchstep_rsrc;

Line 1759: x_return_status := fnd_api.g_ret_sts_unexp_error;

1755: EXCEPTION
1756: WHEN validation_failure OR rsrc_not_found OR rsrc_insert_failure OR error_condition THEN
1757: x_return_status := fnd_api.g_ret_sts_error;
1758: WHEN OTHERS THEN
1759: x_return_status := fnd_api.g_ret_sts_unexp_error;
1760: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1761: END insert_batchstep_rsrc;
1762:
1763: /*===========================================================================================

Line 1871: x_return_status := fnd_api.g_ret_sts_success;

1867: || l_api_name);
1868: END IF;
1869:
1870: /* Initially let us assign the return status to success */
1871: x_return_status := fnd_api.g_ret_sts_success;
1872: /* Get Batch step resource info */
1873: l_rsrc_id := p_batchstep_resource_rec.batchstep_resource_id;
1874:
1875: OPEN cur_get_step_dtl (l_rsrc_id);

Line 2002: x_return_status := fnd_api.g_ret_sts_error;

1998: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1999: END IF;
2000: EXCEPTION
2001: WHEN validation_failure OR analysis_code_not_found OR cost_cmpnt_not_found OR rsrc_fetch_error THEN
2002: x_return_status := fnd_api.g_ret_sts_error;
2003: WHEN rsrc_not_valid OR rsrc_update_failure OR input_param_missing THEN
2004: x_return_status := fnd_api.g_ret_sts_error;
2005: 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
2006: x_return_status := fnd_api.g_ret_sts_error;

Line 2004: x_return_status := fnd_api.g_ret_sts_error;

2000: EXCEPTION
2001: WHEN validation_failure OR analysis_code_not_found OR cost_cmpnt_not_found OR rsrc_fetch_error THEN
2002: x_return_status := fnd_api.g_ret_sts_error;
2003: WHEN rsrc_not_valid OR rsrc_update_failure OR input_param_missing THEN
2004: x_return_status := fnd_api.g_ret_sts_error;
2005: 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
2006: x_return_status := fnd_api.g_ret_sts_error;
2007: WHEN OTHERS THEN
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2006: x_return_status := fnd_api.g_ret_sts_error;

2002: x_return_status := fnd_api.g_ret_sts_error;
2003: WHEN rsrc_not_valid OR rsrc_update_failure OR input_param_missing THEN
2004: x_return_status := fnd_api.g_ret_sts_error;
2005: 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
2006: x_return_status := fnd_api.g_ret_sts_error;
2007: WHEN OTHERS THEN
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;
2009: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2010: END update_batchstep_rsrc;

Line 2008: x_return_status := fnd_api.g_ret_sts_unexp_error;

2004: x_return_status := fnd_api.g_ret_sts_error;
2005: 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
2006: x_return_status := fnd_api.g_ret_sts_error;
2007: WHEN OTHERS THEN
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;
2009: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2010: END update_batchstep_rsrc;
2011:
2012: /*===========================================================================================

Line 2039: x_return_status := fnd_api.g_ret_sts_success;

2035: || l_api_name);
2036: END IF;
2037:
2038: /* Initially let us assign the return status to success */
2039: x_return_status := fnd_api.g_ret_sts_success;
2040: -- load temp table so that save_batch routine does resource txn consolidation
2041: l_batch_header.batch_id := p_batchstep_resource_rec.batch_id;
2042:
2043: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header

Line 2084: x_return_status := fnd_api.g_ret_sts_error;

2080: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
2081: END IF;
2082: EXCEPTION
2083: WHEN error_deleting_rsrc OR error_condition THEN
2084: x_return_status := fnd_api.g_ret_sts_error;
2085: WHEN OTHERS THEN
2086: x_return_status := fnd_api.g_ret_sts_unexp_error;
2087: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2088: END delete_batchstep_rsrc;

Line 2086: x_return_status := fnd_api.g_ret_sts_unexp_error;

2082: EXCEPTION
2083: WHEN error_deleting_rsrc OR error_condition THEN
2084: x_return_status := fnd_api.g_ret_sts_error;
2085: WHEN OTHERS THEN
2086: x_return_status := fnd_api.g_ret_sts_unexp_error;
2087: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2088: END delete_batchstep_rsrc;
2089:
2090: FUNCTION date_within_activity_dates (

Line 2218: DEFAULT fnd_api.g_false

2214: PROCEDURE consolidate_flexfields (
2215: p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2216: ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2217: ,p_validate_flexfield IN VARCHAR2
2218: DEFAULT fnd_api.g_false
2219: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2220: ,x_return_status OUT NOCOPY VARCHAR2)
2221: IS
2222: l_api_name CONSTANT VARCHAR2 (30) := 'consolidate_flexfields';

Line 2233: x_return_status := fnd_api.g_ret_sts_success;

2229: || l_api_name);
2230: END IF;
2231:
2232: /* Initially let us assign the return status to success */
2233: x_return_status := fnd_api.g_ret_sts_success;
2234: l_batchstep_resource_rec := p_old_batchstep_resource_rec;
2235:
2236: IF p_validate_flexfield = fnd_api.g_false THEN
2237: -- start with the old record

Line 2236: IF p_validate_flexfield = fnd_api.g_false THEN

2232: /* Initially let us assign the return status to success */
2233: x_return_status := fnd_api.g_ret_sts_success;
2234: l_batchstep_resource_rec := p_old_batchstep_resource_rec;
2235:
2236: IF p_validate_flexfield = fnd_api.g_false THEN
2237: -- start with the old record
2238: -- field values will be overwritten by data from the new record as appropriate
2239: -- Follow these rules when interpreting inputs from the new rec:
2240: -- NULL means update value not supplied so retain the original (old) value

Line 2245: fnd_api.g_miss_char THEN

2241: -- G_MISS_??? means update with a NULL value
2242: -- NOT NULL update with the supplied value
2243: IF p_new_batchstep_resource_rec.attribute_category IS NOT NULL THEN
2244: IF p_new_batchstep_resource_rec.attribute_category =
2245: fnd_api.g_miss_char THEN
2246: l_batchstep_resource_rec.attribute_category := NULL;
2247: ELSE
2248: l_batchstep_resource_rec.attribute_category :=
2249: p_new_batchstep_resource_rec.attribute_category;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2484: END IF;
2485: END IF;
2486:
2487: IF p_new_batchstep_resource_rec.attribute27 IS NOT NULL THEN
2488: IF p_new_batchstep_resource_rec.attribute27 = fnd_api.g_miss_char THEN
2489: l_batchstep_resource_rec.attribute27 := NULL;
2490: ELSE
2491: l_batchstep_resource_rec.attribute27 :=
2492: p_new_batchstep_resource_rec.attribute27;

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

2493: END IF;
2494: END IF;
2495:
2496: IF p_new_batchstep_resource_rec.attribute28 IS NOT NULL THEN
2497: IF p_new_batchstep_resource_rec.attribute28 = fnd_api.g_miss_char THEN
2498: l_batchstep_resource_rec.attribute28 := NULL;
2499: ELSE
2500: l_batchstep_resource_rec.attribute28 :=
2501: p_new_batchstep_resource_rec.attribute28;

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

2502: END IF;
2503: END IF;
2504:
2505: IF p_new_batchstep_resource_rec.attribute29 IS NOT NULL THEN
2506: IF p_new_batchstep_resource_rec.attribute29 = fnd_api.g_miss_char THEN
2507: l_batchstep_resource_rec.attribute29 := NULL;
2508: ELSE
2509: l_batchstep_resource_rec.attribute29 :=
2510: p_new_batchstep_resource_rec.attribute29;

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

2511: END IF;
2512: END IF;
2513:
2514: IF p_new_batchstep_resource_rec.attribute30 IS NOT NULL THEN
2515: IF p_new_batchstep_resource_rec.attribute30 = fnd_api.g_miss_char THEN
2516: l_batchstep_resource_rec.attribute30 := NULL;
2517: ELSE
2518: l_batchstep_resource_rec.attribute30 :=
2519: p_new_batchstep_resource_rec.attribute30;

Line 2600: x_return_status := fnd_api.g_ret_sts_unexp_error;

2596: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
2597: END IF;
2598: EXCEPTION
2599: WHEN OTHERS THEN
2600: x_return_status := fnd_api.g_ret_sts_unexp_error;
2601: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2602: END consolidate_flexfields;
2603: END gme_batchstep_rsrc_pvt;