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_ACCOUNTS_P dependencies on FND_API

Line 29: * FND_API.G_RET_STS_SUCCESS - for success

25: *
26: * OUT:
27: * x_return_status Return status after the call. The
28: * status can be
29: * FND_API.G_RET_STS_SUCCESS - for success
30: * FND_API.G_RET_STS_ERR - for expected error
31: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
32: * x_msg_count To return the number of error messages
33: * in stack

Line 30: * FND_API.G_RET_STS_ERR - for expected error

26: * OUT:
27: * x_return_status Return status after the call. The
28: * status can be
29: * FND_API.G_RET_STS_SUCCESS - for success
30: * FND_API.G_RET_STS_ERR - for expected error
31: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
32: * x_msg_count To return the number of error messages
33: * in stack
34: * x_msg_data To return the error message if

Line 31: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error

27: * x_return_status Return status after the call. The
28: * status can be
29: * FND_API.G_RET_STS_SUCCESS - for success
30: * FND_API.G_RET_STS_ERR - for expected error
31: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
32: * x_msg_count To return the number of error messages
33: * in stack
34: * x_msg_data To return the error message if
35: * x_msg_count = 1.

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63:
64: x_msg_count := NULL;
65: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68: --
69: -- Verifies if the party_code in xtr_party_info is not same as the bank_code in xtr_bank_accounts
70: IF ((NOT XTR_REPLICATE_BANK_BRANCHES_P.CHK_BANK_BRANCH(p_xtr_bank_account_rec.bank_branch_id))
71: ) THEN -- The Bank does not exist or not authorized in XTR

Line 76: x_return_status := FND_API.G_RET_STS_ERROR;

72:
73: OPEN c_branch_name;
74: FETCH c_branch_name INTO l_bank_branch_name;
75: CLOSE c_branch_name;
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: XTR_REPLICATE_BANK_ACCOUNTS_P.LOG_ERR_MSG('XTR_INV_BANK_BRANCH',l_bank_branch_name);
78:
79: END IF;
80:

Line 81: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

77: XTR_REPLICATE_BANK_ACCOUNTS_P.LOG_ERR_MSG('XTR_INV_BANK_BRANCH',l_bank_branch_name);
78:
79: END IF;
80:
81: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
82: IF(p_action_flag = 'I') THEN -- If user has created a new bank account in CE
83:
84:
85:

Line 97: x_return_status := FND_API.G_RET_STS_ERROR;

93:
94:
95: ELSE
96:
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: LOG_ERR_MSG('XTR_INV_PARAM','ACTION_FLAG');
99:
100:
101: END IF;

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

119: );
120: --
121: EXCEPTION
122: WHEN others THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
125: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
126: ( p_count => x_msg_count ,
127: p_data => x_msg_data

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

225: x_return_status,x_msg_count,x_msg_data);
226:
227: EXCEPTION
228: WHEN others THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
231: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
232: ( p_count => x_msg_count ,
233: p_data => x_msg_data

Line 259: * FND_API.G_RET_STS_SUCCESS - for success

255: *
256: * OUT:
257: * x_return_status Return status after the call. The
258: * status can be
259: * FND_API.G_RET_STS_SUCCESS - for success
260: * FND_API.G_RET_STS_ERR - for expected error
261: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
262: * NOTES
263: *

Line 260: * FND_API.G_RET_STS_ERR - for expected error

256: * OUT:
257: * x_return_status Return status after the call. The
258: * status can be
259: * FND_API.G_RET_STS_SUCCESS - for success
260: * FND_API.G_RET_STS_ERR - for expected error
261: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
262: * NOTES
263: *
264: * MODIFICATION HISTORY

Line 261: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error

257: * x_return_status Return status after the call. The
258: * status can be
259: * FND_API.G_RET_STS_SUCCESS - for success
260: * FND_API.G_RET_STS_ERR - for expected error
261: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
262: * NOTES
263: *
264: * MODIFICATION HISTORY
265: *

Line 284: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

280:
281: --
282: VALIDATE_BANK_ACCOUNTS(p_xtr_bank_account_rec,x_return_status);
283:
284: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
285: /* All validations for bank account are true */
286: MODIFY_BANK_ACCOUNTS(p_xtr_bank_account_rec,'I'
287: ,x_return_status);
288:

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299:
300:
301: EXCEPTION
302: WHEN others THEN
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
305: END INSERT_BANK_ACCOUNTS;
306:
307: /**

Line 328: * FND_API.G_RET_STS_SUCCESS - for success

324: *
325: * OUT:
326: * x_return_status Return status after the call. The
327: * status can be
328: * FND_API.G_RET_STS_SUCCESS - for success
329: * FND_API.G_RET_STS_ERR - for expected error
330: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
331: * NOTES
332: *

Line 329: * FND_API.G_RET_STS_ERR - for expected error

325: * OUT:
326: * x_return_status Return status after the call. The
327: * status can be
328: * FND_API.G_RET_STS_SUCCESS - for success
329: * FND_API.G_RET_STS_ERR - for expected error
330: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
331: * NOTES
332: *
333: * MODIFICATION HISTORY

Line 330: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error

326: * x_return_status Return status after the call. The
327: * status can be
328: * FND_API.G_RET_STS_SUCCESS - for success
329: * FND_API.G_RET_STS_ERR - for expected error
330: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
331: * NOTES
332: *
333: * MODIFICATION HISTORY
334: *

Line 351: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

347: -- This account already exists in XTR and it is being updated in CE
348: VALIDATE_BANK_ACCOUNTS(p_xtr_bank_account_rec
349: ,x_return_status);
350:
351: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
352: /* All validations for bank account are true */
353: MODIFY_BANK_ACCOUNTS(p_xtr_bank_account_rec,'U'
354: ,x_return_status);
355:

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: END IF;
363:
364: EXCEPTION
365: WHEN others THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
368: END UPDATE_BANK_ACCOUNTS;
369:
370:

Line 391: * FND_API.G_RET_STS_SUCCESS - for success

387: *
388: * OUT:
389: * x_return_status Return status after the call. The
390: * status can be
391: * FND_API.G_RET_STS_SUCCESS - for success
392: * FND_API.G_RET_STS_ERR - for expected error
393: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
394: * NOTES
395: *

Line 392: * FND_API.G_RET_STS_ERR - for expected error

388: * OUT:
389: * x_return_status Return status after the call. The
390: * status can be
391: * FND_API.G_RET_STS_SUCCESS - for success
392: * FND_API.G_RET_STS_ERR - for expected error
393: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
394: * NOTES
395: *
396: * MODIFICATION HISTORY

Line 393: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error

389: * x_return_status Return status after the call. The
390: * status can be
391: * FND_API.G_RET_STS_SUCCESS - for success
392: * FND_API.G_RET_STS_ERR - for expected error
393: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
394: * NOTES
395: *
396: * MODIFICATION HISTORY
397: *

Line 446: x_return_status := FND_API.G_RET_STS_SUCCESS;

442:
443: -- Enter the procedure variables here. As shown below
444: --variable_name datatype NOT NULL DEFAULT default_value;
445: BEGIN
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
449: IF(p_xtr_bank_account_rec.ce_bank_account_id is null) THEN
450: x_return_status := FND_API.G_RET_STS_ERROR;

Line 450: x_return_status := FND_API.G_RET_STS_ERROR;

446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
449: IF(p_xtr_bank_account_rec.ce_bank_account_id is null) THEN
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
452: END IF;
453: -- Verifies if the bank_branch_id in XTR_BANK_ACCOUNTS is passed as null
454: IF(p_xtr_bank_account_rec.bank_branch_id is null) THEN

Line 455: x_return_status := FND_API.G_RET_STS_ERROR;

451: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
452: END IF;
453: -- Verifies if the bank_branch_id in XTR_BANK_ACCOUNTS is passed as null
454: IF(p_xtr_bank_account_rec.bank_branch_id is null) THEN
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_BRANCH_ID');
457: END IF;
458: /* Removed the validation Bug 4582759
459: -- Verifies if the bank_acct_use_id in XTR_BANK_ACCOUNTS is passed as null

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457: END IF;
458: /* Removed the validation Bug 4582759
459: -- Verifies if the bank_acct_use_id in XTR_BANK_ACCOUNTS is passed as null
460: IF(p_xtr_bank_account_rec.bank_acct_use_id is null) THEN
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_ACCT_USE_ID');
463: END IF;
464: */
465: -- Verifies if bank_short_code in XTR_BANK_ACCOUNTS is passed as null

Line 467: x_return_status := FND_API.G_RET_STS_ERROR;

463: END IF;
464: */
465: -- Verifies if bank_short_code in XTR_BANK_ACCOUNTS is passed as null
466: IF(p_xtr_bank_account_rec.bank_short_code is null) THEN
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: LOG_ERR_MSG('XTR_ACCT_NAME_MANDATORY');
469: END IF;
470: -- Verifies if currency in XTR_BANK_ACCOUNTS is passed as null
471: IF(p_xtr_bank_account_rec.currency is null ) THEN

Line 472: x_return_status := FND_API.G_RET_STS_ERROR;

468: LOG_ERR_MSG('XTR_ACCT_NAME_MANDATORY');
469: END IF;
470: -- Verifies if currency in XTR_BANK_ACCOUNTS is passed as null
471: IF(p_xtr_bank_account_rec.currency is null ) THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: LOG_ERR_MSG('XTR_CURRENCY_MANDATORY');
474: END IF;
475: -- Verifies if location in XTR_BANK_ACCOUNTS is passed as null
476: IF(p_xtr_bank_account_rec.location is null) THEN

Line 477: x_return_status := FND_API.G_RET_STS_ERROR;

473: LOG_ERR_MSG('XTR_CURRENCY_MANDATORY');
474: END IF;
475: -- Verifies if location in XTR_BANK_ACCOUNTS is passed as null
476: IF(p_xtr_bank_account_rec.location is null) THEN
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: LOG_ERR_MSG('XTR_LOCATION_MANDATORY');
479: END IF;
480: -- Verifies if street in XTR_BANK_ACCOUNTS is passed as null
481: IF(p_xtr_bank_account_rec.street is null) THEN

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

478: LOG_ERR_MSG('XTR_LOCATION_MANDATORY');
479: END IF;
480: -- Verifies if street in XTR_BANK_ACCOUNTS is passed as null
481: IF(p_xtr_bank_account_rec.street is null) THEN
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: LOG_ERR_MSG('XTR_STREET_MANDATORY');
484: END IF;
485: -- Verifies if party_code in XTR_BANK_ACCOUNTS is passed as null
486: IF(p_xtr_bank_account_rec.party_code is null ) THEN

Line 487: x_return_status := FND_API.G_RET_STS_ERROR;

483: LOG_ERR_MSG('XTR_STREET_MANDATORY');
484: END IF;
485: -- Verifies if party_code in XTR_BANK_ACCOUNTS is passed as null
486: IF(p_xtr_bank_account_rec.party_code is null ) THEN
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: LOG_ERR_MSG('XTR_ACCT_OWNER_MANDATORY');
489: END IF;
490: -- Verifies if account_number in XTR_BANK_ACCOUNTS is passed as null
491: IF(p_xtr_bank_account_rec.account_number is null ) THEN

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488: LOG_ERR_MSG('XTR_ACCT_OWNER_MANDATORY');
489: END IF;
490: -- Verifies if account_number in XTR_BANK_ACCOUNTS is passed as null
491: IF(p_xtr_bank_account_rec.account_number is null ) THEN
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: LOG_ERR_MSG('XTR_ACCOUNT_MANDATORY_FIELD');
494: END IF;
495:
496:

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: FETCH c_pm_authorized INTO l_pm_authorized;
499: CLOSE c_pm_authorized;
500: -- Verifies if pricing model in XTR_BANK_ACCOUNTS is authorized or not
501: IF(nvl(l_pm_authorized,'N') = 'N' AND p_xtr_bank_account_rec.pricing_model IS NOT NULL ) THEN
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: LOG_ERR_MSG('XTR_INV_TRS_PRICING_MODEL');
504: END IF;
505:
506: OPEN c_cc_id;

Line 512: x_return_status := FND_API.G_RET_STS_ERROR;

508: CLOSE c_cc_id;
509: -- Verifies if code combination id in XTR_BANK_ACCOUNTS is authorized or not
510: IF(nvl(l_cc_id,'N') = 'N' AND p_xtr_bank_account_rec.code_combination_id IS NOT NULL
511: AND p_xtr_bank_account_rec.party_code IS NOT NULL) THEN
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: LOG_ERR_MSG('XTR_INV_CC_ID');
514: END IF;
515:
516: OPEN C_valid_company;

Line 521: x_return_status := FND_API.G_RET_STS_ERROR;

517: FETCH C_valid_company INTO l_valid_company,l_le_id;
518: CLOSE C_valid_company;
519: -- Verifies if company exists in XTR_PARTIES_V
520: IF(nvl(l_valid_company,'N') = 'N' and p_xtr_bank_account_rec.party_code IS NOT NULL) THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: LOG_ERR_MSG('XTR_INV_LE_COMP_CODE',l_le_id);
523: END IF;
524: OPEN C_default_acct;
525: FETCH C_default_acct INTO l_default_acct,l_chk_default;

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526: CLOSE C_default_acct;
527: -- Verfies if A default account already exists for this company/currency combination.
528: IF((nvl(l_default_acct,'N') = 'Y') AND p_xtr_bank_account_rec.default_acct = 'Y'
529: AND (nvl(l_chk_default,-1) <> p_xtr_bank_account_rec.ce_bank_account_id) ) THEN -- Modified Bug 4764437
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: LOG_ERR_MSG('XTR_DEFAULT_ACCT');
532: END IF;
533: -- Verifies if year calculated basis is '30/' and a day count basis type of Both Days for the same deal.
534: IF(substr(p_xtr_bank_account_rec.year_calc_type,1,2) = '30'

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532: END IF;
533: -- Verifies if year calculated basis is '30/' and a day count basis type of Both Days for the same deal.
534: IF(substr(p_xtr_bank_account_rec.year_calc_type,1,2) = '30'
535: and p_xtr_bank_account_rec.day_count_type = 'B') THEN
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: LOG_ERR_MSG('XTR_CHK_30_BOTH');
538: END IF;
539:
540: IF xtr_risk_debug_pkg.g_Debug THEN

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

555: END IF;
556:
557: EXCEPTION
558: WHEN others THEN
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
561: END VALIDATE_BANK_ACCOUNTS;
562:
563:

Line 586: * FND_API.G_RET_STS_SUCCESS - for success

582: *
583: * OUT:
584: * x_return_status Return status after the call. The
585: * status can be
586: * FND_API.G_RET_STS_SUCCESS - for success
587: * FND_API.G_RET_STS_ERR - for expected error
588: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
589: * NOTES
590: *

Line 587: * FND_API.G_RET_STS_ERR - for expected error

583: * OUT:
584: * x_return_status Return status after the call. The
585: * status can be
586: * FND_API.G_RET_STS_SUCCESS - for success
587: * FND_API.G_RET_STS_ERR - for expected error
588: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
589: * NOTES
590: *
591: * MODIFICATION HISTORY

Line 588: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error

584: * x_return_status Return status after the call. The
585: * status can be
586: * FND_API.G_RET_STS_SUCCESS - for success
587: * FND_API.G_RET_STS_ERR - for expected error
588: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
589: * NOTES
590: *
591: * MODIFICATION HISTORY
592: *

Line 770: x_return_status := FND_API.G_RET_STS_ERROR;

766: if C_CHK_LOCK%ISOPEN then
767: close c_CHK_LOCK;
768: end if;
769: LOG_ERR_MSG('CHK_LOCK');
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: --app_exceptions.RECORD_LOCK_EXCEPTION;
772: WHEN DUP_VAL_ON_INDEX then -- bug 4870353
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: LOG_ERR_MSG('XTR_UNIQUE_ACCOUNT');

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769: LOG_ERR_MSG('CHK_LOCK');
770: x_return_status := FND_API.G_RET_STS_ERROR;
771: --app_exceptions.RECORD_LOCK_EXCEPTION;
772: WHEN DUP_VAL_ON_INDEX then -- bug 4870353
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: LOG_ERR_MSG('XTR_UNIQUE_ACCOUNT');
775: WHEN others THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

772: WHEN DUP_VAL_ON_INDEX then -- bug 4870353
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: LOG_ERR_MSG('XTR_UNIQUE_ACCOUNT');
775: WHEN others THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
778: END MODIFY_BANK_ACCOUNTS;
779:
780: /**

Line 970: * FND_API.G_RET_STS_SUCCESS - for success

966: *
967: * OUT:
968: * x_return_status Return status after the call. The
969: * status can be
970: * FND_API.G_RET_STS_SUCCESS - for success
971: * FND_API.G_RET_STS_ERR - for expected error
972: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
973: * x_msg_count To return the number of error messages
974: * in stack

Line 971: * FND_API.G_RET_STS_ERR - for expected error

967: * OUT:
968: * x_return_status Return status after the call. The
969: * status can be
970: * FND_API.G_RET_STS_SUCCESS - for success
971: * FND_API.G_RET_STS_ERR - for expected error
972: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
973: * x_msg_count To return the number of error messages
974: * in stack
975: * x_msg_data To return the error message if

Line 972: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error

968: * x_return_status Return status after the call. The
969: * status can be
970: * FND_API.G_RET_STS_SUCCESS - for success
971: * FND_API.G_RET_STS_ERR - for expected error
972: * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
973: * x_msg_count To return the number of error messages
974: * in stack
975: * x_msg_data To return the error message if
976: * x_msg_count = 1.

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: BEGIN
1006: x_msg_count := NULL;
1007: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
1008:
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
1011: IF(p_ce_bank_account_id is null) THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');

Line 1012: x_return_status := FND_API.G_RET_STS_ERROR;

1008:
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
1011: IF(p_ce_bank_account_id is null) THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
1014: END IF;
1015: -- Verifies if year calculated basis is '30/' and a day count basis type of Both Days for the same deal.
1016: IF(substr(p_day_count_basis,1,2) = '30' and p_interest_includes = 'B') THEN

Line 1017: x_return_status := FND_API.G_RET_STS_ERROR;

1013: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
1014: END IF;
1015: -- Verifies if year calculated basis is '30/' and a day count basis type of Both Days for the same deal.
1016: IF(substr(p_day_count_basis,1,2) = '30' and p_interest_includes = 'B') THEN
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: LOG_ERR_MSG('XTR_CHK_30_BOTH');
1019: END IF;
1020: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1021: OPEN c_chk_lock_interest;

Line 1020: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1016: IF(substr(p_day_count_basis,1,2) = '30' and p_interest_includes = 'B') THEN
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: LOG_ERR_MSG('XTR_CHK_30_BOTH');
1019: END IF;
1020: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1021: OPEN c_chk_lock_interest;
1022: FETCH c_chk_lock_interest INTO l_ce_bank_account_id;
1023: IF c_chk_lock_interest%FOUND THEN
1024: CLOSE c_chk_lock_interest;

Line 1041: x_return_status := FND_API.G_RET_STS_ERROR;

1037: END IF;
1038: ELSE
1039:
1040: CLOSE c_chk_lock_interest;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
1043:
1044: END IF;
1045:

Line 1057: x_return_status := FND_API.G_RET_STS_ERROR;

1053: if C_CHK_LOCK_INTEREST%ISOPEN then
1054: close c_CHK_LOCK_INTEREST;
1055: end if;
1056: LOG_ERR_MSG('CHK_LOCK');
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1059: ( p_count => x_msg_count ,
1060: p_data => x_msg_data
1061: );

Line 1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1060: p_data => x_msg_data
1061: );
1062: --app_exceptions.RECORD_LOCK_EXCEPTION;
1063: WHEN others THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
1066: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1067: ( p_count => x_msg_count ,
1068: p_data => x_msg_data