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.ASO_DEPENDENCY_UTIL dependencies on FND_API

Line 188: RAISE FND_API.G_EXC_ERROR;

184:
185: -- if there was an error in compiling the package, raise
186: -- an error
187: if n > 0 then
188: RAISE FND_API.G_EXC_ERROR;
189: end if;
190:
191: exception
192: when FND_API.G_EXC_ERROR then

Line 192: when FND_API.G_EXC_ERROR then

188: RAISE FND_API.G_EXC_ERROR;
189: end if;
190:
191: exception
192: when FND_API.G_EXC_ERROR then
193: raise FND_API.G_EXC_ERROR;
194: when others THEN
195: raise_application_error(-20000,SQLERRM||' '||ad_ddl.error_buf);
196:

Line 193: raise FND_API.G_EXC_ERROR;

189: end if;
190:
191: exception
192: when FND_API.G_EXC_ERROR then
193: raise FND_API.G_EXC_ERROR;
194: when others THEN
195: raise_application_error(-20000,SQLERRM||' '||ad_ddl.error_buf);
196:
197: END Pkg_End;

Line 267: Text('IF fnd_api.to_boolean (', 1);

263: NEW_LINE;
264:
265: -- Construct the prelude logic
266: Comment(' Initialize message list if p_init_msg_list is set to TRUE', 1);
267: Text('IF fnd_api.to_boolean (', 1);
268: Text(' p_init_msg_list', 1);
269: Text(' )', 1);
270: Text('THEN', 1);
271: Text(' fnd_msg_pub.initialize;', 1);

Line 277: Text('x_return_status := fnd_api.g_ret_sts_success;', 1);

273:
274: NEW_LINE;
275:
276: Comment(' Initialize API return status to success ', 1);
277: Text('x_return_status := fnd_api.g_ret_sts_success;', 1);
278:
279: NEW_LINE;
280:
281: Comment('--- ', 1);

Line 311: Text(' x_return_status := FND_API.G_RET_STS_ERROR;', 0);

307: Text(' ); ', 1);
308:
309: Text('EXCEPTION ', 0);
310: Text(' WHEN broadcast_exception THEN', 0);
311: Text(' x_return_status := FND_API.G_RET_STS_ERROR;', 0);
312: NEW_LINE;
313:
314: END Api_Body_End;
315:

Line 646: SELECT DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',

642: AND a.attribute_application_id = c.attribute_application_id
643: ORDER BY a.attribute_code;
644:
645: CURSOR c_data_type(lc_attribute_code VARCHAR2) IS
646: SELECT DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
647: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
648: 'DATE', 'FND_API.G_MISS_DATE',
649: 'FND_API.G_MISS_CHAR')
650: FROM ak_attributes

Line 647: 'VARCHAR2', 'FND_API.G_MISS_CHAR',

643: ORDER BY a.attribute_code;
644:
645: CURSOR c_data_type(lc_attribute_code VARCHAR2) IS
646: SELECT DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
647: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
648: 'DATE', 'FND_API.G_MISS_DATE',
649: 'FND_API.G_MISS_CHAR')
650: FROM ak_attributes
651: WHERE attribute_code = lc_attribute_code

Line 648: 'DATE', 'FND_API.G_MISS_DATE',

644:
645: CURSOR c_data_type(lc_attribute_code VARCHAR2) IS
646: SELECT DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
647: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
648: 'DATE', 'FND_API.G_MISS_DATE',
649: 'FND_API.G_MISS_CHAR')
650: FROM ak_attributes
651: WHERE attribute_code = lc_attribute_code
652: AND attribute_application_id = G_APPLICATION_ID;

Line 649: 'FND_API.G_MISS_CHAR')

645: CURSOR c_data_type(lc_attribute_code VARCHAR2) IS
646: SELECT DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
647: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
648: 'DATE', 'FND_API.G_MISS_DATE',
649: 'FND_API.G_MISS_CHAR')
650: FROM ak_attributes
651: WHERE attribute_code = lc_attribute_code
652: AND attribute_application_id = G_APPLICATION_ID;
653:

Line 667: DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',

663: AND attribute_code = lc_attribute_code;
664:
665: CURSOR c_attributes IS
666: SELECT a.attribute_code, a.attribute_id, b.column_name,
667: DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
668: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
669: 'DATE', 'FND_API.G_MISS_DATE',
670: 'FND_API.G_MISS_CHAR') miss_str
671: FROM oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c

Line 668: 'VARCHAR2', 'FND_API.G_MISS_CHAR',

664:
665: CURSOR c_attributes IS
666: SELECT a.attribute_code, a.attribute_id, b.column_name,
667: DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
668: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
669: 'DATE', 'FND_API.G_MISS_DATE',
670: 'FND_API.G_MISS_CHAR') miss_str
671: FROM oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c
672: WHERE a.attribute_application_id = G_APPLICATION_ID

Line 669: 'DATE', 'FND_API.G_MISS_DATE',

665: CURSOR c_attributes IS
666: SELECT a.attribute_code, a.attribute_id, b.column_name,
667: DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
668: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
669: 'DATE', 'FND_API.G_MISS_DATE',
670: 'FND_API.G_MISS_CHAR') miss_str
671: FROM oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c
672: WHERE a.attribute_application_id = G_APPLICATION_ID
673: AND a.database_object_name = p_database_object_name

Line 670: 'FND_API.G_MISS_CHAR') miss_str

666: SELECT a.attribute_code, a.attribute_id, b.column_name,
667: DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
668: 'VARCHAR2', 'FND_API.G_MISS_CHAR',
669: 'DATE', 'FND_API.G_MISS_DATE',
670: 'FND_API.G_MISS_CHAR') miss_str
671: FROM oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c
672: WHERE a.attribute_application_id = G_APPLICATION_ID
673: AND a.database_object_name = p_database_object_name
674: AND a.database_object_name = b.database_object_name

Line 737: 'VARCHAR2',1,TRUE,':= fnd_api.g_false',30,TRUE);

733: --
734: -- Construct the procedure header
735: Text('PROCEDURE Get_Dependent_Attributes_Sets',0);
736: Parameter('init_msg_list','IN',
737: 'VARCHAR2',1,TRUE,':= fnd_api.g_false',30,TRUE);
738: -- One output table for each trigger attribute
739: FOR l_trigger_attr_rec IN c_all_trigger_attribute
740: LOOP
741: Parameter(l_trigger_attr_rec.attribute_code||'_TBL',

Line 801: 'VARCHAR2',1,TRUE,':= fnd_api.g_false',30,TRUE);

797: --
798: -- Construct the procedure header
799: Text('PROCEDURE Get_Dependent_Attributes_Proc',0);
800: Parameter('init_msg_list','IN',
801: 'VARCHAR2',1,TRUE,':= fnd_api.g_false',30,TRUE);
802: Parameter('trigger_record','IN',
803: l_ak_view_name||'%ROWTYPE',1);
804: Parameter('TRIGGERS_ID_TBL','IN',
805: 'ASO_DEFAULTING_INT.attribute_Ids_Tbl_Type',1,

Line 949: Text(' p_control_record.last_update_date = FND_API.G_MISS_Date ) ', 1);

945: Text('THEN', 1);
946: NEW_LINE;
947: COMMENT(' Check whether the database record has been changed.', 1);
948: Text(' IF (p_control_record.last_update_date is NULL OR', 1);
949: Text(' p_control_record.last_update_date = FND_API.G_MISS_Date ) ', 1);
950: Text(' THEN', 1);
951: Text(' IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN', 1);
952: Text(' FND_MESSAGE.Set_Name(''ASO'', ''ASO_API_MISSING_COLUMN'');', 1);
953: Text(' FND_MESSAGE.Set_Token(''COLUMN'', ''Last_Update_Date'', FALSE);', 1);

Line 1044: Text(' IF p_control_record.override_trigger_flag = FND_API.G_TRUE', 1);

1040: OPEN c_data_type(l_attribute_code);
1041: FETCH c_data_type INTO l_miss_str;
1042: CLOSE c_data_type;
1043:
1044: Text(' IF p_control_record.override_trigger_flag = FND_API.G_TRUE', 1);
1045: Text(' OR', 1);
1046: Text(' (p_control_record.override_trigger_flag = FND_API.G_FALSE', 1);
1047: Text(' AND NOT l_triggers_id_tbl.exists(G_'||l_attribute_code||')', 1);
1048: Text(' )', 1);

Line 1046: Text(' (p_control_record.override_trigger_flag = FND_API.G_FALSE', 1);

1042: CLOSE c_data_type;
1043:
1044: Text(' IF p_control_record.override_trigger_flag = FND_API.G_TRUE', 1);
1045: Text(' OR', 1);
1046: Text(' (p_control_record.override_trigger_flag = FND_API.G_FALSE', 1);
1047: Text(' AND NOT l_triggers_id_tbl.exists(G_'||l_attribute_code||')', 1);
1048: Text(' )', 1);
1049: Text(' THEN', 1);
1050: Text(' x_dependent_record.'||l_attribute_name||' := '||l_miss_str||';', 1);

Line 1072: WHEN FND_API.G_EXC_ERROR THEN

1068:
1069: retcode := 0;
1070: EXCEPTION
1071:
1072: WHEN FND_API.G_EXC_ERROR THEN
1073: PUT_LINE('Please check the log file for error messages');
1074: retcode := 2;
1075: errbuf := 'Please check the log file for error messages';
1076: