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_THLDACT_PVT dependencies on AMS_UTILITY_PVT

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

93: -- Debug Message
94: --
95: IF (AMS_DEBUG_HIGH_ON) THEN
96:
97: AMS_Utility_PVT.debug_message(l_full_name||': start');
98: END IF;
99:
100: --
101: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 131: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

127: --
128: -- Validate Trigger Action
129: --
130: IF (AMS_DEBUG_HIGH_ON) THEN
131: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
132: END IF;
133:
134: --
135: -- Find the Unique Primary Key if not sent

Line 172: AMS_Utility_PVT.debug_message(l_full_name ||': insert');

168: -- Insert the Record in Trigger Checks table
169: --
170:
171: IF (AMS_DEBUG_HIGH_ON) THEN
172: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
173: AMS_Utility_PVT.debug_message('CG: the value of trigger_action_id = ' || l_thldact_rec.trigger_action_id);
174: AMS_Utility_PVT.debug_message('CG: the value of process_id = ' || l_thldact_rec.process_id);
175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);
176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);

Line 173: AMS_Utility_PVT.debug_message('CG: the value of trigger_action_id = ' || l_thldact_rec.trigger_action_id);

169: --
170:
171: IF (AMS_DEBUG_HIGH_ON) THEN
172: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
173: AMS_Utility_PVT.debug_message('CG: the value of trigger_action_id = ' || l_thldact_rec.trigger_action_id);
174: AMS_Utility_PVT.debug_message('CG: the value of process_id = ' || l_thldact_rec.process_id);
175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);
176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);
177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);

Line 174: AMS_Utility_PVT.debug_message('CG: the value of process_id = ' || l_thldact_rec.process_id);

170:
171: IF (AMS_DEBUG_HIGH_ON) THEN
172: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
173: AMS_Utility_PVT.debug_message('CG: the value of trigger_action_id = ' || l_thldact_rec.trigger_action_id);
174: AMS_Utility_PVT.debug_message('CG: the value of process_id = ' || l_thldact_rec.process_id);
175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);
176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);
177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);
178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);

Line 175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);

171: IF (AMS_DEBUG_HIGH_ON) THEN
172: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
173: AMS_Utility_PVT.debug_message('CG: the value of trigger_action_id = ' || l_thldact_rec.trigger_action_id);
174: AMS_Utility_PVT.debug_message('CG: the value of process_id = ' || l_thldact_rec.process_id);
175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);
176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);
177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);
178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);
179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);

Line 176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);

172: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
173: AMS_Utility_PVT.debug_message('CG: the value of trigger_action_id = ' || l_thldact_rec.trigger_action_id);
174: AMS_Utility_PVT.debug_message('CG: the value of process_id = ' || l_thldact_rec.process_id);
175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);
176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);
177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);
178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);
179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);
180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);

Line 177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);

173: AMS_Utility_PVT.debug_message('CG: the value of trigger_action_id = ' || l_thldact_rec.trigger_action_id);
174: AMS_Utility_PVT.debug_message('CG: the value of process_id = ' || l_thldact_rec.process_id);
175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);
176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);
177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);
178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);
179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);
180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);
181: AMS_Utility_PVT.debug_message('CG: the value of deliverable_id = ' || l_thldact_rec.deliverable_id);

Line 178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);

174: AMS_Utility_PVT.debug_message('CG: the value of process_id = ' || l_thldact_rec.process_id);
175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);
176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);
177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);
178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);
179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);
180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);
181: AMS_Utility_PVT.debug_message('CG: the value of deliverable_id = ' || l_thldact_rec.deliverable_id);
182: AMS_Utility_PVT.debug_message('CG: the value of activity_offer_id = ' || l_thldact_rec.activity_offer_id);

Line 179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);

175: AMS_Utility_PVT.debug_message('CG: the value of trigger_id = ' || l_thldact_rec.trigger_id);
176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);
177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);
178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);
179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);
180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);
181: AMS_Utility_PVT.debug_message('CG: the value of deliverable_id = ' || l_thldact_rec.deliverable_id);
182: AMS_Utility_PVT.debug_message('CG: the value of activity_offer_id = ' || l_thldact_rec.activity_offer_id);
183: AMS_Utility_PVT.debug_message('CG: the value of cover_letter_id = ' || l_thldact_rec.cover_letter_id);

Line 180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);

176: AMS_Utility_PVT.debug_message('CG: the value of order_number = ' || l_thldact_rec.order_number);
177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);
178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);
179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);
180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);
181: AMS_Utility_PVT.debug_message('CG: the value of deliverable_id = ' || l_thldact_rec.deliverable_id);
182: AMS_Utility_PVT.debug_message('CG: the value of activity_offer_id = ' || l_thldact_rec.activity_offer_id);
183: AMS_Utility_PVT.debug_message('CG: the value of cover_letter_id = ' || l_thldact_rec.cover_letter_id);
184: END IF;

Line 181: AMS_Utility_PVT.debug_message('CG: the value of deliverable_id = ' || l_thldact_rec.deliverable_id);

177: --AMS_Utility_PVT.debug_message('CG: the value of action_notif_user_id = ' || l_thldact_rec.action_notif_user_id);
178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);
179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);
180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);
181: AMS_Utility_PVT.debug_message('CG: the value of deliverable_id = ' || l_thldact_rec.deliverable_id);
182: AMS_Utility_PVT.debug_message('CG: the value of activity_offer_id = ' || l_thldact_rec.activity_offer_id);
183: AMS_Utility_PVT.debug_message('CG: the value of cover_letter_id = ' || l_thldact_rec.cover_letter_id);
184: END IF;
185:

Line 182: AMS_Utility_PVT.debug_message('CG: the value of activity_offer_id = ' || l_thldact_rec.activity_offer_id);

178: AMS_Utility_PVT.debug_message('CG: the value of action_approver_user_id = ' || l_thldact_rec.action_approver_user_id);
179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);
180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);
181: AMS_Utility_PVT.debug_message('CG: the value of deliverable_id = ' || l_thldact_rec.deliverable_id);
182: AMS_Utility_PVT.debug_message('CG: the value of activity_offer_id = ' || l_thldact_rec.activity_offer_id);
183: AMS_Utility_PVT.debug_message('CG: the value of cover_letter_id = ' || l_thldact_rec.cover_letter_id);
184: END IF;
185:
186: IF (l_thldact_rec.process_id = FND_API.G_MISS_NUM) THEN

Line 183: AMS_Utility_PVT.debug_message('CG: the value of cover_letter_id = ' || l_thldact_rec.cover_letter_id);

179: AMS_Utility_PVT.debug_message('CG: the value of list_header_id = ' || l_thldact_rec.list_header_id);
180: AMS_Utility_PVT.debug_message('CG: the value of list_connected_to_id = ' || l_thldact_rec.list_connected_to_id);
181: AMS_Utility_PVT.debug_message('CG: the value of deliverable_id = ' || l_thldact_rec.deliverable_id);
182: AMS_Utility_PVT.debug_message('CG: the value of activity_offer_id = ' || l_thldact_rec.activity_offer_id);
183: AMS_Utility_PVT.debug_message('CG: the value of cover_letter_id = ' || l_thldact_rec.cover_letter_id);
184: END IF;
185:
186: IF (l_thldact_rec.process_id = FND_API.G_MISS_NUM) THEN
187: l_thldact_rec.process_id := NULL;

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

317: p_encoded => FND_API.G_FALSE
318: );
319:
320: IF (AMS_DEBUG_HIGH_ON) THEN
321: AMS_Utility_PVT.debug_message(l_full_name ||': end');
322: END IF;
323:
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN

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

399: -- Debug Message
400: --
401: IF (AMS_DEBUG_HIGH_ON) THEN
402:
403: AMS_Utility_PVT.debug_message(l_full_name||': start');
404: END IF;
405:
406: --
407: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 436: AMS_Utility_PVT.debug_message(l_full_name ||': delete');

432: -- Debug Message
433: --
434: IF (AMS_DEBUG_HIGH_ON) THEN
435:
436: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
437: END IF;
438:
439: --
440: -- Debug Message

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

564: -- Debug Message
565: --
566: IF (AMS_DEBUG_HIGH_ON) THEN
567:
568: AMS_Utility_PVT.debug_message(l_full_name||': start');
569: END IF;
570:
571: --
572: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 601: AMS_Utility_PVT.debug_message(l_full_name||': lock');

597: -- Lock the Trigger Action
598: --
599: IF (AMS_DEBUG_HIGH_ON) THEN
600:
601: AMS_Utility_PVT.debug_message(l_full_name||': lock');
602: END IF;
603:
604: -- Perform the database operation
605: OPEN C_ams_trigger_actions;

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

635: -- Debug Message
636: --
637: IF (AMS_DEBUG_HIGH_ON) THEN
638:
639: AMS_Utility_PVT.debug_message(l_full_name ||': end');
640: END IF;
641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN

Line 659: WHEN AMS_UTILITY_PVT.RESOURCE_LOCKED THEN

655: ( p_count => x_msg_count,
656: p_data => x_msg_data,
657: p_encoded => FND_API.G_FALSE
658: );
659: WHEN AMS_UTILITY_PVT.RESOURCE_LOCKED THEN
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
663: THEN -- MMSG

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

735: -- Debug Message
736: --
737: IF (AMS_DEBUG_HIGH_ON) THEN
738:
739: AMS_Utility_PVT.debug_message(l_full_name||': start');
740: END IF;
741:
742: --
743: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 774: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

770: -- Debug Message
771: --
772: IF (AMS_DEBUG_HIGH_ON) THEN
773:
774: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
775: END IF;
776:
777: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
778: Check_thldact_Items(

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

871: -- Debug Message
872: --
873: IF (AMS_DEBUG_HIGH_ON) THEN
874:
875: AMS_Utility_PVT.debug_message(l_full_name ||': end');
876: END IF;
877:
878: EXCEPTION
879: WHEN FND_API.G_EXC_ERROR THEN

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

955: -- Debug Message
956: --
957: IF (AMS_DEBUG_HIGH_ON) THEN
958:
959: AMS_Utility_PVT.debug_message(l_full_name||': start');
960: END IF;
961:
962: -- Initialize message list if p_init_msg_list is set to TRUE.
963: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1003: AMS_Utility_PVT.debug_message(l_full_name||': check record');

999: -- Debug Message
1000: --
1001: IF (AMS_DEBUG_HIGH_ON) THEN
1002:
1003: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1004: END IF;
1005:
1006: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1007: Check_thldact_record(

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

1031: -- Debug Message
1032: --
1033: IF (AMS_DEBUG_HIGH_ON) THEN
1034:
1035: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1036: END IF;
1037:
1038:
1039:

Line 1170: IF AMS_Utility_PVT.check_uniqueness(

1166: -- check if this trigger_action_id is unique.
1167: IF p_validation_mode = JTF_PLSQL_API.g_create
1168: AND p_thldact_rec.trigger_action_id IS NOT NULL
1169: THEN
1170: IF AMS_Utility_PVT.check_uniqueness(
1171: 'ams_trigger_actions',
1172: 'trigger_action_id = ' || p_thldact_rec.trigger_action_id
1173: ) = FND_API.g_false
1174: THEN

Line 1200: IF AMS_Utility_PVT.Check_Uniqueness(

1196: -- soagrawa 30-apr-2003
1197: l_where_clause := l_where_clause || ' AND execute_action_type <> ' || p_thldact_rec.execute_action_type;
1198: -- END IF;
1199:
1200: IF AMS_Utility_PVT.Check_Uniqueness(
1201: p_table_name => 'ams_trigger_actions',
1202: p_where_clause => l_where_clause
1203: ) = FND_API.g_false
1204: THEN

Line 1260: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1256: THEN
1257: l_table_name := 'AMS_TRIGGERS' ;
1258: l_pk_name := 'trigger_id' ;
1259: l_pk_value := p_thldact_rec.trigger_id;
1260: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1261: l_additional_where_clause := NULL ;
1262:
1263: IF AMS_Utility_PVT.Check_Fk_Exists
1264: (p_table_name => l_table_name

Line 1263: IF AMS_Utility_PVT.Check_Fk_Exists

1259: l_pk_value := p_thldact_rec.trigger_id;
1260: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1261: l_additional_where_clause := NULL ;
1262:
1263: IF AMS_Utility_PVT.Check_Fk_Exists
1264: (p_table_name => l_table_name
1265: ,p_PK_name => l_pk_name
1266: ,p_PK_value => l_pk_value
1267: ,p_pk_data_type => l_pk_data_type

Line 1294: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1290: p_thldact_rec.list_header_id IS NOT NULL THEN
1291: l_table_name := 'AMS_LIST_HEADERS_ALL' ;
1292: l_pk_name := 'LIST_HEADER_ID' ;
1293: l_pk_value := p_thldact_rec.list_header_id;
1294: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1295: l_additional_where_clause := ' list_type = '||''''||'TEMPLATE'||'''' ;
1296:
1297: -- Following code is modified by ptendulk on Mar16th
1298: -- The list of type TEMPLATE can 0nly be attached to the Triggers

Line 1304: IF AMS_Utility_PVT.Check_Fk_Exists

1300: -- l_additional_where_clause := ' generation_type = '||''''||'REPEAT'||''''
1301: -- ||' and status_code = '||''''||'RESERVED'||'''' ;
1302: --
1303: -- dbms_output.put_line('Where Clause '||l_additional_where_clause);
1304: IF AMS_Utility_PVT.Check_Fk_Exists
1305: (p_table_name => l_table_name
1306: ,p_PK_name => l_pk_name
1307: ,p_PK_value => l_pk_value
1308: ,p_pk_data_type => l_pk_data_type

Line 1339: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1335: AND p_thldact_rec.action_approver_user_id IS NOT NULL THEN
1336: l_table_name := 'jtf_rs_resource_extns' ;
1337: l_pk_name := 'resource_id' ;
1338: l_pk_value := p_thldact_rec.action_approver_user_id;
1339: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1340: l_additional_where_clause := ' category = '||''''||'EMPLOYEE'||'''' ;
1341:
1342: IF AMS_Utility_PVT.Check_Fk_Exists
1343: (p_table_name => l_table_name

Line 1342: IF AMS_Utility_PVT.Check_Fk_Exists

1338: l_pk_value := p_thldact_rec.action_approver_user_id;
1339: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1340: l_additional_where_clause := ' category = '||''''||'EMPLOYEE'||'''' ;
1341:
1342: IF AMS_Utility_PVT.Check_Fk_Exists
1343: (p_table_name => l_table_name
1344: ,p_PK_name => l_pk_name
1345: ,p_PK_value => l_pk_value
1346: ,p_pk_data_type => l_pk_data_type

Line 1372: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;

1368: AND p_thldact_rec.dscript_name IS NOT NULL THEN
1369: l_table_name := 'ies_deployed_scripts' ;
1370: l_pk_name := 'dscript_name' ;
1371: l_pk_value := p_thldact_rec.dscript_name;
1372: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;
1373: l_additional_where_clause := NULL ;
1374:
1375: IF AMS_Utility_PVT.Check_Fk_Exists
1376: (p_table_name => l_table_name

Line 1375: IF AMS_Utility_PVT.Check_Fk_Exists

1371: l_pk_value := p_thldact_rec.dscript_name;
1372: l_pk_data_type := AMS_Utility_PVT.G_VARCHAR2;
1373: l_additional_where_clause := NULL ;
1374:
1375: IF AMS_Utility_PVT.Check_Fk_Exists
1376: (p_table_name => l_table_name
1377: ,p_PK_name => l_pk_name
1378: ,p_PK_value => l_pk_value
1379: ,p_pk_data_type => l_pk_data_type

Line 1405: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1401: AND p_thldact_rec.activity_offer_id IS NOT NULL THEN
1402: l_table_name := 'ams_act_offers' ;
1403: l_pk_name := 'activity_offer_id' ;
1404: l_pk_value := p_thldact_rec.activity_offer_id;
1405: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1406: l_additional_where_clause := NULL ;
1407:
1408: IF AMS_Utility_PVT.Check_Fk_Exists
1409: (p_table_name => l_table_name

Line 1408: IF AMS_Utility_PVT.Check_Fk_Exists

1404: l_pk_value := p_thldact_rec.activity_offer_id;
1405: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1406: l_additional_where_clause := NULL ;
1407:
1408: IF AMS_Utility_PVT.Check_Fk_Exists
1409: (p_table_name => l_table_name
1410: ,p_PK_name => l_pk_name
1411: ,p_PK_value => l_pk_value
1412: ,p_pk_data_type => l_pk_data_type

Line 1441: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

1437: p_thldact_rec.cover_letter_id <> FND_API.G_MISS_NUM
1438: THEN
1439: l_table_name := 'jtf_amv_items_vl';
1440: l_pk_name := 'item_id' ;
1441: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
1442: l_pk_value := p_thldact_rec.cover_letter_id ;
1443: l_additional_where_clause := ' content_type_id = 20'||
1444: ' AND (effective_start_date <= SYSDATE OR effective_start_date IS NULL)'||
1445: ' AND (expiration_date >= SYSDATE OR expiration_date IS NULL)' ;

Line 1447: IF AMS_Utility_PVT.Check_FK_Exists (

1443: l_additional_where_clause := ' content_type_id = 20'||
1444: ' AND (effective_start_date <= SYSDATE OR effective_start_date IS NULL)'||
1445: ' AND (expiration_date >= SYSDATE OR expiration_date IS NULL)' ;
1446:
1447: IF AMS_Utility_PVT.Check_FK_Exists (
1448: p_table_name => l_table_name
1449: ,p_pk_name => l_pk_name
1450: ,p_pk_value => l_pk_value
1451: ,p_pk_data_type => l_pk_data_type

Line 1503: IF AMS_Utility_PVT.Check_Lookup_Exists

1499: --
1500: IF p_thldact_rec.execute_action_type <> FND_API.G_MISS_CHAR
1501: AND p_thldact_rec.execute_action_type IS NOT NULL
1502: THEN
1503: IF AMS_Utility_PVT.Check_Lookup_Exists
1504: ( p_lookup_table_name => 'AMS_LOOKUPS'
1505: ,p_lookup_type => 'AMS_TRIG_ACTION_TYPE'
1506: ,p_lookup_code => p_thldact_rec.execute_action_type
1507: ) = FND_API.G_FALSE then

Line 1555: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.notify_flag) = FND_API.g_false

1551: /*
1552: IF p_thldact_rec.notify_flag <> FND_API.g_miss_char
1553: AND p_thldact_rec.notify_flag IS NOT NULL
1554: THEN
1555: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.notify_flag) = FND_API.g_false
1556: THEN
1557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1558: THEN
1559: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_NOTIFY_FLAG');

Line 1575: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.generate_list_flag) = FND_API.g_false

1571: /*
1572: IF p_thldact_rec.generate_list_flag <> FND_API.g_miss_char
1573: AND p_thldact_rec.generate_list_flag IS NOT NULL
1574: THEN
1575: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.generate_list_flag) = FND_API.g_false
1576: THEN
1577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1578: THEN
1579: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_GEN_LIST_FLAG');

Line 1595: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.action_need_approval_flag) = FND_API.g_false

1591: /*
1592: IF p_thldact_rec.action_need_approval_flag <> FND_API.g_miss_char
1593: AND p_thldact_rec.action_need_approval_flag IS NOT NULL
1594: THEN
1595: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.action_need_approval_flag) = FND_API.g_false
1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_APPR_FLAG');

Line 1781: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1777:
1778:
1779: l_pk_value := p_thldact_rec.deliverable_id;
1780: l_pk_name := 'using_object_id';
1781: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1782: l_table_name := 'ams_object_associations';
1783:
1784: -- Following code has been modified by ptendulk on 24Feb2000
1785: l_additional_where_clause := ' master_object_type = '||''''||l_obj_type||''''||

Line 1789: IF AMS_Utility_PVT.Check_FK_Exists (

1785: l_additional_where_clause := ' master_object_type = '||''''||l_obj_type||''''||
1786: ' and using_object_type = '||''''||'DELV'||''''||
1787: ' and master_object_id = '||l_obj_id ;
1788:
1789: IF AMS_Utility_PVT.Check_FK_Exists (
1790: p_table_name => l_table_name
1791: ,p_pk_name => l_pk_name
1792: ,p_pk_value => l_pk_value
1793: ,p_pk_data_type => l_pk_data_type