DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_CUST_WF dependencies on FND_MESSAGE

Line 168: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_INVAL_FIND_APPROVER_METHOD');

164: p_special_instr);
165: END IF;
166:
167: ELSE
168: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_INVAL_FIND_APPROVER_METHOD');
169: p_error_message := FND_MESSAGE.Get;
170: return;
171:
172: /* p_error_message := 'Invalid Find Approver Method';

Line 169: p_error_message := FND_MESSAGE.Get;

165: END IF;
166:
167: ELSE
168: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_INVAL_FIND_APPROVER_METHOD');
169: p_error_message := FND_MESSAGE.Get;
170: return;
171:
172: /* p_error_message := 'Invalid Find Approver Method';
173: return; */

Line 180: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_NO_APPROVER_FOUND');

176: IF (p_next_approver_id IS NULL AND p_error_message IS NULL) THEN
177: ------------------------------------
178: l_debug_info := 'No approver found';
179: ------------------------------------
180: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_NO_APPROVER_FOUND');
181: p_error_message := FND_MESSAGE.Get;
182: END IF;
183:
184: IF (p_next_approver_id = p_employee_id) THEN

Line 181: p_error_message := FND_MESSAGE.Get;

177: ------------------------------------
178: l_debug_info := 'No approver found';
179: ------------------------------------
180: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_NO_APPROVER_FOUND');
181: p_error_message := FND_MESSAGE.Get;
182: END IF;
183:
184: IF (p_next_approver_id = p_employee_id) THEN
185: ---------------------------------------------

Line 188: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');

184: IF (p_next_approver_id = p_employee_id) THEN
185: ---------------------------------------------
186: l_debug_info := 'Loop in Approval Hierarchy';
187: ---------------------------------------------
188: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
189: p_error_message := FND_MESSAGE.Get;
190: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
191: p_instructions := FND_MESSAGE.Get;
192: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

Line 189: p_error_message := FND_MESSAGE.Get;

185: ---------------------------------------------
186: l_debug_info := 'Loop in Approval Hierarchy';
187: ---------------------------------------------
188: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
189: p_error_message := FND_MESSAGE.Get;
190: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
191: p_instructions := FND_MESSAGE.Get;
192: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
193: p_special_instr := FND_MESSAGE.Get;

Line 190: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');

186: l_debug_info := 'Loop in Approval Hierarchy';
187: ---------------------------------------------
188: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
189: p_error_message := FND_MESSAGE.Get;
190: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
191: p_instructions := FND_MESSAGE.Get;
192: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
193: p_special_instr := FND_MESSAGE.Get;
194: END IF;

Line 191: p_instructions := FND_MESSAGE.Get;

187: ---------------------------------------------
188: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
189: p_error_message := FND_MESSAGE.Get;
190: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
191: p_instructions := FND_MESSAGE.Get;
192: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
193: p_special_instr := FND_MESSAGE.Get;
194: END IF;
195:

Line 192: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

188: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
189: p_error_message := FND_MESSAGE.Get;
190: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
191: p_instructions := FND_MESSAGE.Get;
192: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
193: p_special_instr := FND_MESSAGE.Get;
194: END IF;
195:
196: EXCEPTION

Line 193: p_special_instr := FND_MESSAGE.Get;

189: p_error_message := FND_MESSAGE.Get;
190: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
191: p_instructions := FND_MESSAGE.Get;
192: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
193: p_special_instr := FND_MESSAGE.Get;
194: END IF;
195:
196: EXCEPTION
197: WHEN OTHERS THEN

Line 395: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_COST_CTR_DIFF');

391: IF ((l_emp_cost_center <> l_doc_cost_center) AND
392: (l_curr_approver_id IS NULL) AND
393: (nvl(l_ApprReqCC,'N') = 'Y')) THEN
394:
395: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_COST_CTR_DIFF');
396: l_error_message := FND_MESSAGE.Get;
397: raise fixable_exception ;
398:
399:

Line 396: l_error_message := FND_MESSAGE.Get;

392: (l_curr_approver_id IS NULL) AND
393: (nvl(l_ApprReqCC,'N') = 'Y')) THEN
394:
395: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_COST_CTR_DIFF');
396: l_error_message := FND_MESSAGE.Get;
397: raise fixable_exception ;
398:
399:
400: /* l_error_message := 'The Expense Report Cost Center is different

Line 421: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_COST_CTR_DIFF');

417: IF (l_curr_approver_id IS NULL) AND
418: (l_emp_cost_center <> l_doc_cost_center) AND
419: (nvl(l_ApprReqCC,'N') = 'Y') THEN
420:
421: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_COST_CTR_DIFF');
422: l_error_message := FND_MESSAGE.Get;
423: raise fixable_exception ;
424: END IF; --IF (l_emp_cost_center <> l_doc_cost_center)
425:

Line 422: l_error_message := FND_MESSAGE.Get;

418: (l_emp_cost_center <> l_doc_cost_center) AND
419: (nvl(l_ApprReqCC,'N') = 'Y') THEN
420:
421: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_EXP_COST_CTR_DIFF');
422: l_error_message := FND_MESSAGE.Get;
423: raise fixable_exception ;
424: END IF; --IF (l_emp_cost_center <> l_doc_cost_center)
425:
426: -------------------------------------------

Line 465: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');

461: transactionTypeIn => p_item_type,
462: nextApproverOut => l_recNextApprover);
463: EXCEPTION
464: when others then
465: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
466: l_error_message := FND_MESSAGE.Get;
467: -- bug 3257576
468: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
469: l_instructions := FND_MESSAGE.Get;

Line 466: l_error_message := FND_MESSAGE.Get;

462: nextApproverOut => l_recNextApprover);
463: EXCEPTION
464: when others then
465: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
466: l_error_message := FND_MESSAGE.Get;
467: -- bug 3257576
468: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
469: l_instructions := FND_MESSAGE.Get;
470: raise fixable_exception ;

Line 468: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');

464: when others then
465: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
466: l_error_message := FND_MESSAGE.Get;
467: -- bug 3257576
468: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
469: l_instructions := FND_MESSAGE.Get;
470: raise fixable_exception ;
471: END;
472:

Line 469: l_instructions := FND_MESSAGE.Get;

465: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
466: l_error_message := FND_MESSAGE.Get;
467: -- bug 3257576
468: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
469: l_instructions := FND_MESSAGE.Get;
470: raise fixable_exception ;
471: END;
472:
473: /*

Line 488: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');

484: transactionTypeIn => p_item_type,
485: adminApproverOut => l_adminApprover);
486: EXCEPTION
487: when others then
488: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
489: l_error_message := FND_MESSAGE.Get;
490: -- bug 3257576
491: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
492: l_instructions := FND_MESSAGE.Get;

Line 489: l_error_message := FND_MESSAGE.Get;

485: adminApproverOut => l_adminApprover);
486: EXCEPTION
487: when others then
488: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
489: l_error_message := FND_MESSAGE.Get;
490: -- bug 3257576
491: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
492: l_instructions := FND_MESSAGE.Get;
493: raise fixable_exception ;

Line 491: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');

487: when others then
488: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
489: l_error_message := FND_MESSAGE.Get;
490: -- bug 3257576
491: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
492: l_instructions := FND_MESSAGE.Get;
493: raise fixable_exception ;
494: END;
495:

Line 492: l_instructions := FND_MESSAGE.Get;

488: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
489: l_error_message := FND_MESSAGE.Get;
490: -- bug 3257576
491: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
492: l_instructions := FND_MESSAGE.Get;
493: raise fixable_exception ;
494: END;
495:
496: if l_recNextApprover.person_id = l_adminApprover.person_id then

Line 498: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');

494: END;
495:
496: if l_recNextApprover.person_id = l_adminApprover.person_id then
497: if l_adminApprover.person_id <> l_dir_manager_id then
498: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
499: l_error_message := FND_MESSAGE.Get;
500: -- bug 3257576
501: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
502: l_instructions := FND_MESSAGE.Get;

Line 499: l_error_message := FND_MESSAGE.Get;

495:
496: if l_recNextApprover.person_id = l_adminApprover.person_id then
497: if l_adminApprover.person_id <> l_dir_manager_id then
498: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
499: l_error_message := FND_MESSAGE.Get;
500: -- bug 3257576
501: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
502: l_instructions := FND_MESSAGE.Get;
503: raise fixable_exception ;

Line 501: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');

497: if l_adminApprover.person_id <> l_dir_manager_id then
498: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
499: l_error_message := FND_MESSAGE.Get;
500: -- bug 3257576
501: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
502: l_instructions := FND_MESSAGE.Get;
503: raise fixable_exception ;
504: else
505: l_next_approver_id := l_recNextApprover.person_id;

Line 502: l_instructions := FND_MESSAGE.Get;

498: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
499: l_error_message := FND_MESSAGE.Get;
500: -- bug 3257576
501: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
502: l_instructions := FND_MESSAGE.Get;
503: raise fixable_exception ;
504: else
505: l_next_approver_id := l_recNextApprover.person_id;
506: end if;