DBA Data[Home] [Help]

APPS.ARH_CREL_PKG dependencies on FND_MESSAGE

Line 109: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

105: CLOSE cu_cust_relate_version;
106: END IF;
107:
108: IF x_rowid IS NULL THEN
109: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
110: FND_MESSAGE.SET_TOKEN( 'RECORD', p_table_name);
111: FND_MESSAGE.SET_TOKEN( 'VALUE',
112: NVL( p_col_id , 'null' ) || ',' ||
113: NVL( p_col_id2, 'null' ) );

Line 110: FND_MESSAGE.SET_TOKEN( 'RECORD', p_table_name);

106: END IF;
107:
108: IF x_rowid IS NULL THEN
109: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
110: FND_MESSAGE.SET_TOKEN( 'RECORD', p_table_name);
111: FND_MESSAGE.SET_TOKEN( 'VALUE',
112: NVL( p_col_id , 'null' ) || ',' ||
113: NVL( p_col_id2, 'null' ) );
114: FND_MSG_PUB.ADD;

Line 111: FND_MESSAGE.SET_TOKEN( 'VALUE',

107:
108: IF x_rowid IS NULL THEN
109: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
110: FND_MESSAGE.SET_TOKEN( 'RECORD', p_table_name);
111: FND_MESSAGE.SET_TOKEN( 'VALUE',
112: NVL( p_col_id , 'null' ) || ',' ||
113: NVL( p_col_id2, 'null' ) );
114: FND_MSG_PUB.ADD;
115: ELSE

Line 119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

115: ELSE
116: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
117: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
118: THEN
119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
120: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
121: FND_MSG_PUB.ADD;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: END IF;

Line 120: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);

116: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
117: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
118: THEN
119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
120: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
121: FND_MSG_PUB.ADD;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: END IF;
124: END IF;

Line 140: fnd_message.set_name('AR','AR_CUST_REL_ALREADY_EXISTS');

136: and related_cust_account_id = x_related_customer_id
137: and status = 'A'; --Bug Fix: 3237327
138:
139: if (duplicate_count >= 1 ) then
140: fnd_message.set_name('AR','AR_CUST_REL_ALREADY_EXISTS');
141: app_exception.raise_exception;
142: end if;
143: end check_unique;
144: --