DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_HEADERS_PVT dependencies on FND_MESSAGE

Line 112: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_PC_INVALID');

108: FETCH check_pc_right INTO l_dummy_varchar;
109: IF (check_pc_right%NOTFOUND)
110: THEN
111: CLOSE check_pc_right;
112: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_PC_INVALID');
113: -- MEL/CDL can only be associated to nodes of primary complete Product Classifications of unit association type.
114: FND_MSG_PUB.ADD;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;

Line 126: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_EXISTS');

122: OPEN check_can_create;
123: FETCH check_can_create INTO l_dummy_varchar;
124: IF (check_can_create%FOUND)
125: THEN
126: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_EXISTS');
127: -- TYPE is already associated with the Product Classification Node
128: FND_MESSAGE.SET_TOKEN('TYPE', p_x_mel_cdl_header_rec.mel_cdl_type_code);
129: FND_MSG_PUB.ADD;
130: END IF;

Line 128: FND_MESSAGE.SET_TOKEN('TYPE', p_x_mel_cdl_header_rec.mel_cdl_type_code);

124: IF (check_can_create%FOUND)
125: THEN
126: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_EXISTS');
127: -- TYPE is already associated with the Product Classification Node
128: FND_MESSAGE.SET_TOKEN('TYPE', p_x_mel_cdl_header_rec.mel_cdl_type_code);
129: FND_MSG_PUB.ADD;
130: END IF;
131: CLOSE check_can_create;
132:

Line 139: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_DATE_MAND');

135:
136: -- Verify revision date is not null, it is a mandatory field
137: IF (p_x_mel_cdl_header_rec.revision_date IS NULL OR p_x_mel_cdl_header_rec.revision_date = FND_API.G_MISS_DATE)
138: THEN
139: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_DATE_MAND');
140: -- MEL/CDL revision date is mandatory
141: FND_MSG_PUB.ADD;
142: END IF;
143:

Line 147: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_EXP_DATE_LESS');

143:
144: -- Verify expiration date is greater than revision date
145: IF (nvl(p_x_mel_cdl_header_rec.expired_date, p_x_mel_cdl_header_rec.revision_date) < p_x_mel_cdl_header_rec.revision_date)
146: THEN
147: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_EXP_DATE_LESS');
148: -- MEL/CDL expiration date should be greater than revision date
149: FND_MSG_PUB.ADD;
150: END IF;
151:

Line 446: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_PC_ASSOC_NOTCHG');

442: THEN
443: p_x_mel_cdl_header_rec.pc_node_id := l_pc_node_id;
444: ELSIF (l_pc_node_id <> p_x_mel_cdl_header_rec.pc_node_id)
445: THEN
446: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_PC_ASSOC_NOTCHG');
447: -- Cannot modify MEL/CDL association to Product Classification node
448: FND_MSG_PUB.ADD;
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;

Line 455: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOT_DRAFT_UPD');

451:
452: -- Verify only DRAFT/APPROVAL_PENDING MEL/CDL is being modified
453: IF (l_status NOT IN ('DRAFT','APPROVAL_REJECTED'))
454: THEN
455: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOT_DRAFT_UPD');
456: -- Cannot update MEL/CDL not in draft or approval rejected status
457: FND_MSG_PUB.ADD;
458: RAISE FND_API.G_EXC_ERROR;
459: END IF;

Line 471: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_OTH_EXISTS');

467: OPEN check_other_type_exists;
468: FETCH check_other_type_exists INTO l_dummy_varchar;
469: IF (check_other_type_exists%FOUND)
470: THEN
471: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_OTH_EXISTS');
472: -- A TYPE is already associated with the Product Classification Node, hence cannot modify MEL/CDL type
473: FND_MESSAGE.SET_TOKEN('TYPE', p_x_mel_cdl_header_rec.mel_cdl_type_code);
474: FND_MSG_PUB.ADD;
475: RAISE FND_API.G_EXC_ERROR;

Line 473: FND_MESSAGE.SET_TOKEN('TYPE', p_x_mel_cdl_header_rec.mel_cdl_type_code);

469: IF (check_other_type_exists%FOUND)
470: THEN
471: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_OTH_EXISTS');
472: -- A TYPE is already associated with the Product Classification Node, hence cannot modify MEL/CDL type
473: FND_MESSAGE.SET_TOKEN('TYPE', p_x_mel_cdl_header_rec.mel_cdl_type_code);
474: FND_MSG_PUB.ADD;
475: RAISE FND_API.G_EXC_ERROR;
476: ELSE
477: -- This means that the changed MEL/CDL is the 1st revision of the changed type, hence default version number

Line 489: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_DATE_MAND');

485:
486: -- Verify revision date is not null, it is a mandatory field
487: IF (p_x_mel_cdl_header_rec.revision_date IS NULL OR p_x_mel_cdl_header_rec.revision_date = FND_API.G_MISS_DATE)
488: THEN
489: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_DATE_MAND');
490: -- MEL/CDL revision date is mandatory
491: FND_MSG_PUB.ADD;
492: ELSIF (p_x_mel_cdl_header_rec.revision_date <= nvl(l_prev_rev_date, p_x_mel_cdl_header_rec.revision_date - 1))
493: THEN

Line 494: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_DATE_LESS');

490: -- MEL/CDL revision date is mandatory
491: FND_MSG_PUB.ADD;
492: ELSIF (p_x_mel_cdl_header_rec.revision_date <= nvl(l_prev_rev_date, p_x_mel_cdl_header_rec.revision_date - 1))
493: THEN
494: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_DATE_LESS');
495: -- MEL/CDL revision date cannot be less than that of the prior revision
496: FND_MSG_PUB.ADD;
497: END IF;
498:

Line 502: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_EXP_DATE_LESS');

498:
499: -- Verify expiration date is greater than revision date
500: IF (nvl(p_x_mel_cdl_header_rec.expired_date, p_x_mel_cdl_header_rec.revision_date) < p_x_mel_cdl_header_rec.revision_date)
501: THEN
502: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_EXP_DATE_LESS');
503: -- MEL/CDL expiration date should be greater than revision date
504: FND_MSG_PUB.ADD;
505: END IF;
506:

Line 730: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOT_DRAFT_DEL');

726:
727: -- Verify only DRAFT/APPROVAL_PENDING MEL/CDL is being deleted
728: IF (l_status NOT IN ('DRAFT','APPROVAL_REJECTED'))
729: THEN
730: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOT_DRAFT_DEL');
731: -- Cannot delete MEL/CDL not in draft or approval rejected status
732: FND_MSG_PUB.ADD;
733: RAISE FND_API.G_EXC_ERROR;
734: END IF;

Line 1164: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_NOT_COMP');

1160:
1161: -- Verify only COMPLETE MEL/CDL is being revised
1162: IF (l_mel_cdl_rec.status_code <> 'COMPLETE')
1163: THEN
1164: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_NOT_COMP');
1165: -- MEL/CDL is not complete, hence cannot create a new revision
1166: FND_MSG_PUB.ADD;
1167: END IF;
1168:

Line 1179: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_NOT_LATEST');

1175:
1176: -- Verify whether the latest revision of the MEL/CDL line is being revised
1177: IF (l_max_rev <> l_mel_cdl_rec.version_number)
1178: THEN
1179: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_NOT_LATEST');
1180: -- MEL/CDL is not the latest revision, hence cannot create a new revision
1181: FND_MSG_PUB.ADD;
1182: END IF;
1183:

Line 1639: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_OPEN_NRS_EXIST');

1635: -- Need to verify whether to pass all PC nodes within the tree, etc or not
1636:
1637: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1638: THEN
1639: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_OPEN_NRS_EXIST');
1640: -- There exist(s) open Non-routines for the MEL/CDL
1641: FND_MSG_PUB.ADD;
1642: END IF;
1643: -- API body ends here

Line 1852: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOT_DRAFT_APPR');

1848:
1849: -- Verify only DRAFT/APPROVAL_PENDING MEL/CDL is being submitted for approval
1850: IF (l_status NOT IN ('DRAFT','APPROVAL_REJECTED'))
1851: THEN
1852: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOT_DRAFT_APPR');
1853: -- MEL/CDL is not in draft or approval rejected status, hence cannot submit for approval
1854: FND_MSG_PUB.ADD;
1855: RAISE FND_API.G_EXC_ERROR;
1856: END IF;

Line 1863: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DUP_REVISION');

1859: OPEN check_dup_rev(l_pc_node_id, l_mel_cdl_type, l_revision, p_mel_cdl_header_id);
1860: FETCH check_dup_rev INTO l_dummy_varchar;
1861: IF (check_dup_rev%FOUND)
1862: THEN
1863: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DUP_REVISION');
1864: FND_MESSAGE.SET_TOKEN('REV', l_revision);
1865: -- An MEL/CDL with revision 'REV' is already associated with the Product Classification node
1866: FND_MSG_PUB.ADD;
1867: END IF;

Line 1864: FND_MESSAGE.SET_TOKEN('REV', l_revision);

1860: FETCH check_dup_rev INTO l_dummy_varchar;
1861: IF (check_dup_rev%FOUND)
1862: THEN
1863: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DUP_REVISION');
1864: FND_MESSAGE.SET_TOKEN('REV', l_revision);
1865: -- An MEL/CDL with revision 'REV' is already associated with the Product Classification node
1866: FND_MSG_PUB.ADD;
1867: END IF;
1868: CLOSE check_dup_rev;

Line 2099: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOTFOUND');

2095: FETCH check_exists INTO l_ovn;
2096: IF (check_exists%NOTFOUND)
2097: THEN
2098: CLOSE check_exists;
2099: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NOTFOUND');
2100: -- MEL/CDL is not found
2101: FND_MSG_PUB.ADD;
2102: RAISE FND_API.G_EXC_ERROR;
2103: ELSE

Line 2107: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');

2103: ELSE
2104: CLOSE check_exists;
2105: IF (l_ovn <> p_mel_cdl_object_version)
2106: THEN
2107: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_RECORD_CHANGED');
2108: -- Record has been modified by another user
2109: FND_MSG_PUB.ADD;
2110: RAISE FND_API.G_EXC_ERROR;
2111: END IF;

Line 2132: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_TYPE_MAND');

2128: IF (p_x_mel_cdl_header_rec.mel_cdl_type_code IS NULL OR p_x_mel_cdl_header_rec.mel_cdl_type_code = FND_API.G_MISS_CHAR)
2129: THEN
2130: IF (p_x_mel_cdl_header_rec.mel_cdl_type_meaning IS NULL OR p_x_mel_cdl_header_rec.mel_cdl_type_meaning = FND_API.G_MISS_CHAR)
2131: THEN
2132: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_TYPE_MAND');
2133: -- MEL/CDL type is mandatory
2134: FND_MSG_PUB.ADD;
2135: ELSE
2136: AHL_UTIL_MC_PKG.Convert_To_LookupCode

Line 2145: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_TYPE_INV');

2141: x_return_val => l_ret_val
2142: );
2143: IF NOT (l_ret_val)
2144: THEN
2145: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_TYPE_INV');
2146: -- MEL/CDL type is invalid
2147: FND_MSG_PUB.ADD;
2148: END IF;
2149: END IF;

Line 2153: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_TYPE_INV');

2149: END IF;
2150: ELSE
2151: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_MEL_CDL_TYPE', p_x_mel_cdl_header_rec.mel_cdl_type_code))
2152: THEN
2153: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_TYPE_INV');
2154: -- MEL/CDL type is invalid
2155: FND_MSG_PUB.ADD;
2156: END IF;
2157: END IF;

Line 2180: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_MAND');

2176: mel_cdl_header_id <> nvl(p_x_mel_cdl_header_rec.mel_cdl_header_id, -1);
2177: BEGIN
2178: IF (p_x_mel_cdl_header_rec.revision IS NULL OR p_x_mel_cdl_header_rec.revision = FND_API.G_MISS_CHAR)
2179: THEN
2180: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_REV_MAND');
2181: -- MEL/CDL revision is mandatory
2182: FND_MSG_PUB.ADD;
2183: ELSE
2184: OPEN check_dup_rev;

Line 2188: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DUP_REVISION');

2184: OPEN check_dup_rev;
2185: FETCH check_dup_rev INTO l_dummy_varchar;
2186: IF (check_dup_rev%FOUND)
2187: THEN
2188: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DUP_REVISION');
2189: FND_MESSAGE.SET_TOKEN('REV', p_x_mel_cdl_header_rec.revision);
2190: -- An MEL/CDL with revision 'REV' is already associated with the Product Classification node
2191: FND_MSG_PUB.ADD;
2192: END IF;

Line 2189: FND_MESSAGE.SET_TOKEN('REV', p_x_mel_cdl_header_rec.revision);

2185: FETCH check_dup_rev INTO l_dummy_varchar;
2186: IF (check_dup_rev%FOUND)
2187: THEN
2188: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_DUP_REVISION');
2189: FND_MESSAGE.SET_TOKEN('REV', p_x_mel_cdl_header_rec.revision);
2190: -- An MEL/CDL with revision 'REV' is already associated with the Product Classification node
2191: FND_MSG_PUB.ADD;
2192: END IF;
2193: CLOSE check_dup_rev;