105: IF l_count >= 1 THEN
106: -- Ensure that a mapping type must be unique.
107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
108: THEN
109: fnd_message.set_name('CN', 'CL_UNIQUE_MAPPING_TYPE');
110: fnd_msg_pub.add;
111: END IF;
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
305: p_encoded => FND_API.G_FALSE);
306:
307: -- Creating notes for the new Transaction Source. Code written here because the
308: -- sequence is generated in the Pl/SQL call
309: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Transaction Source');
311: FND_MESSAGE.SET_TOKEN('VALUE',p_source_name);
312: l_note_msg := FND_MESSAGE.GET;
313:
306:
307: -- Creating notes for the new Transaction Source. Code written here because the
308: -- sequence is generated in the Pl/SQL call
309: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Transaction Source');
311: FND_MESSAGE.SET_TOKEN('VALUE',p_source_name);
312: l_note_msg := FND_MESSAGE.GET;
313:
314: jtf_notes_pub.create_note
307: -- Creating notes for the new Transaction Source. Code written here because the
308: -- sequence is generated in the Pl/SQL call
309: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Transaction Source');
311: FND_MESSAGE.SET_TOKEN('VALUE',p_source_name);
312: l_note_msg := FND_MESSAGE.GET;
313:
314: jtf_notes_pub.create_note
315: ( p_api_version => 1.0,
308: -- sequence is generated in the Pl/SQL call
309: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Transaction Source');
311: FND_MESSAGE.SET_TOKEN('VALUE',p_source_name);
312: l_note_msg := FND_MESSAGE.GET;
313:
314: jtf_notes_pub.create_note
315: ( p_api_version => 1.0,
316: x_return_status => x_return_status,
324: x_jtf_note_id => x_note_id
325: );
326:
327: -- Adding notes for Transaction Source Type
328: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
329: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Transaction Source Type');
330: FND_MESSAGE.SET_TOKEN('VALUE',p_table_map_rec.mapping_type);
331: l_note_msg := FND_MESSAGE.GET;
332:
325: );
326:
327: -- Adding notes for Transaction Source Type
328: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
329: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Transaction Source Type');
330: FND_MESSAGE.SET_TOKEN('VALUE',p_table_map_rec.mapping_type);
331: l_note_msg := FND_MESSAGE.GET;
332:
333: jtf_notes_pub.create_note
326:
327: -- Adding notes for Transaction Source Type
328: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
329: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Transaction Source Type');
330: FND_MESSAGE.SET_TOKEN('VALUE',p_table_map_rec.mapping_type);
331: l_note_msg := FND_MESSAGE.GET;
332:
333: jtf_notes_pub.create_note
334: ( p_api_version => 1.0,
327: -- Adding notes for Transaction Source Type
328: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
329: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Transaction Source Type');
330: FND_MESSAGE.SET_TOKEN('VALUE',p_table_map_rec.mapping_type);
331: l_note_msg := FND_MESSAGE.GET;
332:
333: jtf_notes_pub.create_note
334: ( p_api_version => 1.0,
335: x_return_status => x_return_status,
347: OPEN get_object_name(p_table_map_rec.source_table_id, p_table_map_rec.org_id);
348: FETCH get_object_name INTO l_object_name;
349: CLOSE get_object_name;
350:
351: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Line Table');
353: FND_MESSAGE.SET_TOKEN('VALUE',l_object_name);
354: l_note_msg := FND_MESSAGE.GET;
355:
348: FETCH get_object_name INTO l_object_name;
349: CLOSE get_object_name;
350:
351: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Line Table');
353: FND_MESSAGE.SET_TOKEN('VALUE',l_object_name);
354: l_note_msg := FND_MESSAGE.GET;
355:
356: jtf_notes_pub.create_note
349: CLOSE get_object_name;
350:
351: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Line Table');
353: FND_MESSAGE.SET_TOKEN('VALUE',l_object_name);
354: l_note_msg := FND_MESSAGE.GET;
355:
356: jtf_notes_pub.create_note
357: ( p_api_version => 1.0,
350:
351: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Line Table');
353: FND_MESSAGE.SET_TOKEN('VALUE',l_object_name);
354: l_note_msg := FND_MESSAGE.GET;
355:
356: jtf_notes_pub.create_note
357: ( p_api_version => 1.0,
358: x_return_status => x_return_status,
370: OPEN get_object_name(p_table_map_rec.source_tbl_pkcol_id, p_table_map_rec.org_id);
371: FETCH get_object_name INTO l_object_name;
372: CLOSE get_object_name;
373:
374: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Line Table Key Column');
376: FND_MESSAGE.SET_TOKEN('VALUE',l_object_name);
377: l_note_msg := FND_MESSAGE.GET;
378:
371: FETCH get_object_name INTO l_object_name;
372: CLOSE get_object_name;
373:
374: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Line Table Key Column');
376: FND_MESSAGE.SET_TOKEN('VALUE',l_object_name);
377: l_note_msg := FND_MESSAGE.GET;
378:
379: jtf_notes_pub.create_note
372: CLOSE get_object_name;
373:
374: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Line Table Key Column');
376: FND_MESSAGE.SET_TOKEN('VALUE',l_object_name);
377: l_note_msg := FND_MESSAGE.GET;
378:
379: jtf_notes_pub.create_note
380: ( p_api_version => 1.0,
373:
374: FND_MESSAGE.SET_NAME('CN', 'CN_TRANS_SRC_ATTR_INSERT_NOTE');
375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Line Table Key Column');
376: FND_MESSAGE.SET_TOKEN('VALUE',l_object_name);
377: l_note_msg := FND_MESSAGE.GET;
378:
379: jtf_notes_pub.create_note
380: ( p_api_version => 1.0,
381: x_return_status => x_return_status,
698: THEN
699:
700: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
701: THEN
702: fnd_message.set_name('CN', 'CL_INVALID_OVN');
703: fnd_msg_pub.add;
704: END IF;
705:
706: RAISE FND_API.G_EXC_ERROR;
828: if (l_object_version_number <> p_object_version_number) THEN
829:
830: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
831: THEN
832: fnd_message.set_name('CN', 'CL_INVALID_OVN');
833: fnd_msg_pub.add;
834: END IF;
835: RAISE FND_API.G_EXC_ERROR;
836: