eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_REPLICATE_BANK_BALANCES dependencies on FND_API

Line 90: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

86: x_return_status );
87: END IF;
88:
89:
90: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
91:
92: IF p_action_flag = 'I' THEN /* Insertion of a record */
93:
94: INSERT_BANK_BALANCE ( p_balance_rec, x_return_status);

Line 105: x_return_status := FND_API.G_RET_STS_ERROR;

101:
102: DELETE_BANK_BALANCE( l_balance_rec, x_return_status);
103:
104: ELSE
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: LOG_ERR_MSG('XTR_INV_PARAM','ACTION_FLAG');
107:
108: END IF;
109:

Line 115: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

111:
112:
113: IF (p_action_flag in ('I','U') )THEN
114:
115: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
116: UPDATE_BANK_ACCOUNT ( p_balance_rec.company_code,
117: p_balance_rec.account_number,
118: p_balance_rec.balance_date ,
119: p_action_flag ,

Line 128: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

124: END IF;
125:
126: IF (p_action_flag in ('D') )THEN
127:
128: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
129: UPDATE_BANK_ACCOUNT ( l_balance_rec.company_code,
130: l_balance_rec.account_number,
131: l_balance_rec.balance_date ,
132: 'D' ,

Line 150: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

146: p_balance_rec.statement_balance+p_balance_rec.balance_adjustment,
147: p_balance_rec.balance_cflow,
148: 'D',
149: x_return_status );
150: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
151: DELETE_BANK_BALANCE( p_balance_rec, x_return_status);
152: END IF;
153: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
154: UPDATE_BANK_ACCOUNT ( p_balance_rec.company_code,

Line 153: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

149: x_return_status );
150: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
151: DELETE_BANK_BALANCE( p_balance_rec, x_return_status);
152: END IF;
153: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
154: UPDATE_BANK_ACCOUNT ( p_balance_rec.company_code,
155: p_balance_rec.account_number,
156: p_balance_rec.balance_date ,
157: 'D' ,

Line 161: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

157: 'D' ,
158: x_return_status );
159:
160: END IF;
161: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
162: VALIDATE_BANK_BALANCE(
163: p_balance_rec.company_code,
164: p_balance_rec.account_number,
165: p_balance_rec.balance_date,

Line 172: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

168: p_balance_rec.balance_cflow,
169: 'I',
170: x_return_status );
171: END IF;
172: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
173: INSERT_BANK_BALANCE( p_balance_rec, x_return_status);
174: END IF;
175: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
176: UPDATE_BANK_ACCOUNT ( p_balance_rec.company_code,

Line 175: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

171: END IF;
172: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
173: INSERT_BANK_BALANCE( p_balance_rec, x_return_status);
174: END IF;
175: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
176: UPDATE_BANK_ACCOUNT ( p_balance_rec.company_code,
177: p_balance_rec.account_number,
178: p_balance_rec.balance_date ,
179: 'I',

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

192:
193: EXCEPTION
194:
195: WHEN others THEN
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
198:
199: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
200: ( p_count => x_msg_count ,

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

284: p_balance_date);
285:
286: else
287: close c_conc_cashpool_id;
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:
290: end if;
291:
292:

Line 302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

298:
299: EXCEPTION
300:
301: WHEN others THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
304:
305: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
306: ( p_count => x_msg_count ,

Line 424: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

420:
421:
422:
423: BEGIN
424: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426: OPEN PREV_DETAILS;
427: FETCH PREV_DETAILS INTO l_prv_date,l_prv_bal,l_int_bf,l_prv_rate,l_prv_accrual_int,
428: l_prv_rounding_type, l_prv_day_count_type;

Line 425: x_return_status := FND_API.G_RET_STS_SUCCESS;

421:
422:
423: BEGIN
424: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426: OPEN PREV_DETAILS;
427: FETCH PREV_DETAILS INTO l_prv_date,l_prv_bal,l_int_bf,l_prv_rate,l_prv_accrual_int,
428: l_prv_rounding_type, l_prv_day_count_type;
429: IF PREV_DETAILS%NOTFOUND THEN

Line 583: x_return_status := FND_API.G_RET_STS_ERROR;

579:
580: ELSE
581: CLOSE BANK_ACCT_DETAILS;
582: LOG_ERR_MSG('XTR_INV_PARAM', p_balance_rec.ce_bank_account_balance_id);
583: x_return_status := FND_API.G_RET_STS_ERROR;
584:
585: END IF;
586:
587: EXCEPTION

Line 590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

586:
587: EXCEPTION
588:
589: WHEN others THEN
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
592:
593: END INSERT_BANK_BALANCE ;
594:

Line 617: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

613: l_ce_bank_acct_bal_id xtr_bank_balances.ce_bank_account_balance_id%TYPE;
614:
615:
616: BEGIN
617: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619: OPEN c_chk_lock;
620: FETCH c_chk_lock INTO l_ce_bank_acct_bal_id;
621: IF c_chk_lock%FOUND THEN

Line 618: x_return_status := FND_API.G_RET_STS_SUCCESS;

614:
615:
616: BEGIN
617: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619: OPEN c_chk_lock;
620: FETCH c_chk_lock INTO l_ce_bank_acct_bal_id;
621: IF c_chk_lock%FOUND THEN
622:

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: IF C_CHK_LOCK%ISOPEN THEN
646: CLOSE C_CHK_LOCK;
647: END IF;
648: LOG_ERR_MSG('CHK_LOCK');
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: WHEN others THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
653:

Line 651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

647: END IF;
648: LOG_ERR_MSG('CHK_LOCK');
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: WHEN others THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
653:
654: END UPDATE_BANK_BALANCE;
655:

Line 715: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

711: FOR UPDATE NOWAIT;
712:
713:
714: BEGIN
715: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_return_status := FND_API.G_RET_STS_SUCCESS;
717: OPEN c_chk_acct_lock;
718: FETCH c_chk_acct_lock INTO l_ce_bank_acct_bal_id;
719: IF c_chk_acct_lock%FOUND THEN

Line 716: x_return_status := FND_API.G_RET_STS_SUCCESS;

712:
713:
714: BEGIN
715: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_return_status := FND_API.G_RET_STS_SUCCESS;
717: OPEN c_chk_acct_lock;
718: FETCH c_chk_acct_lock INTO l_ce_bank_acct_bal_id;
719: IF c_chk_acct_lock%FOUND THEN
720:

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: CLOSE C_CHK_DDA_LOCK;
779: END IF;
780:
781: LOG_ERR_MSG('CHK_LOCK');
782: x_return_status := FND_API.G_RET_STS_ERROR;
783:
784:
785: WHEN others THEN
786:

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

784:
785: WHEN others THEN
786:
787: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789:
790: END DELETE_BANK_BALANCE;
791:
792:

Line 860: x_return_status := FND_API.G_RET_STS_SUCCESS;

856:
857:
858: BEGIN
859:
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861:
862: OPEN c_portfolio;
863: FETCH c_portfolio INTO l_portfolio_code, l_currency,l_bank_code, l_pricing_model, l_ce_bank_account_id ;
864:

Line 872: x_return_status := FND_API.G_RET_STS_ERROR;

868: IF p_action_flag IN ( 'I' , 'U') THEN
869:
870: IF p_action_flag = 'I' AND (l_portfolio_code Is null) THEN
871: -- Checking whether the portfolio code exists for the bank account
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: LOG_ERR_MSG ( 'XTR_PORTFOLIO');
874: END IF;
875:
876: CLOSE c_portfolio;

Line 880: x_return_status := FND_API.G_RET_STS_ERROR;

876: CLOSE c_portfolio;
877:
878: -- Checking whether the balance date is greater than sysdate
879: IF p_balance_date > sysdate THEN
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: LOG_ERR_MSG ( 'XTR_104');
882: END IF;
883:
884: -- Checking whether an interest schedule is assigned to the bank account

Line 891: x_return_status := FND_API.G_RET_STS_ERROR;

887: fetch c_int_schedule into l_int_schedule_id ;
888: close c_int_schedule ;
889:
890: If l_int_schedule_id is Null Then
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: LOG_ERR_MSG ( 'CE_NO_SCHED_BANK_ACCT');
893: End If ;
894:
895: -- Checking whether the pricing model is authorised

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

896: If l_pricing_model Is Not Null Then
897: OPEN c_pm_authorized;
898: FETCH c_pm_authorized into l_authorised;
899: if c_pm_authorized%NOTFOUND then
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: LOG_ERR_MSG ( 'XTR_INV_PRICING_MODEL');
902: end if;
903: close c_pm_authorized;
904: End If ;

Line 910: x_return_status := FND_API.G_RET_STS_ERROR;

906: -- Checking the balance does not exist for the date being entered by the user
907: OPEN c_duplicate_date;
908: FETCH c_duplicate_date INTO l_duplicate;
909: IF c_duplicate_date%FOUND AND p_action_flag = 'I' THEN
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: LOG_ERR_MSG ( 'XTR_1237');
912: END IF;
913: CLOSE c_duplicate_date;
914: -- Checking for interest includes/ interest rounding

Line 916: x_return_status := FND_API.G_RET_STS_ERROR;

912: END IF;
913: CLOSE c_duplicate_date;
914: -- Checking for interest includes/ interest rounding
915: IF ((NOT CHK_ROUNDING_CHANGE ( p_company_code ,p_account_number ,p_balance_date )) AND p_interest_calc_balance IS NOT NULL) THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: LOG_ERR_MSG ( 'XTR_TYPES_CHANGED');
918: END IF;
919:
920: -- Checking for revaluations

Line 933: x_return_status := FND_API.G_RET_STS_ERROR;

929: 'E');
930:
931:
932: IF nvl(l_return_error, 'XXX') = 'XTR_CA_REVAL_DONE' THEN
933: x_return_status := FND_API.G_RET_STS_ERROR;
934: LOG_ERR_MSG ( 'XTR_CA_REVAL_DONE');
935: ELSIF nvl(l_return_error, 'XXX') = 'XTR_REVAL_ACCRL_DATE' THEN
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: LOG_ERR_MSG ( 'XTR_REVAL_ACCRL_DATE',p_balance_date);

Line 936: x_return_status := FND_API.G_RET_STS_ERROR;

932: IF nvl(l_return_error, 'XXX') = 'XTR_CA_REVAL_DONE' THEN
933: x_return_status := FND_API.G_RET_STS_ERROR;
934: LOG_ERR_MSG ( 'XTR_CA_REVAL_DONE');
935: ELSIF nvl(l_return_error, 'XXX') = 'XTR_REVAL_ACCRL_DATE' THEN
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: LOG_ERR_MSG ( 'XTR_REVAL_ACCRL_DATE',p_balance_date);
938: ELSIF nvl(l_return_error, 'XXX') = 'XTR_BANK_REVAL_DONE' THEN
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: LOG_ERR_MSG ( 'XTR_BANK_REVAL_DONE',p_balance_date);

Line 939: x_return_status := FND_API.G_RET_STS_ERROR;

935: ELSIF nvl(l_return_error, 'XXX') = 'XTR_REVAL_ACCRL_DATE' THEN
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: LOG_ERR_MSG ( 'XTR_REVAL_ACCRL_DATE',p_balance_date);
938: ELSIF nvl(l_return_error, 'XXX') = 'XTR_BANK_REVAL_DONE' THEN
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: LOG_ERR_MSG ( 'XTR_BANK_REVAL_DONE',p_balance_date);
941: END IF;
942:
943:

Line 956: x_return_status := FND_API.G_RET_STS_ERROR;

952: p_action_flag,
953: 'E');
954:
955: IF nvl(l_return_error, 'XXX') = 'XTR_BANK_ACCRLS_EXIST' THEN
956: x_return_status := FND_API.G_RET_STS_ERROR;
957: LOG_ERR_MSG ( 'XTR_BANK_ACCRLS_EXIST',p_balance_date);
958:
959: ELSIF nvl(l_return_error, 'XXX') = 'XTR_REVAL_ACCRL_DATE' THEN
960: x_return_status := FND_API.G_RET_STS_ERROR;

Line 960: x_return_status := FND_API.G_RET_STS_ERROR;

956: x_return_status := FND_API.G_RET_STS_ERROR;
957: LOG_ERR_MSG ( 'XTR_BANK_ACCRLS_EXIST',p_balance_date);
958:
959: ELSIF nvl(l_return_error, 'XXX') = 'XTR_REVAL_ACCRL_DATE' THEN
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: LOG_ERR_MSG ( 'XTR_REVAL_ACCRL_DATE',p_balance_date);
962: END IF;
963:
964: ELSIF p_action_flag = 'D' THEN

Line 972: x_return_status := FND_API.G_RET_STS_ERROR;

968:
969: -- Checking for interest includes/ interest rounding
970:
971: IF ((NOT CHK_ROUNDING_CHANGE( p_company_code ,p_account_number ,p_balance_date )) AND p_interest_calc_balance IS NOT NULL) THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: LOG_ERR_MSG ( 'XTR_CHANGED_DAYCOUNT_ROUND');
974: END IF;
975:
976: -- Checking for revaluations

Line 987: x_return_status := FND_API.G_RET_STS_ERROR;

983: 'D',
984: 'E');
985:
986: IF nvl(l_return_error, 'XXX') = 'XTR_ACCT_DELETE' THEN
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: LOG_ERR_MSG ( 'XTR_ACCT_DELETE');
989: END IF;
990:
991:

Line 1003: x_return_status := FND_API.G_RET_STS_ERROR;

999: 'D',
1000: 'E');
1001:
1002: IF nvl(l_return_error, 'XXX') = 'XTR_DEAL_ACCRLS_EXIST' THEN
1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004: LOG_ERR_MSG ( 'XTR_DEAL_ACCRLS_EXIST',p_balance_date);
1005: END IF;
1006:
1007: END IF ; -- p_action_flag

Line 1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1009: EXCEPTION
1010: WHEN others THEN
1011:
1012: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014:
1015: END VALIDATE_BANK_BALANCE;
1016:
1017:

Line 1042: x_return_status := FND_API.G_RET_STS_SUCCESS;

1038: l_balance_rec XTR_BANK_BALANCES%ROWTYPE;
1039:
1040: BEGIN
1041:
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;
1043: l_balance_date_updated := FALSE;
1044: FND_MSG_PUB.Initialize;
1045: IF(p_action_flag in ('U','D')) THEN
1046:

Line 1100: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1096: p_available_balance,
1097: 'D',
1098: x_return_status );
1099:
1100: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1101: VALIDATE_BANK_BALANCE(
1102: p_company_code,
1103: p_account_number,
1104: p_balance_date,

Line 1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1120:
1121: EXCEPTION
1122:
1123: WHEN others THEN
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
1126:
1127: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1128: ( p_count => x_msg_count ,

Line 1447: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Added Bug 4546183

1443: AND COMPANY_CODE = P_COMPANY_CODE);
1444:
1445: BEGIN
1446:
1447: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Added Bug 4546183
1448: OPEN C_ACCT_DETAILS;
1449: FETCH C_ACCT_DETAILS INTO l_ccy,l_portfolio_code, l_bank_code;
1450: CLOSE C_ACCT_DETAILS;
1451:

Line 1957: x_return_status := FND_API.G_RET_STS_SUCCESS;

1953:
1954:
1955: BEGIN
1956:
1957: x_return_status := FND_API.G_RET_STS_SUCCESS;
1958:
1959: OPEN c_old_types;
1960: FETCH c_old_types INTO l_old_rounding_type, l_old_day_count_type,l_party_code,l_account_number;
1961: CLOSE c_old_types;

Line 2028: x_return_status := FND_API.G_RET_STS_ERROR;

2024: IF C_CHK_LOCK%ISOPEN THEN
2025: CLOSE C_CHK_LOCK;
2026: END IF;
2027: LOG_ERR_MSG('CHK_LOCK');
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: WHEN others THEN
2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2031: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
2032:

Line 2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2026: END IF;
2027: LOG_ERR_MSG('CHK_LOCK');
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: WHEN others THEN
2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2031: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
2032:
2033: END UPDATE_ROUNDING_DAYCOUNT;
2034:

Line 2184: x_return_status := FND_API.G_RET_STS_ERROR;

2180: p_balance_cflow,
2181: p_action_flag,
2182: 'W');
2183: IF nvl(l_return_error, '$$$') = 'XTR_DEALS_BEFORE_REVAL' THEN
2184: x_return_status := FND_API.G_RET_STS_ERROR;
2185: LOG_ERR_MSG ( 'XTR_DEALS_BEFORE_REVAL',p_balance_date);
2186: END IF;
2187:
2188: l_return_error := chk_accrual(l_company_code,

Line 2198: x_return_status := FND_API.G_RET_STS_ERROR;

2194: p_action_flag,
2195: 'W');
2196:
2197: IF nvl(l_return_error, '$$$') = 'XTR_DEALS_BEFORE_ACCRUAL' THEN
2198: x_return_status := FND_API.G_RET_STS_ERROR;
2199: LOG_ERR_MSG ( 'XTR_DEALS_BEFORE_ACCRUAL',p_balance_date);
2200: END IF;
2201:
2202: ELSE

Line 2204: x_return_status := FND_API.G_RET_STS_ERROR;

2200: END IF;
2201:
2202: ELSE
2203: CLOSE c_bank_acct_details;
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: LOG_ERR_MSG('XTR_INV_PARAM','ACTION_FLAG');
2206: END IF;
2207:
2208: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

Line 2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2212:
2213: EXCEPTION
2214:
2215: WHEN others THEN
2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2217: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
2218: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
2219: ( p_count => x_msg_count ,
2220: p_data => x_msg_data

Line 2241: x_return_status := FND_API.G_RET_STS_SUCCESS;

2237: p_funding_limit_code ce_bank_acct_uses_all.funding_limit_code%type;
2238:
2239: BEGIN
2240:
2241: x_return_status := FND_API.G_RET_STS_SUCCESS;
2242:
2243: SELECT b.funding_limit_code into p_funding_limit_code
2244: FROM ce_bank_accounts a,
2245: ce_bank_acct_uses_all b

Line 2265: x_return_status := FND_API.G_RET_STS_ERROR;

2261: p_branch_id
2262: );
2263:
2264: if (-(p_bal + p_ledger_balance))>0 then
2265: x_return_status := FND_API.G_RET_STS_ERROR;
2266: LOG_ERR_MSG ('CE_OD_LIMIT_FAIL_INFO');
2267: end if;
2268:
2269: EXCEPTION

Line 2272: x_return_status := FND_API.G_RET_STS_SUCCESS;

2268:
2269: EXCEPTION
2270:
2271: WHEN NO_DATA_FOUND THEN
2272: x_return_status := FND_API.G_RET_STS_SUCCESS;
2273: WHEN others THEN
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
2276:

Line 2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2270:
2271: WHEN NO_DATA_FOUND THEN
2272: x_return_status := FND_API.G_RET_STS_SUCCESS;
2273: WHEN others THEN
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
2276:
2277: FND_MSG_PUB.Count_And_Get
2278: ( p_count => x_msg_count ,