DBA Data[Home] [Help]

APPS.JTF_RS_INTERFACE_PVT dependencies on FND_MSG_PUB

Line 289: fnd_msg_pub.add;

285:
286: -- Get translated value for 'Resource Name cannot be null'
287: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
288: fnd_message.set_token('PROMPTS', l_trans_message);
289: fnd_msg_pub.add;
290:
291: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
292:
293: UPDATE jtf_rs_resource_extns_int

Line 291: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);

287: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
288: fnd_message.set_token('PROMPTS', l_trans_message);
289: fnd_msg_pub.add;
290:
291: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
292:
293: UPDATE jtf_rs_resource_extns_int
294: SET OPERATION_STATUS = l_status_error,
295: OPERATION_MESSAGE = l_trans_message,

Line 417: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';

413: AND l_msg_count > 0)
414: THEN
415: l_msg_data1 := '';
416: FOR i IN 1..l_msg_count LOOP
417: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
418: END LOOP;
419:
420:
421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 521: FND_MSG_PUB.add;

517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
524: p_data => x_msg_data);
525: END do_create_resource;

Line 523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
524: p_data => x_msg_data);
525: END do_create_resource;
526:
527: /**

Line 800: fnd_msg_pub.add;

796:
797: -- Get translated value for 'Resource Id is not of OTHER category.'
798: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RES_ID_CAT');
799: fnd_message.set_token('P_CATEGORY','OTHER');
800: fnd_msg_pub.add;
801:
802: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
803:
804: UPDATE jtf_rs_resource_extns_int rs_int

Line 802: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);

798: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RES_ID_CAT');
799: fnd_message.set_token('P_CATEGORY','OTHER');
800: fnd_msg_pub.add;
801:
802: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
803:
804: UPDATE jtf_rs_resource_extns_int rs_int
805: SET operation_status = l_status_error,
806: operation_message = l_trans_message,

Line 850: fnd_msg_pub.add;

846:
847: -- Get translated value for 'Resource Name cannot be null'
848: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
849: fnd_message.set_token('PROMPTS', l_trans_message);
850: fnd_msg_pub.add;
851:
852: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
853:
854: UPDATE jtf_rs_resource_extns_int

Line 852: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);

848: fnd_message.set_name('JTF', 'JTF_RS_NOT_NULL');
849: fnd_message.set_token('PROMPTS', l_trans_message);
850: fnd_msg_pub.add;
851:
852: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
853:
854: UPDATE jtf_rs_resource_extns_int
855: SET operation_status = l_status_error,
856: operation_message = l_trans_message,

Line 1110: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';

1106: AND l_msg_count > 0)
1107: THEN
1108: l_msg_data1 := '';
1109: FOR i IN 1..l_msg_count LOOP
1110: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1111: END LOOP;
1112:
1113: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1114: debug(p_message=>'Message Count:'||l_msg_count,

Line 1214: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';

1210: THEN
1211:
1212: l_msg_data1 := '';
1213: FOR i IN 1..l_msg_count LOOP
1214: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1215: END LOOP;
1216:
1217: -- Debug info.
1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1283: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';

1279: AND l_msg_count > 0)
1280: THEN
1281: l_msg_data1 := '';
1282: FOR i IN 1..l_msg_count LOOP
1283: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1284: END LOOP;
1285:
1286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1287: debug(p_message=>'Message Count:'||l_msg_count,

Line 1383: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';

1379: AND l_msg_count > 0)
1380: THEN
1381: l_msg_data1 := '';
1382: FOR i IN 1..l_msg_count LOOP
1383: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1384: END LOOP;
1385:
1386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1387: debug(p_message=>'Message Count:'||l_msg_count,

Line 1473: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1469: EXCEPTION
1470: WHEN fnd_api.g_exc_error THEN
1471: ROLLBACK TO do_update_resource;
1472: x_return_status := fnd_api.g_ret_sts_error;
1473: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1474: p_data => x_msg_data);
1475: WHEN fnd_api.g_exc_unexpected_error THEN
1476: ROLLBACK TO do_update_resource;
1477: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1478: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1474: p_data => x_msg_data);
1475: WHEN fnd_api.g_exc_unexpected_error THEN
1476: ROLLBACK TO do_update_resource;
1477: x_return_status := fnd_api.g_ret_sts_unexp_error;
1478: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1479: p_data => x_msg_data);
1480: WHEN OTHERS THEN
1481: -- Debug info.
1482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1492: FND_MSG_PUB.add;

1488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1489: fnd_message.set_token('P_SQLCODE',SQLCODE);
1490: fnd_message.set_token('P_SQLERRM',SQLERRM);
1491: fnd_message.set_token('P_API_NAME', l_api_name);
1492: FND_MSG_PUB.add;
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1495: p_data => x_msg_data);
1496: END;

Line 1494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1490: fnd_message.set_token('P_SQLERRM',SQLERRM);
1491: fnd_message.set_token('P_API_NAME', l_api_name);
1492: FND_MSG_PUB.add;
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1495: p_data => x_msg_data);
1496: END;
1497:
1498: /**

Line 1731: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';

1727: IF (l_return_status <> l_status_success AND l_msg_count > 0)
1728: THEN
1729: l_msg_data1 := '';
1730: FOR i IN 1..l_msg_count LOOP
1731: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
1732: END LOOP;
1733:
1734: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1735: debug(p_message=>'Message Count:'||l_msg_count,

Line 1832: FND_MSG_PUB.add;

1828: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1829: fnd_message.set_token('P_SQLCODE',SQLCODE);
1830: fnd_message.set_token('P_SQLERRM',SQLERRM);
1831: fnd_message.set_token('P_API_NAME', l_api_name);
1832: FND_MSG_PUB.add;
1833: x_return_status := fnd_api.g_ret_sts_unexp_error;
1834: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1835: p_data => x_msg_data);
1836:

Line 1834: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1830: fnd_message.set_token('P_SQLERRM',SQLERRM);
1831: fnd_message.set_token('P_API_NAME', l_api_name);
1832: FND_MSG_PUB.add;
1833: x_return_status := fnd_api.g_ret_sts_unexp_error;
1834: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1835: p_data => x_msg_data);
1836:
1837: END do_create_salesrep;
1838:

Line 1988: fnd_msg_pub.add;

1984: --validate SalesRep Id value.
1985: --Getting Translated 'Salesperson Id is Invalid'.
1986: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
1987: fnd_message.set_token('P_SALESREP_ID','');
1988: fnd_msg_pub.add;
1989:
1990: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
1991:
1992: UPDATE jtf_rs_salesreps_int a

Line 1990: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);

1986: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
1987: fnd_message.set_token('P_SALESREP_ID','');
1988: fnd_msg_pub.add;
1989:
1990: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
1991:
1992: UPDATE jtf_rs_salesreps_int a
1993: SET OPERATION_STATUS = l_status_error,
1994: OPERATION_MESSAGE = l_trans_message,

Line 2087: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';

2083: IF (l_return_status <> l_status_success AND l_msg_count > 0)
2084: THEN
2085: l_msg_data1 := '';
2086: FOR i IN 1..l_msg_count LOOP
2087: l_msg_data1 := l_msg_data1||fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F')||', ';
2088: END LOOP;
2089:
2090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2091: debug(p_message=>'Message Count:'||l_msg_count,

Line 2188: FND_MSG_PUB.add;

2184: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2185: fnd_message.set_token('P_SQLCODE',SQLCODE);
2186: fnd_message.set_token('P_SQLERRM',SQLERRM);
2187: fnd_message.set_token('P_API_NAME', l_api_name);
2188: FND_MSG_PUB.add;
2189: x_return_status := fnd_api.g_ret_sts_unexp_error;
2190: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2191: p_data => x_msg_data);
2192:

Line 2190: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2186: fnd_message.set_token('P_SQLERRM',SQLERRM);
2187: fnd_message.set_token('P_API_NAME', l_api_name);
2188: FND_MSG_PUB.add;
2189: x_return_status := fnd_api.g_ret_sts_unexp_error;
2190: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2191: p_data => x_msg_data);
2192:
2193: END do_update_salesrep;
2194:

Line 2281: FND_MSG_PUB.add;

2277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2278: fnd_message.set_token('P_SQLCODE',SQLCODE);
2279: fnd_message.set_token('P_SQLERRM',SQLERRM);
2280: fnd_message.set_token('P_API_NAME', l_api_name);
2281: FND_MSG_PUB.add;
2282:
2283: x_return_status := fnd_api.g_ret_sts_unexp_error;
2284: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2285: p_data => x_msg_data);

Line 2284: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2280: fnd_message.set_token('P_API_NAME', l_api_name);
2281: FND_MSG_PUB.add;
2282:
2283: x_return_status := fnd_api.g_ret_sts_unexp_error;
2284: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2285: p_data => x_msg_data);
2286:
2287: IF fnd_log.LEVEL_UNEXPECTED >=fnd_log.g_current_runtime_level THEN
2288: debug(p_message=> 'Import Resource API raised EXCEPTION:'||

Line 2382: FND_MSG_PUB.add;

2378: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2379: fnd_message.set_token('P_SQLCODE',SQLCODE);
2380: fnd_message.set_token('P_SQLERRM',SQLERRM);
2381: fnd_message.set_token('P_API_NAME', l_api_name);
2382: FND_MSG_PUB.add;
2383:
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;
2385: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2386: p_data => x_msg_data);

Line 2385: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2381: fnd_message.set_token('P_API_NAME', l_api_name);
2382: FND_MSG_PUB.add;
2383:
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;
2385: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2386: p_data => x_msg_data);
2387:
2388: IF fnd_log.LEVEL_UNEXPECTED >=fnd_log.g_current_runtime_level THEN
2389: debug(p_message=> 'Import Salesrep API raised EXCEPTION:'||