eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on AS_UTILITY_PVT

Line 76: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

72: END IF;
73:
74: -- Debug Message
75: IF (AS_DEBUG_LOW_ON) THEN
76: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
77: 'PVT:' || l_api_name || ' Start');
78: END IF;
79:
80: -- Initialize API return status to SUCCESS

Line 94: AS_UTILITY_PVT.Set_Message(

90: IF FND_GLOBAL.User_Id IS NULL
91: THEN
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: AS_UTILITY_PVT.Set_Message(
95: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
96: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
97: p_token1 => 'PROFILE',
98: p_token1_value => 'USER_ID');

Line 158: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

154: status => l_status,
155: result => l_result);
156:
157: IF (AS_DEBUG_LOW_ON) THEN
158: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
159: 'l_status:' || l_status);
160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
161: 'l_result:' || l_result);
162: END IF;

Line 160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

156:
157: IF (AS_DEBUG_LOW_ON) THEN
158: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
159: 'l_status:' || l_status);
160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
161: 'l_result:' || l_result);
162: END IF;
163:
164: IF l_result <> FND_API.G_RET_STS_SUCCESS AND

Line 182: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

178: END IF;
179:
180: -- Debug Message
181: IF (AS_DEBUG_LOW_ON) THEN
182: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
183: 'PVT: ' || l_api_name || ' End');
184: END IF;
185:
186: -- Standard call to get message count and IF count is 1, get message info.

Line 193: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

189: p_data => x_msg_data );
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
194: P_API_NAME => L_API_NAME
195: ,P_PKG_NAME => G_PKG_NAME
196: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
197: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 197: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

193: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
194: P_API_NAME => L_API_NAME
195: ,P_PKG_NAME => G_PKG_NAME
196: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
197: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
198: ,X_MSG_COUNT => X_MSG_COUNT
199: ,X_MSG_DATA => X_MSG_DATA
200: ,X_RETURN_STATUS => X_RETURN_STATUS);
201:

Line 203: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

199: ,X_MSG_DATA => X_MSG_DATA
200: ,X_RETURN_STATUS => X_RETURN_STATUS);
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
204: P_API_NAME => L_API_NAME
205: ,P_PKG_NAME => G_PKG_NAME
206: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
207: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 207: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

203: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
204: P_API_NAME => L_API_NAME
205: ,P_PKG_NAME => G_PKG_NAME
206: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
207: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
208: ,X_MSG_COUNT => X_MSG_COUNT
209: ,X_MSG_DATA => X_MSG_DATA
210: ,X_RETURN_STATUS => X_RETURN_STATUS);
211:

Line 213: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

209: ,X_MSG_DATA => X_MSG_DATA
210: ,X_RETURN_STATUS => X_RETURN_STATUS);
211:
212: WHEN OTHERS THEN
213: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
214: P_API_NAME => L_API_NAME
215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
217: ,P_SQLCODE => SQLCODE

Line 216: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

212: WHEN OTHERS THEN
213: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
214: P_API_NAME => L_API_NAME
215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
217: ,P_SQLCODE => SQLCODE
218: ,P_SQLERRM => SQLERRM
219: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
220: ,X_MSG_COUNT => X_MSG_COUNT

Line 219: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
217: ,P_SQLCODE => SQLCODE
218: ,P_SQLERRM => SQLERRM
219: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);
223:

Line 314: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

310: WHERE salesforce_id = c_salesforce_id;
311:
312: BEGIN
313: IF (AS_DEBUG_LOW_ON) THEN
314: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
315: 'Partner_Matching: Start');
316: END IF;
317: IF funcmode = 'RUN'
318: THEN

Line 337: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

333: aname => 'SALESGROUP_ID');
334:
335:
336: IF (AS_DEBUG_LOW_ON) THEN
337: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
338: 'lead_id?' || l_lead_id);
339: END IF;
340:
341: -- ==========================================================================

Line 427: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

423: result := FND_API.G_RET_STS_ERROR;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: IF (AS_DEBUG_LOW_ON) THEN
427: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
428: 'selected_rule_id=' || l_selected_rule_id);
429: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'matched_partner_count=' || l_matched_partner_count);
431: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 429: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

425: END IF;
426: IF (AS_DEBUG_LOW_ON) THEN
427: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
428: 'selected_rule_id=' || l_selected_rule_id);
429: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'matched_partner_count=' || l_matched_partner_count);
431: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
432: 'failure_code=' || l_failure_code);
433: END IF;

Line 431: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

427: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
428: 'selected_rule_id=' || l_selected_rule_id);
429: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'matched_partner_count=' || l_matched_partner_count);
431: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
432: 'failure_code=' || l_failure_code);
433: END IF;
434:
435: IF l_selected_rule_id IS NULL

Line 474: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

470: END IF;
471:
472: END IF; -- function mode check
473: IF (AS_DEBUG_LOW_ON) THEN
474: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
475: 'Partner_Matching: End');
476: END IF;
477:
478: EXCEPTION

Line 537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

533: RAISE;
534: END IF;
535:
536: IF (AS_DEBUG_LOW_ON) THEN
537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'lwf rt status = ' || l_Return_Status);
539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
540: 'itemKey = ' || l_itemKey);
541: END IF;

Line 539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

535:
536: IF (AS_DEBUG_LOW_ON) THEN
537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'lwf rt status = ' || l_Return_Status);
539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
540: 'itemKey = ' || l_itemKey);
541: END IF;
542: OPEN c_get_lead_info(l_lead_id);
543: FETCH c_get_lead_info INTO l_Sales_Team_Rec.customer_id,

Line 594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

590: l_Sales_Team_Rec.created_by_TAP_flag := 'N';
591: l_sales_team_rec.owner_flag := 'N';
592:
593: IF (AS_DEBUG_LOW_ON) THEN
594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
597: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
598: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

592:
593: IF (AS_DEBUG_LOW_ON) THEN
594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
597: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
598: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
599: 'Calling Create_SalesTeam');
600: END IF;

Line 598: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
595: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
596: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
597: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
598: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
599: 'Calling Create_SalesTeam');
600: END IF;
601: AS_ACCESS_PUB.Create_SalesTeam (
602: p_api_version_number => 2.0

Line 632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

628: RAISE;
629: END IF;
630:
631: IF (AS_DEBUG_LOW_ON) THEN
632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
633: 'acc rt status = ' || l_Return_Status);
634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
635: 'Create_SalesTeam:l_access_id = ' || l_access_id);
636: END IF;

Line 634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

630:
631: IF (AS_DEBUG_LOW_ON) THEN
632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
633: 'acc rt status = ' || l_Return_Status);
634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
635: 'Create_SalesTeam:l_access_id = ' || l_access_id);
636: END IF;
637: END IF;
638:

Line 720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

716: END IF;
717:
718: -- Debug Message
719: IF (AS_DEBUG_LOW_ON) THEN
720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
721: 'PVT:' || l_api_name || ' Start');
722: END IF;
723:
724: -- Initialize API return status to SUCCESS

Line 738: AS_UTILITY_PVT.Set_Message(

734: IF FND_GLOBAL.User_Id IS NULL
735: THEN
736: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
737: THEN
738: AS_UTILITY_PVT.Set_Message(
739: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
740: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
741: p_token1 => 'PROFILE',
742: p_token1_value => 'USER_ID');

Line 784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_status:' || l_status);

780: status => l_status,
781: result => l_result);
782: END IF;
783: IF (AS_DEBUG_LOW_ON) THEN
784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_status:' || l_status);
785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_result:' || l_result);
786: END IF;
787:
788: IF l_result <> FND_API.G_RET_STS_SUCCESS AND l_result <> '#NULL'

Line 785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_result:' || l_result);

781: result => l_result);
782: END IF;
783: IF (AS_DEBUG_LOW_ON) THEN
784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_status:' || l_status);
785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_result:' || l_result);
786: END IF;
787:
788: IF l_result <> FND_API.G_RET_STS_SUCCESS AND l_result <> '#NULL'
789: THEN

Line 801: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

797: END IF;
798:
799: -- Debug Message
800: IF (AS_DEBUG_LOW_ON) THEN
801: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
802: 'PVT: ' || l_api_name || ' End');
803: END IF;
804:
805: -- Standard call to get message count and IF count is 1, get message info.

Line 812: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

808: p_data => x_msg_data );
809:
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
813: P_API_NAME => L_API_NAME
814: ,P_PKG_NAME => G_PKG_NAME
815: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
816: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 816: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

812: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
813: P_API_NAME => L_API_NAME
814: ,P_PKG_NAME => G_PKG_NAME
815: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
816: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
817: ,X_MSG_COUNT => X_MSG_COUNT
818: ,X_MSG_DATA => X_MSG_DATA
819: ,X_RETURN_STATUS => X_RETURN_STATUS);
820:

Line 822: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

818: ,X_MSG_DATA => X_MSG_DATA
819: ,X_RETURN_STATUS => X_RETURN_STATUS);
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
823: P_API_NAME => L_API_NAME
824: ,P_PKG_NAME => G_PKG_NAME
825: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
826: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 826: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

822: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
823: P_API_NAME => L_API_NAME
824: ,P_PKG_NAME => G_PKG_NAME
825: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
826: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
827: ,X_MSG_COUNT => X_MSG_COUNT
828: ,X_MSG_DATA => X_MSG_DATA
829: ,X_RETURN_STATUS => X_RETURN_STATUS);
830:

Line 832: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

828: ,X_MSG_DATA => X_MSG_DATA
829: ,X_RETURN_STATUS => X_RETURN_STATUS);
830:
831: WHEN OTHERS THEN
832: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
833: P_API_NAME => L_API_NAME
834: ,P_PKG_NAME => G_PKG_NAME
835: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
836: ,P_SQLCODE => SQLCODE

Line 835: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

831: WHEN OTHERS THEN
832: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
833: P_API_NAME => L_API_NAME
834: ,P_PKG_NAME => G_PKG_NAME
835: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
836: ,P_SQLCODE => SQLCODE
837: ,P_SQLERRM => SQLERRM
838: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
839: ,X_MSG_COUNT => X_MSG_COUNT

Line 838: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

834: ,P_PKG_NAME => G_PKG_NAME
835: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
836: ,P_SQLCODE => SQLCODE
837: ,P_SQLERRM => SQLERRM
838: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
839: ,X_MSG_COUNT => X_MSG_COUNT
840: ,X_MSG_DATA => X_MSG_DATA
841: ,X_RETURN_STATUS => X_RETURN_STATUS);
842:

Line 933: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Campaign_Routing: Start');

929: BEGIN
930: IF funcmode = 'RUN' THEN
931:
932: IF (AS_DEBUG_LOW_ON) THEN
933: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Campaign_Routing: Start');
934: END IF;
935:
936: result := FND_API.G_RET_STS_SUCCESS;
937: l_lead_id := wf_engine.GetItemAttrNumber(

Line 1002: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

998: -- --------------------------------------------------------------------
999: IF (l_open_opportunity_flag AND (NOT l_routing_exist_flag)) THEN
1000:
1001: IF (AS_DEBUG_LOW_ON) THEN
1002: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1003: 'This is an open oppty and is not being routed');
1004: END IF;
1005:
1006: OPEN c_get_user_name(l_identity_salesforce_id);

Line 1037: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1033:
1034: end if;
1035:
1036: IF (AS_DEBUG_LOW_ON) THEN
1037: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1038: 'Number of partners attach to campaign: ' || l_partner_id_tbl.count);
1039: end if;
1040:
1041: if l_partner_id_tbl.count = 0 then

Line 1056: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1052:
1053: IF (FND_PROFILE.value('PV_AUTO_ROUTE_FOR_CAMPAIGN') = 'Y') THEN
1054:
1055: IF (AS_DEBUG_LOW_ON) THEN
1056: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1057: 'Before calling Create Assignment' || l_lead_id || 'user name ' ||
1058: l_user_name || 'assn type ' || l_assignment_type );
1059: END IF;
1060:

Line 1087: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1083:
1084: ELSE
1085:
1086: IF (AS_DEBUG_LOW_ON) THEN
1087: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1088: 'Adding partners to external salesteam');
1089: END IF;
1090:
1091: FOR i in 1 .. l_partner_id_tbl.count LOOP

Line 1189: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1185: RAISE;
1186: END IF;
1187:
1188: IF (AS_DEBUG_LOW_ON) THEN
1189: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1190: 'lwf rt status = ' || l_Return_Status);
1191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemKey = ' || l_itemKey);
1192: END IF;
1193:

Line 1191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemKey = ' || l_itemKey);

1187:
1188: IF (AS_DEBUG_LOW_ON) THEN
1189: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1190: 'lwf rt status = ' || l_Return_Status);
1191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemKey = ' || l_itemKey);
1192: END IF;
1193:
1194: -- Create a sales team member for the opportunity
1195: l_Sales_Team_Rec.customer_id := l_customer_id;

Line 1234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1230: l_Sales_Team_Rec.created_by_TAP_flag := 'N';
1231: l_sales_team_rec.owner_flag := 'N';
1232:
1233: IF (AS_DEBUG_LOW_ON) THEN
1234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1235: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
1236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1237: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
1238: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1232:
1233: IF (AS_DEBUG_LOW_ON) THEN
1234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1235: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
1236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1237: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
1238: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1239: 'Calling Create_SalesTeam');
1240: END IF;

Line 1238: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1235: 'sf_id=' || l_Sales_Team_Rec.salesforce_id);
1236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1237: 'sg_id=' || l_Sales_Team_Rec.sales_group_id);
1238: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1239: 'Calling Create_SalesTeam');
1240: END IF;
1241: AS_ACCESS_PUB.Create_SalesTeam (
1242: p_api_version_number => 2.0

Line 1272: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1268: RAISE;
1269: END IF;
1270:
1271: IF (AS_DEBUG_LOW_ON) THEN
1272: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1273: 'acc rt status = ' || l_Return_Status);
1274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1275: 'Create_SalesTeam:l_access_id = ' || l_access_id);
1276: END IF;

Line 1274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1270:
1271: IF (AS_DEBUG_LOW_ON) THEN
1272: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1273: 'acc rt status = ' || l_Return_Status);
1274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1275: 'Create_SalesTeam:l_access_id = ' || l_access_id);
1276: END IF;
1277: END IF;
1278: END IF;