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.AMV_MATCH_PVT dependencies on AMV_UTILITY_PVT

Line 76: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

72: FND_MSG_PUB.initialize;
73: END IF;
74: -- Check if item id is valid.
75: -- The rest of the checking is done on Enqueue_Message().
76: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
77: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
78: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
79: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
80: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));

Line 174: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) <> TRUE) THEN

170: FND_MSG_PUB.initialize;
171: END IF;
172: -- Check if channel id is valid.
173: -- The rest of the checking is done on Enqueue_Message().
174: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) <> TRUE) THEN
175: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
176: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
177: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
178: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));

Line 393: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

389: x_message_obj => l_message_obj
390: );
391: IF (l_message_obj IS NOT NULL) THEN
392: IF (G_DEBUG = TRUE) THEN
393: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
394: '**********Start_MatchingEngine************');
395: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
396: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
397: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 395: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

391: IF (l_message_obj IS NOT NULL) THEN
392: IF (G_DEBUG = TRUE) THEN
393: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
394: '**********Start_MatchingEngine************');
395: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
396: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
397: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
398: 'object_id = ' || l_message_obj.object_id ||
399: ' object_type = ' || l_message_obj.object_type);

Line 397: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

393: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
394: '**********Start_MatchingEngine************');
395: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
396: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
397: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
398: 'object_id = ' || l_message_obj.object_id ||
399: ' object_type = ' || l_message_obj.object_type);
400: END IF;
401: -- The engine is told to quit.

Line 560: AMV_UTILITY_PVT.Get_UserInfo(

556: END IF;
557: -- Initialize API return status to success
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559: -- Get the current (login) user id.
560: AMV_UTILITY_PVT.Get_UserInfo(
561: x_resource_id => l_resource_id,
562: x_user_id => l_current_user_id,
563: x_login_id => l_current_login_id,
564: x_user_status => l_current_user_status

Line 578: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576: END IF;
577: IF (G_DEBUG = TRUE) THEN
578: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
579: '**********Match_ItemWithChannels************');
580: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
581: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
582: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('p_item_id = '||p_item_id);

Line 580: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

576: END IF;
577: IF (G_DEBUG = TRUE) THEN
578: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
579: '**********Match_ItemWithChannels************');
580: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
581: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
582: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('p_item_id = '||p_item_id);
583: END IF;
584: -- Get some basic information of the item

Line 582: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('p_item_id = '||p_item_id);

578: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
579: '**********Match_ItemWithChannels************');
580: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
581: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
582: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('p_item_id = '||p_item_id);
583: END IF;
584: -- Get some basic information of the item
585: -- (and thus check if the item id is valid)
586: OPEN Get_ItemInfo_csr;

Line 602: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600: CLOSE Get_ItemInfo_csr;
601: IF (G_DEBUG = TRUE) THEN
602: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
603: 'The item (id=' ||p_item_id|| ') info: '||
604: ' status=' || l_status ||
605: ', appl id = ' || l_application_id ||
606: ', expiration = ' || l_expiration_date );

Line 613: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

609: l_status <> 'ACTIVE' OR
610: nvl(l_expiration_date, sysdate+1) < sysdate) THEN
611: -- For such item, don't do the match.
612: IF (G_DEBUG = TRUE) THEN
613: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
614: 'The item (id='||p_item_id|| ') does not need to be matched.');
615: END IF;
616: RAISE FND_API.G_EXC_ERROR;
617: END IF;

Line 674: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE( 'SQL Statement');

670: --
671: l_sql_statement := l_sql_statement || l_where_clause;
672: --
673: IF (G_DEBUG = TRUE) THEN
674: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE( '****SQL Statement****');
675: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE( l_sql_statement );
676: END IF;
677: --
678: OPEN l_cursor FOR l_sql_statement USING p_item_id;

Line 675: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE( l_sql_statement );

671: l_sql_statement := l_sql_statement || l_where_clause;
672: --
673: IF (G_DEBUG = TRUE) THEN
674: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE( '****SQL Statement****');
675: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE( l_sql_statement );
676: END IF;
677: --
678: OPEN l_cursor FOR l_sql_statement USING p_item_id;
679: LOOP

Line 690: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('channel_id =' ||

686: l_match_on_item_type_flag;
687: EXIT WHEN l_cursor%NOTFOUND;
688:
689: IF (G_DEBUG = TRUE) THEN
690: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('channel_id =' ||
691: l_channel_id);
692: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on authors =' ||
693: l_match_on_author_flag );
694: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on keyword =' ||

Line 692: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on authors =' ||

688:
689: IF (G_DEBUG = TRUE) THEN
690: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('channel_id =' ||
691: l_channel_id);
692: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on authors =' ||
693: l_match_on_author_flag );
694: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on keyword =' ||
695: l_match_on_keyword_flag );
696: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match_on_persp. =' ||

Line 694: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on keyword =' ||

690: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('channel_id =' ||
691: l_channel_id);
692: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on authors =' ||
693: l_match_on_author_flag );
694: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on keyword =' ||
695: l_match_on_keyword_flag );
696: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match_on_persp. =' ||
697: l_match_on_perspective_flag);
698: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on C_type ='||

Line 696: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match_on_persp. =' ||

692: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on authors =' ||
693: l_match_on_author_flag );
694: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on keyword =' ||
695: l_match_on_keyword_flag );
696: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match_on_persp. =' ||
697: l_match_on_perspective_flag);
698: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on C_type ='||
699: l_match_on_content_type_flag);
700: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on I_type ='||

Line 698: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on C_type ='||

694: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on keyword =' ||
695: l_match_on_keyword_flag );
696: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match_on_persp. =' ||
697: l_match_on_perspective_flag);
698: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on C_type ='||
699: l_match_on_content_type_flag);
700: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on I_type ='||
701: l_match_on_item_type_flag);
702: END IF;

Line 700: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on I_type ='||

696: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match_on_persp. =' ||
697: l_match_on_perspective_flag);
698: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on C_type ='||
699: l_match_on_content_type_flag);
700: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('match on I_type ='||
701: l_match_on_item_type_flag);
702: END IF;
703: IF (l_match_on_author_flag = FND_API.G_FALSE AND
704: l_match_on_keyword_flag = FND_API.G_FALSE AND

Line 709: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

705: l_match_on_perspective_flag = FND_API.G_FALSE AND
706: l_match_on_content_type_flag = FND_API.G_FALSE AND
707: l_match_on_item_type_flag = FND_API.G_FALSE) THEN
708: IF (G_DEBUG = TRUE) THEN
709: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
710: 'Invalid channel data on matching flags(id='||l_channel_id
711: || '): all flags are ''F'' (T F F F F F)' );
712: END IF;
713: ELSE

Line 740: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

736: x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: END IF;
739: IF (G_DEBUG = TRUE) THEN
740: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
741: 'MATCH REUSLT = '||l_match_flag);
742: END IF;
743: IF (l_match_flag = FND_API.G_TRUE) THEN
744: -- match the channel with the content item

Line 757: p_match_type => AMV_UTILITY_PVT.G_MATCH

753: p_check_login_user => FND_API.G_FALSE,
754: p_channel_id => l_channel_id,
755: p_item_id => p_item_id,
756: p_table_name_code => G_MATCH_ITEM_TABLE,
757: p_match_type => AMV_UTILITY_PVT.G_MATCH
758: );
759: IF (G_DEBUG = TRUE) THEN
760: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
761: 'Do_ItemChannelMatch = '||l_return_status);

Line 760: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

756: p_table_name_code => G_MATCH_ITEM_TABLE,
757: p_match_type => AMV_UTILITY_PVT.G_MATCH
758: );
759: IF (G_DEBUG = TRUE) THEN
760: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
761: 'Do_ItemChannelMatch = '||l_return_status);
762: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
763: 'count = '||l_msg_count ||
764: ' msg = ' || l_msg_data);

Line 762: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

758: );
759: IF (G_DEBUG = TRUE) THEN
760: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
761: 'Do_ItemChannelMatch = '||l_return_status);
762: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
763: 'count = '||l_msg_count ||
764: ' msg = ' || l_msg_data);
765: END IF;
766: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 778: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('Match_ItemWithChannels: End time '

774: END LOOP;
775: CLOSE l_cursor;
776: --
777: IF (G_DEBUG = TRUE) THEN
778: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('Match_ItemWithChannels: End time '
779: || to_char(sysdate, 'DD-MON-YYYY: HH:MI:SS') );
780: END IF;
781: --Standard check of commit
782: IF FND_API.To_Boolean ( p_commit ) THEN

Line 896: AMV_UTILITY_PVT.Get_UserInfo(

892: END IF;
893: -- Initialize API return status to success
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895: -- Get the current (login) user id.
896: AMV_UTILITY_PVT.Get_UserInfo(
897: x_resource_id => l_resource_id,
898: x_user_id => l_current_user_id,
899: x_login_id => l_current_login_id,
900: x_user_status => l_current_user_status

Line 915: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

911: END IF;
912: END IF;
913: --
914: IF (G_DEBUG = TRUE) THEN
915: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
916: '**********Match_ChannelWithItems************');
917: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
918: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
919: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('p_channel_id = '|| p_channel_id);

Line 917: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

913: --
914: IF (G_DEBUG = TRUE) THEN
915: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
916: '**********Match_ChannelWithItems************');
917: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
918: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
919: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('p_channel_id = '|| p_channel_id);
920: END IF;
921: -- Get all the matching flags.

Line 919: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('p_channel_id = '|| p_channel_id);

915: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
916: '**********Match_ChannelWithItems************');
917: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
918: 'Time= '||to_char(sysdate,'DD-MON: HH:MI:SS'));
919: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('p_channel_id = '|| p_channel_id);
920: END IF;
921: -- Get all the matching flags.
922: OPEN Get_ChannelInfo_csr;
923: FETCH Get_ChannelInfo_csr

Line 943: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

939: RAISE FND_API.G_EXC_ERROR;
940: END IF;
941: CLOSE Get_ChannelInfo_csr;
942: IF (G_DEBUG = TRUE) THEN
943: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
944: 'The channel id='||p_channel_id);
945: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
946: 'Need Match flag = ' || l_need_to_match_flag);
947: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 945: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

941: CLOSE Get_ChannelInfo_csr;
942: IF (G_DEBUG = TRUE) THEN
943: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
944: 'The channel id='||p_channel_id);
945: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
946: 'Need Match flag = ' || l_need_to_match_flag);
947: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
948: 'Match on author flag = ' || l_match_on_author_flag);
949: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 947: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

943: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
944: 'The channel id='||p_channel_id);
945: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
946: 'Need Match flag = ' || l_need_to_match_flag);
947: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
948: 'Match on author flag = ' || l_match_on_author_flag);
949: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
950: 'Match on keyword flag = ' || l_match_on_keyword_flag);
951: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 949: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

945: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
946: 'Need Match flag = ' || l_need_to_match_flag);
947: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
948: 'Match on author flag = ' || l_match_on_author_flag);
949: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
950: 'Match on keyword flag = ' || l_match_on_keyword_flag);
951: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
952: 'Match on persp flag = ' || l_match_on_perspective_flag);
953: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 951: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

947: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
948: 'Match on author flag = ' || l_match_on_author_flag);
949: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
950: 'Match on keyword flag = ' || l_match_on_keyword_flag);
951: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
952: 'Match on persp flag = ' || l_match_on_perspective_flag);
953: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
954: 'Match on C type flag = ' || l_match_on_content_type_flag);
955: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 953: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

949: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
950: 'Match on keyword flag = ' || l_match_on_keyword_flag);
951: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
952: 'Match on persp flag = ' || l_match_on_perspective_flag);
953: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
954: 'Match on C type flag = ' || l_match_on_content_type_flag);
955: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
956: 'Match on I type flag = ' || l_match_on_item_type_flag);
957: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 955: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

951: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
952: 'Match on persp flag = ' || l_match_on_perspective_flag);
953: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
954: 'Match on C type flag = ' || l_match_on_content_type_flag);
955: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
956: 'Match on I type flag = ' || l_match_on_item_type_flag);
957: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
958: 'appl id = ' || l_application_id);
959: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 957: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

953: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
954: 'Match on C type flag = ' || l_match_on_content_type_flag);
955: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
956: 'Match on I type flag = ' || l_match_on_item_type_flag);
957: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
958: 'appl id = ' || l_application_id);
959: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
960: 'channel_type=' || l_channel_type);
961: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 959: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

955: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
956: 'Match on I type flag = ' || l_match_on_item_type_flag);
957: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
958: 'appl id = ' || l_application_id);
959: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
960: 'channel_type=' || l_channel_type);
961: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
962: 'status=' || l_status);
963: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 961: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

957: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
958: 'appl id = ' || l_application_id);
959: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
960: 'channel_type=' || l_channel_type);
961: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
962: 'status=' || l_status);
963: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
964: 'expiration = ' || l_expiration_date);
965: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

Line 963: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

959: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
960: 'channel_type=' || l_channel_type);
961: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
962: 'status=' || l_status);
963: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
964: 'expiration = ' || l_expiration_date);
965: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
966: 'access_level_type = ' || l_access_level_type);
967: END IF;

Line 965: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

961: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
962: 'status=' || l_status);
963: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
964: 'expiration = ' || l_expiration_date);
965: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
966: 'access_level_type = ' || l_access_level_type);
967: END IF;
968: -- For such channel, don't do the match.
969: -- Make sure the channel is good for rule matching.

Line 987: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

983: l_match_on_content_type_flag = FND_API.G_FALSE AND
984: l_match_on_item_type_flag = FND_API.G_FALSE) THEN
985: -- We should not get here: data error.
986: IF (G_DEBUG = TRUE) THEN
987: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
988: 'Invalid channel data on matching flags(id='||p_channel_id
989: || '): all flags are ''F'' (T F F F F F)' );
990: END IF;
991: -- For such channel, don't do the match.

Line 1050: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

1046: 'and ci.item_type = item.item_type) ';
1047: END IF;
1048: l_sql_statement := l_sql_statement || l_where_clause;
1049: IF (G_DEBUG = TRUE) THEN
1050: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
1051: '*************SQL Statement*************');
1052: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
1053: END IF;
1054: -- Now do the execution.

Line 1052: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);

1048: l_sql_statement := l_sql_statement || l_where_clause;
1049: IF (G_DEBUG = TRUE) THEN
1050: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
1051: '*************SQL Statement*************');
1052: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
1053: END IF;
1054: -- Now do the execution.
1055: OPEN l_cursor FOR l_sql_statement USING p_channel_id;
1056: LOOP

Line 1060: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

1056: LOOP
1057: FETCH l_cursor INTO l_item_id;
1058: EXIT WHEN l_cursor%NOTFOUND;
1059: IF (G_DEBUG = TRUE) THEN
1060: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
1061: ' Matching item (id = ' || l_item_id || ') ');
1062: END IF;
1063: -- match the content item with the channel
1064: Do_ItemChannelMatch

Line 1076: p_match_type => AMV_UTILITY_PVT.G_MATCH

1072: p_check_login_user => FND_API.G_FALSE,
1073: p_channel_id => p_channel_id,
1074: p_item_id => l_item_id,
1075: p_table_name_code => G_MATCH_ITEM_TABLE,
1076: p_match_type => AMV_UTILITY_PVT.G_MATCH
1077: );
1078: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR AND

Line 1087: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('Match_ChannelWithItems: End time '

1083: END IF;
1084: END LOOP;
1085: --
1086: IF (G_DEBUG = TRUE) THEN
1087: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE('Match_ChannelWithItems: End time '
1088: || to_char(sysdate, 'DD-MON: HH:MI:SS') );
1089: END IF;
1090: --Standard check of commit
1091: IF FND_API.To_Boolean ( p_commit ) THEN

Line 1177: AMV_UTILITY_PVT.Get_UserInfo(

1173: END IF;
1174: -- Initialize API return status to success
1175: x_return_status := FND_API.G_RET_STS_SUCCESS;
1176: -- Get the current (login) user id.
1177: AMV_UTILITY_PVT.Get_UserInfo(
1178: x_resource_id => l_resource_id,
1179: x_user_id => l_current_user_id,
1180: x_login_id => l_current_login_id,
1181: x_user_status => l_current_user_status

Line 1341: AMV_UTILITY_PVT.Get_UserInfo(

1337: ELSE
1338: x_match_flag := FND_API.G_TRUE;
1339: END IF;
1340: -- Get the current (login) user id.
1341: AMV_UTILITY_PVT.Get_UserInfo(
1342: x_resource_id => l_resource_id,
1343: x_user_id => l_current_user_id,
1344: x_login_id => l_current_login_id,
1345: x_user_status => l_current_user_status

Line 1510: AMV_UTILITY_PVT.Get_UserInfo(

1506: ELSE
1507: x_match_flag := FND_API.G_TRUE;
1508: END IF;
1509: -- Get the current (login) user id.
1510: AMV_UTILITY_PVT.Get_UserInfo(
1511: x_resource_id => l_resource_id,
1512: x_user_id => l_current_user_id,
1513: x_login_id => l_current_login_id,
1514: x_user_status => l_current_user_status

Line 1571: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(

1567: 'and ci.item_type = item.item_type) ';
1568: END IF;
1569: l_sql_statement := l_sql_statement || l_where_clause;
1570: IF (G_DEBUG = TRUE) THEN
1571: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
1572: '*************SQL Statement*************');
1573: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
1574: END IF;
1575: -- Now do the execution.

Line 1573: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);

1569: l_sql_statement := l_sql_statement || l_where_clause;
1570: IF (G_DEBUG = TRUE) THEN
1571: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(
1572: '*************SQL Statement*************');
1573: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
1574: END IF;
1575: -- Now do the execution.
1576: OPEN l_cursor FOR l_sql_statement USING p_item_id, p_channel_id;
1577: FETCH l_cursor INTO l_tmp_number;

Line 1709: AMV_UTILITY_PVT.Get_UserInfo(

1705: END IF;
1706: -- Initialize API return status to success
1707: x_return_status := FND_API.G_RET_STS_SUCCESS;
1708: -- Get the current (login) user id.
1709: AMV_UTILITY_PVT.Get_UserInfo(
1710: x_resource_id => l_resource_id,
1711: x_user_id => l_current_user_id,
1712: x_login_id => l_current_login_id,
1713: x_user_status => l_current_user_status

Line 1772: l_approval_flag := AMV_UTILITY_PVT.G_NEED_APPROVAL;

1768: END IF;
1769: CLOSE Get_ChannelInfo_csr;
1770: --
1771: IF (l_pub_need_approval_f = FND_API.G_TRUE) THEN
1772: l_approval_flag := AMV_UTILITY_PVT.G_NEED_APPROVAL;
1773: ELSE
1774: l_approval_flag := AMV_UTILITY_PVT.G_APPROVED;
1775: END IF;
1776: --

Line 1774: l_approval_flag := AMV_UTILITY_PVT.G_APPROVED;

1770: --
1771: IF (l_pub_need_approval_f = FND_API.G_TRUE) THEN
1772: l_approval_flag := AMV_UTILITY_PVT.G_NEED_APPROVAL;
1773: ELSE
1774: l_approval_flag := AMV_UTILITY_PVT.G_APPROVED;
1775: END IF;
1776: --
1777: --l_owner_name := 'TEST'; l_owner_id := 1;
1778: OPEN Get_OwnerIDAndName_csr (l_resource_id);

Line 1842: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN

1838: );
1839: END IF;
1840: ELSE -- add the item to the category.
1841: --check category id
1842: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
1843: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1844: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
1845: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
1846: FND_MSG_PUB.Add;

Line 1886: AMV_UTILITY_PVT.G_APPROVED,

1882: p_item_id,
1883: p_table_name_code,
1884: p_category_id,
1885: p_application_id,
1886: AMV_UTILITY_PVT.G_APPROVED,
1887: p_match_type,
1888: l_current_date
1889: );
1890: END IF;

Line 2049: AMV_UTILITY_PVT.Get_UserInfo(

2045: END IF;
2046: -- Initialize API return status to success
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048: -- Get the current (login) user id.
2049: AMV_UTILITY_PVT.Get_UserInfo(
2050: x_resource_id => l_resource_id,
2051: x_user_id => l_current_user_id,
2052: x_login_id => l_current_login_id,
2053: x_user_status => l_current_user_status

Line 2132: ,AMV_UTILITY_PVT.G_APPROVED -- APPROVAL_STATUS_TYPE

2128: ,p_item_id -- ITEM_ID
2129: ,p_table_name_code -- TABLE_NAME_CODE
2130: ,NULL -- CHANNEL_CATEGORY_ID
2131: ,p_application_id -- APPLICATION_ID
2132: ,AMV_UTILITY_PVT.G_APPROVED -- APPROVAL_STATUS_TYPE
2133: ,p_match_type -- AVAILABLE_DUE_TO_TYPE
2134: ,l_current_date -- AVAILABLE_FOR_CHANNEL_DATE
2135: ,p_territory_tbl(l_rec_count) -- TERRITORY_ID
2136: );

Line 2172: l_approval_flag := AMV_UTILITY_PVT.G_NEED_APPROVAL;

2168: END IF;
2169: CLOSE Get_ChannelInfo_csr;
2170: --
2171: IF (l_pub_need_approval_f = FND_API.G_TRUE) THEN
2172: l_approval_flag := AMV_UTILITY_PVT.G_NEED_APPROVAL;
2173: ELSE
2174: l_approval_flag := AMV_UTILITY_PVT.G_APPROVED;
2175: END IF;
2176: --

Line 2174: l_approval_flag := AMV_UTILITY_PVT.G_APPROVED;

2170: --
2171: IF (l_pub_need_approval_f = FND_API.G_TRUE) THEN
2172: l_approval_flag := AMV_UTILITY_PVT.G_NEED_APPROVAL;
2173: ELSE
2174: l_approval_flag := AMV_UTILITY_PVT.G_APPROVED;
2175: END IF;
2176: --
2177: --l_owner_name := 'TEST'; l_owner_id := 1;
2178: OPEN Get_OwnerIDAndName_csr (l_resource_id);

Line 2255: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN

2251: CLOSE c_exist_item_catg_match;
2252:
2253: IF l_match_item_catg = 'Y' THEN
2254: --check category id
2255: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
2256: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2257: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
2258: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
2259: FND_MSG_PUB.Add;

Line 2299: AMV_UTILITY_PVT.G_APPROVED,

2295: p_item_id,
2296: p_table_name_code,
2297: p_category_id,
2298: p_application_id,
2299: AMV_UTILITY_PVT.G_APPROVED,
2300: p_match_type,
2301: l_current_date
2302: );
2303: END IF;

Line 2424: AMV_UTILITY_PVT.Get_UserInfo(

2420: END IF;
2421: -- Initialize API return status to success
2422: x_return_status := FND_API.G_RET_STS_SUCCESS;
2423: -- Get the current (login) user id.
2424: AMV_UTILITY_PVT.Get_UserInfo(
2425: x_resource_id => l_resource_id,
2426: x_user_id => l_current_user_id,
2427: x_login_id => l_current_login_id,
2428: x_user_status => l_current_user_status

Line 2469: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN

2465: AND table_name_code = p_table_name_code;
2466: --
2467: ELSE -- delete the item to category match.
2468: --check category id
2469: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
2470: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2471: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
2472: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
2473: FND_MSG_PUB.Add;

Line 2583: AMV_UTILITY_PVT.Get_UserInfo(

2579: END IF;
2580: -- Initialize API return status to success
2581: x_return_status := FND_API.G_RET_STS_SUCCESS;
2582: -- Get the current (login) user id.
2583: AMV_UTILITY_PVT.Get_UserInfo(
2584: x_resource_id => l_resource_id,
2585: x_user_id => l_current_user_id,
2586: x_login_id => l_current_login_id,
2587: x_user_status => l_current_user_status

Line 2698: AMV_UTILITY_PVT.Get_UserInfo(

2694: END IF;
2695: -- Initialize API return status to success
2696: x_return_status := FND_API.G_RET_STS_SUCCESS;
2697: -- Get the current (login) user id.
2698: AMV_UTILITY_PVT.Get_UserInfo(
2699: x_resource_id => l_resource_id,
2700: x_user_id => l_current_user_id,
2701: x_login_id => l_current_login_id,
2702: x_user_status => l_current_user_status