656: p_UOM_CODE => l_uom_code,
657: p_QUANTITY => l_quantity,
658: p_BUDGET_AMOUNT => NULL,
659: p_SOURCE_PROMOTION_ID => l_source_code_id_tbl(i),
660: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
657: p_QUANTITY => l_quantity,
658: p_BUDGET_AMOUNT => NULL,
659: p_SOURCE_PROMOTION_ID => l_source_code_id_tbl(i),
660: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
658: p_BUDGET_AMOUNT => NULL,
659: p_SOURCE_PROMOTION_ID => l_source_code_id_tbl(i),
660: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
659: p_SOURCE_PROMOTION_ID => l_source_code_id_tbl(i),
660: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
672: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
672: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
673: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
666: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
672: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
673: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
674: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
667: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
672: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
673: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
674: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
675: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
668: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
672: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
673: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
674: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
675: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
676: p_OFFER_ID => l_offer_id);
669: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
672: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
673: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
674: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
675: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
676: p_OFFER_ID => l_offer_id);
677: AML_DEBUG('created sales_lead_line_id='
670: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
672: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
673: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
674: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
675: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
676: p_OFFER_ID => l_offer_id);
677: AML_DEBUG('created sales_lead_line_id='
678: || l_sales_lead_line_id);
671: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
672: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
673: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
674: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
675: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
676: p_OFFER_ID => l_offer_id);
677: AML_DEBUG('created sales_lead_line_id='
678: || l_sales_lead_line_id);
679: END LOOP;
717: FND_MSG_PUB.initialize;
718:
719: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Update(
720: P_Api_Version_Number => 2.0,
721: P_Init_Msg_List => FND_API.G_FALSE,
722: p_Commit => FND_API.G_FALSE,
723: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
724: P_Check_Access_Flag => 'N',
725: p_Admin_Flag => 'N',
718:
719: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Update(
720: P_Api_Version_Number => 2.0,
721: P_Init_Msg_List => FND_API.G_FALSE,
722: p_Commit => FND_API.G_FALSE,
723: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
724: P_Check_Access_Flag => 'N',
725: p_Admin_Flag => 'N',
726: P_Admin_Group_Id => NULL,
719: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Update(
720: P_Api_Version_Number => 2.0,
721: P_Init_Msg_List => FND_API.G_FALSE,
722: p_Commit => FND_API.G_FALSE,
723: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
724: P_Check_Access_Flag => 'N',
725: p_Admin_Flag => 'N',
726: P_Admin_Group_Id => NULL,
727: P_identity_salesforce_id => l_identity_salesforce_id,
730: X_Return_Status => l_return_status,
731: X_Msg_Count => l_msg_count,
732: X_Msg_Data => l_msg_data);
733:
734: IF l_return_status = FND_API.G_RET_STS_ERROR OR
735: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
736: THEN
737: AML_DEBUG('Lead_Process_After_Update has error for '
738: || 'sales_lead_id ' || l_sales_lead_id || '!');
731: X_Msg_Count => l_msg_count,
732: X_Msg_Data => l_msg_data);
733:
734: IF l_return_status = FND_API.G_RET_STS_ERROR OR
735: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
736: THEN
737: AML_DEBUG('Lead_Process_After_Update has error for '
738: || 'sales_lead_id ' || l_sales_lead_id || '!');
739: -- RAISE FND_API.G_EXC_ERROR;
735: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
736: THEN
737: AML_DEBUG('Lead_Process_After_Update has error for '
738: || 'sales_lead_id ' || l_sales_lead_id || '!');
739: -- RAISE FND_API.G_EXC_ERROR;
740: END IF;
741:
742: l_count := FND_MSG_PUB.Count_Msg;
743: FOR l_index IN 1..l_count LOOP
742: l_count := FND_MSG_PUB.Count_Msg;
743: FOR l_index IN 1..l_count LOOP
744: l_message := FND_MSG_PUB.Get(
745: p_msg_index => l_index,
746: p_encoded => FND_API.G_FALSE);
747: AML_DEBUG(l_message);
748: END LOOP;
749: ELSE
750: -- Lead doesn't need to be reprocessed, update
995: WHERE interaction_id = l_interaction_id;
996: */
997:
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: AML_DEBUG('Expected error');
1001:
1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: AML_DEBUG('Unexpected error');
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: AML_DEBUG('Expected error');
1001:
1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: AML_DEBUG('Unexpected error');
1004:
1005: WHEN others THEN
1006: AML_DEBUG('Exception: others in Run_Interaction_Engine');
1007: AML_DEBUG('SQLCODE ' || to_char(SQLCODE) ||
1008: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1009:
1010: errbuf := SQLERRM;
1011: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
1012: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
1013:
1014: END Run_Interaction_Engine;
1015: