[Home] [Help]
206: p_messages => l_messages,
207: p_property_table => l_timecard_props
208: );
209:
210: hxc_timecard_message_helper.processerrors
211: (p_messages => l_messages);
212:
213: -- Determine if this is a resubmitted timecard
214: l_timecard_index :=
244: p_timecard_props => l_timecard_props,
245: p_messages => l_messages
246: );
247:
248: hxc_timecard_message_helper.processerrors
249: (p_messages => l_messages);
250:
251: hxc_timecard_summary_pkg.update_summary_row
252: (p_timecard_id => p_timecard_id,
295: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
296: l_old_messages hxc_self_service_time_deposit.message_table;
297: BEGIN
298: fnd_msg_pub.initialize;
299: hxc_timecard_message_helper.initializeerrors;
300: hxc_time_category_utils_pkg.push_timecard (p_blocks, p_attributes);
301: p_messages := hxc_message_table_type ();
302: hxc_timecard_block_utils.initialize_timecard_index;
303: -- Check input parameters
306: p_deposit_mode => hxc_timecard.c_save,
307: p_template => hxc_timecard.c_no,
308: p_messages => p_messages
309: );
310: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
311: -- First we are getting the preferences
312: l_timecard_index :=
313: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
314: hxc_timecard_properties.get_preference_properties
323: p_for_timecard => FALSE,
324: p_messages => p_messages,
325: p_property_table => l_timecard_props
326: );
327: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
328: -- p_messages.DELETE;
329: -- Sort blocks
330: hxc_timecard_block_utils.sort_blocks
331: (p_blocks => p_blocks,
340: p_days => l_day_blocks,
341: p_details => l_detail_blocks,
342: p_messages => p_messages
343: );
344: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
345: -- Add the security attributes
346: -- ARR: 115.26 Add message structure
347: hxc_security.add_security_attribute
348: (p_blocks => p_blocks,
349: p_attributes => p_attributes,
350: p_timecard_props => l_timecard_props,
351: p_messages => p_messages
352: );
353: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
354: -- Translate any aliases
355: hxc_timecard_deposit_common.alias_translation
356: (p_blocks => p_blocks,
357: p_attributes => p_attributes,
356: (p_blocks => p_blocks,
357: p_attributes => p_attributes,
358: p_messages => p_messages
359: );
360: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
361: -- Set the block and attribute update process flags Based on the data sent
362: -- and in the db
363: hxc_block_attribute_update.set_process_flags
364: (p_blocks => p_blocks,
375: ,p_attributes => p_attributes
376: ,p_messages => p_messages
377: );
378:
379: hxc_timecard_message_helper.processerrors
380: (p_messages => p_messages);
381: */ -- Call time entry rules for save
382:
383: l_old_style_blks :=
398: (p_messages => p_messages,
399: p_old_messages => l_old_messages,
400: p_retrieval_process_id => NULL
401: );
402: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
403:
404: -- Store blocks and attributes
405: IF hxc_timecard_message_helper.noerrors
406: THEN
401: );
402: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
403:
404: -- Store blocks and attributes
405: IF hxc_timecard_message_helper.noerrors
406: THEN
407: hxc_timecard_deposit.EXECUTE
408: (p_blocks => p_blocks,
409: p_attributes => p_attributes,
412: p_detail_blocks => l_detail_blocks,
413: p_messages => p_messages,
414: p_transaction_info => l_transaction_info
415: );
416: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
417: --
418: -- Maintain summary table
419: --
420: hxc_timecard_summary_api.timecard_deposit
429: hxc_timecard_audit.maintain_latest_details (p_blocks => p_blocks);
430: END IF;
431:
432: -- get all the errors
433: p_messages := hxc_timecard_message_helper.getmessages;
434: p_timecard_id :=
435: p_blocks
436: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
437: ).time_building_block_id;
490: l_item_key wf_items.item_key%TYPE := NULL;
491: l_mode VARCHAR2 (30);
492: BEGIN
493: fnd_msg_pub.initialize;
494: hxc_timecard_message_helper.initializeerrors;
495: p_messages := hxc_message_table_type ();
496: hxc_timecard_block_utils.initialize_timecard_index;
497: -- Check input parameters
498: hxc_deposit_checks.check_inputs
501: p_deposit_mode => hxc_timecard.c_submit,
502: p_template => hxc_timecard.c_no,
503: p_messages => p_messages
504: );
505: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
506: -- Determine if this is a resubmitted timecard
507: l_timecard_index :=
508: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
509:
541: p_for_timecard => FALSE,
542: p_messages => p_messages,
543: p_property_table => l_timecard_props
544: );
545: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
546: -- Sort the blocks - needed for deposit and all sorts of short cuts!
547: hxc_timecard_block_utils.sort_blocks
548: (p_blocks => p_blocks,
549: p_timecard_blocks => l_timecard_blocks,
573: p_days => l_day_blocks,
574: p_details => l_detail_blocks,
575: p_messages => p_messages
576: );
577: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
578: END IF;
579:
580: -- Add the security attributes
581: -- ARR: 115.26 Add message structure
584: p_attributes => p_attributes,
585: p_timecard_props => l_timecard_props,
586: p_messages => p_messages
587: );
588: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
589: -- Translate any aliases
590: hxc_timecard_deposit_common.alias_translation
591: (p_blocks => p_blocks,
592: p_attributes => p_attributes,
591: (p_blocks => p_blocks,
592: p_attributes => p_attributes,
593: p_messages => p_messages
594: );
595: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
596: -- Set the block and attribute update process flags based on the data sent
597: -- and in the db
598: hxc_block_attribute_update.set_process_flags
599: (p_blocks => p_blocks,
611: p_template => hxc_timecard.c_no,
612: p_deposit_mode => hxc_timecard.c_submit,
613: p_messages => p_messages
614: );
615: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
616:
617: -- Validate blocks, attributes
618: IF (p_mode <> hxc_timestore_deposit.c_migration)
619: THEN
633: p_messages => p_messages
634: );
635: END IF;
636:
637: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
638: -- Validate the set up for the user Do this only for timecards, and not
639: -- for templates.
640: /*
641: hxc_timecard_deposit_common.validate_setup
644: ,p_attributes => p_attributes
645: ,p_messages => p_messages
646: );
647:
648: hxc_timecard_message_helper.processerrors
649: (p_messages => p_messages);
650: */
651: -- Reform time data, if required e.g Denormalize time data
652: hxc_block_attribute_update.denormalize_time (p_blocks => p_blocks,
655:
656: IF perform_audit (p_props => l_timecard_props, p_blocks => p_blocks)
657: THEN
658: -- Get the messages to perform the audit check
659: p_messages := hxc_timecard_message_helper.getmessages;
660: -- Perform Audit Checks
661: -- Mental Note on how this works:)
662: -- hxc_timecard_validation.deposit_validation called above, raises
663: -- proper errors if something is really wrong, e.g. during the
664: -- project or payroll validation. However for Change and Late Audit
665: -- (CLA), it stores special messages in message table p_messages.
666: -- These messages have a message_level of REASON, are not considered
667: -- errors and will not be recognized by
668: -- hxc_timecard_message_helper.noerrors as errors.
669: -- hxc_deposit_checks.audit_checks transforms these REASON errors
670: -- into proper errors that will be caught by
671: -- hxc_timecard_message_helper.noerrors.
672: -- So effectively what we are doing here is converting the audit
667: -- errors and will not be recognized by
668: -- hxc_timecard_message_helper.noerrors as errors.
669: -- hxc_deposit_checks.audit_checks transforms these REASON errors
670: -- into proper errors that will be caught by
671: -- hxc_timecard_message_helper.noerrors.
672: -- So effectively what we are doing here is converting the audit
673: -- message into errors when the user calls the API and AUDIT is
674: -- switched on in the preferences of the employee/resource.
675: -- If the user calls the API and AUDIT is not set, we completely
677: hxc_deposit_checks.audit_checks (p_blocks => p_blocks,
678: p_attributes => p_attributes,
679: p_messages => p_messages
680: );
681: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
682: END IF;
683:
684: -- Store blocks and attributes
685: IF hxc_timecard_message_helper.noerrors
681: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
682: END IF;
683:
684: -- Store blocks and attributes
685: IF hxc_timecard_message_helper.noerrors
686: THEN
687: hxc_timecard_deposit.EXECUTE
688: (p_blocks => p_blocks,
689: p_attributes => p_attributes,
692: p_detail_blocks => l_detail_blocks,
693: p_messages => p_messages,
694: p_transaction_info => l_transaction_info
695: );
696: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
697: -- set the out parameters
698: p_timecard_id :=
699: p_blocks
700: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
704: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
705: ).object_version_number;
706:
707: IF ( (p_template <> hxc_timecard.c_yes)
708: AND (hxc_timecard_message_helper.noerrors)
709: )
710: THEN
711: --
712: -- Maintain summary table
728: p_tk_audit_process_name => NULL,
729: p_tk_audit_item_key => NULL
730: );
731: hxc_timecard_audit.maintain_latest_details (p_blocks => p_blocks);
732: hxc_timecard_message_helper.processerrors
733: (p_messages => p_messages);
734:
735: IF (p_mode <> hxc_timestore_deposit.c_migration)
736: THEN
743: p_timecard_props => l_timecard_props,
744: p_messages => p_messages
745: );
746:
747: hxc_timecard_message_helper.processerrors
748: (p_messages => p_messages);
749:
750: hxc_timecard_summary_pkg.update_summary_row
751: (p_timecard_id => p_timecard_id,
754: p_approval_item_key => l_item_key
755: );
756: END IF;
757: ELSIF ( (p_template = hxc_timecard.c_yes)
758: AND (hxc_timecard_message_helper.noerrors)
759: )
760: THEN
761: hxc_template_summary_api.template_deposit
762: (p_blocks => p_blocks,
770: hxc_timecard_audit.audit_deposit
771: (p_transaction_info => l_transaction_info,
772: p_messages => p_messages
773: );
774: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
775:
776: IF ( (p_mode = hxc_timestore_deposit.c_migration)
777: AND (hxc_timecard_message_helper.noerrors)
778: )
773: );
774: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
775:
776: IF ( (p_mode = hxc_timestore_deposit.c_migration)
777: AND (hxc_timecard_message_helper.noerrors)
778: )
779: THEN
780: l_old_transaction_info :=
781: convert_new_trans_info_to_old
788: ),
789: p_overall_status => 'SUCCESS',
790: p_transaction_tab => l_old_transaction_info
791: );
792: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
793: END IF;
794:
795: -- get all the errors
796: p_messages := hxc_timecard_message_helper.getmessages;
792: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
793: END IF;
794:
795: -- get all the errors
796: p_messages := hxc_timecard_message_helper.getmessages;
797: END submit_timecard;
798:
799: -----------------------------------------------------------------------------
800: -- Type: Function