137: ,x_msg_data => l_msg_data
138: );
139:
140: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
141: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
142: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.UPSERT_ITEM_FULL');
143: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
144: Log_Message(
145: pi_migration_code => l_migration_code
138: );
139:
140: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
141: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
142: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.UPSERT_ITEM_FULL');
143: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
144: Log_Message(
145: pi_migration_code => l_migration_code
146: ,pi_module_name => l_module_name
139:
140: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
141: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
142: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.UPSERT_ITEM_FULL');
143: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
144: Log_Message(
145: pi_migration_code => l_migration_code
146: ,pi_module_name => l_module_name
147: ,pi_log_level => 'I'
144: Log_Message(
145: pi_migration_code => l_migration_code
146: ,pi_module_name => l_module_name
147: ,pi_log_level => 'I'
148: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151:
152:
164: );
165:
166:
167: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
168: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
169: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.APPROVE_ITEM');
170: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
171: Log_Message(
172: pi_migration_code => l_migration_code
165:
166:
167: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
168: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
169: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.APPROVE_ITEM');
170: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
171: Log_Message(
172: pi_migration_code => l_migration_code
173: ,pi_module_name => l_module_name
166:
167: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
168: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
169: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.APPROVE_ITEM');
170: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
171: Log_Message(
172: pi_migration_code => l_migration_code
173: ,pi_module_name => l_module_name
174: ,pi_log_level => 'I'
171: Log_Message(
172: pi_migration_code => l_migration_code
173: ,pi_module_name => l_module_name
174: ,pi_log_level => 'I'
175: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178:
179: IF px_content_item_id is null THEN
196: ,x_msg_data => l_msg_data
197: );
198:
199: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
200: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
201: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
202: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
203: Log_Message(
204: pi_migration_code => l_migration_code
197: );
198:
199: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
200: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
201: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
202: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
203: Log_Message(
204: pi_migration_code => l_migration_code
205: ,pi_module_name => l_module_name
198:
199: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
200: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
201: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
202: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
203: Log_Message(
204: pi_migration_code => l_migration_code
205: ,pi_module_name => l_module_name
206: ,pi_log_level => 'I'
203: Log_Message(
204: pi_migration_code => l_migration_code
205: ,pi_module_name => l_module_name
206: ,pi_log_level => 'I'
207: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:
211: END IF;
228: ,x_msg_data => l_msg_data
229: );
230:
231: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
232: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
233: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
234: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
235: Log_Message(
236: pi_migration_code => l_migration_code
229: );
230:
231: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
232: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
233: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
234: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
235: Log_Message(
236: pi_migration_code => l_migration_code
237: ,pi_module_name => l_module_name
230:
231: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
232: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
233: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
234: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
235: Log_Message(
236: pi_migration_code => l_migration_code
237: ,pi_module_name => l_module_name
238: ,pi_log_level => 'I'
235: Log_Message(
236: pi_migration_code => l_migration_code
237: ,pi_module_name => l_module_name
238: ,pi_log_level => 'I'
239: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242:
243: -- Assign values to out variables.
373: ,x_msg_data => l_msg_data
374: );
375:
376: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
377: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
378: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.UPSERT_ITEM_FULL');
379: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');
380: Log_Message(
381: pi_migration_code => l_migration_code
374: );
375:
376: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
377: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
378: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.UPSERT_ITEM_FULL');
379: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');
380: Log_Message(
381: pi_migration_code => l_migration_code
382: ,pi_module_name => l_module_name
375:
376: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
377: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
378: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.UPSERT_ITEM_FULL');
379: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');
380: Log_Message(
381: pi_migration_code => l_migration_code
382: ,pi_module_name => l_module_name
383: ,pi_log_level => 'I'
380: Log_Message(
381: pi_migration_code => l_migration_code
382: ,pi_module_name => l_module_name
383: ,pi_log_level => 'I'
384: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388:
400: ,x_msg_data => l_msg_data);
401:
402:
403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
404: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
405: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.CHANGE_TRANSLATION_STATUS');
406: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');
407: Log_Message(
408: pi_migration_code => l_migration_code
401:
402:
403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
404: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
405: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.CHANGE_TRANSLATION_STATUS');
406: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');
407: Log_Message(
408: pi_migration_code => l_migration_code
409: ,pi_module_name => l_module_name
402:
403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
404: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
405: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.CHANGE_TRANSLATION_STATUS');
406: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');
407: Log_Message(
408: pi_migration_code => l_migration_code
409: ,pi_module_name => l_module_name
410: ,pi_log_level => 'I'
407: Log_Message(
408: pi_migration_code => l_migration_code
409: ,pi_module_name => l_module_name
410: ,pi_log_level => 'I'
411: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
412: RAISE FND_API.G_EXC_ERROR;
413: END IF;
414:
415: -- Update PRP_COMP_STYLE_CTNTVERS table with citem_version_id.
430: ,x_msg_data => l_msg_data
431: );
432:
433: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
434: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
435: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
436: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
437: Log_Message(
438: pi_migration_code => l_migration_code
431: );
432:
433: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
434: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
435: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
436: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
437: Log_Message(
438: pi_migration_code => l_migration_code
439: ,pi_module_name => l_module_name
432:
433: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
434: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
435: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
436: FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.CREATE_CONTENT');
437: Log_Message(
438: pi_migration_code => l_migration_code
439: ,pi_module_name => l_module_name
440: ,pi_log_level => 'I'
437: Log_Message(
438: pi_migration_code => l_migration_code
439: ,pi_module_name => l_module_name
440: ,pi_log_level => 'I'
441: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: px_object_version_number := l_object_version_number;
564: ,x_msg_data => l_msg_data
565: );
566:
567: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
568: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
569: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.UPSERT_ITEM_FULL');
570: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
571: Log_Message(
572: pi_migration_code => l_migration_code
565: );
566:
567: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
568: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
569: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.UPSERT_ITEM_FULL');
570: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
571: Log_Message(
572: pi_migration_code => l_migration_code
573: ,pi_module_name => l_module_name
566:
567: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
568: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
569: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.UPSERT_ITEM_FULL');
570: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
571: Log_Message(
572: pi_migration_code => l_migration_code
573: ,pi_module_name => l_module_name
574: ,pi_log_level => 'I'
571: Log_Message(
572: pi_migration_code => l_migration_code
573: ,pi_module_name => l_module_name
574: ,pi_log_level => 'I'
575: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578:
579:
591: );
592:
593:
594: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
595: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
596: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.APPROVE_ITEM');
597: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
598: Log_Message(
599: pi_migration_code => l_migration_code
592:
593:
594: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
595: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
596: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.APPROVE_ITEM');
597: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
598: Log_Message(
599: pi_migration_code => l_migration_code
600: ,pi_module_name => l_module_name
593:
594: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
595: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
596: FND_MESSAGE.Set_Token('API', 'IBC_CITEM_ADMIN_GRP.APPROVE_ITEM');
597: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
598: Log_Message(
599: pi_migration_code => l_migration_code
600: ,pi_module_name => l_module_name
601: ,pi_log_level => 'I'
598: Log_Message(
599: pi_migration_code => l_migration_code
600: ,pi_module_name => l_module_name
601: ,pi_log_level => 'I'
602: ,pi_message_text => FND_MESSAGE.get || l_msg_data);
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605:
606: IF px_content_item_id is null THEN
623: ,x_msg_data => l_msg_data
624: );
625:
626: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
627: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
628: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
629: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
630: Log_Message(
631: pi_migration_code => l_migration_code
624: );
625:
626: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
627: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
628: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
629: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
630: Log_Message(
631: pi_migration_code => l_migration_code
632: ,pi_module_name => l_module_name
625:
626: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
627: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
628: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
629: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
630: Log_Message(
631: pi_migration_code => l_migration_code
632: ,pi_module_name => l_module_name
633: ,pi_log_level => 'I'
630: Log_Message(
631: pi_migration_code => l_migration_code
632: ,pi_module_name => l_module_name
633: ,pi_log_level => 'I'
634: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
635: RAISE FND_API.G_EXC_ERROR;
636: END IF;
637:
638: END IF;
655: ,x_msg_data => l_msg_data
656: );
657:
658: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
659: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
660: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
661: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
662: Log_Message(
663: pi_migration_code => l_migration_code
656: );
657:
658: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
659: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
660: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
661: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
662: Log_Message(
663: pi_migration_code => l_migration_code
664: ,pi_module_name => l_module_name
657:
658: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
659: FND_MESSAGE.Set_Name('PRP', 'PRP_MG_API_RETURN_ERR');
660: FND_MESSAGE.Set_Token('API', 'IBC_ASSOCIATIONS_GRP.CREATE_ASSOCIATION');
661: FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.MIGRATE_PROPOSAL_DOC');
662: Log_Message(
663: pi_migration_code => l_migration_code
664: ,pi_module_name => l_module_name
665: ,pi_log_level => 'I'
662: Log_Message(
663: pi_migration_code => l_migration_code
664: ,pi_module_name => l_module_name
665: ,pi_log_level => 'I'
666: ,pi_message_text => FND_MESSAGE.get ||' '|| l_msg_data);
667: RAISE FND_API.G_EXC_ERROR;
668: END IF;
669:
670: