DBA Data[Home] [Help]

APPS.ARI_SELF_REGISTRATION_PKG dependencies on APP_EXCEPTION

Line 199: APP_EXCEPTION.RAISE_EXCEPTION;

195: InformSysAdminError(p_procedure_name => l_procedure_name,
196: p_debug_info => l_debug_info,
197: p_error => SQLERRM);
198: END IF;
199: APP_EXCEPTION.RAISE_EXCEPTION;
200: END ResolveCustomerAccessRequest;
201:
202: /* =======================================================================
203: | PROCEDURE InitiateHZUserCreation

Line 464: APP_EXCEPTION.RAISE_EXCEPTION;

460: InformSysAdminError(p_procedure_name => l_procedure_name,
461: p_debug_info => l_debug_info,
462: p_error => SQLERRM);
463: END IF;
464: APP_EXCEPTION.RAISE_EXCEPTION;
465: END OpenCustAcctCur;
466:
467: /* =======================================================================
468: | PROCEDURE InformSysAdminError

Line 505: APP_EXCEPTION.RAISE_EXCEPTION;

501: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
502: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
503: FND_MSG_PUB.ADD;
504: END IF;
505: APP_EXCEPTION.RAISE_EXCEPTION;
506: END InformSysAdminError;
507:
508: /* =======================================================================
509: | PROCEDURE GenerateAccessVerifyQuestion

Line 615: APP_EXCEPTION.RAISE_EXCEPTION;

611: InformSysAdminError(p_procedure_name => l_procedure_name,
612: p_debug_info => l_debug_info,
613: p_error => SQLERRM);
614: END IF;
615: APP_EXCEPTION.RAISE_EXCEPTION;
616: END GenerateAccessVerifyQuestion;
617:
618: /* =======================================================================
619: | PROCEDURE ClearRegistrationTable

Line 766: APP_EXCEPTION.RAISE_EXCEPTION;

762: InformSysAdminError(p_procedure_name => l_procedure_name,
763: p_debug_info => l_debug_info,
764: p_error => SQLERRM);
765: END IF;
766: APP_EXCEPTION.RAISE_EXCEPTION;
767: END GenCustDetailAccessQuestion;
768:
769: /* =======================================================================
770: | FUNCTION ValidateAnswer

Line 1232: APP_EXCEPTION.RAISE_EXCEPTION;

1228: InformSysAdminError(p_procedure_name => l_procedure_name,
1229: p_debug_info => l_debug_info,
1230: p_error => SQLERRM);
1231: END IF;
1232: APP_EXCEPTION.RAISE_EXCEPTION;
1233: END CreatePersonPartyInternal;
1234:
1235: /*=======================================================================
1236: | FUNCTION GetOrgPartyId

Line 1524: APP_EXCEPTION.RAISE_EXCEPTION;

1520: InformSysAdminError(p_procedure_name => l_procedure_name,
1521: p_debug_info => l_debug_info,
1522: p_error => SQLERRM);
1523: END IF;
1524: APP_EXCEPTION.RAISE_EXCEPTION;
1525:
1526: END CreateOrgContactInternal;
1527:
1528: /*=======================================================================

Line 1839: APP_EXCEPTION.RAISE_EXCEPTION;

1835: InformSysAdminError(p_procedure_name => l_procedure_name,
1836: p_debug_info => l_debug_info,
1837: p_error => SQLERRM);
1838: END IF;
1839: APP_EXCEPTION.RAISE_EXCEPTION;
1840:
1841: END CreateContactPointInternal;
1842:
1843: /* =======================================================================

Line 2056: APP_EXCEPTION.RAISE_EXCEPTION;

2052: InformSysAdminError(p_procedure_name => l_procedure_name,
2053: p_debug_info => l_debug_info,
2054: p_error => SQLERRM);
2055: END IF;
2056: APP_EXCEPTION.RAISE_EXCEPTION;
2057:
2058: END CreateCustAcctRoleFor;
2059:
2060:

Line 2193: APP_EXCEPTION.RAISE_EXCEPTION;

2189: InformSysAdminError(p_procedure_name => l_procedure_name,
2190: p_debug_info => l_debug_info,
2191: p_error => SQLERRM);
2192: END IF;
2193: APP_EXCEPTION.RAISE_EXCEPTION;
2194: END CreateRoleRespFor;
2195:
2196: /*=======================================================================
2197: | PROCEDURE RegisterB2BUser

Line 3393: APP_EXCEPTION.RAISE_EXCEPTION;

3389: InformSysAdminError(p_procedure_name => l_procedure_name,
3390: p_debug_info => l_debug_info,
3391: p_error => SQLERRM);
3392: END IF;
3393: APP_EXCEPTION.RAISE_EXCEPTION;
3394: END CheckPastRegStatus;
3395:
3396: PROCEDURE OpenRegistrationCur(p_cust_account_id IN VARCHAR2,
3397: p_billto_id IN VARCHAR2,

Line 3498: APP_EXCEPTION.RAISE_EXCEPTION;

3494: InformSysAdminError(p_procedure_name => l_procedure_name,
3495: p_debug_info => l_debug_info,
3496: p_error => SQLERRM);
3497: END IF;
3498: APP_EXCEPTION.RAISE_EXCEPTION;
3499: END OpenRegistrationCur;
3500:
3501: PROCEDURE ReleaseRegHold(p_registration_id IN NUMBER,
3502: p_reg_status_lookup_code OUT NOCOPY VARCHAR2)

Line 3546: APP_EXCEPTION.RAISE_EXCEPTION;

3542: InformSysAdminError(p_procedure_name => l_procedure_name,
3543: p_debug_info => l_debug_info,
3544: p_error => SQLERRM);
3545: END IF;
3546: APP_EXCEPTION.RAISE_EXCEPTION;
3547: END ReleaseRegHold;
3548:
3549: PROCEDURE LogRegistration(p_registration_id IN OUT NOCOPY NUMBER,
3550: p_application_code IN VARCHAR2,

Line 3664: APP_EXCEPTION.RAISE_EXCEPTION;

3660: InformSysAdminError(p_procedure_name => l_procedure_name,
3661: p_debug_info => l_debug_info,
3662: p_error => SQLERRM);
3663: END IF;
3664: APP_EXCEPTION.RAISE_EXCEPTION;
3665: END LogRegistration;
3666:
3667: PROCEDURE OpenInvCustAcctCur(p_access_domain_search_number IN VARCHAR2,
3668: p_inv_cust_acct_cur OUT NOCOPY GenCursorRef)

Line 3722: APP_EXCEPTION.RAISE_EXCEPTION;

3718: InformSysAdminError(p_procedure_name => l_procedure_name,
3719: p_debug_info => l_debug_info,
3720: p_error => SQLERRM);
3721: END IF;
3722: APP_EXCEPTION.RAISE_EXCEPTION;
3723: END OpenInvCustAcctCur;
3724:
3725: PROCEDURE HoldRegistrationRequest(p_registration_id IN VARCHAR2,
3726: p_status IN VARCHAR2)

Line 3762: APP_EXCEPTION.RAISE_EXCEPTION;

3758: InformSysAdminError(p_procedure_name => l_procedure_name,
3759: p_debug_info => l_debug_info,
3760: p_error => SQLERRM);
3761: END IF;
3762: APP_EXCEPTION.RAISE_EXCEPTION;
3763: END HoldRegistrationRequest;
3764:
3765: PROCEDURE IncrementMissedCount(p_registration_id IN VARCHAR2,
3766: p_missed_cust_count IN VARCHAR2,

Line 3804: APP_EXCEPTION.RAISE_EXCEPTION;

3800: InformSysAdminError(p_procedure_name => l_procedure_name,
3801: p_debug_info => l_debug_info,
3802: p_error => SQLERRM);
3803: END IF;
3804: APP_EXCEPTION.RAISE_EXCEPTION;
3805: END IncrementMissedCount;
3806:
3807: PROCEDURE UpdateBilltoSite(p_registration_id IN VARCHAR2,
3808: p_access_domain_billto_id IN VARCHAR2)

Line 3844: APP_EXCEPTION.RAISE_EXCEPTION;

3840: InformSysAdminError(p_procedure_name => l_procedure_name,
3841: p_debug_info => l_debug_info,
3842: p_error => SQLERRM);
3843: END IF;
3844: APP_EXCEPTION.RAISE_EXCEPTION;
3845: END UpdateBilltoSite;
3846: -- Added this for Bug# 13869981
3847: /* =======================================================================
3848: | PROCEDURE UpdateRequestAccess

Line 3900: APP_EXCEPTION.RAISE_EXCEPTION;

3896: InformSysAdminError(p_procedure_name => l_procedure_name,
3897: p_debug_info => l_debug_info,
3898: p_error => SQLERRM);
3899: END IF;
3900: APP_EXCEPTION.RAISE_EXCEPTION;
3901: END UpdateRequestAccess;
3902:
3903: PROCEDURE Set_Application_Login_Url(p_itemtype IN VARCHAR2,
3904: p_itemkey IN VARCHAR2,

Line 3994: APP_EXCEPTION.RAISE_EXCEPTION;

3990: InformSysAdminError(p_procedure_name => l_procedure_name,
3991: p_debug_info => l_debug_info,
3992: p_error => l_error_msg);
3993: END IF;
3994: APP_EXCEPTION.RAISE_EXCEPTION;
3995:
3996: END Set_Application_Login_Url;
3997:
3998: /*=======================================================================

Line 4093: APP_EXCEPTION.RAISE_EXCEPTION;

4089: InformSysAdminError(p_procedure_name => l_procedure_name,
4090: p_debug_info => l_debug_info,
4091: p_error => l_error_msg);
4092: END IF;
4093: APP_EXCEPTION.RAISE_EXCEPTION;
4094: END UpdateApprovalStatus;
4095:
4096:
4097: /*=======================================================================

Line 4191: APP_EXCEPTION.RAISE_EXCEPTION;

4187: InformSysAdminError(p_procedure_name => l_procedure_name,
4188: p_debug_info => l_debug_info,
4189: p_error => l_error_msg);
4190: END IF;
4191: APP_EXCEPTION.RAISE_EXCEPTION;
4192: END UpdateRejectStatus;
4193:
4194: END ARI_SELF_REGISTRATION_PKG;