1: PACKAGE body hxc_timekeeper AS
2: /* $Header: hxctimekeeper.pkb 120.7.12010000.2 2008/08/05 12:08:10 ubhat ship $ */
3:
4: g_package varchar2(50) := 'HXC_TIMEKEEPER';
5:
1: PACKAGE body hxc_timekeeper AS
2: /* $Header: hxctimekeeper.pkb 120.7.12010000.2 2008/08/05 12:08:10 ubhat ship $ */
3:
4: g_package varchar2(50) := 'HXC_TIMEKEEPER';
5:
6: ----
7: ----
8: ----
156: --
157: fnd_msg_pub.initialize;
158: /*
159: IF g_debug THEN
160: hxc_debug_timecard.writeTimecard(p_blocks,p_attributes,'HXC_TIMEKEEPER',10);
161: END IF;
162: */
163: ----------------------------------------------------------------------------
164: -- Timecard Preparation
181: );
182: /*
183: -- debug
184: IF g_debug THEN
185: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',20);
186: END IF;
187: */
188: hxc_timecard_message_helper.processerrors
189: (p_messages => p_messages);
207: );
208: /*
209: -- debug
210: IF g_debug THEN
211: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',30);
212: END IF;
213: */
214: hxc_timecard_message_helper.processerrors
215: (p_messages => p_messages);
240: );
241: /*
242: -- debug
243: IF g_debug THEN
244: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',40);
245: END IF;
246: */
247: hxc_timecard_message_helper.processerrors
248: (p_messages => p_messages);
274: );
275: /*
276: -- debug
277: IF g_debug THEN
278: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',50);
279: END IF;
280: */
281: hxc_timecard_message_helper.processerrors
282: (p_messages => p_messages);
314: );
315:
316: -- debug
317: IF g_debug THEN
318: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',60);
319: END IF;
320:
321: hxc_timecard_message_helper.processerrors
322: (p_messages => p_messages);
397: p_messages := hxc_timecard_message_helper.getMessages;
398: /*
399: -- debug
400: IF g_debug THEN
401: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);
402: END IF;
403: */
404: hxc_timekeeper_errors.rollback_tc_or_set_err_status
405: (p_message_table => p_messages
400: IF g_debug THEN
401: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);
402: END IF;
403: */
404: hxc_timekeeper_errors.rollback_tc_or_set_err_status
405: (p_message_table => p_messages
406: ,p_blocks => p_blocks
407: ,p_attributes => p_attributes
408: ,p_rollback => l_rollback
456: if (c_previous_timecard%found) then
457:
458: --Cancel notifications for TK Audit
459:
460: hxc_timekeeper_wf_pkg.cancel_previous_notifications
461: ( p_tk_audit_item_type => l_previous_tk_item_type
462: ,p_tk_audit_item_key => l_previous_tk_item_key
463: );
464:
465: end if;
466: close c_previous_timecard;
467:
468: l_item_key :=
469: hxc_timekeeper_wf_pkg.begin_audit_process
470: (p_timecard_id => p_timecard_id
471: ,p_timecard_ovn => p_timecard_ovn
472: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id
473: ,p_timekeeper_id => p_timekeeper_id
511: -- get all the errors
512: -- p_messages := hxc_timecard_message_helper.getMessages;
513: /*
514: if g_debug THEN
515: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',80);
516: end if;
517: */
518:
519: -- set the out parameters --
517: */
518:
519: -- set the out parameters --
520:
521: hxc_timekeeper_errors.maintain_errors
522: (p_messages => p_messages
523: ,p_timecard_id => p_timecard_id
524: ,p_timecard_ovn => p_timecard_ovn);
525:
758: --set process/changed flag to 'Y'.
759:
760: IF p_messages.count > 0 THEN
761:
762: hxc_timekeeper_utilities.check_msg_set_process_flag
763: ( p_blocks => p_blocks
764: ,p_attributes => p_attributes
765: ,p_messages => p_messages
766: );
841: p_messages := hxc_timecard_message_helper.getMessages;
842: /*
843: -- debug
844: IF g_debug THEN
845: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);
846: END IF;
847: */
848:
849: hxc_timekeeper_errors.rollback_tc_or_set_err_status
845: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);
846: END IF;
847: */
848:
849: hxc_timekeeper_errors.rollback_tc_or_set_err_status
850: (p_message_table => p_messages
851: ,p_blocks => p_blocks
852: ,p_attributes => p_attributes
853: ,p_rollback => l_rollback
892: if (c_previous_timecard%found) then
893:
894: --Cancel notifications for TK Audit
895:
896: hxc_timekeeper_wf_pkg.cancel_previous_notifications
897: ( p_tk_audit_item_type => l_previous_tk_item_type
898: ,p_tk_audit_item_key => l_previous_tk_item_key
899: );
900:
901: end if;
902: close c_previous_timecard;
903:
904: tk_item_key :=
905: hxc_timekeeper_wf_pkg.begin_audit_process
906: (p_timecard_id => p_timecard_id
907: ,p_timecard_ovn => p_timecard_ovn
908: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id
909: ,p_timekeeper_id => p_timekeeper_id
980: );
981:
982: /*
983: if g_debug THEN
984: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',80);
985: end if;
986: */
987: hxc_timekeeper_errors.maintain_errors
988: (p_messages => p_messages
983: if g_debug THEN
984: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',80);
985: end if;
986: */
987: hxc_timekeeper_errors.maintain_errors
988: (p_messages => p_messages
989: ,p_timecard_id => p_timecard_id
990: ,p_timecard_ovn => p_timecard_ovn);
991:
1076: fnd_message.raise_error;
1077: else
1078:
1079: --Cancel notifications for TK Audit
1080: hxc_timekeeper_wf_pkg.cancel_previous_notifications
1081: ( p_tk_audit_item_type => l_previous_tk_item_type
1082: ,p_tk_audit_item_key => l_previous_tk_item_key
1083: );
1084: close c_previous_timecard;
1180: l_messages := hxc_timecard_message_helper.getMessages;
1181: /*
1182: -- debug
1183: IF g_debug THEN
1184: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);
1185: END IF;
1186: */
1187: hxc_timekeeper_errors.rollback_tc_or_set_err_status
1188: (p_message_table => l_messages
1183: IF g_debug THEN
1184: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);
1185: END IF;
1186: */
1187: hxc_timekeeper_errors.rollback_tc_or_set_err_status
1188: (p_message_table => l_messages
1189: ,p_blocks => l_blocks
1190: ,p_attributes => l_attributes
1191: ,p_rollback => l_rollback
1240: -- get all the errors
1241: --l_messages := hxc_timecard_message_helper.getMessages;
1242: /*
1243: if g_debug THEN
1244: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',80);
1245: end if;
1246: */
1247:
1248: hxc_timekeeper_errors.maintain_errors
1244: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',80);
1245: end if;
1246: */
1247:
1248: hxc_timekeeper_errors.maintain_errors
1249: (p_messages => l_messages
1250: ,p_timecard_id => p_timecard_id
1251: ,p_timecard_ovn => l_timecard_ovn);
1252:
1261: End delete_timecard;
1262:
1263:
1264:
1265: END hxc_timekeeper;