APPS.HZ_WORD_REPLACEMENTS1_PKG dependencies on FND_MSG_PUB

Line 69: FND_MSG_PUB.ADD;

65: x_msg_count := x_msg_count +1;
66: l_count := 0;
67: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DUPL_WORD' );
68: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_ORIGINAL_WORD) );
69: FND_MSG_PUB.ADD;
70: END IF;
71: /* No Cyclic Pairs */
72: SELECT count(*) INTO l_count
73: FROM hz_word_replacements

Line 84: FND_MSG_PUB.ADD;

80: l_count := 0;
81: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_CYCLIC' );
82: FND_MESSAGE.SET_TOKEN( 'ORIGINALWORD', UPPER(x_ORIGINAL_WORD) );
83: FND_MESSAGE.SET_TOKEN( 'REPLACEMENTWORD', UPPER(x_REPLACEMENT_WORD) );
84: FND_MSG_PUB.ADD;
85: END IF;
86: /* Pairs cannot be same */
87: IF UPPER(x_ORIGINAL_WORD) = UPPER(x_REPLACEMENT_WORD) THEN
88: x_msg_count := x_msg_count+1;

Line 91: FND_MSG_PUB.ADD;

87: IF UPPER(x_ORIGINAL_WORD) = UPPER(x_REPLACEMENT_WORD) THEN
88: x_msg_count := x_msg_count+1;
89: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_SAME_PAIR_VALUE' );
90: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_REPLACEMENT_WORD) );
91: FND_MSG_PUB.ADD;
92: END IF;
93: /* Original Word is Mandatory */
94: IF (x_ORIGINAL_WORD IS NULL OR x_ORIGINAL_WORD = FND_API.G_MISS_CHAR)
95: THEN

Line 98: FND_MSG_PUB.ADD;

94: IF (x_ORIGINAL_WORD IS NULL OR x_ORIGINAL_WORD = FND_API.G_MISS_CHAR)
95: THEN
96: x_msg_count := x_msg_count+1;
97: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_ORIG_WORD_MANDATORY' );
98: FND_MSG_PUB.ADD;
99: END IF;
100:
101: IF x_msg_count > 0 THEN
102: return;

Line 347: FND_MSG_PUB.ADD;

343: x_msg_count := x_msg_count+1;
344: l_count := 0;
345: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_SAME_PAIR_VALUE' );
346: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_REPLACEMENT_WORD) );
347: FND_MSG_PUB.ADD;
348: END IF;
349:
350: /* Original Word is unique for a word list */
351: SELECT count(*) INTO l_count

Line 373: FND_MSG_PUB.ADD;

369: x_msg_count := x_msg_count +1;
370: l_count := 0;
371: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DUPL_WORD' );
372: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_ORIGINAL_WORD) );
373: FND_MSG_PUB.ADD;
374: END IF;
375:
376: /* No Cyclic Pairs */
377: SELECT count(*) INTO l_count

Line 390: FND_MSG_PUB.ADD;

386: l_count := 0;
387: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_CYCLIC' );
388: FND_MESSAGE.SET_TOKEN( 'ORIGINALWORD', UPPER(x_ORIGINAL_WORD) );
389: FND_MESSAGE.SET_TOKEN( 'REPLACEMENTWORD', UPPER(x_REPLACEMENT_WORD) );
390: FND_MSG_PUB.ADD;
391: END IF;
392: IF x_msg_count > 0 THEN
393: return;
394: END IF;