[Home] [Help]
77: );
78:
79:
80:
81: hxc_timecard_message_helper.processerrors
82: (p_messages => p_messages);
83:
84: /*
85: Add the security attributes
91: p_timecard_props => p_timecard_props,
92: p_messages => p_messages
93: );
94:
95: hxc_timecard_message_helper.processerrors
96: (p_messages => p_messages);
97:
98: /*
99: Translate any aliases
103: ,p_attributes => p_attributes
104: ,p_messages => p_messages
105: );
106:
107: hxc_timecard_message_helper.processerrors
108: (p_messages => p_messages);
109:
110: /*
111: Set the block and attribute update process flags
154: ,p_deposit_mode => hxc_timecard.c_save
155: ,p_messages => p_messages
156: );
157:
158: hxc_timecard_message_helper.processerrors
159: (p_messages => p_messages);
160:
161: /*
162: Validate blocks, attributes - including TERs.
170: ,p_deposit_mode => hxc_timecard.c_save
171: ,p_resubmit => p_resubmit
172: );
173:
174: hxc_timecard_message_helper.processerrors
175: (p_messages => p_messages);
176:
177: hxc_timecard_validation.data_set_validation
178: (p_blocks => p_blocks
178: (p_blocks => p_blocks
179: ,p_messages => p_messages
180: );
181:
182: hxc_timecard_message_helper.processerrors
183: (p_messages => p_messages);
184:
185: /*
186: Store blocks and attributes
185: /*
186: Store blocks and attributes
187: */
188:
189: if hxc_timecard_message_helper.noErrors then
190:
191: hxc_timecard_deposit.execute
192: (p_blocks => p_blocks
193: ,p_attributes => p_attributes
197: ,p_messages => p_messages
198: ,p_transaction_info => l_transaction_info
199: );
200:
201: hxc_timecard_message_helper.processerrors
202: (p_messages => p_messages);
203:
204: end if;
205: if hxc_timecard_message_helper.noErrors then
201: hxc_timecard_message_helper.processerrors
202: (p_messages => p_messages);
203:
204: end if;
205: if hxc_timecard_message_helper.noErrors then
206:
207: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
208:
209: /*
226:
227: hxc_timecard_audit.maintain_latest_details
228: (p_blocks => p_blocks );
229:
230: hxc_timecard_message_helper.processerrors
231: (p_messages => p_messages);
232:
233: end if;
234:
314: ,p_template => p_template
315: ,p_messages => p_messages
316: );
317:
318: hxc_timecard_message_helper.processerrors
319: (p_messages => p_messages);
320:
321: /*
322: Determine if this is a resubmitted timecard
362: ,p_timecard_bb_id => l_tbb_id -- passs the extra parameter timecard ID
363: ,p_timecard_bb_ovn => l_tbb_ovn -- pass the extra parameter timecard OVN
364: );
365:
366: hxc_timecard_message_helper.processerrors
367: (p_messages => p_messages);
368:
369: p_messages.delete;
370:
418: ,p_attributes => l_attributes
419: ,p_messages => p_messages
420: );
421:
422: hxc_timecard_message_helper.processerrors
423: (p_messages => p_messages);
424:
425: /*
426: Hold the completed blocks and attributes
428: there were no error messages from audit
429: validation
430: */
431:
432: if(hxc_timecard_message_helper.noerrors) then
433: g_deposit_blocks := l_blocks;
434: g_deposit_attributes := l_attributes;
435: end if;
436:
472: ,p_messages => p_messages
473: );
474:
475:
476: hxc_timecard_message_helper.processerrors
477: (p_messages => p_messages);
478:
479: p_messages.delete;
480:
490: p_timecard_props => l_timecard_props,
491: p_messages => p_messages
492: );
493:
494: hxc_timecard_message_helper.processerrors
495: (p_messages => p_messages);
496:
497: /*
498: Translate any aliases
505: ,p_messages => p_messages
506: );
507:
508:
509: hxc_timecard_message_helper.processerrors
510: (p_messages => p_messages);
511:
512: /*
513: Set the block and attribute update process flags
544: ,p_deposit_mode => p_deposit_mode
545: ,p_messages => p_messages
546: );
547:
548: hxc_timecard_message_helper.processerrors
549: (p_messages => p_messages);
550: /*
551: Validate blocks, attributes
552: */
562: ,p_resubmit => l_resubmit
563: ,p_can_deposit => l_can_deposit
564: );
565:
566: hxc_timecard_message_helper.processerrors
567: (p_messages => p_messages);
568:
569: --
570: -- Validate the set up for the user
582: );
583:
584: end if;
585:
586: hxc_timecard_message_helper.processerrors
587: (p_messages => p_messages);
588:
589: */
590: /*
615: for immeadiate deposit if required
616: */
617: g_deposit_blocks := l_blocks;
618: g_deposit_attributes := l_attributes;
619: g_audit_messages := hxc_timecard_message_helper.getMessages;
620:
621: end if;
622:
623: if(((p_validate=c_no)OR(p_template=c_yes))AND(l_can_deposit))then
647: ,p_details => l_detail_blocks
648: ,p_messages => p_messages
649: );
650:
651: hxc_timecard_message_helper.processerrors
652: (p_messages => p_messages);
653:
654: p_messages.delete;
655:
657:
658: /*
659: Store blocks and attributes
660: */
661: if(hxc_timecard_message_helper.noErrors) then
662:
663: /*
664: At this point, if we're saving a template,
665: we should look to see if the id corresponding
725: END LOOP;
726:
727: hr_utility.trace('Restrict Blank Rows on Save : '||l_restrict_blank_rows_on_save);
728: -- Added for DA
729: if((p_template <> c_yes) and (hxc_timecard_message_helper.noErrors)) then
730: l_index := g_deposit_blocks.first;
731: LOOP
732: EXIT WHEN NOT g_deposit_blocks.exists(l_index);
733:
821: ,p_messages => p_messages
822: ,p_transaction_info => l_transaction_info
823: );
824:
825: hxc_timecard_message_helper.processerrors
826: (p_messages => p_messages);
827:
828: p_timecard_id := g_deposit_blocks
829: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).time_building_block_id;
830:
831: p_timecard_ovn := g_deposit_blocks
832: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).object_version_number;
833:
834: if((p_template <> c_yes) and (hxc_timecard_message_helper.noErrors)) then
835:
836:
837:
838: -- Maintain summary table
849:
850: hxc_timecard_audit.maintain_latest_details
851: (p_blocks => g_deposit_blocks );
852:
853: hxc_timecard_message_helper.processerrors
854: (p_messages => p_messages);
855:
856: l_item_key :=
857: hxc_timecard_approval.begin_approval
862: p_timecard_props => l_timecard_props,
863: p_messages => p_messages
864: );
865:
866: hxc_timecard_message_helper.processerrors
867: (p_messages => p_messages);
868:
869: hxc_timecard_summary_pkg.update_summary_row
870: (p_timecard_id => p_timecard_id
884: --
885: --115.43 Change Note: The delete on the structures are
886: --in both the if and elsif clauses here, since we must only
887: --delete the structures if there has been a successful deposit,
888: --namely the hxc_timecard_message_helper.noErrors function
889: --returns true. Customer tested this configuration.
890: --
891: g_deposit_blocks.delete;
892: g_deposit_attributes.delete;
890: --
891: g_deposit_blocks.delete;
892: g_deposit_attributes.delete;
893: g_audit_messages.delete;
894: elsif((p_template = c_yes) and (hxc_timecard_message_helper.noErrors)) then
895: hxc_template_summary_api.template_deposit
896: (p_blocks => g_deposit_blocks,
897: p_attributes =>g_deposit_attributes,
898: p_template_id =>p_timecard_id);
913: (p_transaction_info => l_transaction_info
914: ,p_messages => p_messages
915: );
916:
917: hxc_timecard_message_helper.processerrors
918: (p_messages => p_messages);
919:
920: end if;
921:
922: /*
923: Finally, deal with the errors
924: */
925:
926: p_messages := hxc_timecard_message_helper.prepareMessages;
927:
928: END deposit_controller;
929:
930: Procedure create_timecard
965: end if;
966:
967: fnd_msg_pub.initialize;
968:
969: hxc_timecard_message_helper.initializeErrors;
970:
971: p_messages := hxc_message_table_type();
972:
973: if(p_template = hxc_timecard.c_no) then
1031: ,p_timecard_ovn => p_timecard_ovn
1032: );
1033:
1034: if(
1035: ((p_deposit_mode = hxc_timecard.c_save) AND (hxc_timecard_message_helper.noerrors))
1036: OR
1037: ((p_deposit_mode = hxc_timecard.c_submit) AND (p_validate = hxc_timecard.c_no) AND (p_template = hxc_timecard.c_no))
1038: ) then
1039:
1049: ,P_MESSAGES => p_messages
1050: ,P_RELEASED_SUCCESS => l_released_success
1051: );
1052:
1053: elsif ((p_template = hxc_timecard.c_yes) AND (hxc_timecard_message_helper.noerrors))then
1054: --
1055: -- This is important, because we might have saved
1056: -- a timecard as a template, in which case, we should
1057: -- release the lock that we might have
1062: end if;
1063:
1064: else
1065:
1066: hxc_timecard_message_helper.addErrorToCollection
1067: (p_messages
1068: ,'HXC_TIMECARD_LOCK_FAILED'
1069: ,hxc_timecard.c_error
1070: ,null
1300: -- Initialize the message stack
1301: --
1302:
1303: fnd_msg_pub.initialize;
1304: hxc_timecard_message_helper.initializeErrors;
1305: --
1306: -- Get the timecard or timecard template blocks and attributes
1307: --
1308:
1325: ,p_timecard_bb_id => p_timecard_id --passs the extra parameter timecard ID
1326: ,p_timecard_bb_ovn => l_timecard_ovn -- pass the extra parameter timecard OVN
1327: );
1328:
1329: hxc_timecard_message_helper.processerrors
1330: (p_messages => l_messages);
1331:
1332: l_messages.delete;
1333:
1361: p_deposit_mode => p_mode,
1362: p_messages => l_messages
1363: );
1364:
1365: hxc_timecard_message_helper.processerrors
1366: (p_messages => l_messages);
1367:
1368: hxc_timecard_validation.deposit_validation
1369: (p_blocks => l_blocks
1375: ,p_resubmit => c_delete
1376: ,p_can_deposit => l_dummy
1377: );
1378:
1379: hxc_timecard_message_helper.processerrors
1380: (p_messages => l_messages);
1381:
1382: elsif(l_blocks(l_timecard_index).scope = c_template_scope) then
1383:
1385: (l_blocks(l_timecard_index).time_building_block_id
1386: ,l_messages
1387: );
1388:
1389: hxc_timecard_message_helper.processerrors
1390: (p_messages => l_messages);
1391:
1392: end if;
1393:
1390: (p_messages => l_messages);
1391:
1392: end if;
1393:
1394: if(hxc_timecard_message_helper.noErrors) then
1395:
1396: hxc_timecard_deposit.execute
1397: (p_blocks => l_blocks
1398: ,p_attributes => l_attributes
1401: ,p_detail_blocks => l_detail_blocks
1402: ,p_messages => l_messages
1403: ,p_transaction_info => l_transaction_info
1404: );
1405: hxc_timecard_message_helper.processerrors
1406: (p_messages => l_messages);
1407:
1408: /*
1409: Bug 3345143
1426:
1427: hxc_timecard_audit.maintain_latest_details
1428: (p_blocks => l_blocks );
1429: end if;
1430: hxc_timecard_message_helper.processerrors
1431: (p_messages => l_messages);
1432:
1433: end if;
1434:
1434:
1435: hxc_lock_api.release_lock
1436: (p_row_lock_id => l_lock_rowid);
1437:
1438: hxc_timecard_message_helper.prepareErrors;
1439:
1440: end if; -- Is the timecard ok?
1441:
1442: End delete_timecard;