[Home] [Help]
211: p_messages => l_messages,
212: p_property_table => l_timecard_props
213: );
214:
215: hxc_timecard_message_helper.processerrors
216: (p_messages => l_messages);
217:
218: -- Determine if this is a resubmitted timecard
219: l_timecard_index :=
268: --dbms_output.put_line('online retrieval error : '||substr(l_message,1,255));
269:
270: rollback to TC_APPROVAL_SAVEPOINT;
271:
272: hxc_timecard_message_helper.processerrors
273: (p_messages => l_messages);
274: end if;
275: END IF;
276:
275: END IF;
276:
277: -- Absences end
278:
279: hxc_timecard_message_helper.processerrors
280: (p_messages => l_messages);
281:
282: hxc_timecard_summary_pkg.update_summary_row
283: (p_timecard_id => p_timecard_id,
341:
342: l_index NUMBER;
343: BEGIN
344: fnd_msg_pub.initialize;
345: hxc_timecard_message_helper.initializeerrors;
346:
347: --This is done in the call to hxc_timecard_validation.deposit_validation
348: --hxc_time_category_utils_pkg.push_timecard (p_blocks, p_attributes);
349:
359: p_deposit_mode => hxc_timecard.c_save,
360: p_template => hxc_timecard.c_no,
361: p_messages => p_messages
362: );
363: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
364: -- First we are getting the preferences
365: l_timecard_index :=
366: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
367:
406: p_for_timecard => FALSE,
407: p_messages => p_messages,
408: p_property_table => l_timecard_props
409: );
410: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
411:
412: -- Bug 9023209
413: -- API absences validation
414: hxc_retrieve_absences.verify_view_only_absences
481: p_days => l_day_blocks,
482: p_details => l_detail_blocks,
483: p_messages => p_messages
484: );
485: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
486: -- Add the security attributes
487: -- ARR: 115.26 Add message structure
488: hxc_security.add_security_attribute
489: (p_blocks => p_blocks,
490: p_attributes => p_attributes,
491: p_timecard_props => l_timecard_props,
492: p_messages => p_messages
493: );
494: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
495: -- Translate any aliases
496: hxc_timecard_deposit_common.alias_translation
497: (p_blocks => p_blocks,
498: p_attributes => p_attributes,
497: (p_blocks => p_blocks,
498: p_attributes => p_attributes,
499: p_messages => p_messages
500: );
501: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
502:
503: -- Set the block and attribute update process flags Based on the data sent
504: -- and in the db
505: hxc_block_attribute_update.set_process_flags
517: ,p_attributes => p_attributes
518: ,p_messages => p_messages
519: );
520:
521: hxc_timecard_message_helper.processerrors
522: (p_messages => p_messages);
523: */ -- Call time entry rules for save
524:
525:
542: (p_messages => p_messages,
543: p_old_messages => l_old_messages,
544: p_retrieval_process_id => NULL
545: );
546: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
547: */
548:
549: -- Added the following validation code for bug 8900783
550: -- This validation is to check if the timecard start and stop times falls within the
561: p_timecard_stop_time => trunc(l_timecard_stop_time),
562: p_messages => p_messages
563: );
564:
565: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
566:
567:
568:
569: -- Call hxc_timecard_validation.deposit_validation to do this along with
581: p_can_deposit => l_can_deposit
582: );
583:
584:
585: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
586:
587: --svg start Bug 9181950
588: if NOT hxc_timecard_message_helper.noErrors then
589: --HXC_SVG_LOG.record_log('Reached here:svg');
584:
585: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
586:
587: --svg start Bug 9181950
588: if NOT hxc_timecard_message_helper.noErrors then
589: --HXC_SVG_LOG.record_log('Reached here:svg');
590: if g_debug then
591: hr_utility.trace('SVG: Rollingback to savepoint TC_SAVE_SAVEPOINT for any Projects related updates');
592: end if;
596:
597:
598:
599: -- Store blocks and attributes
600: IF hxc_timecard_message_helper.noerrors
601: THEN
602: hxc_timecard_deposit.EXECUTE
603: (p_blocks => p_blocks,
604: p_attributes => p_attributes,
607: p_detail_blocks => l_detail_blocks,
608: p_messages => p_messages,
609: p_transaction_info => l_transaction_info
610: );
611: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
612: --
613: -- Maintain summary table
614: --
615: hxc_timecard_summary_api.timecard_deposit
628: (p_blocks => p_blocks,
629: p_attributes => p_attributes);
630:
631:
632: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
633: END IF;
634:
635: -- get all the errors
636: p_messages := hxc_timecard_message_helper.getmessages;
632: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
633: END IF;
634:
635: -- get all the errors
636: p_messages := hxc_timecard_message_helper.getmessages;
637: p_timecard_id :=
638: p_blocks
639: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
640: ).time_building_block_id;
645:
646:
647: -- OTL-Absences Integration (Bug 8779478)
648: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
649: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
650: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope) THEN
651:
652: IF g_debug THEN
653: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMESTORE_DEPOSIT_UTIL.SAVE_TIMECARD');
691: EXIT;
692: END IF;
693: END LOOP;
694:
695: hxc_timecard_message_helper.processerrors
696: (p_messages => p_messages);
697:
698: END IF;
699:
771:
772: l_index NUMBER;
773: BEGIN
774: fnd_msg_pub.initialize;
775: hxc_timecard_message_helper.initializeerrors;
776:
777: p_messages := hxc_message_table_type ();
778: hxc_timecard_block_utils.initialize_timecard_index;
779:
787: p_deposit_mode => hxc_timecard.c_submit,
788: p_template => hxc_timecard.c_no,
789: p_messages => p_messages
790: );
791: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
792: -- Determine if this is a resubmitted timecard
793: l_timecard_index :=
794: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
795:
858: p_for_timecard => FALSE,
859: p_messages => p_messages,
860: p_property_table => l_timecard_props
861: );
862: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
863: -- Sort the blocks - needed for deposit and all sorts of short cuts!
864:
865: -- Bug 9023209
866: -- API absences validation
946: p_days => l_day_blocks,
947: p_details => l_detail_blocks,
948: p_messages => p_messages
949: );
950: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
951: END IF;
952:
953: -- Add the security attributes
954: -- ARR: 115.26 Add message structure
957: p_attributes => p_attributes,
958: p_timecard_props => l_timecard_props,
959: p_messages => p_messages
960: );
961: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
962: -- Translate any aliases
963: hxc_timecard_deposit_common.alias_translation
964: (p_blocks => p_blocks,
965: p_attributes => p_attributes,
964: (p_blocks => p_blocks,
965: p_attributes => p_attributes,
966: p_messages => p_messages
967: );
968: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
969:
970: -- Set the block and attribute update process flags based on the data sent
971: -- and in the db
972: hxc_block_attribute_update.set_process_flags
985: p_template => hxc_timecard.c_no,
986: p_deposit_mode => hxc_timecard.c_submit,
987: p_messages => p_messages
988: );
989: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
990:
991:
992: -- Added the following validation code for bug 8900783
993: -- This validation is to check if the timecard start and stop times falls within the
1004: p_timecard_stop_time => trunc(l_timecard_stop_time),
1005: p_messages => p_messages
1006: );
1007:
1008: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1009:
1010: -- Validate blocks, attributes
1011: IF (p_mode <> hxc_timestore_deposit.c_migration
1012: --AND hxc_timestore_deposit.g_validate <> TRUE) -- Commented this condition for the bug 14494474
1028: p_messages => p_messages
1029: );
1030: END IF;
1031:
1032: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1033: -- Validate the set up for the user Do this only for timecards, and not
1034: -- for templates.
1035: /*
1036: hxc_timecard_deposit_common.validate_setup
1039: ,p_attributes => p_attributes
1040: ,p_messages => p_messages
1041: );
1042:
1043: hxc_timecard_message_helper.processerrors
1044: (p_messages => p_messages);
1045: */
1046: -- Reform time data, if required e.g Denormalize time data
1047: hxc_block_attribute_update.denormalize_time (p_blocks => p_blocks,
1050:
1051: IF perform_audit (p_props => l_timecard_props, p_blocks => p_blocks)
1052: THEN
1053: -- Get the messages to perform the audit check
1054: p_messages := hxc_timecard_message_helper.getmessages;
1055: -- Perform Audit Checks
1056: -- Mental Note on how this works:)
1057: -- hxc_timecard_validation.deposit_validation called above, raises
1058: -- proper errors if something is really wrong, e.g. during the
1059: -- project or payroll validation. However for Change and Late Audit
1060: -- (CLA), it stores special messages in message table p_messages.
1061: -- These messages have a message_level of REASON, are not considered
1062: -- errors and will not be recognized by
1063: -- hxc_timecard_message_helper.noerrors as errors.
1064: -- hxc_deposit_checks.audit_checks transforms these REASON errors
1065: -- into proper errors that will be caught by
1066: -- hxc_timecard_message_helper.noerrors.
1067: -- So effectively what we are doing here is converting the audit
1062: -- errors and will not be recognized by
1063: -- hxc_timecard_message_helper.noerrors as errors.
1064: -- hxc_deposit_checks.audit_checks transforms these REASON errors
1065: -- into proper errors that will be caught by
1066: -- hxc_timecard_message_helper.noerrors.
1067: -- So effectively what we are doing here is converting the audit
1068: -- message into errors when the user calls the API and AUDIT is
1069: -- switched on in the preferences of the employee/resource.
1070: -- If the user calls the API and AUDIT is not set, we completely
1072: hxc_deposit_checks.audit_checks (p_blocks => p_blocks,
1073: p_attributes => p_attributes,
1074: p_messages => p_messages
1075: );
1076: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1077: END IF;
1078:
1079: --svg start Bug 9181950
1080: if NOT hxc_timecard_message_helper.noErrors then
1076: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1077: END IF;
1078:
1079: --svg start Bug 9181950
1080: if NOT hxc_timecard_message_helper.noErrors then
1081: --HXC_SVG_LOG.record_log('Reached here:svg');
1082: if g_debug then
1083: hr_utility.trace('SVG: Rollingback to savepoint TC_SUB_SAVEPOINT for any Projects related updates');
1084: end if;
1088:
1089:
1090:
1091: -- Store blocks and attributes
1092: IF hxc_timecard_message_helper.noerrors
1093: THEN
1094: hxc_timecard_deposit.EXECUTE
1095: (p_blocks => p_blocks,
1096: p_attributes => p_attributes,
1103:
1104:
1105:
1106:
1107: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1108: -- set the out parameters
1109: p_timecard_id :=
1110: p_blocks
1111: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
1115: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
1116: ).object_version_number;
1117:
1118: IF ( (p_template <> hxc_timecard.c_yes)
1119: AND (hxc_timecard_message_helper.noerrors)
1120: )
1121: THEN
1122: --
1123: -- Maintain summary table
1145: hxc_timecard_audit.maintain_rdb_snapshot
1146: (p_blocks => p_blocks,
1147: p_attributes => p_attributes);
1148:
1149: hxc_timecard_message_helper.processerrors
1150: (p_messages => p_messages);
1151:
1152: -- OTL-Absences Integration (Bug 8779478)
1153: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y')
1151:
1152: -- OTL-Absences Integration (Bug 8779478)
1153: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y')
1154: THEN
1155: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
1156: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope)
1157: THEN
1158: IF g_debug THEN
1159: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMESTORE_DEPOSIT_UTIL.SUBMIT_TIMECARD');
1198: EXIT;
1199: END IF;
1200: END LOOP;
1201:
1202: hxc_timecard_message_helper.processerrors
1203: (p_messages => p_messages);
1204:
1205: end if;
1206:
1222: p_timecard_props => l_timecard_props,
1223: p_messages => p_messages
1224: );
1225:
1226: hxc_timecard_message_helper.processerrors
1227: (p_messages => p_messages);
1228:
1229: -- Absences start
1230:
1243: --dbms_output.put_line('online retrieval error : '||substr(l_message,1,255));
1244:
1245: rollback to TC_SUB_SAVEPOINT;
1246:
1247: hxc_timecard_message_helper.processerrors
1248: (p_messages => p_messages);
1249: end if;
1250: END IF;
1251:
1258: p_approval_item_key => l_item_key
1259: );
1260: END IF;
1261: ELSIF ( (p_template = hxc_timecard.c_yes)
1262: AND (hxc_timecard_message_helper.noerrors)
1263: )
1264: THEN
1265: hxc_template_summary_api.template_deposit
1266: (p_blocks => p_blocks,
1274: hxc_timecard_audit.audit_deposit
1275: (p_transaction_info => l_transaction_info,
1276: p_messages => p_messages
1277: );
1278: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1279:
1280:
1281:
1282:
1280:
1281:
1282:
1283: IF ( (p_mode = hxc_timestore_deposit.c_migration)
1284: AND (hxc_timecard_message_helper.noerrors)
1285: )
1286: THEN
1287: l_old_transaction_info :=
1288: convert_new_trans_info_to_old
1295: ),
1296: p_overall_status => 'SUCCESS',
1297: p_transaction_tab => l_old_transaction_info
1298: );
1299: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1300: END IF;
1301:
1302: -- get all the errors
1303: p_messages := hxc_timecard_message_helper.getmessages;
1299: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1300: END IF;
1301:
1302: -- get all the errors
1303: p_messages := hxc_timecard_message_helper.getmessages;
1304:
1305: IF g_debug THEN
1306: hr_utility.trace('Leaving SUBMIT_TIMECARD');
1307: END IF;
4005: p_timecard_stop_time > l_future_date_limit ) THEN
4006:
4007: hr_utility.trace('Timecard not within the allowed past and future days limit');
4008:
4009: hxc_timecard_message_helper.addErrorToCollection
4010: (p_messages,
4011: 'HXC_NO_PERIODS_TO_CREATE',
4012: hxc_timecard.c_error,
4013: null,