DBA Data[Home] [Help]

APPS.HZ_WORD_REPLACEMENTS1_PKG dependencies on FND_MESSAGE

Line 67: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DUPL_WORD' );

63:
64: IF l_count > 0 THEN
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 */

Line 68: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_ORIGINAL_WORD) );

64: IF l_count > 0 THEN
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

Line 81: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_CYCLIC' );

77: replacement_word = UPPER(x_ORIGINAL_WORD));
78: IF l_count > 0 THEN
79: x_msg_count := x_msg_count+1;
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;

Line 82: FND_MESSAGE.SET_TOKEN( 'ORIGINALWORD', UPPER(x_ORIGINAL_WORD) );

78: IF l_count > 0 THEN
79: x_msg_count := x_msg_count+1;
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 */

Line 83: FND_MESSAGE.SET_TOKEN( 'REPLACEMENTWORD', UPPER(x_REPLACEMENT_WORD) );

79: x_msg_count := x_msg_count+1;
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

Line 89: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_SAME_PAIR_VALUE' );

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;
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 */

Line 90: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_REPLACEMENT_WORD) );

86: /* Pairs cannot be same */
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)

Line 97: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_ORIG_WORD_MANDATORY' );

93: /* Original Word is Mandatory */
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

Line 345: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_SAME_PAIR_VALUE' );

341: /* Pairs cannot be same */
342: IF x_ORIGINAL_WORD = UPPER(x_REPLACEMENT_WORD) THEN
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:

Line 346: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_REPLACEMENT_WORD) );

342: IF x_ORIGINAL_WORD = UPPER(x_REPLACEMENT_WORD) THEN
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 */

Line 371: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DUPL_WORD' );

367:
368: IF l_count > 0 THEN
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:

Line 372: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_ORIGINAL_WORD) );

368: IF l_count > 0 THEN
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 */

Line 387: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_CYCLIC' );

383: AND rowid <> x_Rowid;
384: IF l_count > 0 THEN
385: x_msg_count := x_msg_count+1;
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;

Line 388: FND_MESSAGE.SET_TOKEN( 'ORIGINALWORD', UPPER(x_ORIGINAL_WORD) );

384: IF l_count > 0 THEN
385: x_msg_count := x_msg_count+1;
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

Line 389: FND_MESSAGE.SET_TOKEN( 'REPLACEMENTWORD', UPPER(x_REPLACEMENT_WORD) );

385: x_msg_count := x_msg_count+1;
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;

Line 527: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

523: OPEN C;
524: FETCH C INTO Recinfo;
525: If (C%NOTFOUND) then
526: CLOSE C;
527: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
528: APP_EXCEPTION.RAISE_EXCEPTION;
529: End If;
530: CLOSE C;
531:

Line 540: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

536: recinfo.OBJECT_VERSION_NUMBER = X_object_version_number )
537: ) then
538: null;
539: else
540: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
541: app_exception.raise_exception;
542: end if;
543:
544: END Lock_Row;