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

Line 208: RAISE FND_API.G_EXC_ERROR;

204:
205: -- if there was an error in compiling the package, raise
206: -- an error
207: if n > 0 then
208: RAISE FND_API.G_EXC_ERROR;
209: end if;
210:
211: exception
212: when FND_API.G_EXC_ERROR then

Line 212: when FND_API.G_EXC_ERROR then

208: RAISE FND_API.G_EXC_ERROR;
209: end if;
210:
211: exception
212: when FND_API.G_EXC_ERROR then
213: raise FND_API.G_EXC_ERROR;
214: when others THEN
215: raise_application_error(-20000,SQLERRM||' '||ad_ddl.error_buf);
216: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);

Line 213: raise FND_API.G_EXC_ERROR;

209: end if;
210:
211: exception
212: when FND_API.G_EXC_ERROR then
213: raise FND_API.G_EXC_ERROR;
214: when others THEN
215: raise_application_error(-20000,SQLERRM||' '||ad_ddl.error_buf);
216: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);
217: -- RAISE FND_API.G_EXC_ERROR;

Line 217: -- RAISE FND_API.G_EXC_ERROR;

213: raise FND_API.G_EXC_ERROR;
214: when others THEN
215: raise_application_error(-20000,SQLERRM||' '||ad_ddl.error_buf);
216: -- PUT_LINE('Iam into exception' ||ad_ddl.error_buf);
217: -- RAISE FND_API.G_EXC_ERROR;
218:
219: END Pkg_End;
220:
221: -------------------------------------------------------------------------------

Line 852: Text ('RAISE FND_API.G_EXC_ERROR;',2);

848: Comment ('if max. iteration is reached exit',0);
849: Text ('IF p_iteration > ONT_DEF_UTIL.G_MAX_DEF_ITERATIONS THEN',0);
850: Text ('FND_MESSAGE.SET_NAME('||''''||'ONT'||''''||','||''''||'OE_DEF_MAX_ITERATIONS'||''''||');',2);
851: Text ('OE_MSG_PUB.ADD;',2);
852: Text ('RAISE FND_API.G_EXC_ERROR;',2);
853: Text ('END IF;',0);
854: New_Line;
855:
856: -- Default missing attributes.

Line 876: l_buffer := 'FND_API.G_MISS_DATE';

872: l_defaulting_condn_ref_flag := l_obj_attr_tbl(j).defaulting_condn_ref_flag ;
873: l_defaulting_enabled_flag := l_obj_attr_tbl(j).defaulting_enabled_flag ;
874: Text ('l_attr:= '''||l_attribute_code||''';',0); --bug 4002431
875: if substr(l_data_type,1,4) = 'DATE' then
876: l_buffer := 'FND_API.G_MISS_DATE';
877: elsif substr(l_data_type,1,3) = 'NUM'
878: or substr(l_data_type,1,3) = 'INT' then
879: l_buffer := 'FND_API.G_MISS_NUM';
880: else

Line 879: l_buffer := 'FND_API.G_MISS_NUM';

875: if substr(l_data_type,1,4) = 'DATE' then
876: l_buffer := 'FND_API.G_MISS_DATE';
877: elsif substr(l_data_type,1,3) = 'NUM'
878: or substr(l_data_type,1,3) = 'INT' then
879: l_buffer := 'FND_API.G_MISS_NUM';
880: else
881: l_buffer := 'FND_API.G_MISS_CHAR';
882: end if;
883:

Line 881: l_buffer := 'FND_API.G_MISS_CHAR';

877: elsif substr(l_data_type,1,3) = 'NUM'
878: or substr(l_data_type,1,3) = 'INT' then
879: l_buffer := 'FND_API.G_MISS_NUM';
880: else
881: l_buffer := 'FND_API.G_MISS_CHAR';
882: end if;
883:
884: -- ATTRIBUTE IS NOT DEFAULTABLE, RETURN NULL IF ATTRIBUTE IS MISSING
885: IF upper(l_defaulting_enabled_flag) <> 'Y' THEN

Line 986: Text(' RAISE FND_API.G_EXC_ERROR;',3);

982: Text ('IF '||l_security_api||
983: '(p_record => g_record, x_on_operation_action => l_action) = OE_PC_GLOBALS.YES THEN',3);
984: Text (
985: '-- Raise error if security returns YES, operation IS CONSTRAINED',3);
986: Text(' RAISE FND_API.G_EXC_ERROR;',3);
987: Text('END IF;',3);
988: Text('OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := ''Y'';',3);
989: Text('END IF;',2);
990: Text('END IF;',1);

Line 1069: l_buffer := 'FND_API.G_MISS_DATE';

1065: l_attribute_code := l_obj_attr_tbl(j).attribute_code ;
1066: l_column_name := l_obj_attr_tbl(j).column_name ;
1067:
1068: if substr(l_data_type,1,4) = 'DATE' then
1069: l_buffer := 'FND_API.G_MISS_DATE';
1070: elsif substr(l_data_type,1,3) = 'NUM'
1071: or substr(l_data_type,1,3) = 'INT' then
1072: l_buffer := 'FND_API.G_MISS_NUM';
1073: else

Line 1072: l_buffer := 'FND_API.G_MISS_NUM';

1068: if substr(l_data_type,1,4) = 'DATE' then
1069: l_buffer := 'FND_API.G_MISS_DATE';
1070: elsif substr(l_data_type,1,3) = 'NUM'
1071: or substr(l_data_type,1,3) = 'INT' then
1072: l_buffer := 'FND_API.G_MISS_NUM';
1073: else
1074: l_buffer := 'FND_API.G_MISS_CHAR';
1075: end if;
1076:

Line 1074: l_buffer := 'FND_API.G_MISS_CHAR';

1070: elsif substr(l_data_type,1,3) = 'NUM'
1071: or substr(l_data_type,1,3) = 'INT' then
1072: l_buffer := 'FND_API.G_MISS_NUM';
1073: else
1074: l_buffer := 'FND_API.G_MISS_CHAR';
1075: end if;
1076:
1077: if j =0 then
1078: Text(' (g_record.'||l_column_name||' =' ||l_buffer||') ',2);

Line 1109: Text('WHEN FND_API.G_EXC_ERROR THEN',1);

1105: New_Line;
1106:
1107: Text('EXCEPTION',0);
1108: New_Line;
1109: Text('WHEN FND_API.G_EXC_ERROR THEN',1);
1110: Text('OE_'||l_entity_code||'_Security.'||
1111: 'G_Is_Caller_Defaulting := ''N'';',2);
1112: Text('RAISE FND_API.G_EXC_ERROR;',2);
1113: Text('WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',1);

Line 1112: Text('RAISE FND_API.G_EXC_ERROR;',2);

1108: New_Line;
1109: Text('WHEN FND_API.G_EXC_ERROR THEN',1);
1110: Text('OE_'||l_entity_code||'_Security.'||
1111: 'G_Is_Caller_Defaulting := ''N'';',2);
1112: Text('RAISE FND_API.G_EXC_ERROR;',2);
1113: Text('WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',1);
1114: Text('OE_'||l_entity_code||'_Security.'||
1115: 'G_Is_Caller_Defaulting := ''N'';',2);
1116: Text('RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',2);

Line 1113: Text('WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',1);

1109: Text('WHEN FND_API.G_EXC_ERROR THEN',1);
1110: Text('OE_'||l_entity_code||'_Security.'||
1111: 'G_Is_Caller_Defaulting := ''N'';',2);
1112: Text('RAISE FND_API.G_EXC_ERROR;',2);
1113: Text('WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',1);
1114: Text('OE_'||l_entity_code||'_Security.'||
1115: 'G_Is_Caller_Defaulting := ''N'';',2);
1116: Text('RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',2);
1117: Text('WHEN OTHERS THEN',1);

Line 1116: Text('RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',2);

1112: Text('RAISE FND_API.G_EXC_ERROR;',2);
1113: Text('WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN',1);
1114: Text('OE_'||l_entity_code||'_Security.'||
1115: 'G_Is_Caller_Defaulting := ''N'';',2);
1116: Text('RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',2);
1117: Text('WHEN OTHERS THEN',1);
1118: Text('IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)',2);
1119: Text('THEN',2);
1120: Text('OE_MSG_PUB.Add_Exc_Msg',3);

Line 1127: Text('RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',2);

1123: Text(',''Default_Record: ''||l_attr',3); --bug 4002431
1124: Text(');',3);
1125: Text('END IF;',2);
1126: Text('OE_'||l_entity_code||'_Security.G_Is_Caller_Defaulting := ''N'';',2);
1127: Text('RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',2);
1128: New_Line;
1129: Text('END Default_Record;',0);
1130: New_Line;
1131:

Line 1141: WHEN FND_API.G_EXC_ERROR THEN

1137: retcode := 0;
1138:
1139: EXCEPTION
1140:
1141: WHEN FND_API.G_EXC_ERROR THEN
1142: retcode := 2;
1143: errbuf := 'Please check the log file for error messages';
1144:
1145: WHEN OTHERS THEN

Line 1511: ||l_fk_attribute||',FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,OE_SYS_Parameters.Value(''MASTER_ORGANIZATION_ID''))',2);

1507: -- Bug 2422910: Item Validation Org System Parameter should be
1508: -- be passed to the item caching API if ship from is null
1509: -- OR missing on the line.
1510: Text(',p_'||l_uk_attribute||' => REPLACE(nvl(p_'||LOWER(p_entity_code)||'_rec.'
1511: ||l_fk_attribute||',FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,OE_SYS_Parameters.Value(''MASTER_ORGANIZATION_ID''))',2);
1512: ELSE
1513: Text(',p_'||l_uk_attribute||' => p_'||LOWER(p_entity_code)||'_rec.'
1514: ||l_fk_attribute,2);
1515: END IF;

Line 1672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1668:
1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: PUT_LINE('Error :'||substr(sqlerrm,1,200));
1672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1673: END Create_Obj_Attr_Def_handler;
1674:
1675: -- Procedure to create the object attribute handler
1676: -- This procedure generates the attribute defaulting handler for the Rule based

Line 1808: RAISE FND_API.G_EXC_ERROR;

1804:
1805: EXCEPTION
1806: WHEN OTHERS THEN
1807: PUT_LINE( 'ERROR: Not a Valid Constant; '||sqlerrm);
1808: RAISE FND_API.G_EXC_ERROR;
1809: END;
1810: END;
1811:
1812:

Line 2071: Text(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',0);

2067: Text( ' OE_MSG_PUB.Add_Exc_Msg',0);
2068: Text( ' ( G_PKG_NAME',0);
2069: Text( ' , ''Get_Default_Value''',0);
2070: Text( ' );',0);
2071: Text(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',0);
2072: Text( 'END Get_Default_Value; ',0);
2073: New_Line ;
2074: Pkg_End (l_package,'BODY');
2075:

Line 2438: RAISE FND_API.G_EXC_ERROR;

2434:
2435: IF l_ak_obj_attr_tbl.COUNT = 0 THEN
2436: PUT_LINE
2437: (' ERROR: NO ATTRIBUTES DEFINED FOR THIS ENTITY');
2438: RAISE FND_API.G_EXC_ERROR;
2439: END IF;
2440:
2441: j:= 0;
2442: FOR J IN 0..l_ak_obj_attr_tbl.COUNT -1 LOOP

Line 2448: l_missing_data_str := 'FND_API.G_MISS_NUM';

2444: l_attribute_code := l_ak_obj_attr_tbl(j).attribute_code ;
2445: l_column_name := l_ak_obj_attr_tbl(j).column_name ;
2446:
2447: IF l_ak_obj_attr_tbl(j).data_type = 'NUMBER' THEN
2448: l_missing_data_str := 'FND_API.G_MISS_NUM';
2449: ELSIF l_ak_obj_attr_tbl(j).data_type = 'VARCHAR2' THEN
2450: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2451: ELSIF l_ak_obj_attr_tbl(j).data_type = 'DATE' THEN
2452: l_missing_data_str := 'FND_API.G_MISS_DATE';

Line 2450: l_missing_data_str := 'FND_API.G_MISS_CHAR';

2446:
2447: IF l_ak_obj_attr_tbl(j).data_type = 'NUMBER' THEN
2448: l_missing_data_str := 'FND_API.G_MISS_NUM';
2449: ELSIF l_ak_obj_attr_tbl(j).data_type = 'VARCHAR2' THEN
2450: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2451: ELSIF l_ak_obj_attr_tbl(j).data_type = 'DATE' THEN
2452: l_missing_data_str := 'FND_API.G_MISS_DATE';
2453: END IF;
2454:

Line 2452: l_missing_data_str := 'FND_API.G_MISS_DATE';

2448: l_missing_data_str := 'FND_API.G_MISS_NUM';
2449: ELSIF l_ak_obj_attr_tbl(j).data_type = 'VARCHAR2' THEN
2450: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2451: ELSIF l_ak_obj_attr_tbl(j).data_type = 'DATE' THEN
2452: l_missing_data_str := 'FND_API.G_MISS_DATE';
2453: END IF;
2454:
2455: if j=0 then
2456: Text ('IF p_attr_code =('||''''||l_attribute_code||''''||') THEN',0);

Line 2507: l_missing_data_str := 'FND_API.G_MISS_DATE';

2503:
2504: IF l_ak_obj_attr_tbl(j).data_type = 'DATE' THEN
2505: l_attribute_code := l_ak_obj_attr_tbl(j).attribute_code ;
2506: l_column_name := l_ak_obj_attr_tbl(j).column_name ;
2507: l_missing_data_str := 'FND_API.G_MISS_DATE';
2508: if l_date_field_exists = 'N' then
2509: Text ('IF p_attr_code =('||''''||l_attribute_code||''''||') THEN',0);
2510: else
2511: Text ('ELSIF p_attr_code =('||''''||l_attribute_code||''''||') THEN',0);

Line 2532: l_missing_data_str := 'FND_API.G_MISS_NUM';

2528: IF l_ak_obj_attr_tbl(j).data_type <> 'DATE' THEN
2529: l_attribute_code := l_ak_obj_attr_tbl(j).attribute_code ;
2530: l_column_name := l_ak_obj_attr_tbl(j).column_name ;
2531: IF l_ak_obj_attr_tbl(j).data_type = 'NUMBER' THEN
2532: l_missing_data_str := 'FND_API.G_MISS_NUM';
2533: ELSIF l_ak_obj_attr_tbl(j).data_type = 'VARCHAR2' THEN
2534: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2535: END IF;
2536: if l_date_field_exists = 'N' then

Line 2534: l_missing_data_str := 'FND_API.G_MISS_CHAR';

2530: l_column_name := l_ak_obj_attr_tbl(j).column_name ;
2531: IF l_ak_obj_attr_tbl(j).data_type = 'NUMBER' THEN
2532: l_missing_data_str := 'FND_API.G_MISS_NUM';
2533: ELSIF l_ak_obj_attr_tbl(j).data_type = 'VARCHAR2' THEN
2534: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2535: END IF;
2536: if l_date_field_exists = 'N' then
2537: Text ('IF p_attr_code =('||''''||l_attribute_code||''''||') THEN',0);
2538: else

Line 2653: l_buffer := 'FND_API.G_MISS_DATE';

2649:
2650: l_uk_column := l_ukey_attr_tbl(U).column_name;
2651:
2652: if substr(l_ukey_attr_tbl(U).data_type,1,4) = 'DATE' then
2653: l_buffer := 'FND_API.G_MISS_DATE';
2654: elsif substr(l_ukey_attr_tbl(U).data_type,1,3) = 'NUM'
2655: or substr(l_ukey_attr_tbl(U).data_type,1,3) = 'INT' then
2656: l_buffer := 'FND_API.G_MISS_NUM';
2657: else

Line 2656: l_buffer := 'FND_API.G_MISS_NUM';

2652: if substr(l_ukey_attr_tbl(U).data_type,1,4) = 'DATE' then
2653: l_buffer := 'FND_API.G_MISS_DATE';
2654: elsif substr(l_ukey_attr_tbl(U).data_type,1,3) = 'NUM'
2655: or substr(l_ukey_attr_tbl(U).data_type,1,3) = 'INT' then
2656: l_buffer := 'FND_API.G_MISS_NUM';
2657: else
2658: l_buffer := 'FND_API.G_MISS_CHAR';
2659: end if;
2660:

Line 2658: l_buffer := 'FND_API.G_MISS_CHAR';

2654: elsif substr(l_ukey_attr_tbl(U).data_type,1,3) = 'NUM'
2655: or substr(l_ukey_attr_tbl(U).data_type,1,3) = 'INT' then
2656: l_buffer := 'FND_API.G_MISS_NUM';
2657: else
2658: l_buffer := 'FND_API.G_MISS_CHAR';
2659: end if;
2660:
2661: if u = 0 then
2662: Text('IF (NVL(p_'||l_uk_column||','||l_buffer||

Line 2678: l_buffer := 'FND_API.G_MISS_DATE';

2674: FOR U in 0..l_ukey_attr_tbl.COUNT -1 LOOP
2675: l_uk_column := l_ukey_attr_tbl(U).column_name;
2676:
2677: if substr(l_ukey_attr_tbl(U).data_type,1,4) = 'DATE' then
2678: l_buffer := 'FND_API.G_MISS_DATE';
2679: elsif substr(l_ukey_attr_tbl(U).data_type,1,3) = 'NUM'
2680: or substr(l_ukey_attr_tbl(U).data_type,1,3) = 'INT' then
2681: l_buffer := 'FND_API.G_MISS_NUM';
2682: else

Line 2681: l_buffer := 'FND_API.G_MISS_NUM';

2677: if substr(l_ukey_attr_tbl(U).data_type,1,4) = 'DATE' then
2678: l_buffer := 'FND_API.G_MISS_DATE';
2679: elsif substr(l_ukey_attr_tbl(U).data_type,1,3) = 'NUM'
2680: or substr(l_ukey_attr_tbl(U).data_type,1,3) = 'INT' then
2681: l_buffer := 'FND_API.G_MISS_NUM';
2682: else
2683: l_buffer := 'FND_API.G_MISS_CHAR';
2684: end if;
2685:

Line 2683: l_buffer := 'FND_API.G_MISS_CHAR';

2679: elsif substr(l_ukey_attr_tbl(U).data_type,1,3) = 'NUM'
2680: or substr(l_ukey_attr_tbl(U).data_type,1,3) = 'INT' then
2681: l_buffer := 'FND_API.G_MISS_NUM';
2682: else
2683: l_buffer := 'FND_API.G_MISS_CHAR';
2684: end if;
2685:
2686: if u = 0 then
2687: Text

Line 2790: RAISE FND_API.G_EXC_ERROR;

2786: IF l_ukey_attr_tbl.COUNT =0 THEN
2787: -- THere are no unique keys defined in the AK for this entity. so exit
2788: PUT_LINE(' ERROR: No unique key columns on the key:'
2789: ||l_uk_name);
2790: RAISE FND_API.G_EXC_ERROR;
2791: END IF;
2792:
2793: l_fkey_attr_tbl.DELETE;
2794: F :=0;

Line 2807: RAISE FND_API.G_EXC_ERROR;

2803:
2804: IF l_fkey_attr_tbl.COUNT = 0 THEN
2805: PUT_LINE(' ERROR: No foreign key columns on the key:'
2806: ||l_fk_name);
2807: RAISE FND_API.G_EXC_ERROR;
2808: END IF;
2809:
2810: if j=0 then
2811: Text (' IF (p_foreign_database_object_name = '||''''

Line 2825: l_missing_data_str := 'FND_API.G_MISS_NUM';

2821: l_fk_attribute := l_fkey_attr_tbl(0).attribute_code;
2822: l_uk_column := l_ukey_attr_tbl(0).column_name;
2823: l_fk_column := l_fkey_attr_tbl(0).column_name;
2824: IF l_fkey_attr_tbl(0).data_type = 'NUMBER' THEN
2825: l_missing_data_str := 'FND_API.G_MISS_NUM';
2826: ELSIF l_fkey_attr_tbl(0).data_type = 'VARCHAR2' THEN
2827: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2828: ELSIF l_fkey_attr_tbl(0).data_type = 'DATE' THEN
2829: l_missing_data_str := 'FND_API.G_MISS_DATE';

Line 2827: l_missing_data_str := 'FND_API.G_MISS_CHAR';

2823: l_fk_column := l_fkey_attr_tbl(0).column_name;
2824: IF l_fkey_attr_tbl(0).data_type = 'NUMBER' THEN
2825: l_missing_data_str := 'FND_API.G_MISS_NUM';
2826: ELSIF l_fkey_attr_tbl(0).data_type = 'VARCHAR2' THEN
2827: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2828: ELSIF l_fkey_attr_tbl(0).data_type = 'DATE' THEN
2829: l_missing_data_str := 'FND_API.G_MISS_DATE';
2830: END IF;
2831: -- Fix Bug 1549538: Return NULL if the foreign key column is null

Line 2829: l_missing_data_str := 'FND_API.G_MISS_DATE';

2825: l_missing_data_str := 'FND_API.G_MISS_NUM';
2826: ELSIF l_fkey_attr_tbl(0).data_type = 'VARCHAR2' THEN
2827: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2828: ELSIF l_fkey_attr_tbl(0).data_type = 'DATE' THEN
2829: l_missing_data_str := 'FND_API.G_MISS_DATE';
2830: END IF;
2831: -- Fix Bug 1549538: Return NULL if the foreign key column is null
2832: -- or missing
2833: Text('IF NVL(p_record.'||l_fk_column||','||l_missing_data_str||') = '

Line 2851: l_missing_data_str := 'FND_API.G_MISS_NUM';

2847:
2848: l_fk_attribute := l_fkey_attr_tbl(U).attribute_code;
2849: l_fk_column := l_fkey_attr_tbl(U).column_name;
2850: IF l_fkey_attr_tbl(U).data_type = 'NUMBER' THEN
2851: l_missing_data_str := 'FND_API.G_MISS_NUM';
2852: ELSIF l_fkey_attr_tbl(U).data_type = 'VARCHAR2' THEN
2853: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2854: ELSIF l_fkey_attr_tbl(U).data_type = 'DATE' THEN
2855: l_missing_data_str := 'FND_API.G_MISS_DATE';

Line 2853: l_missing_data_str := 'FND_API.G_MISS_CHAR';

2849: l_fk_column := l_fkey_attr_tbl(U).column_name;
2850: IF l_fkey_attr_tbl(U).data_type = 'NUMBER' THEN
2851: l_missing_data_str := 'FND_API.G_MISS_NUM';
2852: ELSIF l_fkey_attr_tbl(U).data_type = 'VARCHAR2' THEN
2853: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2854: ELSIF l_fkey_attr_tbl(U).data_type = 'DATE' THEN
2855: l_missing_data_str := 'FND_API.G_MISS_DATE';
2856: END IF;
2857:

Line 2855: l_missing_data_str := 'FND_API.G_MISS_DATE';

2851: l_missing_data_str := 'FND_API.G_MISS_NUM';
2852: ELSIF l_fkey_attr_tbl(U).data_type = 'VARCHAR2' THEN
2853: l_missing_data_str := 'FND_API.G_MISS_CHAR';
2854: ELSIF l_fkey_attr_tbl(U).data_type = 'DATE' THEN
2855: l_missing_data_str := 'FND_API.G_MISS_DATE';
2856: END IF;
2857:
2858: -- Fix Bug 1549538: Return NULL if any one of the foreign key
2859: -- columns is null or missing

Line 2965: RAISE FND_API.G_EXC_ERROR;

2961: IF l_ukey_attr_tbl.COUNT =0 THEN
2962: -- THere are no unique keys defined in the AK for this entity. so exit
2963: PUT_LINE(' ERROR: No unique key columns on the key:'
2964: ||l_uk_name);
2965: RAISE FND_API.G_EXC_ERROR;
2966: END IF;
2967:
2968: l_fkey_attr_tbl.DELETE;
2969: F :=0;

Line 2982: RAISE FND_API.G_EXC_ERROR;

2978:
2979: IF l_fkey_attr_tbl.COUNT = 0 THEN
2980: PUT_LINE(' ERROR: No foreign key columns on the key:'
2981: ||l_fk_name);
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;
2984:
2985: if j=0 then
2986: Text (' IF (p_foreign_database_object_name = '||''''

Line 3000: l_missing_data_str := 'FND_API.G_MISS_NUM';

2996: l_fk_attribute := l_fkey_attr_tbl(0).attribute_code;
2997: l_uk_column := l_ukey_attr_tbl(0).column_name;
2998: l_fk_column := l_fkey_attr_tbl(0).column_name;
2999: IF l_fkey_attr_tbl(0).data_type = 'NUMBER' THEN
3000: l_missing_data_str := 'FND_API.G_MISS_NUM';
3001: ELSIF l_fkey_attr_tbl(0).data_type = 'VARCHAR2' THEN
3002: l_missing_data_str := 'FND_API.G_MISS_CHAR';
3003: ELSIF l_fkey_attr_tbl(0).data_type = 'DATE' THEN
3004: l_missing_data_str := 'FND_API.G_MISS_DATE';

Line 3002: l_missing_data_str := 'FND_API.G_MISS_CHAR';

2998: l_fk_column := l_fkey_attr_tbl(0).column_name;
2999: IF l_fkey_attr_tbl(0).data_type = 'NUMBER' THEN
3000: l_missing_data_str := 'FND_API.G_MISS_NUM';
3001: ELSIF l_fkey_attr_tbl(0).data_type = 'VARCHAR2' THEN
3002: l_missing_data_str := 'FND_API.G_MISS_CHAR';
3003: ELSIF l_fkey_attr_tbl(0).data_type = 'DATE' THEN
3004: l_missing_data_str := 'FND_API.G_MISS_DATE';
3005: END IF;
3006: Text('IF NVL(p_record.'||l_fk_column||','||l_missing_data_str||') = '

Line 3004: l_missing_data_str := 'FND_API.G_MISS_DATE';

3000: l_missing_data_str := 'FND_API.G_MISS_NUM';
3001: ELSIF l_fkey_attr_tbl(0).data_type = 'VARCHAR2' THEN
3002: l_missing_data_str := 'FND_API.G_MISS_CHAR';
3003: ELSIF l_fkey_attr_tbl(0).data_type = 'DATE' THEN
3004: l_missing_data_str := 'FND_API.G_MISS_DATE';
3005: END IF;
3006: Text('IF NVL(p_record.'||l_fk_column||','||l_missing_data_str||') = '
3007: ||l_missing_data_str||' THEN ',2);
3008: Text('RETURN NULL;',3);

Line 3024: l_missing_data_str := 'FND_API.G_MISS_NUM';

3020:
3021: l_fk_attribute := l_fkey_attr_tbl(U).attribute_code;
3022: l_fk_column := l_fkey_attr_tbl(U).column_name;
3023: IF l_fkey_attr_tbl(U).data_type = 'NUMBER' THEN
3024: l_missing_data_str := 'FND_API.G_MISS_NUM';
3025: ELSIF l_fkey_attr_tbl(U).data_type = 'VARCHAR2' THEN
3026: l_missing_data_str := 'FND_API.G_MISS_CHAR';
3027: ELSIF l_fkey_attr_tbl(U).data_type = 'DATE' THEN
3028: l_missing_data_str := 'FND_API.G_MISS_DATE';

Line 3026: l_missing_data_str := 'FND_API.G_MISS_CHAR';

3022: l_fk_column := l_fkey_attr_tbl(U).column_name;
3023: IF l_fkey_attr_tbl(U).data_type = 'NUMBER' THEN
3024: l_missing_data_str := 'FND_API.G_MISS_NUM';
3025: ELSIF l_fkey_attr_tbl(U).data_type = 'VARCHAR2' THEN
3026: l_missing_data_str := 'FND_API.G_MISS_CHAR';
3027: ELSIF l_fkey_attr_tbl(U).data_type = 'DATE' THEN
3028: l_missing_data_str := 'FND_API.G_MISS_DATE';
3029: END IF;
3030:

Line 3028: l_missing_data_str := 'FND_API.G_MISS_DATE';

3024: l_missing_data_str := 'FND_API.G_MISS_NUM';
3025: ELSIF l_fkey_attr_tbl(U).data_type = 'VARCHAR2' THEN
3026: l_missing_data_str := 'FND_API.G_MISS_CHAR';
3027: ELSIF l_fkey_attr_tbl(U).data_type = 'DATE' THEN
3028: l_missing_data_str := 'FND_API.G_MISS_DATE';
3029: END IF;
3030:
3031: if u = 0 then
3032: Text('IF ( NVL(p_record.'||l_fk_column||','||l_missing_data_str||') = '

Line 3286: Text(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',0);

3282: Text(' ( G_PKG_NAME ,',0);
3283: Text(' ''Update_Attr_Rules_Cache: ''||l_attribute_code',0);
3284: Text(' );',0);
3285: Text(' END IF;',0);
3286: Text(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',0);
3287: Text('END Update_Attr_Rules_Cache;',0);
3288: New_Line;
3289:
3290: /*-------------------------------------------------------------------------------*/

Line 3407: Text(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',0);

3403: Text(' ( G_PKG_NAME ,',0);
3404: Text(' ''Get_Valid_Defaulting_Rules :''||p_attr_code',0);
3405: Text(' );',0);
3406: Text(' END IF;',0);
3407: Text(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;',0);
3408: Text('END Get_Valid_Defaulting_Rules;',0);
3409: New_Line;
3410: New_Line;
3411: