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.AMS_CT_RULE_PVT dependencies on AMS_UTILITY_PVT

Line 103: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || 'start');

99:
100: -- Debug Message
101: IF (AMS_DEBUG_HIGH_ON) THEN
102:
103: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || 'start');
104: END IF;
105:
106:
107: -- Initialize API return status to SUCCESS

Line 130: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

126:
127: -- Validate Environment
128: IF FND_GLOBAL.User_Id IS NULL
129: THEN
130: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
131: RAISE FND_API.G_EXC_ERROR;
132: END IF;
133:
134: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 139: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || ' Validate_Ct_Rule');

135: THEN
136: -- Debug message
137: IF (AMS_DEBUG_HIGH_ON) THEN
138:
139: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || ' Validate_Ct_Rule');
140: END IF;
141:
142: -- Invoke validation procedures
143: Validate_ct_rule(

Line 162: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || ' Calling create table handler');

158:
159: -- Debug Message
160: IF (AMS_DEBUG_HIGH_ON) THEN
161:
162: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || ' Calling create table handler');
163: END IF;
164:
165: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Insert_Row)
166: AMS_CONTENT_RULES_B_PKG.Insert_Row(

Line 206: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || 'end');

202:
203: -- Debug Message
204: IF (AMS_DEBUG_HIGH_ON) THEN
205:
206: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || 'end');
207: END IF;
208:
209: -- Standard call to get message count and if count is 1, get message info.
210: FND_MSG_PUB.Count_And_Get

Line 216: WHEN AMS_Utility_PVT.resource_locked THEN

212: p_data => x_msg_data
213: );
214: EXCEPTION
215:
216: WHEN AMS_Utility_PVT.resource_locked THEN
217: x_return_status := FND_API.g_ret_sts_error;
218: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
219:
220: WHEN FND_API.G_EXC_ERROR THEN

Line 218: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

214: EXCEPTION
215:
216: WHEN AMS_Utility_PVT.resource_locked THEN
217: x_return_status := FND_API.g_ret_sts_error;
218: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
219:
220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO CREATE_Ct_Rule_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR;

Line 323: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

319:
320: -- Debug Message
321: IF (AMS_DEBUG_HIGH_ON) THEN
322:
323: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
324: END IF;
325:
326:
327: -- Initialize API return status to SUCCESS

Line 333: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

329:
330: -- Debug Message
331: IF (AMS_DEBUG_HIGH_ON) THEN
332:
333: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
334: END IF;
335:
336: /*
337: OPEN c_get_Ct_Rule( l_tar_ct_rule_rec.content_rule_id);

Line 342: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

338:
339: FETCH c_get_Ct_Rule INTO l_ref_ct_rule_rec ;
340:
341: If ( c_get_Ct_Rule%NOTFOUND) THEN
342: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
343: p_token_name => 'INFO',
344: p_token_value => 'Ct_Rule') ;
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;

Line 350: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

346: END IF;
347: -- Debug Message
348: IF (AMS_DEBUG_HIGH_ON) THEN
349:
350: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
351: END IF;
352: CLOSE c_get_Ct_Rule;
353: */
354:

Line 358: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

354:
355:
356: If (l_tar_ct_rule_rec.object_version_number is NULL or
357: l_tar_ct_rule_rec.object_version_number = FND_API.G_MISS_NUM ) Then
358: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
359: p_token_name => 'COLUMN',
360: p_token_value => 'Last_Update_Date') ;
361: raise FND_API.G_EXC_ERROR;
362: End if;

Line 365: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

361: raise FND_API.G_EXC_ERROR;
362: End if;
363: -- Check Whether record has been changed by someone else
364: If (l_tar_ct_rule_rec.object_version_number <> l_ref_ct_rule_rec.object_version_number) Then
365: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
366: p_token_name => 'INFO',
367: p_token_value => 'Ct_Rule') ;
368: raise FND_API.G_EXC_ERROR;
369: End if;

Line 375: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ct_Rule');

371: THEN
372: -- Debug message
373: IF (AMS_DEBUG_HIGH_ON) THEN
374:
375: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ct_Rule');
376: END IF;
377:
378: -- Invoke validation procedures
379: Validate_ct_rule(

Line 396: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;

392: END IF;
393:
394:
395: -- Debug Message
396: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
397: IF (AMS_DEBUG_HIGH_ON) THEN
398:
399: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
400: END IF;

Line 399: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');

395: -- Debug Message
396: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
397: IF (AMS_DEBUG_HIGH_ON) THEN
398:
399: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
400: END IF;
401:
402: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Update_Row)
403: AMS_CONTENT_RULES_B_PKG.Update_Row(

Line 441: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

437:
438: -- Debug Message
439: IF (AMS_DEBUG_HIGH_ON) THEN
440:
441: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
442: END IF;
443:
444: -- Standard call to get message count and if count is 1, get message info.
445: FND_MSG_PUB.Count_And_Get

Line 451: WHEN AMS_Utility_PVT.resource_locked THEN

447: p_data => x_msg_data
448: );
449: EXCEPTION
450:
451: WHEN AMS_Utility_PVT.resource_locked THEN
452: x_return_status := FND_API.g_ret_sts_error;
453: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
454:
455: WHEN FND_API.G_EXC_ERROR THEN

Line 453: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

449: EXCEPTION
450:
451: WHEN AMS_Utility_PVT.resource_locked THEN
452: x_return_status := FND_API.g_ret_sts_error;
453: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
454:
455: WHEN FND_API.G_EXC_ERROR THEN
456: ROLLBACK TO UPDATE_Ct_Rule_PVT;
457: x_return_status := FND_API.G_RET_STS_ERROR;

Line 544: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

540:
541: -- Debug Message
542: IF (AMS_DEBUG_HIGH_ON) THEN
543:
544: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
545: END IF;
546:
547:
548: -- Initialize API return status to SUCCESS

Line 557: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

553: --
554: -- Debug Message
555: IF (AMS_DEBUG_HIGH_ON) THEN
556:
557: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
558: END IF;
559:
560: -- Invoke table handler(AMS_CONTENT_RULES_B_PKG.Delete_Row)
561: AMS_CONTENT_RULES_B_PKG.Delete_Row(

Line 577: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

573:
574: -- Debug Message
575: IF (AMS_DEBUG_HIGH_ON) THEN
576:
577: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
578: END IF;
579:
580: -- Standard call to get message count and if count is 1, get message info.
581: FND_MSG_PUB.Count_And_Get

Line 587: WHEN AMS_Utility_PVT.resource_locked THEN

583: p_data => x_msg_data
584: );
585: EXCEPTION
586:
587: WHEN AMS_Utility_PVT.resource_locked THEN
588: x_return_status := FND_API.g_ret_sts_error;
589: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
590:
591: WHEN FND_API.G_EXC_ERROR THEN

Line 589: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

585: EXCEPTION
586:
587: WHEN AMS_Utility_PVT.resource_locked THEN
588: x_return_status := FND_API.g_ret_sts_error;
589: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
590:
591: WHEN FND_API.G_EXC_ERROR THEN
592: ROLLBACK TO DELETE_Ct_Rule_PVT;
593: x_return_status := FND_API.G_RET_STS_ERROR;

Line 672: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

668:
669: -- Debug Message
670: IF (AMS_DEBUG_HIGH_ON) THEN
671:
672: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
673: END IF;
674:
675: -- Initialize message list if p_init_msg_list is set to TRUE.
676: IF FND_API.to_Boolean( p_init_msg_list )

Line 701: AMS_Utility_PVT.debug_message(l_full_name||': start');

697: IF (AMS_DEBUG_HIGH_ON) THEN
698:
699:
700:
701: AMS_Utility_PVT.debug_message(l_full_name||': start');
702:
703: END IF;
704: OPEN c_Ct_Rule;
705:

Line 726: AMS_Utility_PVT.debug_message(l_full_name ||': end');

722: p_count => x_msg_count,
723: p_data => x_msg_data);
724: IF (AMS_DEBUG_HIGH_ON) THEN
725:
726: AMS_Utility_PVT.debug_message(l_full_name ||': end');
727: END IF;
728: EXCEPTION
729:
730: WHEN AMS_Utility_PVT.resource_locked THEN

Line 730: WHEN AMS_Utility_PVT.resource_locked THEN

726: AMS_Utility_PVT.debug_message(l_full_name ||': end');
727: END IF;
728: EXCEPTION
729:
730: WHEN AMS_Utility_PVT.resource_locked THEN
731: x_return_status := FND_API.g_ret_sts_error;
732: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
733:
734: WHEN FND_API.G_EXC_ERROR THEN

Line 732: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

728: EXCEPTION
729:
730: WHEN AMS_Utility_PVT.resource_locked THEN
731: x_return_status := FND_API.g_ret_sts_error;
732: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
733:
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO LOCK_Ct_Rule_PVT;
736: x_return_status := FND_API.G_RET_STS_ERROR;

Line 814: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique start');

810: IF (AMS_DEBUG_HIGH_ON) THEN
811:
812:
813:
814: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique start');
815:
816: END IF;
817:
818: IF p_object_id IS null

Line 822: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique : is null');

818: IF p_object_id IS null
819: THEN
820: IF (AMS_DEBUG_HIGH_ON) THEN
821:
822: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique : is null');
823: END IF;
824: OPEN c_rule_det_null ;
825: FETCH c_rule_det_null INTO l_dummy ;
826: CLOSE c_rule_det_null ;

Line 830: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique : is not null');

826: CLOSE c_rule_det_null ;
827: ELSE
828: IF (AMS_DEBUG_HIGH_ON) THEN
829:
830: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique : is not null');
831: END IF;
832: OPEN c_rule_det ;
833: FETCH c_rule_det INTO l_dummy ;
834: CLOSE c_rule_det ;

Line 840: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique : did not find anything');

836:
837: IF l_dummy IS NULL THEN
838: IF (AMS_DEBUG_HIGH_ON) THEN
839:
840: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique : did not find anything');
841: END IF;
842: RETURN FND_API.g_true ;
843: ELSE
844: IF (AMS_DEBUG_HIGH_ON) THEN

Line 846: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique : found something');

842: RETURN FND_API.g_true ;
843: ELSE
844: IF (AMS_DEBUG_HIGH_ON) THEN
845:
846: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_rule_unique : found something');
847: END IF;
848: RETURN FND_API.g_false;
849: END IF;
850:

Line 879: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items start');

875: l_sql VARCHAR2(400);
876: BEGIN
877: IF (AMS_DEBUG_HIGH_ON) THEN
878:
879: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items start');
880: END IF;
881:
882: x_return_status := FND_API.g_ret_sts_success;
883: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 884: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

880: END IF;
881:
882: x_return_status := FND_API.g_ret_sts_success;
883: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
884: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
885: 'AMS_CONTENT_RULES_B',
886: 'CONTENT_RULE_ID = ''' || p_ct_rule_rec.CONTENT_RULE_ID ||''''
887: );
888: ELSE

Line 889: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

885: 'AMS_CONTENT_RULES_B',
886: 'CONTENT_RULE_ID = ''' || p_ct_rule_rec.CONTENT_RULE_ID ||''''
887: );
888: ELSE
889: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
890: 'AMS_CONTENT_RULES_B',
891: 'CONTENT_RULE_ID = ''' || p_ct_rule_rec.CONTENT_RULE_ID ||
892: ''' AND CONTENT_RULE_ID <> ' || p_ct_rule_rec.CONTENT_RULE_ID
893: );

Line 899: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items before unique check');

895:
896: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
897: IF (AMS_DEBUG_HIGH_ON) THEN
898:
899: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items before unique check');
900: END IF;
901: l_sql := ' WHERE OBJECT_TYPE <> ''' || p_ct_rule_rec.OBJECT_TYPE || '''';
902: l_sql := l_sql || ' AND TRIGGER_CODE <>''' || p_ct_rule_rec.TRIGGER_CODE || '''';
903: IF p_ct_rule_rec.object_id IS null

Line 912: AMS_UTILITY_PVT.debug_message(l_sql);

908: IF (AMS_DEBUG_HIGH_ON) THEN
909:
910:
911:
912: AMS_UTILITY_PVT.debug_message(l_sql);
913:
914: END IF;
915:
916: /*

Line 917: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

913:
914: END IF;
915:
916: /*
917: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
918: 'AMS_CONTENT_RULES_B',
919: l_sql
920: );
921:

Line 931: AMS_Utility_PVT.Error_Message('AMS_CONR_ONLY_ONE');

927: , p_ct_rule_rec.object_id
928: , p_ct_rule_rec.enabled_flag
929: )
930: THEN
931: AMS_Utility_PVT.Error_Message('AMS_CONR_ONLY_ONE');
932: x_return_status := FND_API.g_ret_sts_error;
933: RAISE FND_API.g_exc_error;
934: END IF ;
935: END IF;

Line 938: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items after unique check');

934: END IF ;
935: END IF;
936: IF (AMS_DEBUG_HIGH_ON) THEN
937:
938: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items after unique check');
939: END IF;
940:
941: IF l_valid_flag = FND_API.g_false THEN
942: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTENT_RULE_ID_DUPLICATE');

Line 942: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTENT_RULE_ID_DUPLICATE');

938: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_ct_rule_uk_items after unique check');
939: END IF;
940:
941: IF l_valid_flag = FND_API.g_false THEN
942: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTENT_RULE_ID_DUPLICATE');
943: x_return_status := FND_API.g_ret_sts_error;
944: RETURN;
945: END IF;
946:

Line 1341: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1337:
1338: -- Debug Message
1339: IF (AMS_DEBUG_HIGH_ON) THEN
1340:
1341: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1342: END IF;
1343:
1344:
1345: -- Initialize API return status to SUCCESS

Line 1352: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1348:
1349: -- Debug Message
1350: IF (AMS_DEBUG_HIGH_ON) THEN
1351:
1352: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1353: END IF;
1354:
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get

Line 1362: WHEN AMS_Utility_PVT.resource_locked THEN

1358: p_data => x_msg_data
1359: );
1360: EXCEPTION
1361:
1362: WHEN AMS_Utility_PVT.resource_locked THEN
1363: x_return_status := FND_API.g_ret_sts_error;
1364: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1365:
1366: WHEN FND_API.G_EXC_ERROR THEN

Line 1364: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1360: EXCEPTION
1361:
1362: WHEN AMS_Utility_PVT.resource_locked THEN
1363: x_return_status := FND_API.g_ret_sts_error;
1364: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1365:
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: ROLLBACK TO VALIDATE_Ct_Rule_;
1368: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1442: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1438:
1439: -- Debug Message
1440: IF (AMS_DEBUG_HIGH_ON) THEN
1441:
1442: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1443: END IF;
1444: -- Standard call to get message count and if count is 1, get message info.
1445: FND_MSG_PUB.Count_And_Get
1446: (p_count => x_msg_count,

Line 1593: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : start');

1589: IF (AMS_DEBUG_HIGH_ON) THEN
1590:
1591:
1592:
1593: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : start');
1594:
1595: END IF;
1596: -- (1)
1597: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1599: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : before check for object level trigger');

1595: END IF;
1596: -- (1)
1597: IF (AMS_DEBUG_HIGH_ON) THEN
1598:
1599: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : before check for object level trigger');
1600: END IF;
1601: OPEN c_rules_for_object_enabled;
1602: FETCH c_rules_for_object_enabled INTO l_dummy_template_id, l_dummy_email_subject, l_dummy_sender, l_dummy_reply_to,l_dummy_sender_display_name, l_dummy_delivery_mode;-- dhsingh on 02-sep-2004
1603: IF c_rules_for_object_enabled%NOTFOUND

Line 1607: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : NOT FOUND object level trigger');

1603: IF c_rules_for_object_enabled%NOTFOUND
1604: THEN
1605: IF (AMS_DEBUG_HIGH_ON) THEN
1606:
1607: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : NOT FOUND object level trigger');
1608: END IF;
1609: -- (2)
1610: IF (AMS_DEBUG_HIGH_ON) THEN
1611:

Line 1612: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : before check for generic level trigger');

1608: END IF;
1609: -- (2)
1610: IF (AMS_DEBUG_HIGH_ON) THEN
1611:
1612: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : before check for generic level trigger');
1613: END IF;
1614: OPEN c_rules_generic;
1615: FETCH c_rules_generic INTO l_dummy_template_id, l_dummy_email_subject,l_dummy_sender, l_dummy_reply_to,l_dummy_sender_display_name, l_dummy_delivery_mode;-- dhsingh on 02-sep-2004
1616: IF c_rules_generic%NOTFOUND

Line 1621: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : NOT FOUND generic level trigger');

1617: THEN
1618: -- not found
1619: IF (AMS_DEBUG_HIGH_ON) THEN
1620:
1621: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : NOT FOUND generic level trigger');
1622: END IF;
1623: NULL;
1624: ELSE
1625: -- found

Line 1628: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND generic level trigger');

1624: ELSE
1625: -- found
1626: IF (AMS_DEBUG_HIGH_ON) THEN
1627:
1628: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND generic level trigger');
1629: END IF;
1630: l_template_id := l_dummy_template_id;
1631: l_email_subject := l_dummy_email_subject;
1632: -- start dhsingh on 02-sep-2004

Line 1641: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : before check for is generic level trigger disabled');

1637: -- (3)
1638: l_delivery_mode := l_dummy_delivery_mode;
1639: IF (AMS_DEBUG_HIGH_ON) THEN
1640:
1641: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : before check for is generic level trigger disabled');
1642: END IF;
1643: OPEN c_rules_for_object_disabled;
1644: FETCH c_rules_for_object_disabled INTO l_dummy_template_id, l_dummy_email_subject, l_dummy_sender, l_dummy_reply_to,l_dummy_sender_display_name, l_dummy_delivery_mode;-- dhsingh on 02-sep-2004
1645: IF c_rules_for_object_disabled%NOTFOUND

Line 1650: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : generic level trigger NOT disabled');

1646: THEN
1647: -- not found
1648: IF (AMS_DEBUG_HIGH_ON) THEN
1649:
1650: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : generic level trigger NOT disabled');
1651: END IF;
1652: l_send_request := 1;
1653: IF (AMS_DEBUG_HIGH_ON) THEN
1654:

Line 1655: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : template id is '||l_template_id);

1651: END IF;
1652: l_send_request := 1;
1653: IF (AMS_DEBUG_HIGH_ON) THEN
1654:
1655: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : template id is '||l_template_id);
1656: END IF;
1657: IF (AMS_DEBUG_HIGH_ON) THEN
1658:
1659: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : subject is '||l_email_subject);

Line 1659: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : subject is '||l_email_subject);

1655: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : template id is '||l_template_id);
1656: END IF;
1657: IF (AMS_DEBUG_HIGH_ON) THEN
1658:
1659: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : subject is '||l_email_subject);
1660: END IF;
1661: -- start dhsingh on 02-sep-2004
1662: IF (AMS_DEBUG_HIGH_ON) THEN
1663: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sender is '||l_sender);

Line 1663: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sender is '||l_sender);

1659: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : subject is '||l_email_subject);
1660: END IF;
1661: -- start dhsingh on 02-sep-2004
1662: IF (AMS_DEBUG_HIGH_ON) THEN
1663: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sender is '||l_sender);
1664: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : reply-to is '||l_reply_to);
1665: END IF;
1666: -- end dhsingh on 02-sep-2004
1667:

Line 1664: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : reply-to is '||l_reply_to);

1660: END IF;
1661: -- start dhsingh on 02-sep-2004
1662: IF (AMS_DEBUG_HIGH_ON) THEN
1663: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sender is '||l_sender);
1664: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : reply-to is '||l_reply_to);
1665: END IF;
1666: -- end dhsingh on 02-sep-2004
1667:
1668: ELSE

Line 1672: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : generic level trigger IS disabled');

1668: ELSE
1669: -- found
1670: IF (AMS_DEBUG_HIGH_ON) THEN
1671:
1672: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : generic level trigger IS disabled');
1673: END IF;
1674: NULL;
1675: END IF;
1676: CLOSE c_rules_for_object_disabled;

Line 1684: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND object level trigger');

1680:
1681: ELSE
1682: IF (AMS_DEBUG_HIGH_ON) THEN
1683:
1684: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND object level trigger');
1685: END IF;
1686: -- found
1687: l_send_request := 1;
1688: l_template_id := l_dummy_template_id;

Line 1699: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND object level trigger id is '||l_template_id);

1695: -- prageorg 29-May-2006
1696: l_delivery_mode := l_dummy_delivery_mode;
1697: IF (AMS_DEBUG_HIGH_ON) THEN
1698:
1699: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND object level trigger id is '||l_template_id);
1700: END IF;
1701: IF (AMS_DEBUG_HIGH_ON) THEN
1702:
1703: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND object level trigger subject is '||l_email_subject);

Line 1703: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND object level trigger subject is '||l_email_subject);

1699: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND object level trigger id is '||l_template_id);
1700: END IF;
1701: IF (AMS_DEBUG_HIGH_ON) THEN
1702:
1703: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : FOUND object level trigger subject is '||l_email_subject);
1704: END IF;
1705: END IF;
1706: -- start dhsingh on 02-sep-2004
1707: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1709: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sender is '||l_sender);

1705: END IF;
1706: -- start dhsingh on 02-sep-2004
1707: IF (AMS_DEBUG_HIGH_ON) THEN
1708: begin
1709: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sender is '||l_sender);
1710: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : reply-to is '||l_reply_to);
1711: end;
1712: END IF;
1713: -- end dhsingh on 02-sep-2004

Line 1710: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : reply-to is '||l_reply_to);

1706: -- start dhsingh on 02-sep-2004
1707: IF (AMS_DEBUG_HIGH_ON) THEN
1708: begin
1709: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sender is '||l_sender);
1710: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : reply-to is '||l_reply_to);
1711: end;
1712: END IF;
1713: -- end dhsingh on 02-sep-2004
1714: CLOSE c_rules_for_object_enabled;

Line 1728: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : BEFORE sending REQUEST ');

1724: FETCH c_source_code INTO l_source_code, l_source_code_id;
1725: CLOSE c_source_code ;
1726:
1727: IF (AMS_DEBUG_HIGH_ON) THEN
1728: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : BEFORE sending REQUEST ');
1729: END IF;
1730:
1731: -- soagrawa 12-dec-2002 replaced AMF callout with JTF 1-to-1 call for 11.5.9
1732:

Line 1808: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.template_id := '||l_template_id);

1804: x_request_history_id => x_request_history_id
1805: );
1806:
1807: IF (AMS_DEBUG_HIGH_ON) THEN
1808: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.template_id := '||l_template_id);
1809: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.version_id := '||'1');
1810: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_type := '||p_object_type);
1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);
1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);

Line 1809: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.version_id := '||'1');

1805: );
1806:
1807: IF (AMS_DEBUG_HIGH_ON) THEN
1808: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.template_id := '||l_template_id);
1809: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.version_id := '||'1');
1810: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_type := '||p_object_type);
1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);
1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);
1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);

Line 1810: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_type := '||p_object_type);

1806:
1807: IF (AMS_DEBUG_HIGH_ON) THEN
1808: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.template_id := '||l_template_id);
1809: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.version_id := '||'1');
1810: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_type := '||p_object_type);
1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);
1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);
1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);
1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);

Line 1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);

1807: IF (AMS_DEBUG_HIGH_ON) THEN
1808: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.template_id := '||l_template_id);
1809: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.version_id := '||'1');
1810: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_type := '||p_object_type);
1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);
1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);
1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);
1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);
1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;

Line 1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);

1808: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.template_id := '||l_template_id);
1809: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.version_id := '||'1');
1810: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_type := '||p_object_type);
1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);
1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);
1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);
1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);
1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;
1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);

Line 1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);

1809: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.version_id := '||'1');
1810: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_type := '||p_object_type);
1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);
1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);
1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);
1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);
1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;
1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);
1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);

Line 1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);

1810: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_type := '||p_object_type);
1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);
1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);
1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);
1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);
1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;
1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);
1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);
1818: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.media_types := '||p_media_types); --??

Line 1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;

1811: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.object_id := '||p_object_id);
1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);
1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);
1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);
1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;
1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);
1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);
1818: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.media_types := '||p_media_types); --??
1819: --l_fulfill_electronic_rec.archive := 'N'; -- thts the default

Line 1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);

1812: ams_utility_pvt.debug_message(' l_fulfill_electronic_rec.source_code := '||l_source_code);
1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);
1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);
1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;
1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);
1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);
1818: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.media_types := '||p_media_types); --??
1819: --l_fulfill_electronic_rec.archive := 'N'; -- thts the default
1820: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.log_user_ih := '||p_log_user_ih);

Line 1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);

1813: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.source_code_id := '||l_source_code_id);
1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);
1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;
1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);
1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);
1818: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.media_types := '||p_media_types); --??
1819: --l_fulfill_electronic_rec.archive := 'N'; -- thts the default
1820: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.log_user_ih := '||p_log_user_ih);
1821: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.request_type := '||p_request_type);

Line 1818: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.media_types := '||p_media_types); --??

1814: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_type := '||p_requestor_type);
1815: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.requestor_id := '||p_requestor_id); --l_resource_id;
1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);
1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);
1818: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.media_types := '||p_media_types); --??
1819: --l_fulfill_electronic_rec.archive := 'N'; -- thts the default
1820: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.log_user_ih := '||p_log_user_ih);
1821: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.request_type := '||p_request_type);
1822: --l_fulfill_electronic_rec.profile_id := p_profile_id;

Line 1820: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.log_user_ih := '||p_log_user_ih);

1816: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.server_group := '||p_server_group);
1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);
1818: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.media_types := '||p_media_types); --??
1819: --l_fulfill_electronic_rec.archive := 'N'; -- thts the default
1820: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.log_user_ih := '||p_log_user_ih);
1821: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.request_type := '||p_request_type);
1822: --l_fulfill_electronic_rec.profile_id := p_profile_id;
1823: --l_fulfill_electronic_rec.order_id := order_id;
1824: --l_fulfill_electronic_rec.collateral_id := collateral_id;

Line 1821: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.request_type := '||p_request_type);

1817: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.schedule_date := '||p_scheduled_date);
1818: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.media_types := '||p_media_types); --??
1819: --l_fulfill_electronic_rec.archive := 'N'; -- thts the default
1820: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.log_user_ih := '||p_log_user_ih);
1821: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.request_type := '||p_request_type);
1822: --l_fulfill_electronic_rec.profile_id := p_profile_id;
1823: --l_fulfill_electronic_rec.order_id := order_id;
1824: --l_fulfill_electronic_rec.collateral_id := collateral_id;
1825: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.subject := '||l_email_subject);

Line 1825: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.subject := '||l_email_subject);

1821: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.request_type := '||p_request_type);
1822: --l_fulfill_electronic_rec.profile_id := p_profile_id;
1823: --l_fulfill_electronic_rec.order_id := order_id;
1824: --l_fulfill_electronic_rec.collateral_id := collateral_id;
1825: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.subject := '||l_email_subject);
1826: -- start dhsingh on 02-sep-2004
1827: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.extended_header := '||l_extended_header);
1828: -- end dhsingh on 02-sep-2004
1829: ams_utility_pvt.debug_message('Length of bind variables names '|| p_bind_names.count);

Line 1827: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.extended_header := '||l_extended_header);

1823: --l_fulfill_electronic_rec.order_id := order_id;
1824: --l_fulfill_electronic_rec.collateral_id := collateral_id;
1825: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.subject := '||l_email_subject);
1826: -- start dhsingh on 02-sep-2004
1827: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.extended_header := '||l_extended_header);
1828: -- end dhsingh on 02-sep-2004
1829: ams_utility_pvt.debug_message('Length of bind variables names '|| p_bind_names.count);
1830: ams_utility_pvt.debug_message('Length of bind variables values '|| p_bind_values.count);
1831: ams_utility_pvt.debug_message('Delivery mode '|| l_delivery_mode);

Line 1829: ams_utility_pvt.debug_message('Length of bind variables names '|| p_bind_names.count);

1825: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.subject := '||l_email_subject);
1826: -- start dhsingh on 02-sep-2004
1827: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.extended_header := '||l_extended_header);
1828: -- end dhsingh on 02-sep-2004
1829: ams_utility_pvt.debug_message('Length of bind variables names '|| p_bind_names.count);
1830: ams_utility_pvt.debug_message('Length of bind variables values '|| p_bind_values.count);
1831: ams_utility_pvt.debug_message('Delivery mode '|| l_delivery_mode);
1832:
1833: for i IN 1..p_bind_values.count LOOP

Line 1830: ams_utility_pvt.debug_message('Length of bind variables values '|| p_bind_values.count);

1826: -- start dhsingh on 02-sep-2004
1827: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.extended_header := '||l_extended_header);
1828: -- end dhsingh on 02-sep-2004
1829: ams_utility_pvt.debug_message('Length of bind variables names '|| p_bind_names.count);
1830: ams_utility_pvt.debug_message('Length of bind variables values '|| p_bind_values.count);
1831: ams_utility_pvt.debug_message('Delivery mode '|| l_delivery_mode);
1832:
1833: for i IN 1..p_bind_values.count LOOP
1834: ams_utility_pvt.debug_message(i||': bind name ' ||p_bind_names(i));

Line 1831: ams_utility_pvt.debug_message('Delivery mode '|| l_delivery_mode);

1827: ams_utility_pvt.debug_message('l_fulfill_electronic_rec.extended_header := '||l_extended_header);
1828: -- end dhsingh on 02-sep-2004
1829: ams_utility_pvt.debug_message('Length of bind variables names '|| p_bind_names.count);
1830: ams_utility_pvt.debug_message('Length of bind variables values '|| p_bind_values.count);
1831: ams_utility_pvt.debug_message('Delivery mode '|| l_delivery_mode);
1832:
1833: for i IN 1..p_bind_values.count LOOP
1834: ams_utility_pvt.debug_message(i||': bind name ' ||p_bind_names(i));
1835: ams_utility_pvt.debug_message(i||': bind value ' ||p_bind_values(i));

Line 1834: ams_utility_pvt.debug_message(i||': bind name ' ||p_bind_names(i));

1830: ams_utility_pvt.debug_message('Length of bind variables values '|| p_bind_values.count);
1831: ams_utility_pvt.debug_message('Delivery mode '|| l_delivery_mode);
1832:
1833: for i IN 1..p_bind_values.count LOOP
1834: ams_utility_pvt.debug_message(i||': bind name ' ||p_bind_names(i));
1835: ams_utility_pvt.debug_message(i||': bind value ' ||p_bind_values(i));
1836: end loop;
1837:
1838:

Line 1835: ams_utility_pvt.debug_message(i||': bind value ' ||p_bind_values(i));

1831: ams_utility_pvt.debug_message('Delivery mode '|| l_delivery_mode);
1832:
1833: for i IN 1..p_bind_values.count LOOP
1834: ams_utility_pvt.debug_message(i||': bind name ' ||p_bind_names(i));
1835: ams_utility_pvt.debug_message(i||': bind value ' ||p_bind_values(i));
1836: end loop;
1837:
1838:
1839:

Line 1840: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST ');

1836: end loop;
1837:
1838:
1839:
1840: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST ');
1841: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST template id sent was '||l_template_id);
1842: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sending REQUEST was '||x_return_status);
1843: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST req_his_id is '||x_request_history_id);
1844: END IF;

Line 1841: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST template id sent was '||l_template_id);

1837:
1838:
1839:
1840: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST ');
1841: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST template id sent was '||l_template_id);
1842: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sending REQUEST was '||x_return_status);
1843: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST req_his_id is '||x_request_history_id);
1844: END IF;
1845: END IF;

Line 1842: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sending REQUEST was '||x_return_status);

1838:
1839:
1840: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST ');
1841: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST template id sent was '||l_template_id);
1842: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sending REQUEST was '||x_return_status);
1843: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST req_his_id is '||x_request_history_id);
1844: END IF;
1845: END IF;
1846:

Line 1843: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST req_his_id is '||x_request_history_id);

1839:
1840: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST ');
1841: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST template id sent was '||l_template_id);
1842: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : sending REQUEST was '||x_return_status);
1843: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: check_content_rule : AFTER sending REQUEST req_his_id is '||x_request_history_id);
1844: END IF;
1845: END IF;
1846:
1847: