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.

[Home] [Help]

APPS.JTF_RS_INTERFACE_PVT dependencies on FND_API

Line 20: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_INTERFACE_PVT';
18:
19:
20: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
21: l_miss_num NUMBER := FND_API.G_MISS_NUM;
22: l_miss_date DATE := FND_API.G_MISS_DATE;
23:
24: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;

Line 21: l_miss_num NUMBER := FND_API.G_MISS_NUM;

17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_INTERFACE_PVT';
18:
19:
20: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
21: l_miss_num NUMBER := FND_API.G_MISS_NUM;
22: l_miss_date DATE := FND_API.G_MISS_DATE;
23:
24: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
25: l_null_num NUMBER := FND_API.G_NULL_NUM;

Line 22: l_miss_date DATE := FND_API.G_MISS_DATE;

18:
19:
20: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
21: l_miss_num NUMBER := FND_API.G_MISS_NUM;
22: l_miss_date DATE := FND_API.G_MISS_DATE;
23:
24: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
25: l_null_num NUMBER := FND_API.G_NULL_NUM;
26: l_null_date DATE := FND_API.G_NULL_DATE;

Line 24: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;

20: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
21: l_miss_num NUMBER := FND_API.G_MISS_NUM;
22: l_miss_date DATE := FND_API.G_MISS_DATE;
23:
24: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
25: l_null_num NUMBER := FND_API.G_NULL_NUM;
26: l_null_date DATE := FND_API.G_NULL_DATE;
27: l_trans_message VARCHAR2(250);
28: /**

Line 25: l_null_num NUMBER := FND_API.G_NULL_NUM;

21: l_miss_num NUMBER := FND_API.G_MISS_NUM;
22: l_miss_date DATE := FND_API.G_MISS_DATE;
23:
24: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
25: l_null_num NUMBER := FND_API.G_NULL_NUM;
26: l_null_date DATE := FND_API.G_NULL_DATE;
27: l_trans_message VARCHAR2(250);
28: /**
29: * PROCEDURE debug

Line 26: l_null_date DATE := FND_API.G_NULL_DATE;

22: l_miss_date DATE := FND_API.G_MISS_DATE;
23:
24: l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
25: l_null_num NUMBER := FND_API.G_NULL_NUM;
26: l_null_date DATE := FND_API.G_NULL_DATE;
27: l_trans_message VARCHAR2(250);
28: /**
29: * PROCEDURE debug
30: *

Line 209: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;

205: l_msg_count NUMBER;
206: l_msg_data VARCHAR2(4000);
207: l_msg_data1 VARCHAR2(4000);
208: l_api_version CONSTANT NUMBER := 1.0;
209: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
210: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
211: BEGIN
212:
213: SAVEPOINT do_create_resource;

Line 210: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;

206: l_msg_data VARCHAR2(4000);
207: l_msg_data1 VARCHAR2(4000);
208: l_api_version CONSTANT NUMBER := 1.0;
209: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
210: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
211: BEGIN
212:
213: SAVEPOINT do_create_resource;
214:

Line 225: x_return_status := fnd_api.g_ret_sts_success;

221: p_msg_level=>fnd_log.level_statement);
222: END IF;
223:
224: -- initialize variables
225: x_return_status := fnd_api.g_ret_sts_success;
226: l_init_msg_list := fnd_api.g_true;
227: l_commit := fnd_api.g_false;
228: l_commit_count := 0;
229: l_batch_id := p_batch_id;

Line 226: l_init_msg_list := fnd_api.g_true;

222: END IF;
223:
224: -- initialize variables
225: x_return_status := fnd_api.g_ret_sts_success;
226: l_init_msg_list := fnd_api.g_true;
227: l_commit := fnd_api.g_false;
228: l_commit_count := 0;
229: l_batch_id := p_batch_id;
230:

Line 227: l_commit := fnd_api.g_false;

223:
224: -- initialize variables
225: x_return_status := fnd_api.g_ret_sts_success;
226: l_init_msg_list := fnd_api.g_true;
227: l_commit := fnd_api.g_false;
228: l_commit_count := 0;
229: l_batch_id := p_batch_id;
230:
231: -- Debug info.

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 458: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

454: WHEN OTHERS THEN
455:
456: -- When any other unexpected error then try to capture it
457: l_msg_data1 := SQLERRM;
458: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459:
460: -- Debug info.
461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
462: debug(p_message=>'Unexpected Error in Create Resource loop at'

Line 522: x_return_status := fnd_api.g_ret_sts_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;
526:

Line 554: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;

550: X_MSG_DATA OUT NOCOPY VARCHAR2
551: ) IS
552:
553: l_api_version CONSTANT NUMBER := 1.0;
554: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
555: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
556: -- l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
557: -- l_miss_num NUMBER := FND_API.G_MISS_NUM;
558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;

Line 555: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;

551: ) IS
552:
553: l_api_version CONSTANT NUMBER := 1.0;
554: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
555: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
556: -- l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
557: -- l_miss_num NUMBER := FND_API.G_MISS_NUM;
558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;
559:

Line 556: -- l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

552:
553: l_api_version CONSTANT NUMBER := 1.0;
554: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
555: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
556: -- l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
557: -- l_miss_num NUMBER := FND_API.G_MISS_NUM;
558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;
559:
560: -- l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;

Line 557: -- l_miss_num NUMBER := FND_API.G_MISS_NUM;

553: l_api_version CONSTANT NUMBER := 1.0;
554: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
555: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
556: -- l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
557: -- l_miss_num NUMBER := FND_API.G_MISS_NUM;
558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;
559:
560: -- l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
561: -- l_null_num NUMBER := FND_API.G_NULL_NUM;

Line 558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;

554: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
555: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
556: -- l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
557: -- l_miss_num NUMBER := FND_API.G_MISS_NUM;
558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;
559:
560: -- l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
561: -- l_null_num NUMBER := FND_API.G_NULL_NUM;
562: -- l_null_date DATE := FND_API.G_NULL_DATE;

Line 560: -- l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;

556: -- l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
557: -- l_miss_num NUMBER := FND_API.G_MISS_NUM;
558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;
559:
560: -- l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
561: -- l_null_num NUMBER := FND_API.G_NULL_NUM;
562: -- l_null_date DATE := FND_API.G_NULL_DATE;
563: l_other_value BOOLEAN;
564: l_start_date_active_char VARCHAR2(20);

Line 561: -- l_null_num NUMBER := FND_API.G_NULL_NUM;

557: -- l_miss_num NUMBER := FND_API.G_MISS_NUM;
558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;
559:
560: -- l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
561: -- l_null_num NUMBER := FND_API.G_NULL_NUM;
562: -- l_null_date DATE := FND_API.G_NULL_DATE;
563: l_other_value BOOLEAN;
564: l_start_date_active_char VARCHAR2(20);
565:

Line 562: -- l_null_date DATE := FND_API.G_NULL_DATE;

558: -- l_miss_date DATE ;-- := FND_API.G_MISS_DATE;
559:
560: -- l_null_char VARCHAR2(1) := FND_API.G_NULL_CHAR;
561: -- l_null_num NUMBER := FND_API.G_NULL_NUM;
562: -- l_null_date DATE := FND_API.G_NULL_DATE;
563: l_other_value BOOLEAN;
564: l_start_date_active_char VARCHAR2(20);
565:
566: --Cursor to get Resource records for Create mode.

Line 567: --If User wants to set to NULL from Not Null then provide FND_API.G_NULL_xxx

563: l_other_value BOOLEAN;
564: l_start_date_active_char VARCHAR2(20);
565:
566: --Cursor to get Resource records for Create mode.
567: --If User wants to set to NULL from Not Null then provide FND_API.G_NULL_xxx
568: --When it match with FND_API.G_NULL_xxx then will provide NULL to public API.
569: --When it is NULL then will provide FND_API.G_MISS_xxx to public API to retain existing value.
570: --Bug16190251 -- Corrected attribute information in DECODE statements.
571: CURSOR c_resource_int (p_batch_id IN NUMBER)

Line 568: --When it match with FND_API.G_NULL_xxx then will provide NULL to public API.

564: l_start_date_active_char VARCHAR2(20);
565:
566: --Cursor to get Resource records for Create mode.
567: --If User wants to set to NULL from Not Null then provide FND_API.G_NULL_xxx
568: --When it match with FND_API.G_NULL_xxx then will provide NULL to public API.
569: --When it is NULL then will provide FND_API.G_MISS_xxx to public API to retain existing value.
570: --Bug16190251 -- Corrected attribute information in DECODE statements.
571: CURSOR c_resource_int (p_batch_id IN NUMBER)
572: IS

Line 569: --When it is NULL then will provide FND_API.G_MISS_xxx to public API to retain existing value.

565:
566: --Cursor to get Resource records for Create mode.
567: --If User wants to set to NULL from Not Null then provide FND_API.G_NULL_xxx
568: --When it match with FND_API.G_NULL_xxx then will provide NULL to public API.
569: --When it is NULL then will provide FND_API.G_MISS_xxx to public API to retain existing value.
570: --Bug16190251 -- Corrected attribute information in DECODE statements.
571: CURSOR c_resource_int (p_batch_id IN NUMBER)
572: IS
573: SELECT

Line 708: l_miss_date := FND_API.G_MISS_DATE;

704: END IF;
705:
706: -- initialize variables
707: l_api_name := 'DO_UPDATE_RESOURCE';
708: l_miss_date := FND_API.G_MISS_DATE;
709: x_return_status := fnd_api.g_ret_sts_success;
710: l_init_msg_list := fnd_api.g_true;
711: l_commit := fnd_api.g_false;
712: l_commit_count := 0;

Line 709: x_return_status := fnd_api.g_ret_sts_success;

705:
706: -- initialize variables
707: l_api_name := 'DO_UPDATE_RESOURCE';
708: l_miss_date := FND_API.G_MISS_DATE;
709: x_return_status := fnd_api.g_ret_sts_success;
710: l_init_msg_list := fnd_api.g_true;
711: l_commit := fnd_api.g_false;
712: l_commit_count := 0;
713: l_batch_id := p_batch_id;

Line 710: l_init_msg_list := fnd_api.g_true;

706: -- initialize variables
707: l_api_name := 'DO_UPDATE_RESOURCE';
708: l_miss_date := FND_API.G_MISS_DATE;
709: x_return_status := fnd_api.g_ret_sts_success;
710: l_init_msg_list := fnd_api.g_true;
711: l_commit := fnd_api.g_false;
712: l_commit_count := 0;
713: l_batch_id := p_batch_id;
714:

Line 711: l_commit := fnd_api.g_false;

707: l_api_name := 'DO_UPDATE_RESOURCE';
708: l_miss_date := FND_API.G_MISS_DATE;
709: x_return_status := fnd_api.g_ret_sts_success;
710: l_init_msg_list := fnd_api.g_true;
711: l_commit := fnd_api.g_false;
712: l_commit_count := 0;
713: l_batch_id := p_batch_id;
714:
715: -- Debug info.

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 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 1423: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1419: WHEN OTHERS THEN
1420:
1421: -- When any other unexpected error then try to capture it
1422: l_msg_data1 := SQLERRM;
1423: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424:
1425: -- Debug info.
1426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1427: debug(p_message=>'Unexpected Error in Update Resource loop at'

Line 1470: WHEN fnd_api.g_exc_error THEN

1466: p_msg_level=>fnd_log.level_statement);
1467: END IF;
1468:
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);

Line 1472: x_return_status := fnd_api.g_ret_sts_error;

1468:
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;

Line 1475: WHEN fnd_api.g_exc_unexpected_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;
1478: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1479: p_data => x_msg_data);

Line 1477: x_return_status := fnd_api.g_ret_sts_unexp_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;
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.

Line 1493: x_return_status := fnd_api.g_ret_sts_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;
1497:

Line 1564: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;

1560: l_api_name VARCHAR2(30);
1561: l_init_msg_list VARCHAR2(1);
1562: l_commit VARCHAR2(1);
1563: l_api_version CONSTANT NUMBER := 1.0;
1564: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
1565: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
1566: l_debug_prefix VARCHAR2(30) := 'RS_UPD:';
1567: l_batch_id NUMBER;
1568: l_return_status VARCHAR2(1);

Line 1565: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;

1561: l_init_msg_list VARCHAR2(1);
1562: l_commit VARCHAR2(1);
1563: l_api_version CONSTANT NUMBER := 1.0;
1564: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
1565: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
1566: l_debug_prefix VARCHAR2(30) := 'RS_UPD:';
1567: l_batch_id NUMBER;
1568: l_return_status VARCHAR2(1);
1569: l_msg_count NUMBER;

Line 1585: x_return_status := fnd_api.g_ret_sts_success;

1581: p_msg_level=>fnd_log.level_statement);
1582: END IF;
1583:
1584: -- initialize variables
1585: x_return_status := fnd_api.g_ret_sts_success;
1586: l_init_msg_list := fnd_api.g_true;
1587: l_commit := fnd_api.g_false;
1588: l_commit_count := 0;
1589: l_batch_id := p_batch_id;

Line 1586: l_init_msg_list := fnd_api.g_true;

1582: END IF;
1583:
1584: -- initialize variables
1585: x_return_status := fnd_api.g_ret_sts_success;
1586: l_init_msg_list := fnd_api.g_true;
1587: l_commit := fnd_api.g_false;
1588: l_commit_count := 0;
1589: l_batch_id := p_batch_id;
1590:

Line 1587: l_commit := fnd_api.g_false;

1583:
1584: -- initialize variables
1585: x_return_status := fnd_api.g_ret_sts_success;
1586: l_init_msg_list := fnd_api.g_true;
1587: l_commit := fnd_api.g_false;
1588: l_commit_count := 0;
1589: l_batch_id := p_batch_id;
1590:
1591: -- Debug info.

Line 1773: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: -- When any other unexpected error then try to capture it
1772: l_msg_data1 := SQLERRM;
1773: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: -- Debug info.
1775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1776: debug(p_message=>'Unexpected Error in Create Salesrep loop at '||
1777: 'Batch Id ' ||l_batch_id||' Interface Id : '||l_interface_id,

Line 1833: x_return_status := fnd_api.g_ret_sts_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:
1837: END do_create_salesrep;

Line 1912: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;

1908: l_api_name VARCHAR2(30);
1909: l_init_msg_list VARCHAR2(1);
1910: l_commit VARCHAR2(1);
1911: l_api_version CONSTANT NUMBER := 1.0;
1912: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
1913: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
1914: l_debug_prefix VARCHAR2(30) := 'RS_UPD:';
1915: l_batch_id NUMBER;
1916: l_return_status VARCHAR2(1);

Line 1913: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;

1909: l_init_msg_list VARCHAR2(1);
1910: l_commit VARCHAR2(1);
1911: l_api_version CONSTANT NUMBER := 1.0;
1912: l_status_error CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_error;
1913: l_status_success CONSTANT VARCHAR2(10) := fnd_api.g_ret_sts_success;
1914: l_debug_prefix VARCHAR2(30) := 'RS_UPD:';
1915: l_batch_id NUMBER;
1916: l_return_status VARCHAR2(1);
1917: l_msg_count NUMBER;

Line 1931: l_miss_date := FND_API.G_MISS_DATE;

1927: p_prefix =>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_statement);
1929: END IF;
1930: -- initialize variables
1931: l_miss_date := FND_API.G_MISS_DATE;
1932: l_init_msg_list := fnd_api.g_true;
1933: l_commit := fnd_api.g_false;
1934: l_commit_count := 0;
1935: l_batch_id := p_batch_id;

Line 1932: l_init_msg_list := fnd_api.g_true;

1928: p_msg_level=>fnd_log.level_statement);
1929: END IF;
1930: -- initialize variables
1931: l_miss_date := FND_API.G_MISS_DATE;
1932: l_init_msg_list := fnd_api.g_true;
1933: l_commit := fnd_api.g_false;
1934: l_commit_count := 0;
1935: l_batch_id := p_batch_id;
1936: l_api_name := 'DO_UPDATE_SALESREP';

Line 1933: l_commit := fnd_api.g_false;

1929: END IF;
1930: -- initialize variables
1931: l_miss_date := FND_API.G_MISS_DATE;
1932: l_init_msg_list := fnd_api.g_true;
1933: l_commit := fnd_api.g_false;
1934: l_commit_count := 0;
1935: l_batch_id := p_batch_id;
1936: l_api_name := 'DO_UPDATE_SALESREP';
1937: x_return_status := fnd_api.g_ret_sts_success;

Line 1937: x_return_status := fnd_api.g_ret_sts_success;

1933: l_commit := fnd_api.g_false;
1934: l_commit_count := 0;
1935: l_batch_id := p_batch_id;
1936: l_api_name := 'DO_UPDATE_SALESREP';
1937: x_return_status := fnd_api.g_ret_sts_success;
1938: l_batch_id := p_batch_id;
1939:
1940: -- Debug info.
1941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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 2125: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2121: WHEN OTHERS THEN
2122:
2123: -- When any other unexpected error then try to capture it
2124: l_msg_data1 := SQLERRM;
2125: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126:
2127: -- Debug info.
2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2129: debug(p_message=>'Unexpected Error in Update Salesrep loop at'

Line 2189: x_return_status := fnd_api.g_ret_sts_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:
2193: END do_update_salesrep;

Line 2230: x_return_status := fnd_api.g_ret_sts_success;

2226: l_debug_prefix CONSTANT VARCHAR2(30) := 'RS_IMP:';
2227:
2228: BEGIN
2229:
2230: x_return_status := fnd_api.g_ret_sts_success;
2231:
2232: --Call Create Resource and then Update Resource along with Batch Id
2233: /* Call Create Resource */
2234: do_create_resource(p_batch_id => p_batch_id,

Line 2251: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN

2247: p_prefix =>l_debug_prefix,
2248: p_msg_level=>fnd_log.level_statement);
2249: END IF;
2250:
2251: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
2252: /* Call Update Resource */
2253: do_update_resource(p_batch_id => p_batch_id,
2254: x_return_status => x_return_status,
2255: x_msg_count => x_msg_count,

Line 2283: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
2286:
2287: IF fnd_log.LEVEL_UNEXPECTED >=fnd_log.g_current_runtime_level THEN

Line 2331: x_return_status := fnd_api.g_ret_sts_success;

2327:
2328: BEGIN
2329:
2330:
2331: x_return_status := fnd_api.g_ret_sts_success;
2332:
2333: --Call Create Salesrep and then Update Salesrep along with Batch Id
2334: /* Call Create Salesrep */
2335: do_create_salesrep(p_batch_id => p_batch_id,

Line 2352: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN

2348: p_prefix =>l_debug_prefix,
2349: p_msg_level=>fnd_log.level_statement);
2350: END IF;
2351:
2352: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
2353: /* Call Update Salesrep */
2354: do_update_salesrep(p_batch_id => p_batch_id,
2355: x_return_status => x_return_status,
2356: x_msg_count => x_msg_count,

Line 2384: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
2387:
2388: IF fnd_log.LEVEL_UNEXPECTED >=fnd_log.g_current_runtime_level THEN