68: , x_return_status => x_return_status
69: );
70:
71: IF (x_return_status = 'S') THEN
72: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
73: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','SUBSTITUTION');
74: FND_MESSAGE.SET_TOKEN('VERSION',l_new_substitution_version);
75: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',l_old_substitution_name);
76: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE','SUBSTITUTION');
69: );
70:
71: IF (x_return_status = 'S') THEN
72: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
73: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','SUBSTITUTION');
74: FND_MESSAGE.SET_TOKEN('VERSION',l_new_substitution_version);
75: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',l_old_substitution_name);
76: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE','SUBSTITUTION');
77: FND_MESSAGE.SET_TOKEN('NEW_ITEM',l_old_substitution_name||' - '||
70:
71: IF (x_return_status = 'S') THEN
72: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
73: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','SUBSTITUTION');
74: FND_MESSAGE.SET_TOKEN('VERSION',l_new_substitution_version);
75: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',l_old_substitution_name);
76: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE','SUBSTITUTION');
77: FND_MESSAGE.SET_TOKEN('NEW_ITEM',l_old_substitution_name||' - '||
78: l_old_substitution_version);
71: IF (x_return_status = 'S') THEN
72: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
73: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','SUBSTITUTION');
74: FND_MESSAGE.SET_TOKEN('VERSION',l_new_substitution_version);
75: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',l_old_substitution_name);
76: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE','SUBSTITUTION');
77: FND_MESSAGE.SET_TOKEN('NEW_ITEM',l_old_substitution_name||' - '||
78: l_old_substitution_version);
79: FND_MSG_PUB.ADD;
72: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
73: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','SUBSTITUTION');
74: FND_MESSAGE.SET_TOKEN('VERSION',l_new_substitution_version);
75: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',l_old_substitution_name);
76: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE','SUBSTITUTION');
77: FND_MESSAGE.SET_TOKEN('NEW_ITEM',l_old_substitution_name||' - '||
78: l_old_substitution_version);
79: FND_MSG_PUB.ADD;
80: END IF;
73: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','SUBSTITUTION');
74: FND_MESSAGE.SET_TOKEN('VERSION',l_new_substitution_version);
75: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',l_old_substitution_name);
76: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE','SUBSTITUTION');
77: FND_MESSAGE.SET_TOKEN('NEW_ITEM',l_old_substitution_name||' - '||
78: l_old_substitution_version);
79: FND_MSG_PUB.ADD;
80: END IF;
81: END IF;
124: FETCH get_item_info INTO l_original_prim_item_um;
125: CLOSE get_item_info;
126:
127: IF (l_original_prim_item_um IS NULL) THEN
128: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_ORIGINAL_ITEM');
129: FND_MSG_PUB.ADD;
130: RAISE substitution_creation_failure;
131: END IF;
132:
459: FETCH check_for_date_overlap into l_dummy;
460: CLOSE check_for_date_overlap;
461:
462: IF (l_dummy > 0) THEN
463: FND_MESSAGE.SET_NAME('GMD','GMD_ITSUB_DATE_PRE_OVERLAP');
464: FND_MSG_PUB.ADD;
465: RAISE substitution_update_failure;
466: END IF;
467: