APPS.AME_APPROVER_DEVIATION_PKG dependencies on AME_APPROVER_DEVIATION_PKG

Line 1: package body ame_approver_deviation_pkg as

1: package body ame_approver_deviation_pkg as
2: /* $Header: ameaprdv.pkb 120.11 2008/02/21 12:45:31 prasashe noship $ */
3: /*check if the any approver is deviated*/
4: function IsTransactionDeviated(deviationListIn in deviationReasonList)
5: return boolean as

Line 54: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

50: where application_id = applicationIdIn
51: and transaction_id = tranasactionId;
52: exception
53: when others then
54: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
55: routineNameIn => 'markTransactionDeviation',
56: exceptionNumberIn => sqlcode,
57: exceptionStringIn => sqlerrm);
58: end;

Line 74: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

70: where application_id = applicationIdIn
71: and transaction_id = tranasactionId;
72: exception
73: when others then
74: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
75: routineNameIn => 'markTransactionDeviation',
76: exceptionNumberIn => sqlcode,
77: exceptionStringIn => sqlerrm);
78: end;

Line 139: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

135: exit when rowsFound < 100;
136: end loop;
137: dbms_sql.close_cursor(dynamicCursor);
138: if tempAttributeValues1.count > 1 then
139: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
140: routineNameIn => 'getTransactionDecription',
141: exceptionNumberIn => -20001,
142: exceptionStringIn => 'sql returned incorrect number of rows');
143: descriptionOut := null;

Line 151: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

147: return;
148: end if;
149: exception
150: when others then
151: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
152: routineNameIn => 'getTransactionDecription',
153: exceptionNumberIn => sqlcode,
154: exceptionStringIn => sqlerrm);
155: descriptionOut := null;

Line 323: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

319: ,null
320: );
321: exception
322: when others then
323: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
324: routineNameIn => 'insertDeviations',
325: exceptionNumberIn => sqlcode,
326: exceptionStringIn => sqlerrm);
327: end;

Line 370: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

366: and lookup_code = templookupcode;
367: exception
368: when others then
369: descrOut := null;
370: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
371: routineNameIn => 'getreasonDescription',
372: exceptionNumberIn => sqlcode,
373: exceptionStringIn => sqlerrm);
374: end;

Line 400: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

396: return;
397: end if;
398: exception
399: when others then
400: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
401: routineNameIn => 'updateDeviationState',
402: exceptionNumberIn => sqlcode,
403: exceptionStringIn => sqlerrm);
404: return;

Line 427: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

423: where temp_transactions_id = tempTransactionKey;
424: return;
425: exception
426: when others then
427: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
428: routineNameIn => 'updateDeviationState',
429: exceptionNumberIn => sqlcode,
430: exceptionStringIn => sqlerrm);
431: end;

Line 489: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

485: fndApplicationIdIn => null,
486: transactionTypeIdIn => null );
487: exception
488: when others then
489: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
490: routineNameIn => 'clearDeviationState',
491: exceptionNumberIn => sqlcode,
492: exceptionStringIn => sqlerrm);
493: end;

Line 606: end ame_approver_deviation_pkg;

602: exception
603: when others then
604: return to_char(P_ENDDATE);
605: end getEndDateParam;
606: end ame_approver_deviation_pkg;