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.ASO_VALIDATE_PVT dependencies on FND_PROFILE

Line 4497: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

4493: THEN
4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4495: END IF;
4496:
4497: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4498:
4499: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4500: aso_debug_pub.add('Start of Validate_Promotion .....',1,'Y');
4501: END IF;

Line 4978: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

4974: END IF;
4975:
4976: -- Inititalizing Global Debug Flag Variable.
4977:
4978: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4979:
4980: -- Initialize API return status to success
4981: x_return_status := FND_API.G_RET_STS_SUCCESS;
4982:

Line 5036: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

5032: END IF;
5033:
5034: -- Inititalizing Global Debug Flag Variable.
5035:
5036: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5037:
5038: -- Initialize API return status to success
5039: x_return_status := FND_API.G_RET_STS_SUCCESS;
5040:

Line 5124: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

5120: END IF;
5121:
5122: -- Inititalizing Global Debug Flag Variable.
5123:
5124: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5125:
5126: -- Initialize API return status to success
5127: x_return_status := FND_API.G_RET_STS_SUCCESS;
5128:

Line 5998: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' THEN --Base Query

5994: l_manager_flag VARCHAR2(1);
5995:
5996: BEGIN
5997:
5998: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' THEN --Base Query
5999:
6000: aso_debug_pub.add('Before Opening the cursor...C_CUST_PARTY', 1, 'Y');
6001:
6002: OPEN C_CUST_PARTY ;

Line 6060: IF (NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'T' AND p_resource_id IS NOT NULL) THEN

6056: aso_debug_pub.add('After Closing the Cursor...C_CUST_PARTY', 1, 'Y');
6057: END IF;
6058:
6059:
6060: IF (NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'T' AND p_resource_id IS NOT NULL) THEN
6061:
6062: aso_debug_pub.add('Before Opening the cursor...C_Mgr_Check', 1, 'Y');
6063: OPEN C_Mgr_Check ; --Assigning the manager flag
6064: aso_debug_pub.add('After Opening the cursor...C_Mgr_Check', 1, 'Y');

Line 6505: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'Y'

6501: BEGIN
6502:
6503: --Case:1 ==================================Enforced Account Relationship is set to 'Y'(Start)=========================================================
6504:
6505: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'Y'
6506: AND p_cust_acct_id IS NOT NULL THEN
6507:
6508: IF P_FLAG = 'BILL' THEN
6509: aso_debug_pub.add('Before Opening the cursor...C_INVOICE_TO_CUSTOMER', 1, 'Y');

Line 6576: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'N' THEN

6572: END IF;
6573:
6574: --Case:2==================================Enforced Account Relationship is set to 'N' =========================================================
6575:
6576: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'N' THEN
6577: --Case 2a
6578: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' THEN --Put the base query
6579: aso_debug_pub.add('Before Opening the cursor...C_CUSTOMER', 1, 'Y');
6580: OPEN C_CUSTOMER ;

Line 6578: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' THEN --Put the base query

6574: --Case:2==================================Enforced Account Relationship is set to 'N' =========================================================
6575:
6576: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'N' THEN
6577: --Case 2a
6578: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' THEN --Put the base query
6579: aso_debug_pub.add('Before Opening the cursor...C_CUSTOMER', 1, 'Y');
6580: OPEN C_CUSTOMER ;
6581: aso_debug_pub.add('Before Fetching the cursor...C_CUSTOMER', 1, 'Y');
6582: FETCH C_CUSTOMER INTO l_data_exists ;

Line 6643: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'T' then --Check for the manager flag

6639: END IF;
6640:
6641: --Case 2b
6642:
6643: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'T' then --Check for the manager flag
6644:
6645: OPEN C_Mgr_Check ; --Assigning the manager flag
6646: FETCH C_Mgr_Check INTO l_data_exists ;
6647: IF C_Mgr_Check%FOUND THEN

Line 7033: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'Y' then

7029:
7030: BEGIN
7031:
7032: --Case:1 ==================================Enforced Account Relationship is set to 'Y'(Start)=========================================================
7033: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'Y' then
7034:
7035: IF P_FLAG = 'BILL' THEN
7036: aso_debug_pub.add('Before opening the cursor...C_INVOICE_TO_CUST_ACCOUNT', 1, 'Y');
7037: OPEN C_INVOICE_TO_CUST_ACCOUNT;

Line 7101: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'N' THEN

7097: END IF;
7098: END IF;
7099: --Case:2==================================Enforced Account Relationship is set to 'N' =========================================================
7100:
7101: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'N' THEN
7102:
7103: --Case 2a
7104: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' THEN --Put the base query
7105: aso_debug_pub.add('Before Opening the cursor...C_CUST_ACCOUNT', 1, 'Y');

Line 7104: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' THEN --Put the base query

7100:
7101: IF NVL(FND_PROFILE.value('ASO_ENFORCE_ACCOUNT_RELATIONSHIPS'),'N') = 'N' THEN
7102:
7103: --Case 2a
7104: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' THEN --Put the base query
7105: aso_debug_pub.add('Before Opening the cursor...C_CUST_ACCOUNT', 1, 'Y');
7106: OPEN C_CUST_ACCOUNT;
7107: aso_debug_pub.add('Before Fetching the cursor...C_CUST_ACCOUNT', 1, 'Y');
7108: FETCH C_CUST_ACCOUNT INTO l_data_exists ;

Line 7162: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'T' then --Check for the manager flag

7158:
7159: END IF;
7160:
7161: --Case 2b
7162: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'T' then --Check for the manager flag
7163:
7164: OPEN C_Mgr_Check ; --Assigning the manager flag
7165: FETCH C_Mgr_Check INTO l_data_exists ;
7166:

Line 7790: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' AND p_cust_party_id is not null THEN

7786:
7787: BEGIN
7788: --case:1 When sold-to or End Customer customer is specified
7789:
7790: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'F' AND p_cust_party_id is not null THEN
7791: aso_debug_pub.add('Before opeing the cursor...C_SOLD_TO_ACCOUNT', 1, 'Y');
7792: OPEN C_SOLD_TO_ACCOUNT;
7793: FETCH C_SOLD_TO_ACCOUNT INTO l_data_exists ;
7794:

Line 7839: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'T' AND p_resource_id IS NOT NULL THEN

7835: END IF;
7836:
7837: --Case:2 When ASN:Customer Access Privilege is set to Sales Team and resource_id is not null
7838:
7839: IF NVL(FND_PROFILE.VALUE('ASN_CUST_ACCESS'),'T') = 'T' AND p_resource_id IS NOT NULL THEN
7840:
7841:
7842: OPEN C_Mgr_Check; --Checking the manager flag
7843: FETCH C_Mgr_Check INTO l_data_exists ;

Line 8330: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

8326: END;
8327:
8328: BEGIN
8329:
8330: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
8331:
8332: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8333: aso_debug_pub.add('******************************************************', 1, 'Y');
8334: aso_debug_pub.add('Begin VALIDATE_DEFAULTING_DATA', 1, 'Y');

Line 8372: l_periodicity_profile := FND_PROFILE.value('ONT_UOM_CLASS_CHARGE_PERIODICITY');

8368: END IF;
8369:
8370:
8371: --For charged periodicity
8372: l_periodicity_profile := FND_PROFILE.value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
8373: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8374: aso_debug_pub.add('Value of profile ONT_UOM_CLASS_CHARGE_PERIODICITY : '||l_periodicity_profile, 1, 'Y');
8375: END IF;
8376: