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

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.process_match.begin',
58: 'Start of the procedure JTY_ASSIGN_REALTIME_PUB.process_match');
59: END IF;
60:
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62: l_num_terr := 0;
63: l_sysdate := SYSDATE;
64:
65: /* Depending on the mode, get the real time matching sql generated by GTP */

Line 130: x_return_status := FND_API.G_RET_STS_SUCCESS;

126:
127: EXCEPTION
128:
129: WHEN NO_MATCH_SQL_ERROR THEN
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131: x_msg_data := 'No matching SQL exist for this usage, transaction type and program name';
132: x_msg_count := 1;
133: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
134: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 140: x_return_status := FND_API.G_RET_STS_SUCCESS;

136: x_msg_data);
137: END IF;
138:
139: WHEN NO_TERR_ERROR THEN
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141: x_msg_data := 'No active territories exist for this usage and transaction type';
142: x_msg_count := 1;
143: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

146: x_msg_data);
147: END IF;
148:
149: WHEN OTHERS THEN
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151: x_msg_data := SQLCODE || ' : ' || SQLERRM;
152: x_msg_count := 1;
153: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.single_level_winning_process.begin',
183: 'Start of the procedure JTY_ASSIGN_REALTIME_PUB.single_level_winning_process');
184: END IF;
185:
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: IF (p_mode LIKE '%RESOURCE') THEN
189: IF ( p_source_id = -1002 AND p_trans_id IN (-1005,-1009 ) AND
190: p_plan_start_date IS NOT NULL AND p_plan_end_date IS NOT NULL ) THEN

Line 842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

838:
839: EXCEPTION
840:
841: WHEN OTHERS THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
843: x_msg_data := SQLCODE || ' : ' || SQLERRM;
844: x_msg_count := 1;
845: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
846: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 888: x_return_status := FND_API.G_RET_STS_SUCCESS;

884: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.begin',
885: 'Start of the procedure JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process');
886: END IF;
887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889: l_worker_id := 1;
890: l_matches_target := 'JTF_TERR_RESULTS_GT_MT';
891: l_terr_L1_target := 'JTF_TERR_RESULTS_GT_L1';
892: l_terr_L2_target := 'JTF_TERR_RESULTS_GT_L2';

Line 924: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

920: x_return_status => x_return_status,
921: p_worker_id => l_worker_id
922: );
923:
924: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
925: -- debug message
926: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 1';
927: x_msg_count := 1;
928: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 934: RAISE FND_API.G_EXC_ERROR;

930: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l1',
931: x_msg_data);
932: END IF;
933:
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936:
937: -- debug message
938: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 961: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

957: x_return_status => x_return_status,
958: p_worker_id => l_worker_id
959: );
960:
961: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
962: -- debug message
963: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 2';
964: x_msg_count := 1;
965: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 971: RAISE FND_API.G_EXC_ERROR;

967: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l2',
968: x_msg_data);
969: END IF;
970:
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973:
974: -- debug message
975: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 998: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

994: x_return_status => x_return_status,
995: p_worker_id => l_worker_id
996: );
997:
998: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
999: -- debug message
1000: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 3';
1001: x_msg_count := 1;
1002: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1008: RAISE FND_API.G_EXC_ERROR;

1004: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l3',
1005: x_msg_data);
1006: END IF;
1007:
1008: RAISE FND_API.G_EXC_ERROR;
1009: END IF;
1010:
1011: -- debug message
1012: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1035: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1031: x_return_status => x_return_status,
1032: p_worker_id => l_worker_id
1033: );
1034:
1035: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1036: -- debug message
1037: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 4';
1038: x_msg_count := 1;
1039: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l4',
1042: x_msg_data);
1043: END IF;
1044:
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048: -- debug message
1049: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1072: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1068: x_return_status => x_return_status,
1069: p_worker_id => l_worker_id
1070: );
1071:
1072: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1073: -- debug message
1074: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 5';
1075: x_msg_count := 1;
1076: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1082: RAISE FND_API.G_EXC_ERROR;

1078: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l5',
1079: x_msg_data);
1080: END IF;
1081:
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084:
1085: -- debug message
1086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1103: x_return_status => x_return_status,
1104: p_worker_id => l_worker_id
1105: );
1106:
1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1108: -- debug message
1109: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners has failed';
1110: x_msg_count := 1;
1111: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1117: RAISE FND_API.G_EXC_ERROR;

1113: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.wt',
1114: x_msg_data);
1115: END IF;
1116:
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119:
1120: -- debug message
1121: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1918: WHEN FND_API.G_EXC_ERROR THEN

1914: END IF;
1915:
1916: EXCEPTION
1917:
1918: WHEN FND_API.G_EXC_ERROR THEN
1919: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1920: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1921: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.other',
1922: substr(x_msg_data, 1, 4000));

Line 1926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1922: substr(x_msg_data, 1, 4000));
1923: END IF;
1924:
1925: WHEN OTHERS THEN
1926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1927: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1928: x_msg_count := 1;
1929: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1930: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 1964: x_return_status := FND_API.G_RET_STS_SUCCESS;

1960: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.process_winners.begin',
1961: 'Start of the procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
1962: END IF;
1963:
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965:
1966: /* Get the multi level winning flag corresponding */
1967: /* to the usage, transaction type and program name */
1968: SELECT tup.multi_level_winning_flag

Line 2008: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2004: ,x_msg_data => x_msg_data
2005: ,x_winners_rec => x_winners_rec);
2006: END IF;
2007:
2008: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2009: -- debug message
2010: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2011: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2012: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.process_winners.winning_process',

Line 2016: RAISE FND_API.G_EXC_ERROR;

2012: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.process_winners.winning_process',
2013: 'JTY_ASSIGN_REALTIME_PUB.winning_process API has failed');
2014: END IF;
2015:
2016: RAISE FND_API.G_EXC_ERROR;
2017: END IF;
2018:
2019: -- debug message
2020: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2028: WHEN FND_API.G_EXC_ERROR THEN

2024: END IF;
2025:
2026: EXCEPTION
2027:
2028: WHEN FND_API.G_EXC_ERROR THEN
2029: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2030: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2031: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.process_winners.g_exc_error',
2032: x_msg_data);

Line 2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2032: x_msg_data);
2033: END IF;
2034:
2035: WHEN NO_DATA_FOUND THEN
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2037: x_msg_data := 'No record in the table jty_trans_usg_pgm_details for the usage : ' || p_source_id ||
2038: ', transaction type : ' || p_trans_id || ' and program name : ' || p_program_name;
2039: x_msg_count := 1;
2040: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2043: x_msg_data);
2044: END IF;
2045:
2046: WHEN OTHERS THEN
2047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2048: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2049: x_msg_count := 1;
2050: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2051: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2104: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2100: 'Start of the procedure JTY_ASSIGN_REALTIME_PUB.get_winners');
2101: END IF;
2102:
2103: -- Standard call to check for call compatibility.
2104: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2105: p_api_version_number,
2106: l_api_name,
2107: G_PKG_NAME) THEN
2108:

Line 2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2105: p_api_version_number,
2106: l_api_name,
2107: G_PKG_NAME) THEN
2108:
2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2110: END IF;
2111:
2112: -- Initialize message list if p_init_msg_list is set to TRUE.
2113: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2113: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2110: END IF;
2111:
2112: -- Initialize message list if p_init_msg_list is set to TRUE.
2113: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2114: FND_MSG_PUB.initialize;
2115: END IF;
2116:
2117: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2117: x_return_status := FND_API.G_RET_STS_SUCCESS;

2113: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2114: FND_MSG_PUB.initialize;
2115: END IF;
2116:
2117: x_return_status := FND_API.G_RET_STS_SUCCESS;
2118: l_sysdate := SYSDATE;
2119: l_trans_rec_records := 0;
2120: l_nvp_records := 0;
2121:

Line 2327: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2323: x_msg_count => x_msg_count,
2324: x_msg_data => x_msg_data
2325: );
2326:
2327: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2328: -- debug message
2329: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2330: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2331: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners.process_match',

Line 2335: RAISE FND_API.G_EXC_ERROR;

2331: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners.process_match',
2332: 'JTY_ASSIGN_REALTIME_PUB.process_match API has failed');
2333: END IF;
2334:
2335: RAISE FND_API.G_EXC_ERROR;
2336: END IF;
2337:
2338: -- debug message
2339: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2359: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2355: x_msg_data => x_msg_data,
2356: x_winners_rec => x_winners_rec
2357: );
2358:
2359: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2360: -- debug message
2361: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2362: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2363: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners.process_winners',

Line 2367: RAISE FND_API.G_EXC_ERROR;

2363: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners.process_winners',
2364: 'JTY_ASSIGN_REALTIME_PUB.process_winners API has failed');
2365: END IF;
2366:
2367: RAISE FND_API.G_EXC_ERROR;
2368: END IF;
2369:
2370: -- debug message
2371: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2385: WHEN FND_API.G_EXC_ERROR THEN

2381: 'End of the procedure JTY_ASSIGN_REALTIME_PUB.get_winners');
2382: END IF;
2383:
2384: EXCEPTION
2385: WHEN FND_API.G_EXC_ERROR THEN
2386: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2387: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2388: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners.g_exc_error',
2389: x_msg_data);

Line 2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2390: END IF;
2391:
2392:
2393: WHEN INVALID_PRM_PSS_MCH THEN
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395: x_msg_data := 'Invalid Parameter Passing Mechanism : valid values are PBR and PBV';
2396: x_msg_count := 1;
2397: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2398: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2401: END IF;
2402:
2403:
2404: WHEN NO_TXN_SQL_ERROR THEN
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: x_msg_data := 'Invalid real time transaction SQL for usage : ' || p_source_id ||
2407: ', transaction type : ' || p_trans_id || ' and program name : ' || p_program_name;
2408: x_msg_count := 1;
2409: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2412: x_msg_data);
2413: END IF;
2414:
2415: WHEN NO_TRANS_TABLE_ERROR THEN
2416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2417: x_msg_data := 'Invalid real time trans table for usage : ' || p_source_id ||
2418: ', transaction type : ' || p_trans_id || ' and program name : ' || p_program_name;
2419: x_msg_count := 1;
2420: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2423: x_msg_data);
2424: END IF;
2425:
2426: WHEN OTHERS THEN
2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2428: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2429: x_msg_count := 1;
2430: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2431: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,