DBA Data[Home] [Help]

APPS.PAY_CA_WORKFLOW_API_PKG dependencies on HR_UTILITY

Line 77: hr_utility.trace('Before ROE Assignment Information');

73: ln_complete := 0;
74: ln_error := 0;
75: ln_unprocessed := 0;
76:
77: hr_utility.trace('Before ROE Assignment Information');
78: hr_utility.trace('Document Id '||document_id);
79:
80: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
81: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,

Line 78: hr_utility.trace('Document Id '||document_id);

74: ln_error := 0;
75: ln_unprocessed := 0;
76:
77: hr_utility.trace('Before ROE Assignment Information');
78: hr_utility.trace('Document Id '||document_id);
79:
80: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
81: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
82: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );

Line 85: hr_utility.trace('ln_request_id = '||ln_request_id);

81: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
82: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
83: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
84:
85: hr_utility.trace('ln_request_id = '||ln_request_id);
86: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
87: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
88:
89: FOR asg_roe_info_rec IN asg_roe_info_cur (ln_request_id)

Line 86: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);

82: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
83: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
84:
85: hr_utility.trace('ln_request_id = '||ln_request_id);
86: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
87: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
88:
89: FOR asg_roe_info_rec IN asg_roe_info_cur (ln_request_id)
90: LOOP

Line 87: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);

83: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
84:
85: hr_utility.trace('ln_request_id = '||ln_request_id);
86: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
87: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
88:
89: FOR asg_roe_info_rec IN asg_roe_info_cur (ln_request_id)
90: LOOP
91:

Line 110: hr_utility.trace('Document '||document);

106: document := '

'||X_segment1||'
'||X_segment2||'
'||X_segment3||'

';
107:
108: document := document || l_space||wf_core.newline;
109:
110: hr_utility.trace('Document '||document);
111:
112:
113: document_type := 'text/html';
114:

Line 116: hr_utility.trace('Exception Others');

112:
113: document_type := 'text/html';
114:
115: exception when others then
116: hr_utility.trace('Exception Others');
117:
118: end get_roe_assignment_info;
119:
120:

Line 167: hr_utility.trace('Before ROE MAG Assignment Information');

163: ln_complete := 0;
164: ln_error := 0;
165: ln_unprocessed := 0;
166:
167: hr_utility.trace('Before ROE MAG Assignment Information');
168: hr_utility.trace('Document Id '||document_id);
169:
170: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
171: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,

Line 168: hr_utility.trace('Document Id '||document_id);

164: ln_error := 0;
165: ln_unprocessed := 0;
166:
167: hr_utility.trace('Before ROE MAG Assignment Information');
168: hr_utility.trace('Document Id '||document_id);
169:
170: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
171: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
172: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );

Line 175: hr_utility.trace('ln_request_id = '||ln_request_id);

171: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
172: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
173: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
174:
175: hr_utility.trace('ln_request_id = '||ln_request_id);
176: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
177: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
178:
179: FOR asg_roe_mag_info_rec IN asg_roe_mag_info_cur (ln_request_id)

Line 176: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);

172: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
173: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
174:
175: hr_utility.trace('ln_request_id = '||ln_request_id);
176: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
177: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
178:
179: FOR asg_roe_mag_info_rec IN asg_roe_mag_info_cur (ln_request_id)
180: LOOP

Line 177: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);

173: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
174:
175: hr_utility.trace('ln_request_id = '||ln_request_id);
176: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
177: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
178:
179: FOR asg_roe_mag_info_rec IN asg_roe_mag_info_cur (ln_request_id)
180: LOOP
181:

Line 200: hr_utility.trace('Document '||document);

196: document := '

'||X_segment1||'
'||X_segment2||'
'||X_segment3||'

';
197:
198: document := document || l_space||wf_core.newline;
199:
200: hr_utility.trace('Document '||document);
201:
202: document_type := 'text/html';
203:
204: exception when others then

Line 205: hr_utility.trace('Exception Others');

201:
202: document_type := 'text/html';
203:
204: exception when others then
205: hr_utility.trace('Exception Others');
206:
207: end get_roe_mag_assignment_info;
208:
209: end pay_ca_workflow_api_pkg;