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

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

310: FND_MSG_PUB.ADD;
311: END IF;
312:
313: -- Initialize API return status to success
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: SELECT request, hist_req_id
317: INTO l_bind, l_request_id
318: FROM jtf_fm_request_history_all

Line 969: WHEN FND_API.G_EXC_ERROR

965: x_msg_count := 0;
966: x_msg_data := '';
967:
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR
970: THEN
971: x_return_status := FND_API.g_ret_sts_error ;
972: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
973: p_data => x_msg_data,

Line 971: x_return_status := FND_API.g_ret_sts_error ;

967:
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR
970: THEN
971: x_return_status := FND_API.g_ret_sts_error ;
972: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
973: p_data => x_msg_data,
974: p_encoded => FND_API.G_FALSE
975: );

Line 974: p_encoded => FND_API.G_FALSE

970: THEN
971: x_return_status := FND_API.g_ret_sts_error ;
972: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
973: p_data => x_msg_data,
974: p_encoded => FND_API.G_FALSE
975: );
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
977: THEN
978: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

972: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
973: p_data => x_msg_data,
974: p_encoded => FND_API.G_FALSE
975: );
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
977: THEN
978: x_return_status := FND_API.g_ret_sts_unexp_error ;
979: FND_MSG_PUB.Count_AND_Get
980: ( p_count => x_msg_count,

Line 978: x_return_status := FND_API.g_ret_sts_unexp_error ;

974: p_encoded => FND_API.G_FALSE
975: );
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
977: THEN
978: x_return_status := FND_API.g_ret_sts_unexp_error ;
979: FND_MSG_PUB.Count_AND_Get
980: ( p_count => x_msg_count,
981: p_data => x_msg_data,
982: p_encoded => FND_API.G_FALSE

Line 982: p_encoded => FND_API.G_FALSE

978: x_return_status := FND_API.g_ret_sts_unexp_error ;
979: FND_MSG_PUB.Count_AND_Get
980: ( p_count => x_msg_count,
981: p_data => x_msg_data,
982: p_encoded => FND_API.G_FALSE
983: );
984: WHEN e_too_many_bind_vars
985: THEN
986: x_return_status := FND_API.g_ret_sts_error ;

Line 986: x_return_status := FND_API.g_ret_sts_error ;

982: p_encoded => FND_API.G_FALSE
983: );
984: WHEN e_too_many_bind_vars
985: THEN
986: x_return_status := FND_API.g_ret_sts_error ;
987: x_msg_data := 'Error : Only 5 bind variables allowed in query';
988: WHEN e_partition_not_found
989: THEN
990: x_return_status := FND_API.g_ret_sts_error ;

Line 990: x_return_status := FND_API.g_ret_sts_error ;

986: x_return_status := FND_API.g_ret_sts_error ;
987: x_msg_data := 'Error : Only 5 bind variables allowed in query';
988: WHEN e_partition_not_found
989: THEN
990: x_return_status := FND_API.g_ret_sts_error ;
991: x_msg_data := 'Unable to locate partition';
992: WHEN OTHERS
993: THEN
994: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 994: x_return_status := FND_API.g_ret_sts_unexp_error ;

990: x_return_status := FND_API.g_ret_sts_error ;
991: x_msg_data := 'Unable to locate partition';
992: WHEN OTHERS
993: THEN
994: x_return_status := FND_API.g_ret_sts_unexp_error ;
995: x_msg_data := SQLERRM;
996: END process_request;
997:
998: /*---------------------------------------------------------------------------------*

Line 1013: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1009: *---------------------------------------------------------------------------------*/
1010: PROCEDURE update_lines_status_bulk ( line_ids IN JTF_VARCHAR2_TABLE_100
1011: , request_id IN NUMBER
1012: , line_status IN JTF_VARCHAR2_TABLE_100
1013: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1014: , x_return_status OUT NOCOPY VARCHAR2
1015: , x_msg_count OUT NOCOPY NUMBER
1016: , x_msg_data OUT NOCOPY VARCHAR2
1017: ) IS

Line 1091: IF x_return_status = fnd_api.g_ret_sts_error

1087: WHERE request_id = l_request_id ;
1088:
1089: END IF;
1090:
1091: IF x_return_status = fnd_api.g_ret_sts_error
1092: THEN
1093: RAISE FND_API.g_exc_error;
1094: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1095: THEN

Line 1093: RAISE FND_API.g_exc_error;

1089: END IF;
1090:
1091: IF x_return_status = fnd_api.g_ret_sts_error
1092: THEN
1093: RAISE FND_API.g_exc_error;
1094: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1095: THEN
1096: RAISE FND_API.g_exc_unexpected_error;
1097: END IF;

Line 1094: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1090:
1091: IF x_return_status = fnd_api.g_ret_sts_error
1092: THEN
1093: RAISE FND_API.g_exc_error;
1094: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1095: THEN
1096: RAISE FND_API.g_exc_unexpected_error;
1097: END IF;
1098:

Line 1096: RAISE FND_API.g_exc_unexpected_error;

1092: THEN
1093: RAISE FND_API.g_exc_error;
1094: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1095: THEN
1096: RAISE FND_API.g_exc_unexpected_error;
1097: END IF;
1098:
1099: IF p_commit = FND_API.g_true
1100: THEN

Line 1099: IF p_commit = FND_API.g_true

1095: THEN
1096: RAISE FND_API.g_exc_unexpected_error;
1097: END IF;
1098:
1099: IF p_commit = FND_API.g_true
1100: THEN
1101: COMMIT WORK;
1102: END IF;
1103:

Line 1108: p_encoded => FND_API.G_FALSE );

1104: x_return_status := 'S';
1105:
1106: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1107: p_data => x_msg_data,
1108: p_encoded => FND_API.G_FALSE );
1109:
1110: EXCEPTION
1111: WHEN FND_API.G_EXC_ERROR
1112: THEN

Line 1111: WHEN FND_API.G_EXC_ERROR

1107: p_data => x_msg_data,
1108: p_encoded => FND_API.G_FALSE );
1109:
1110: EXCEPTION
1111: WHEN FND_API.G_EXC_ERROR
1112: THEN
1113: x_return_status := FND_API.g_ret_sts_error ;
1114: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1115: p_data => x_msg_data,

Line 1113: x_return_status := FND_API.g_ret_sts_error ;

1109:
1110: EXCEPTION
1111: WHEN FND_API.G_EXC_ERROR
1112: THEN
1113: x_return_status := FND_API.g_ret_sts_error ;
1114: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1115: p_data => x_msg_data,
1116: p_encoded => FND_API.G_FALSE
1117: );

Line 1116: p_encoded => FND_API.G_FALSE

1112: THEN
1113: x_return_status := FND_API.g_ret_sts_error ;
1114: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1115: p_data => x_msg_data,
1116: p_encoded => FND_API.G_FALSE
1117: );
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1119: THEN
1120: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1114: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1115: p_data => x_msg_data,
1116: p_encoded => FND_API.G_FALSE
1117: );
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1119: THEN
1120: x_return_status := FND_API.g_ret_sts_unexp_error ;
1121: FND_MSG_PUB.Count_AND_Get
1122: ( p_count => x_msg_count,

Line 1120: x_return_status := FND_API.g_ret_sts_unexp_error ;

1116: p_encoded => FND_API.G_FALSE
1117: );
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1119: THEN
1120: x_return_status := FND_API.g_ret_sts_unexp_error ;
1121: FND_MSG_PUB.Count_AND_Get
1122: ( p_count => x_msg_count,
1123: p_data => x_msg_data,
1124: p_encoded => FND_API.G_FALSE

Line 1124: p_encoded => FND_API.G_FALSE

1120: x_return_status := FND_API.g_ret_sts_unexp_error ;
1121: FND_MSG_PUB.Count_AND_Get
1122: ( p_count => x_msg_count,
1123: p_data => x_msg_data,
1124: p_encoded => FND_API.G_FALSE
1125: );
1126: WHEN OTHERS
1127: THEN
1128: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

Line 1128: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

1124: p_encoded => FND_API.G_FALSE
1125: );
1126: WHEN OTHERS
1127: THEN
1128: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1129:
1130: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1131: THEN
1132: NULL;

Line 1137: p_encoded => FND_API.G_FALSE

1133: END IF;
1134:
1135: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1136: p_data => x_msg_data,
1137: p_encoded => FND_API.G_FALSE
1138: );
1139:
1140: END;
1141:

Line 1153: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1149: *---------------------------------------------------------------------------------*/
1150: PROCEDURE update_lines_status ( line_ids IN JTF_VARCHAR2_TABLE_100
1151: , request_id IN NUMBER
1152: , line_status IN VARCHAR2
1153: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1154: , x_return_status OUT NOCOPY VARCHAR2
1155: , x_msg_count OUT NOCOPY NUMBER
1156: , x_msg_data OUT NOCOPY VARCHAR2
1157: ) IS

Line 1164: IF x_return_status = fnd_api.g_ret_sts_error

1160: UPDATE jtf_fm_int_request_lines
1161: SET email_status = line_status
1162: WHERE request_line_id = line_ids(i);
1163:
1164: IF x_return_status = fnd_api.g_ret_sts_error
1165: THEN
1166: RAISE FND_API.g_exc_error;
1167: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1168: THEN

Line 1166: RAISE FND_API.g_exc_error;

1162: WHERE request_line_id = line_ids(i);
1163:
1164: IF x_return_status = fnd_api.g_ret_sts_error
1165: THEN
1166: RAISE FND_API.g_exc_error;
1167: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1168: THEN
1169: RAISE FND_API.g_exc_unexpected_error;
1170: END IF;

Line 1167: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1163:
1164: IF x_return_status = fnd_api.g_ret_sts_error
1165: THEN
1166: RAISE FND_API.g_exc_error;
1167: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1168: THEN
1169: RAISE FND_API.g_exc_unexpected_error;
1170: END IF;
1171:

Line 1169: RAISE FND_API.g_exc_unexpected_error;

1165: THEN
1166: RAISE FND_API.g_exc_error;
1167: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1168: THEN
1169: RAISE FND_API.g_exc_unexpected_error;
1170: END IF;
1171:
1172: IF p_commit = FND_API.g_true
1173: THEN

Line 1172: IF p_commit = FND_API.g_true

1168: THEN
1169: RAISE FND_API.g_exc_unexpected_error;
1170: END IF;
1171:
1172: IF p_commit = FND_API.g_true
1173: THEN
1174: COMMIT WORK;
1175: END IF;
1176:

Line 1180: p_encoded => FND_API.G_FALSE );

1176:
1177: x_return_status := 'S';
1178: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1179: p_data => x_msg_data,
1180: p_encoded => FND_API.G_FALSE );
1181:
1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR
1184: THEN

Line 1183: WHEN FND_API.G_EXC_ERROR

1179: p_data => x_msg_data,
1180: p_encoded => FND_API.G_FALSE );
1181:
1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR
1184: THEN
1185: x_return_status := FND_API.g_ret_sts_error ;
1186: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1187: p_data => x_msg_data,

Line 1185: x_return_status := FND_API.g_ret_sts_error ;

1181:
1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR
1184: THEN
1185: x_return_status := FND_API.g_ret_sts_error ;
1186: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1187: p_data => x_msg_data,
1188: p_encoded => FND_API.G_FALSE
1189: );

Line 1188: p_encoded => FND_API.G_FALSE

1184: THEN
1185: x_return_status := FND_API.g_ret_sts_error ;
1186: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1187: p_data => x_msg_data,
1188: p_encoded => FND_API.G_FALSE
1189: );
1190:
1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1192: THEN

Line 1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1187: p_data => x_msg_data,
1188: p_encoded => FND_API.G_FALSE
1189: );
1190:
1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1192: THEN
1193: x_return_status := FND_API.g_ret_sts_unexp_error ;
1194: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1195: p_data => x_msg_data,

Line 1193: x_return_status := FND_API.g_ret_sts_unexp_error ;

1189: );
1190:
1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1192: THEN
1193: x_return_status := FND_API.g_ret_sts_unexp_error ;
1194: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1195: p_data => x_msg_data,
1196: p_encoded => FND_API.G_FALSE
1197: );

Line 1196: p_encoded => FND_API.G_FALSE

1192: THEN
1193: x_return_status := FND_API.g_ret_sts_unexp_error ;
1194: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1195: p_data => x_msg_data,
1196: p_encoded => FND_API.G_FALSE
1197: );
1198: WHEN OTHERS
1199: THEN
1200: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

Line 1200: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

1196: p_encoded => FND_API.G_FALSE
1197: );
1198: WHEN OTHERS
1199: THEN
1200: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1201:
1202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1203: THEN
1204: NULL;

Line 1209: p_encoded => FND_API.G_FALSE

1205: END IF;
1206:
1207: FND_MSG_PUB.Count_AND_Get ( p_count => x_msg_count,
1208: p_data => x_msg_data,
1209: p_encoded => FND_API.G_FALSE
1210: );
1211:
1212: END;
1213:

Line 1228: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1224: PROCEDURE update_instance_status( p_request_id IN NUMBER
1225: , p_server_id IN NUMBER
1226: , p_instance_id IN NUMBER
1227: , p_status IN VARCHAR2
1228: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1229: , x_return_status OUT NOCOPY VARCHAR2
1230: , x_msg_count OUT NOCOPY NUMBER
1231: , x_msg_data OUT NOCOPY VARCHAR2
1232: ) IS

Line 1306: IF x_return_status = fnd_api.g_ret_sts_error

1302: WHERE request_id=l_request_id ;
1303:
1304: END IF;
1305:
1306: IF x_return_status = fnd_api.g_ret_sts_error
1307: THEN
1308: RAISE FND_API.g_exc_error;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1310: THEN

Line 1308: RAISE FND_API.g_exc_error;

1304: END IF;
1305:
1306: IF x_return_status = fnd_api.g_ret_sts_error
1307: THEN
1308: RAISE FND_API.g_exc_error;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1310: THEN
1311: RAISE FND_API.g_exc_unexpected_error;
1312: END IF;

Line 1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1305:
1306: IF x_return_status = fnd_api.g_ret_sts_error
1307: THEN
1308: RAISE FND_API.g_exc_error;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1310: THEN
1311: RAISE FND_API.g_exc_unexpected_error;
1312: END IF;
1313:

Line 1311: RAISE FND_API.g_exc_unexpected_error;

1307: THEN
1308: RAISE FND_API.g_exc_error;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1310: THEN
1311: RAISE FND_API.g_exc_unexpected_error;
1312: END IF;
1313:
1314: IF p_commit = FND_API.g_true
1315: THEN

Line 1314: IF p_commit = FND_API.g_true

1310: THEN
1311: RAISE FND_API.g_exc_unexpected_error;
1312: END IF;
1313:
1314: IF p_commit = FND_API.g_true
1315: THEN
1316: COMMIT WORK;
1317: END IF;
1318:

Line 1326: p_encoded => FND_API.G_FALSE );

1322:
1323: FND_MSG_PUB.Count_AND_Get
1324: ( p_count => x_msg_count,
1325: p_data => x_msg_data,
1326: p_encoded => FND_API.G_FALSE );
1327:
1328: EXCEPTION
1329: WHEN FND_API.G_EXC_ERROR
1330: THEN

Line 1329: WHEN FND_API.G_EXC_ERROR

1325: p_data => x_msg_data,
1326: p_encoded => FND_API.G_FALSE );
1327:
1328: EXCEPTION
1329: WHEN FND_API.G_EXC_ERROR
1330: THEN
1331: x_return_status := FND_API.g_ret_sts_error ;
1332: FND_MSG_PUB.Count_AND_Get
1333: ( p_count => x_msg_count,

Line 1331: x_return_status := FND_API.g_ret_sts_error ;

1327:
1328: EXCEPTION
1329: WHEN FND_API.G_EXC_ERROR
1330: THEN
1331: x_return_status := FND_API.g_ret_sts_error ;
1332: FND_MSG_PUB.Count_AND_Get
1333: ( p_count => x_msg_count,
1334: p_data => x_msg_data,
1335: p_encoded => FND_API.G_FALSE

Line 1335: p_encoded => FND_API.G_FALSE

1331: x_return_status := FND_API.g_ret_sts_error ;
1332: FND_MSG_PUB.Count_AND_Get
1333: ( p_count => x_msg_count,
1334: p_data => x_msg_data,
1335: p_encoded => FND_API.G_FALSE
1336: );
1337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1338: THEN
1339: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1333: ( p_count => x_msg_count,
1334: p_data => x_msg_data,
1335: p_encoded => FND_API.G_FALSE
1336: );
1337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1338: THEN
1339: x_return_status := FND_API.g_ret_sts_unexp_error ;
1340: FND_MSG_PUB.Count_AND_Get
1341: ( p_count => x_msg_count,

Line 1339: x_return_status := FND_API.g_ret_sts_unexp_error ;

1335: p_encoded => FND_API.G_FALSE
1336: );
1337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1338: THEN
1339: x_return_status := FND_API.g_ret_sts_unexp_error ;
1340: FND_MSG_PUB.Count_AND_Get
1341: ( p_count => x_msg_count,
1342: p_data => x_msg_data,
1343: p_encoded => FND_API.G_FALSE

Line 1343: p_encoded => FND_API.G_FALSE

1339: x_return_status := FND_API.g_ret_sts_unexp_error ;
1340: FND_MSG_PUB.Count_AND_Get
1341: ( p_count => x_msg_count,
1342: p_data => x_msg_data,
1343: p_encoded => FND_API.G_FALSE
1344: );
1345: WHEN OTHERS
1346: THEN
1347: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

Line 1347: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

1343: p_encoded => FND_API.G_FALSE
1344: );
1345: WHEN OTHERS
1346: THEN
1347: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1348:
1349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1350: THEN
1351: NULL;

Line 1357: p_encoded => FND_API.G_FALSE

1353:
1354: FND_MSG_PUB.Count_AND_Get
1355: ( p_count => x_msg_count,
1356: p_data => x_msg_data,
1357: p_encoded => FND_API.G_FALSE
1358: );
1359:
1360: END;
1361:

Line 1371: , P_commit IN VARCHAR2 := FND_API.G_FALSE

1367: *---------------------------------------------------------------------------------*/
1368: PROCEDURE clean_up_instance( p_request_id IN NUMBER
1369: , p_server_id IN NUMBER
1370: , p_instance_id IN NUMBER
1371: , P_commit IN VARCHAR2 := FND_API.G_FALSE
1372: , x_return_status OUT NOCOPY VARCHAR2
1373: , x_msg_count OUT NOCOPY NUMBER
1374: , x_msg_data OUT NOCOPY VARCHAR2) IS
1375: BEGIN

Line 1382: IF x_return_status = fnd_api.g_ret_sts_error

1378: last_update_date = SYSDATE
1379: WHERE request_ID = p_request_id
1380: AND server_instance_id = p_instance_id;
1381:
1382: IF x_return_status = fnd_api.g_ret_sts_error
1383: THEN
1384: RAISE FND_API.g_exc_error;
1385: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1386: THEN

Line 1384: RAISE FND_API.g_exc_error;

1380: AND server_instance_id = p_instance_id;
1381:
1382: IF x_return_status = fnd_api.g_ret_sts_error
1383: THEN
1384: RAISE FND_API.g_exc_error;
1385: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1386: THEN
1387: RAISE FND_API.g_exc_unexpected_error;
1388: END IF;

Line 1385: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1381:
1382: IF x_return_status = fnd_api.g_ret_sts_error
1383: THEN
1384: RAISE FND_API.g_exc_error;
1385: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1386: THEN
1387: RAISE FND_API.g_exc_unexpected_error;
1388: END IF;
1389:

Line 1387: RAISE FND_API.g_exc_unexpected_error;

1383: THEN
1384: RAISE FND_API.g_exc_error;
1385: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1386: THEN
1387: RAISE FND_API.g_exc_unexpected_error;
1388: END IF;
1389:
1390: IF p_commit = FND_API.g_true
1391: THEN

Line 1390: IF p_commit = FND_API.g_true

1386: THEN
1387: RAISE FND_API.g_exc_unexpected_error;
1388: END IF;
1389:
1390: IF p_commit = FND_API.g_true
1391: THEN
1392: COMMIT WORK;
1393: END IF;
1394:

Line 1400: p_encoded => FND_API.G_FALSE );

1396:
1397: FND_MSG_PUB.Count_AND_Get
1398: ( p_count => x_msg_count,
1399: p_data => x_msg_data,
1400: p_encoded => FND_API.G_FALSE );
1401:
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR
1404: THEN

Line 1403: WHEN FND_API.G_EXC_ERROR

1399: p_data => x_msg_data,
1400: p_encoded => FND_API.G_FALSE );
1401:
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR
1404: THEN
1405: x_return_status := FND_API.g_ret_sts_error ;
1406: FND_MSG_PUB.Count_AND_Get
1407: ( p_count => x_msg_count,

Line 1405: x_return_status := FND_API.g_ret_sts_error ;

1401:
1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR
1404: THEN
1405: x_return_status := FND_API.g_ret_sts_error ;
1406: FND_MSG_PUB.Count_AND_Get
1407: ( p_count => x_msg_count,
1408: p_data => x_msg_data,
1409: p_encoded => FND_API.G_FALSE

Line 1409: p_encoded => FND_API.G_FALSE

1405: x_return_status := FND_API.g_ret_sts_error ;
1406: FND_MSG_PUB.Count_AND_Get
1407: ( p_count => x_msg_count,
1408: p_data => x_msg_data,
1409: p_encoded => FND_API.G_FALSE
1410: );
1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1412: THEN
1413: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1407: ( p_count => x_msg_count,
1408: p_data => x_msg_data,
1409: p_encoded => FND_API.G_FALSE
1410: );
1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1412: THEN
1413: x_return_status := FND_API.g_ret_sts_unexp_error ;
1414: FND_MSG_PUB.Count_AND_Get
1415: ( p_count => x_msg_count,

Line 1413: x_return_status := FND_API.g_ret_sts_unexp_error ;

1409: p_encoded => FND_API.G_FALSE
1410: );
1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1412: THEN
1413: x_return_status := FND_API.g_ret_sts_unexp_error ;
1414: FND_MSG_PUB.Count_AND_Get
1415: ( p_count => x_msg_count,
1416: p_data => x_msg_data,
1417: p_encoded => FND_API.G_FALSE

Line 1417: p_encoded => FND_API.G_FALSE

1413: x_return_status := FND_API.g_ret_sts_unexp_error ;
1414: FND_MSG_PUB.Count_AND_Get
1415: ( p_count => x_msg_count,
1416: p_data => x_msg_data,
1417: p_encoded => FND_API.G_FALSE
1418: );
1419: WHEN OTHERS
1420: THEN
1421: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

Line 1421: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

1417: p_encoded => FND_API.G_FALSE
1418: );
1419: WHEN OTHERS
1420: THEN
1421: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
1422:
1423: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1424: THEN
1425: NULL;

Line 1430: p_encoded => FND_API.G_FALSE

1426: END IF;
1427: FND_MSG_PUB.Count_AND_Get
1428: ( p_count => x_msg_count,
1429: p_data => x_msg_data,
1430: p_encoded => FND_API.G_FALSE
1431: );
1432:
1433: END;
1434:

Line 1729: , P_commit IN VARCHAR2 := FND_API.G_FALSE

1725: *---------------------------------------------------------------------------------*/
1726: PROCEDURE get_next_batch ( p_request_id IN NUMBER
1727: , p_server_id IN NUMBER
1728: , p_instance_id IN NUMBER
1729: , P_commit IN VARCHAR2 := FND_API.G_FALSE
1730: , p_line_ids OUT NOCOPY JTF_NUMBER_TABLE
1731: , p_party_id OUT NOCOPY JTF_NUMBER_TABLE
1732: , p_party_name OUT NOCOPY JTF_VARCHAR2_TABLE_200
1733: , p_email_address OUT NOCOPY JTF_VARCHAR2_TABLE_200

Line 2309: p_encoded => FND_API.G_FALSE );

2305:
2306: FND_MSG_PUB.Count_AND_Get
2307: ( p_count => x_msg_count,
2308: p_data => x_msg_data,
2309: p_encoded => FND_API.G_FALSE );
2310:
2311: EXCEPTION
2312: WHEN FND_API.G_EXC_ERROR
2313: THEN

Line 2312: WHEN FND_API.G_EXC_ERROR

2308: p_data => x_msg_data,
2309: p_encoded => FND_API.G_FALSE );
2310:
2311: EXCEPTION
2312: WHEN FND_API.G_EXC_ERROR
2313: THEN
2314: x_return_status := FND_API.g_ret_sts_error ;
2315: FND_MSG_PUB.Count_AND_Get
2316: ( p_count => x_msg_count,

Line 2314: x_return_status := FND_API.g_ret_sts_error ;

2310:
2311: EXCEPTION
2312: WHEN FND_API.G_EXC_ERROR
2313: THEN
2314: x_return_status := FND_API.g_ret_sts_error ;
2315: FND_MSG_PUB.Count_AND_Get
2316: ( p_count => x_msg_count,
2317: p_data => x_msg_data,
2318: p_encoded => FND_API.G_FALSE

Line 2318: p_encoded => FND_API.G_FALSE

2314: x_return_status := FND_API.g_ret_sts_error ;
2315: FND_MSG_PUB.Count_AND_Get
2316: ( p_count => x_msg_count,
2317: p_data => x_msg_data,
2318: p_encoded => FND_API.G_FALSE
2319: );
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2321: THEN
2322: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2316: ( p_count => x_msg_count,
2317: p_data => x_msg_data,
2318: p_encoded => FND_API.G_FALSE
2319: );
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2321: THEN
2322: x_return_status := FND_API.g_ret_sts_unexp_error ;
2323: FND_MSG_PUB.Count_AND_Get
2324: ( p_count => x_msg_count,

Line 2322: x_return_status := FND_API.g_ret_sts_unexp_error ;

2318: p_encoded => FND_API.G_FALSE
2319: );
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2321: THEN
2322: x_return_status := FND_API.g_ret_sts_unexp_error ;
2323: FND_MSG_PUB.Count_AND_Get
2324: ( p_count => x_msg_count,
2325: p_data => x_msg_data,
2326: p_encoded => FND_API.G_FALSE

Line 2326: p_encoded => FND_API.G_FALSE

2322: x_return_status := FND_API.g_ret_sts_unexp_error ;
2323: FND_MSG_PUB.Count_AND_Get
2324: ( p_count => x_msg_count,
2325: p_data => x_msg_data,
2326: p_encoded => FND_API.G_FALSE
2327: );
2328: WHEN OTHERS
2329: THEN
2330: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

Line 2330: x_return_status := FND_API.g_ret_sts_unexp_erroR ;

2326: p_encoded => FND_API.G_FALSE
2327: );
2328: WHEN OTHERS
2329: THEN
2330: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
2331: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2332: THEN
2333: NULL;
2334: END IF;

Line 2338: p_encoded => FND_API.G_FALSE

2334: END IF;
2335: FND_MSG_PUB.Count_AND_Get
2336: ( p_count => x_msg_count,
2337: p_data => x_msg_data,
2338: p_encoded => FND_API.G_FALSE
2339: );
2340: END get_next_batch;
2341:
2342:

Line 2701: x_return_status := FND_API.G_RET_STS_SUCCESS;

2697: ;
2698:
2699: COMMIT;
2700:
2701: x_return_status := FND_API.G_RET_STS_SUCCESS;
2702:
2703: EXCEPTION
2704: WHEN OTHERS
2705: THEN

Line 2706: x_return_status := FND_API.G_RET_STS_ERROR;

2702:
2703: EXCEPTION
2704: WHEN OTHERS
2705: THEN
2706: x_return_status := FND_API.G_RET_STS_ERROR;
2707: END clean_stalled_request;
2708:
2709: PROCEDURE get_next_partition ( x_errbuf OUT NOCOPY VARCHAR2
2710: , x_retcode OUT NOCOPY VARCHAR2

Line 2782: x_retcode := FND_API.g_ret_sts_unexp_error ;

2778: EXCEPTION
2779: WHEN e_partition_not_found
2780: THEN
2781: x_errbuf := SQLERRM;
2782: x_retcode := FND_API.g_ret_sts_unexp_error ;
2783: WHEN OTHERS
2784: THEN
2785: x_errbuf := SQLERRM;
2786: x_retcode := FND_API.g_ret_sts_unexp_error ;

Line 2786: x_retcode := FND_API.g_ret_sts_unexp_error ;

2782: x_retcode := FND_API.g_ret_sts_unexp_error ;
2783: WHEN OTHERS
2784: THEN
2785: x_errbuf := SQLERRM;
2786: x_retcode := FND_API.g_ret_sts_unexp_error ;
2787: END get_next_partition;
2788:
2789: PROCEDURE lock_partition ( x_errbuf OUT NOCOPY VARCHAR2
2790: , x_retcode OUT NOCOPY VARCHAR2

Line 2809: x_retcode := FND_API.g_ret_sts_unexp_error ;

2805: EXCEPTION
2806: WHEN OTHERS
2807: THEN
2808: x_errbuf := SQLERRM;
2809: x_retcode := FND_API.g_ret_sts_unexp_error ;
2810: END lock_partition;
2811:
2812:
2813: PROCEDURE unlock_partition ( x_errbuf OUT NOCOPY VARCHAR2

Line 2833: x_retcode := FND_API.g_ret_sts_unexp_error ;

2829: EXCEPTION
2830: WHEN OTHERS
2831: THEN
2832: x_errbuf := SQLERRM;
2833: x_retcode := FND_API.g_ret_sts_unexp_error ;
2834: END unlock_partition;
2835:
2836:
2837: END JTF_FM_INT_REQUEST_PKG;