DBA Data[Home] [Help]

APPS.AME_API6 dependencies on AME_UTIL

Line 4: ambiguousApproverMessage constant ame_util.longestStringType :=

1: package body ame_api6 as
2: /* $Header: ameeapi6.pkb 120.1 2006/07/22 12:36:15 pvelugul noship $ */
3: ambiguousApproverException exception;
4: ambiguousApproverMessage constant ame_util.longestStringType :=
5: ame_util.getMessage(applicationShortNameIn =>'PER',
6: messageNameIn => 'AME_400249_API_APR_REC_NULL');
7: procedure getApprovers(applicationIdIn in number
8: ,transactionTypeIn in varchar2

Line 5: ame_util.getMessage(applicationShortNameIn =>'PER',

1: package body ame_api6 as
2: /* $Header: ameeapi6.pkb 120.1 2006/07/22 12:36:15 pvelugul noship $ */
3: ambiguousApproverException exception;
4: ambiguousApproverMessage constant ame_util.longestStringType :=
5: ame_util.getMessage(applicationShortNameIn =>'PER',
6: messageNameIn => 'AME_400249_API_APR_REC_NULL');
7: procedure getApprovers(applicationIdIn in number
8: ,transactionTypeIn in varchar2
9: ,transactionIdIn in varchar2

Line 10: ,approversOut out nocopy ame_util.approversTable2) as

6: messageNameIn => 'AME_400249_API_APR_REC_NULL');
7: procedure getApprovers(applicationIdIn in number
8: ,transactionTypeIn in varchar2
9: ,transactionIdIn in varchar2
10: ,approversOut out nocopy ame_util.approversTable2) as
11: ameApplicationId integer;
12: tempIndex integer;
13: cursor approversCursor (applicationIdIn in integer
14: ,transactionIdIn in varchar2) is

Line 86: ame_util.runtimeException(packageNameIn => 'ame_api6',

82: approversOut(tempIndex).source := null;
83: end loop;
84: exception
85: when others then
86: ame_util.runtimeException(packageNameIn => 'ame_api6',
87: routineNameIn => 'getApprovers',
88: exceptionNumberIn => sqlcode,
89: exceptionStringIn => sqlerrm);
90: approversOut.delete;

Line 96: approverIn in ame_util.approverRecord2,

92: end getApprovers;
93: procedure updateApprovalStatus(applicationIdIn in number,
94: transactionTypeIn in varchar2,
95: transactionIdIn in varchar2,
96: approverIn in ame_util.approverRecord2,
97: notificationIn in ame_util2.notificationRecord
98: default ame_util2.emptyNotificationRecord,
99: forwardeeIn in ame_util.approverRecord2 default
100: ame_util.emptyApproverRecord2,

Line 97: notificationIn in ame_util2.notificationRecord

93: procedure updateApprovalStatus(applicationIdIn in number,
94: transactionTypeIn in varchar2,
95: transactionIdIn in varchar2,
96: approverIn in ame_util.approverRecord2,
97: notificationIn in ame_util2.notificationRecord
98: default ame_util2.emptyNotificationRecord,
99: forwardeeIn in ame_util.approverRecord2 default
100: ame_util.emptyApproverRecord2,
101: updateItemIn in boolean default false) as

Line 98: default ame_util2.emptyNotificationRecord,

94: transactionTypeIn in varchar2,
95: transactionIdIn in varchar2,
96: approverIn in ame_util.approverRecord2,
97: notificationIn in ame_util2.notificationRecord
98: default ame_util2.emptyNotificationRecord,
99: forwardeeIn in ame_util.approverRecord2 default
100: ame_util.emptyApproverRecord2,
101: updateItemIn in boolean default false) as
102: errorCode integer;

Line 99: forwardeeIn in ame_util.approverRecord2 default

95: transactionIdIn in varchar2,
96: approverIn in ame_util.approverRecord2,
97: notificationIn in ame_util2.notificationRecord
98: default ame_util2.emptyNotificationRecord,
99: forwardeeIn in ame_util.approverRecord2 default
100: ame_util.emptyApproverRecord2,
101: updateItemIn in boolean default false) as
102: errorCode integer;
103: errorMessage ame_util.longStringType;

Line 100: ame_util.emptyApproverRecord2,

96: approverIn in ame_util.approverRecord2,
97: notificationIn in ame_util2.notificationRecord
98: default ame_util2.emptyNotificationRecord,
99: forwardeeIn in ame_util.approverRecord2 default
100: ame_util.emptyApproverRecord2,
101: updateItemIn in boolean default false) as
102: errorCode integer;
103: errorMessage ame_util.longStringType;
104: begin

Line 103: errorMessage ame_util.longStringType;

99: forwardeeIn in ame_util.approverRecord2 default
100: ame_util.emptyApproverRecord2,
101: updateItemIn in boolean default false) as
102: errorCode integer;
103: errorMessage ame_util.longStringType;
104: begin
105: /* Validate the input approver. */
106: if(approverIn.name is null) then
107: raise ambiguousApproverException;

Line 120: ame_util.runtimeException(packageNameIn => 'ame_api2',

116: exception
117: when ambiguousApproverException then
118: errorCode := -20001;
119: errorMessage := ambiguousApproverMessage;
120: ame_util.runtimeException(packageNameIn => 'ame_api2',
121: routineNameIn => 'updateApprovalStatus',
122: exceptionNumberIn => errorCode,
123: exceptionStringIn => errorMessage);
124: raise_application_error(errorCode,

Line 127: ame_util.runtimeException(packageNameIn => 'ame_api2',

123: exceptionStringIn => errorMessage);
124: raise_application_error(errorCode,
125: errorMessage);
126: when others then
127: ame_util.runtimeException(packageNameIn => 'ame_api2',
128: routineNameIn => 'updateApprovalStatus',
129: exceptionNumberIn => sqlcode,
130: exceptionStringIn => sqlerrm);
131: raise;

Line 143: notificationIn in ame_util2.notificationRecord

139: itemIdIn in varchar2 default null,
140: actionTypeIdIn in number default null,
141: groupOrChainIdIn in number default null,
142: occurrenceIn in number default null,
143: notificationIn in ame_util2.notificationRecord
144: default ame_util2.emptyNotificationRecord,
145: forwardeeIn in ame_util.approverRecord2
146: default ame_util.emptyApproverRecord2,
147: updateItemIn in boolean default false) as

Line 144: default ame_util2.emptyNotificationRecord,

140: actionTypeIdIn in number default null,
141: groupOrChainIdIn in number default null,
142: occurrenceIn in number default null,
143: notificationIn in ame_util2.notificationRecord
144: default ame_util2.emptyNotificationRecord,
145: forwardeeIn in ame_util.approverRecord2
146: default ame_util.emptyApproverRecord2,
147: updateItemIn in boolean default false) as
148: approver ame_util.approverRecord2;

Line 145: forwardeeIn in ame_util.approverRecord2

141: groupOrChainIdIn in number default null,
142: occurrenceIn in number default null,
143: notificationIn in ame_util2.notificationRecord
144: default ame_util2.emptyNotificationRecord,
145: forwardeeIn in ame_util.approverRecord2
146: default ame_util.emptyApproverRecord2,
147: updateItemIn in boolean default false) as
148: approver ame_util.approverRecord2;
149: errorCode integer;

Line 146: default ame_util.emptyApproverRecord2,

142: occurrenceIn in number default null,
143: notificationIn in ame_util2.notificationRecord
144: default ame_util2.emptyNotificationRecord,
145: forwardeeIn in ame_util.approverRecord2
146: default ame_util.emptyApproverRecord2,
147: updateItemIn in boolean default false) as
148: approver ame_util.approverRecord2;
149: errorCode integer;
150: errorMessage ame_util.longStringType;

Line 148: approver ame_util.approverRecord2;

144: default ame_util2.emptyNotificationRecord,
145: forwardeeIn in ame_util.approverRecord2
146: default ame_util.emptyApproverRecord2,
147: updateItemIn in boolean default false) as
148: approver ame_util.approverRecord2;
149: errorCode integer;
150: errorMessage ame_util.longStringType;
151: nullApproverException exception;
152: begin

Line 150: errorMessage ame_util.longStringType;

146: default ame_util.emptyApproverRecord2,
147: updateItemIn in boolean default false) as
148: approver ame_util.approverRecord2;
149: errorCode integer;
150: errorMessage ame_util.longStringType;
151: nullApproverException exception;
152: begin
153: /* No locking needed here as it is done in updateApprovalStatus */
154: if approverNameIn is not null then

Line 180: ame_util.getMessage(applicationShortNameIn =>'PER',

176: exception
177: when nullApproverException then
178: errorCode := -20001;
179: errorMessage :=
180: ame_util.getMessage(applicationShortNameIn =>'PER',
181: messageNameIn => 'AME_400248_API_USR_PER_NULL');
182: ame_util.runtimeException(packageNameIn => 'ame_api2',
183: routineNameIn => 'updateApprovalStatus2',
184: exceptionNumberIn => errorCode,

Line 182: ame_util.runtimeException(packageNameIn => 'ame_api2',

178: errorCode := -20001;
179: errorMessage :=
180: ame_util.getMessage(applicationShortNameIn =>'PER',
181: messageNameIn => 'AME_400248_API_USR_PER_NULL');
182: ame_util.runtimeException(packageNameIn => 'ame_api2',
183: routineNameIn => 'updateApprovalStatus2',
184: exceptionNumberIn => errorCode,
185: exceptionStringIn => errorMessage);
186: raise_application_error(errorCode,

Line 189: ame_util.runtimeException(packageNameIn => 'ame_api2',

185: exceptionStringIn => errorMessage);
186: raise_application_error(errorCode,
187: errorMessage);
188: when others then
189: ame_util.runtimeException(packageNameIn => 'ame_api2',
190: routineNameIn => 'updateApprovalStatus2',
191: exceptionNumberIn => sqlcode,
192: exceptionStringIn => sqlerrm);
193: raise;