DBA Data[Home] [Help]

APPS.CSFW_TASKS_PUB dependencies on FND_API

Line 84: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

80: x_object_version_number => l_object_version_number
81: );
82:
83:
84: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
85: /* API-call was successfull */
86: x_error_id := 0;
87: x_error := FND_API.G_RET_STS_SUCCESS;
88:

Line 87: x_error := FND_API.G_RET_STS_SUCCESS;

83:
84: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
85: /* API-call was successfull */
86: x_error_id := 0;
87: x_error := FND_API.G_RET_STS_SUCCESS;
88:
89: -- get the record from table
90: l_task_rec := l_task_table_type(1);
91:

Line 256: IF l_return_status = FND_API.G_RET_STS_SUCCESS

252: x_msg_data => l_msg_data,
253: x_object_version_number => l_object_version_number
254: );
255:
256: IF l_return_status = FND_API.G_RET_STS_SUCCESS
257: THEN
258: /* API-call was successfull */
259: x_error_id := 0;
260: x_error := FND_API.G_RET_STS_SUCCESS;

Line 260: x_error := FND_API.G_RET_STS_SUCCESS;

256: IF l_return_status = FND_API.G_RET_STS_SUCCESS
257: THEN
258: /* API-call was successfull */
259: x_error_id := 0;
260: x_error := FND_API.G_RET_STS_SUCCESS;
261: l_task_rec := l_task_table_type(1);
262:
263: --notes
264: if p_notes <> '$$#@'

Line 329: p_commit => fnd_api.g_true,

325: -- bug # 4570867
326: -- use csf_task_pub instead of jtf_task_pub
327: csf_tasks_pub.create_task (
328: p_api_version => 1.0,
329: p_commit => fnd_api.g_true,
330: p_task_name => p_task_name ,
331: p_task_type_name => l_task_rec.task_type,
332: p_task_type_id => p_task_type_id,
333: p_description => null,

Line 394: IF l_return_status = FND_API.G_RET_STS_SUCCESS

390: p_attribute_category => p_context,
391: p_date_selected => l_task_rec.date_selected
392: );
393:
394: IF l_return_status = FND_API.G_RET_STS_SUCCESS
395: THEN
396: /* API-call was successfull */
397: x_error_id := 0;
398: x_error := FND_API.G_RET_STS_SUCCESS;

Line 398: x_error := FND_API.G_RET_STS_SUCCESS;

394: IF l_return_status = FND_API.G_RET_STS_SUCCESS
395: THEN
396: /* API-call was successfull */
397: x_error_id := 0;
398: x_error := FND_API.G_RET_STS_SUCCESS;
399:
400: --ADding up skills (Bug 3290577)
401:
402: FOR R_FIND_SKILL IN FIND_SKILL (l_task_id)

Line 406: , P_INIT_MSG_LIST => FND_API.G_FALSE

402: FOR R_FIND_SKILL IN FIND_SKILL (l_task_id)
403: LOOP
404: CSF_REQUIRED_SKILLS_PKG.CREATE_ROW
405: ( P_API_VERSION => 1.0
406: , P_INIT_MSG_LIST => FND_API.G_FALSE
407: , P_COMMIT => fnd_api.g_true
408: , P_VALIDATION_LEVEL => 100
409: , X_RETURN_STATUS => l_return_status
410: , X_MSG_COUNT => L_MSG_COUNT

Line 407: , P_COMMIT => fnd_api.g_true

403: LOOP
404: CSF_REQUIRED_SKILLS_PKG.CREATE_ROW
405: ( P_API_VERSION => 1.0
406: , P_INIT_MSG_LIST => FND_API.G_FALSE
407: , P_COMMIT => fnd_api.g_true
408: , P_VALIDATION_LEVEL => 100
409: , X_RETURN_STATUS => l_return_status
410: , X_MSG_COUNT => L_MSG_COUNT
411: , X_MSG_DATA => L_MSG_DATA

Line 420: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

416:
417:
418: -- ERROR PROCESSING IF THERE ARE ANY ERRORS WHILE CALLING THE API
419:
420: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
421: x_error_id := 0;
422: x_error := FND_API.G_RET_STS_SUCCESS;
423: /*
424: lets update the row with the disable flag

Line 422: x_error := FND_API.G_RET_STS_SUCCESS;

418: -- ERROR PROCESSING IF THERE ARE ANY ERRORS WHILE CALLING THE API
419:
420: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
421: x_error_id := 0;
422: x_error := FND_API.G_RET_STS_SUCCESS;
423: /*
424: lets update the row with the disable flag
425: This is a temporary fix as there is no API from CSF_SKILL
426: to update the row or set the DISABLE_FLAG while creating

Line 444: , p_encoded => FND_API.G_FALSE

440: FOR l_counter IN 1 .. l_msg_count
441: LOOP
442: fnd_msg_pub.get
443: ( p_msg_index => l_counter
444: , p_encoded => FND_API.G_FALSE
445: , p_data => l_data
446: , p_msg_index_out => l_msg_index_out
447: );
448: --dbms_output.put_line( 'Message: '||l_data );

Line 523: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

519: x_msg_data => l_msg_data,
520: x_msg_count => l_msg_count
521: );
522:
523: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
524: x_error_id := 0;
525: x_error := FND_API.G_RET_STS_SUCCESS;
526: ELSE
527: FOR l_counter IN 1 .. l_msg_count

Line 525: x_error := FND_API.G_RET_STS_SUCCESS;

521: );
522:
523: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
524: x_error_id := 0;
525: x_error := FND_API.G_RET_STS_SUCCESS;
526: ELSE
527: FOR l_counter IN 1 .. l_msg_count
528: LOOP
529: fnd_msg_pub.get

Line 531: , p_encoded => FND_API.G_FALSE

527: FOR l_counter IN 1 .. l_msg_count
528: LOOP
529: fnd_msg_pub.get
530: ( p_msg_index => l_counter
531: , p_encoded => FND_API.G_FALSE
532: , p_data => l_data
533: , p_msg_index_out => l_msg_index_out
534: );
535: END LOOP ;

Line 548: , p_encoded => FND_API.G_FALSE

544: FOR l_counter IN 1 .. l_msg_count
545: LOOP
546: fnd_msg_pub.get
547: ( p_msg_index => l_counter
548: , p_encoded => FND_API.G_FALSE
549: , p_data => l_data
550: , p_msg_index_out => l_msg_index_out
551: );
552: --dbms_output.put_line( 'Message: '||l_data );

Line 564: , p_encoded => FND_API.G_FALSE

560: FOR l_counter IN 1 .. l_msg_count
561: LOOP
562: fnd_msg_pub.get
563: ( p_msg_index => l_counter
564: , p_encoded => FND_API.G_FALSE
565: , p_data => l_data
566: , p_msg_index_out => l_msg_index_out
567: );
568: --dbms_output.put_line( 'Message: '||l_data );

Line 780: p_commit => fnd_api.g_true,

776: IF has_field_service_rule (p_task_type_id) THEN
777:
778: csf_tasks_pub.create_task (
779: p_api_version => 1.0,
780: p_commit => fnd_api.g_true,
781: p_task_name => p_task_name,
782: p_task_type_name => l_task_type_name,
783: p_task_type_id => p_task_type_id,
784: p_task_status_id => p_status_id,

Line 827: p_commit => fnd_api.g_true,

823: ELSE
824: -- call JTF for non DISPATCH type task
825: jtf_tasks_pub.create_task (
826: p_api_version => 1.0,
827: p_commit => fnd_api.g_true,
828: p_task_name => p_task_name,
829: p_task_type_name => l_task_type_name,
830: p_task_type_id => p_task_type_id,
831: p_description => '',

Line 927: IF l_return_status = FND_API.G_RET_STS_SUCCESS

923: p_template_group_id => null
924: );
925: END IF;
926:
927: IF l_return_status = FND_API.G_RET_STS_SUCCESS
928: THEN
929: /* API-call was successfull */
930: x_error_id := 0;
931: x_error := FND_API.G_RET_STS_SUCCESS;

Line 931: x_error := FND_API.G_RET_STS_SUCCESS;

927: IF l_return_status = FND_API.G_RET_STS_SUCCESS
928: THEN
929: /* API-call was successfull */
930: x_error_id := 0;
931: x_error := FND_API.G_RET_STS_SUCCESS;
932: ELSE
933: FOR l_counter IN 1 .. l_msg_count
934: LOOP
935: fnd_msg_pub.get

Line 937: , p_encoded => FND_API.G_FALSE

933: FOR l_counter IN 1 .. l_msg_count
934: LOOP
935: fnd_msg_pub.get
936: ( p_msg_index => l_counter
937: , p_encoded => FND_API.G_FALSE
938: , p_data => l_data
939: , p_msg_index_out => l_msg_index_out
940: );
941: --dbms_output.put_line( 'Message: '||l_data );

Line 1359: l_notes_rec.note := FND_API.G_MISS_CHAR;

1355: l_notes_rec.note := p_notes;
1356: l_notes_rec.note_type := 'KB_FACT';
1357: l_notes_table (1) := l_notes_rec;
1358: else
1359: l_notes_rec.note := FND_API.G_MISS_CHAR;
1360: l_notes_rec.note_type := FND_API.G_MISS_CHAR;
1361: l_notes_table (1) := l_notes_rec;
1362: end if;
1363:

Line 1360: l_notes_rec.note_type := FND_API.G_MISS_CHAR;

1356: l_notes_rec.note_type := 'KB_FACT';
1357: l_notes_table (1) := l_notes_rec;
1358: else
1359: l_notes_rec.note := FND_API.G_MISS_CHAR;
1360: l_notes_rec.note_type := FND_API.G_MISS_CHAR;
1361: l_notes_table (1) := l_notes_rec;
1362: end if;
1363:
1364: --Contacts

Line 1383: p_init_msg_list => FND_API.G_FALSE,

1379:
1380: --CALLING API
1381: cs_servicerequest_pub.Create_ServiceRequest
1382: ( p_api_version => 3.0,
1383: p_init_msg_list => FND_API.G_FALSE,
1384: p_commit => FND_API.G_TRUE, -- COMMIT
1385: x_return_status => x_return_status,
1386: x_msg_count => x_msg_count,
1387: x_msg_data => x_msg_data,

Line 1384: p_commit => FND_API.G_TRUE, -- COMMIT

1380: --CALLING API
1381: cs_servicerequest_pub.Create_ServiceRequest
1382: ( p_api_version => 3.0,
1383: p_init_msg_list => FND_API.G_FALSE,
1384: p_commit => FND_API.G_TRUE, -- COMMIT
1385: x_return_status => x_return_status,
1386: x_msg_count => x_msg_count,
1387: x_msg_data => x_msg_data,
1388: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,

Line 1423: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1419: -- UTL_FILE.PUT_LINE(debug_handler,'**************** FINISHED RUN **********' );
1420: -- UTL_FILE.FCLOSE(debug_handler);
1421: end if;
1422: */
1423: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1424: THEN
1425: /* API-call was successfull */
1426: x_error_id := 0;
1427: x_error := NULL ;

Line 1434: , p_encoded => FND_API.G_FALSE

1430: FOR l_counter IN 1 .. x_msg_count
1431: LOOP
1432: fnd_msg_pub.get
1433: ( p_msg_index => l_counter
1434: , p_encoded => FND_API.G_FALSE
1435: , p_data => l_data
1436: , p_msg_index_out => l_msg_index_out
1437: );
1438: /*

Line 1596: p_init_msg_list => FND_API.G_FALSE,

1592: -- call csf_task_pub instead of jtf_task_pub
1593:
1594: csf_tasks_pub.update_task (
1595: p_api_version => 1.0,
1596: p_init_msg_list => FND_API.G_FALSE,
1597: p_commit => FND_API.G_TRUE,
1598: p_object_version_number => l_object_version_number,
1599: p_task_id => p_task_id,
1600: x_return_status => x_return_status,

Line 1597: p_commit => FND_API.G_TRUE,

1593:
1594: csf_tasks_pub.update_task (
1595: p_api_version => 1.0,
1596: p_init_msg_list => FND_API.G_FALSE,
1597: p_commit => FND_API.G_TRUE,
1598: p_object_version_number => l_object_version_number,
1599: p_task_id => p_task_id,
1600: x_return_status => x_return_status,
1601: x_msg_count => x_msg_count,

Line 1621: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1617: p_attribute15 => p_attribute_15,
1618: p_attribute_category => p_context
1619: );
1620:
1621: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1622: THEN
1623: -- API-call was successfull
1624: commit;
1625: ELSE

Line 1630: , p_encoded => FND_API.G_FALSE

1626: FOR l_counter IN 1 .. x_msg_count
1627: LOOP
1628: fnd_msg_pub.get
1629: ( p_msg_index => l_counter
1630: , p_encoded => FND_API.G_FALSE
1631: , p_data => l_data
1632: , p_msg_index_out => l_msg_index_out
1633: );
1634: --dbms_output.put_line( 'Message: '||l_data );

Line 1679: l_find_overlap := fnd_api.G_TRUE;

1675: open c_prez_data(p_task_id);
1676: fetch c_prez_data into l_object_version_number;
1677: close c_prez_data ;
1678:
1679: l_find_overlap := fnd_api.G_TRUE;
1680: l_validation_level := fnd_api.G_VALID_LEVEL_FULL;
1681:
1682: if p_allow_overlap = 'Y' then
1683: l_find_overlap := fnd_api.G_FALSE;

Line 1680: l_validation_level := fnd_api.G_VALID_LEVEL_FULL;

1676: fetch c_prez_data into l_object_version_number;
1677: close c_prez_data ;
1678:
1679: l_find_overlap := fnd_api.G_TRUE;
1680: l_validation_level := fnd_api.G_VALID_LEVEL_FULL;
1681:
1682: if p_allow_overlap = 'Y' then
1683: l_find_overlap := fnd_api.G_FALSE;
1684: l_validation_level := fnd_api.G_VALID_LEVEL_NONE;

Line 1683: l_find_overlap := fnd_api.G_FALSE;

1679: l_find_overlap := fnd_api.G_TRUE;
1680: l_validation_level := fnd_api.G_VALID_LEVEL_FULL;
1681:
1682: if p_allow_overlap = 'Y' then
1683: l_find_overlap := fnd_api.G_FALSE;
1684: l_validation_level := fnd_api.G_VALID_LEVEL_NONE;
1685: end if;
1686:
1687: savepoint before_sch_date;

Line 1684: l_validation_level := fnd_api.G_VALID_LEVEL_NONE;

1680: l_validation_level := fnd_api.G_VALID_LEVEL_FULL;
1681:
1682: if p_allow_overlap = 'Y' then
1683: l_find_overlap := fnd_api.G_FALSE;
1684: l_validation_level := fnd_api.G_VALID_LEVEL_NONE;
1685: end if;
1686:
1687: savepoint before_sch_date;
1688: -- Call API

Line 1691: , p_init_msg_list => fnd_api.g_true

1687: savepoint before_sch_date;
1688: -- Call API
1689: CSF_TASKS_PUB.Update_Task
1690: ( p_api_version => 1.0
1691: , p_init_msg_list => fnd_api.g_true
1692: , p_commit => fnd_api.g_false
1693: , p_validation_level => l_validation_level
1694: , p_find_overlap => l_find_overlap
1695: , p_task_id => p_task_id

Line 1692: , p_commit => fnd_api.g_false

1688: -- Call API
1689: CSF_TASKS_PUB.Update_Task
1690: ( p_api_version => 1.0
1691: , p_init_msg_list => fnd_api.g_true
1692: , p_commit => fnd_api.g_false
1693: , p_validation_level => l_validation_level
1694: , p_find_overlap => l_find_overlap
1695: , p_task_id => p_task_id
1696: , p_object_version_number => l_object_version_number

Line 1697: , p_planned_start_date => fnd_api.g_miss_date

1693: , p_validation_level => l_validation_level
1694: , p_find_overlap => l_find_overlap
1695: , p_task_id => p_task_id
1696: , p_object_version_number => l_object_version_number
1697: , p_planned_start_date => fnd_api.g_miss_date
1698: , p_planned_end_date => fnd_api.g_miss_date
1699: , p_scheduled_start_date => p_scheduled_start_date
1700: , p_scheduled_end_date => p_scheduled_end_date
1701: , p_actual_start_date => fnd_api.g_miss_date

Line 1698: , p_planned_end_date => fnd_api.g_miss_date

1694: , p_find_overlap => l_find_overlap
1695: , p_task_id => p_task_id
1696: , p_object_version_number => l_object_version_number
1697: , p_planned_start_date => fnd_api.g_miss_date
1698: , p_planned_end_date => fnd_api.g_miss_date
1699: , p_scheduled_start_date => p_scheduled_start_date
1700: , p_scheduled_end_date => p_scheduled_end_date
1701: , p_actual_start_date => fnd_api.g_miss_date
1702: , p_actual_end_date => fnd_api.g_miss_date

Line 1701: , p_actual_start_date => fnd_api.g_miss_date

1697: , p_planned_start_date => fnd_api.g_miss_date
1698: , p_planned_end_date => fnd_api.g_miss_date
1699: , p_scheduled_start_date => p_scheduled_start_date
1700: , p_scheduled_end_date => p_scheduled_end_date
1701: , p_actual_start_date => fnd_api.g_miss_date
1702: , p_actual_end_date => fnd_api.g_miss_date
1703: , p_timezone_id => fnd_api.g_miss_num
1704: , p_source_object_type_code => fnd_api.g_miss_char
1705: , p_source_object_id => fnd_api.g_miss_num

Line 1702: , p_actual_end_date => fnd_api.g_miss_date

1698: , p_planned_end_date => fnd_api.g_miss_date
1699: , p_scheduled_start_date => p_scheduled_start_date
1700: , p_scheduled_end_date => p_scheduled_end_date
1701: , p_actual_start_date => fnd_api.g_miss_date
1702: , p_actual_end_date => fnd_api.g_miss_date
1703: , p_timezone_id => fnd_api.g_miss_num
1704: , p_source_object_type_code => fnd_api.g_miss_char
1705: , p_source_object_id => fnd_api.g_miss_num
1706: , p_source_object_name => fnd_api.g_miss_char

Line 1703: , p_timezone_id => fnd_api.g_miss_num

1699: , p_scheduled_start_date => p_scheduled_start_date
1700: , p_scheduled_end_date => p_scheduled_end_date
1701: , p_actual_start_date => fnd_api.g_miss_date
1702: , p_actual_end_date => fnd_api.g_miss_date
1703: , p_timezone_id => fnd_api.g_miss_num
1704: , p_source_object_type_code => fnd_api.g_miss_char
1705: , p_source_object_id => fnd_api.g_miss_num
1706: , p_source_object_name => fnd_api.g_miss_char
1707: , p_task_status_id => fnd_api.g_miss_num

Line 1704: , p_source_object_type_code => fnd_api.g_miss_char

1700: , p_scheduled_end_date => p_scheduled_end_date
1701: , p_actual_start_date => fnd_api.g_miss_date
1702: , p_actual_end_date => fnd_api.g_miss_date
1703: , p_timezone_id => fnd_api.g_miss_num
1704: , p_source_object_type_code => fnd_api.g_miss_char
1705: , p_source_object_id => fnd_api.g_miss_num
1706: , p_source_object_name => fnd_api.g_miss_char
1707: , p_task_status_id => fnd_api.g_miss_num
1708: , p_task_type_id => fnd_api.g_miss_num

Line 1705: , p_source_object_id => fnd_api.g_miss_num

1701: , p_actual_start_date => fnd_api.g_miss_date
1702: , p_actual_end_date => fnd_api.g_miss_date
1703: , p_timezone_id => fnd_api.g_miss_num
1704: , p_source_object_type_code => fnd_api.g_miss_char
1705: , p_source_object_id => fnd_api.g_miss_num
1706: , p_source_object_name => fnd_api.g_miss_char
1707: , p_task_status_id => fnd_api.g_miss_num
1708: , p_task_type_id => fnd_api.g_miss_num
1709: , p_task_priority_id => fnd_api.g_miss_num

Line 1706: , p_source_object_name => fnd_api.g_miss_char

1702: , p_actual_end_date => fnd_api.g_miss_date
1703: , p_timezone_id => fnd_api.g_miss_num
1704: , p_source_object_type_code => fnd_api.g_miss_char
1705: , p_source_object_id => fnd_api.g_miss_num
1706: , p_source_object_name => fnd_api.g_miss_char
1707: , p_task_status_id => fnd_api.g_miss_num
1708: , p_task_type_id => fnd_api.g_miss_num
1709: , p_task_priority_id => fnd_api.g_miss_num
1710: , p_owner_type_code => fnd_api.g_miss_char

Line 1707: , p_task_status_id => fnd_api.g_miss_num

1703: , p_timezone_id => fnd_api.g_miss_num
1704: , p_source_object_type_code => fnd_api.g_miss_char
1705: , p_source_object_id => fnd_api.g_miss_num
1706: , p_source_object_name => fnd_api.g_miss_char
1707: , p_task_status_id => fnd_api.g_miss_num
1708: , p_task_type_id => fnd_api.g_miss_num
1709: , p_task_priority_id => fnd_api.g_miss_num
1710: , p_owner_type_code => fnd_api.g_miss_char
1711: , p_owner_id => fnd_api.g_miss_num

Line 1708: , p_task_type_id => fnd_api.g_miss_num

1704: , p_source_object_type_code => fnd_api.g_miss_char
1705: , p_source_object_id => fnd_api.g_miss_num
1706: , p_source_object_name => fnd_api.g_miss_char
1707: , p_task_status_id => fnd_api.g_miss_num
1708: , p_task_type_id => fnd_api.g_miss_num
1709: , p_task_priority_id => fnd_api.g_miss_num
1710: , p_owner_type_code => fnd_api.g_miss_char
1711: , p_owner_id => fnd_api.g_miss_num
1712: , p_owner_territory_id => fnd_api.g_miss_num

Line 1709: , p_task_priority_id => fnd_api.g_miss_num

1705: , p_source_object_id => fnd_api.g_miss_num
1706: , p_source_object_name => fnd_api.g_miss_char
1707: , p_task_status_id => fnd_api.g_miss_num
1708: , p_task_type_id => fnd_api.g_miss_num
1709: , p_task_priority_id => fnd_api.g_miss_num
1710: , p_owner_type_code => fnd_api.g_miss_char
1711: , p_owner_id => fnd_api.g_miss_num
1712: , p_owner_territory_id => fnd_api.g_miss_num
1713: , p_assigned_by_id => fnd_api.g_miss_num

Line 1710: , p_owner_type_code => fnd_api.g_miss_char

1706: , p_source_object_name => fnd_api.g_miss_char
1707: , p_task_status_id => fnd_api.g_miss_num
1708: , p_task_type_id => fnd_api.g_miss_num
1709: , p_task_priority_id => fnd_api.g_miss_num
1710: , p_owner_type_code => fnd_api.g_miss_char
1711: , p_owner_id => fnd_api.g_miss_num
1712: , p_owner_territory_id => fnd_api.g_miss_num
1713: , p_assigned_by_id => fnd_api.g_miss_num
1714: , p_customer_id => fnd_api.g_miss_num

Line 1711: , p_owner_id => fnd_api.g_miss_num

1707: , p_task_status_id => fnd_api.g_miss_num
1708: , p_task_type_id => fnd_api.g_miss_num
1709: , p_task_priority_id => fnd_api.g_miss_num
1710: , p_owner_type_code => fnd_api.g_miss_char
1711: , p_owner_id => fnd_api.g_miss_num
1712: , p_owner_territory_id => fnd_api.g_miss_num
1713: , p_assigned_by_id => fnd_api.g_miss_num
1714: , p_customer_id => fnd_api.g_miss_num
1715: , p_cust_account_id => fnd_api.g_miss_num

Line 1712: , p_owner_territory_id => fnd_api.g_miss_num

1708: , p_task_type_id => fnd_api.g_miss_num
1709: , p_task_priority_id => fnd_api.g_miss_num
1710: , p_owner_type_code => fnd_api.g_miss_char
1711: , p_owner_id => fnd_api.g_miss_num
1712: , p_owner_territory_id => fnd_api.g_miss_num
1713: , p_assigned_by_id => fnd_api.g_miss_num
1714: , p_customer_id => fnd_api.g_miss_num
1715: , p_cust_account_id => fnd_api.g_miss_num
1716: , p_address_id => fnd_api.g_miss_num

Line 1713: , p_assigned_by_id => fnd_api.g_miss_num

1709: , p_task_priority_id => fnd_api.g_miss_num
1710: , p_owner_type_code => fnd_api.g_miss_char
1711: , p_owner_id => fnd_api.g_miss_num
1712: , p_owner_territory_id => fnd_api.g_miss_num
1713: , p_assigned_by_id => fnd_api.g_miss_num
1714: , p_customer_id => fnd_api.g_miss_num
1715: , p_cust_account_id => fnd_api.g_miss_num
1716: , p_address_id => fnd_api.g_miss_num
1717: , p_task_name => fnd_api.g_miss_char

Line 1714: , p_customer_id => fnd_api.g_miss_num

1710: , p_owner_type_code => fnd_api.g_miss_char
1711: , p_owner_id => fnd_api.g_miss_num
1712: , p_owner_territory_id => fnd_api.g_miss_num
1713: , p_assigned_by_id => fnd_api.g_miss_num
1714: , p_customer_id => fnd_api.g_miss_num
1715: , p_cust_account_id => fnd_api.g_miss_num
1716: , p_address_id => fnd_api.g_miss_num
1717: , p_task_name => fnd_api.g_miss_char
1718: , p_description => fnd_api.g_miss_char

Line 1715: , p_cust_account_id => fnd_api.g_miss_num

1711: , p_owner_id => fnd_api.g_miss_num
1712: , p_owner_territory_id => fnd_api.g_miss_num
1713: , p_assigned_by_id => fnd_api.g_miss_num
1714: , p_customer_id => fnd_api.g_miss_num
1715: , p_cust_account_id => fnd_api.g_miss_num
1716: , p_address_id => fnd_api.g_miss_num
1717: , p_task_name => fnd_api.g_miss_char
1718: , p_description => fnd_api.g_miss_char
1719: , p_duration => fnd_api.g_miss_num

Line 1716: , p_address_id => fnd_api.g_miss_num

1712: , p_owner_territory_id => fnd_api.g_miss_num
1713: , p_assigned_by_id => fnd_api.g_miss_num
1714: , p_customer_id => fnd_api.g_miss_num
1715: , p_cust_account_id => fnd_api.g_miss_num
1716: , p_address_id => fnd_api.g_miss_num
1717: , p_task_name => fnd_api.g_miss_char
1718: , p_description => fnd_api.g_miss_char
1719: , p_duration => fnd_api.g_miss_num
1720: , p_duration_uom => fnd_api.g_miss_char

Line 1717: , p_task_name => fnd_api.g_miss_char

1713: , p_assigned_by_id => fnd_api.g_miss_num
1714: , p_customer_id => fnd_api.g_miss_num
1715: , p_cust_account_id => fnd_api.g_miss_num
1716: , p_address_id => fnd_api.g_miss_num
1717: , p_task_name => fnd_api.g_miss_char
1718: , p_description => fnd_api.g_miss_char
1719: , p_duration => fnd_api.g_miss_num
1720: , p_duration_uom => fnd_api.g_miss_char
1721: , p_planned_effort => p_planned_effort

Line 1718: , p_description => fnd_api.g_miss_char

1714: , p_customer_id => fnd_api.g_miss_num
1715: , p_cust_account_id => fnd_api.g_miss_num
1716: , p_address_id => fnd_api.g_miss_num
1717: , p_task_name => fnd_api.g_miss_char
1718: , p_description => fnd_api.g_miss_char
1719: , p_duration => fnd_api.g_miss_num
1720: , p_duration_uom => fnd_api.g_miss_char
1721: , p_planned_effort => p_planned_effort
1722: , p_planned_effort_uom => p_planned_effort_uom

Line 1719: , p_duration => fnd_api.g_miss_num

1715: , p_cust_account_id => fnd_api.g_miss_num
1716: , p_address_id => fnd_api.g_miss_num
1717: , p_task_name => fnd_api.g_miss_char
1718: , p_description => fnd_api.g_miss_char
1719: , p_duration => fnd_api.g_miss_num
1720: , p_duration_uom => fnd_api.g_miss_char
1721: , p_planned_effort => p_planned_effort
1722: , p_planned_effort_uom => p_planned_effort_uom
1723: , p_actual_effort => fnd_api.g_miss_num

Line 1720: , p_duration_uom => fnd_api.g_miss_char

1716: , p_address_id => fnd_api.g_miss_num
1717: , p_task_name => fnd_api.g_miss_char
1718: , p_description => fnd_api.g_miss_char
1719: , p_duration => fnd_api.g_miss_num
1720: , p_duration_uom => fnd_api.g_miss_char
1721: , p_planned_effort => p_planned_effort
1722: , p_planned_effort_uom => p_planned_effort_uom
1723: , p_actual_effort => fnd_api.g_miss_num
1724: , p_actual_effort_uom => fnd_api.g_miss_char

Line 1723: , p_actual_effort => fnd_api.g_miss_num

1719: , p_duration => fnd_api.g_miss_num
1720: , p_duration_uom => fnd_api.g_miss_char
1721: , p_planned_effort => p_planned_effort
1722: , p_planned_effort_uom => p_planned_effort_uom
1723: , p_actual_effort => fnd_api.g_miss_num
1724: , p_actual_effort_uom => fnd_api.g_miss_char
1725: , p_percentage_complete => fnd_api.g_miss_num
1726: , p_reason_code => fnd_api.g_miss_char
1727: , p_private_flag => fnd_api.g_miss_char

Line 1724: , p_actual_effort_uom => fnd_api.g_miss_char

1720: , p_duration_uom => fnd_api.g_miss_char
1721: , p_planned_effort => p_planned_effort
1722: , p_planned_effort_uom => p_planned_effort_uom
1723: , p_actual_effort => fnd_api.g_miss_num
1724: , p_actual_effort_uom => fnd_api.g_miss_char
1725: , p_percentage_complete => fnd_api.g_miss_num
1726: , p_reason_code => fnd_api.g_miss_char
1727: , p_private_flag => fnd_api.g_miss_char
1728: , p_publish_flag => fnd_api.g_miss_char

Line 1725: , p_percentage_complete => fnd_api.g_miss_num

1721: , p_planned_effort => p_planned_effort
1722: , p_planned_effort_uom => p_planned_effort_uom
1723: , p_actual_effort => fnd_api.g_miss_num
1724: , p_actual_effort_uom => fnd_api.g_miss_char
1725: , p_percentage_complete => fnd_api.g_miss_num
1726: , p_reason_code => fnd_api.g_miss_char
1727: , p_private_flag => fnd_api.g_miss_char
1728: , p_publish_flag => fnd_api.g_miss_char
1729: , p_restrict_closure_flag => fnd_api.g_miss_char

Line 1726: , p_reason_code => fnd_api.g_miss_char

1722: , p_planned_effort_uom => p_planned_effort_uom
1723: , p_actual_effort => fnd_api.g_miss_num
1724: , p_actual_effort_uom => fnd_api.g_miss_char
1725: , p_percentage_complete => fnd_api.g_miss_num
1726: , p_reason_code => fnd_api.g_miss_char
1727: , p_private_flag => fnd_api.g_miss_char
1728: , p_publish_flag => fnd_api.g_miss_char
1729: , p_restrict_closure_flag => fnd_api.g_miss_char
1730: , p_attribute1 => fnd_api.g_miss_char

Line 1727: , p_private_flag => fnd_api.g_miss_char

1723: , p_actual_effort => fnd_api.g_miss_num
1724: , p_actual_effort_uom => fnd_api.g_miss_char
1725: , p_percentage_complete => fnd_api.g_miss_num
1726: , p_reason_code => fnd_api.g_miss_char
1727: , p_private_flag => fnd_api.g_miss_char
1728: , p_publish_flag => fnd_api.g_miss_char
1729: , p_restrict_closure_flag => fnd_api.g_miss_char
1730: , p_attribute1 => fnd_api.g_miss_char
1731: , p_attribute2 => fnd_api.g_miss_char

Line 1728: , p_publish_flag => fnd_api.g_miss_char

1724: , p_actual_effort_uom => fnd_api.g_miss_char
1725: , p_percentage_complete => fnd_api.g_miss_num
1726: , p_reason_code => fnd_api.g_miss_char
1727: , p_private_flag => fnd_api.g_miss_char
1728: , p_publish_flag => fnd_api.g_miss_char
1729: , p_restrict_closure_flag => fnd_api.g_miss_char
1730: , p_attribute1 => fnd_api.g_miss_char
1731: , p_attribute2 => fnd_api.g_miss_char
1732: , p_attribute3 => fnd_api.g_miss_char

Line 1729: , p_restrict_closure_flag => fnd_api.g_miss_char

1725: , p_percentage_complete => fnd_api.g_miss_num
1726: , p_reason_code => fnd_api.g_miss_char
1727: , p_private_flag => fnd_api.g_miss_char
1728: , p_publish_flag => fnd_api.g_miss_char
1729: , p_restrict_closure_flag => fnd_api.g_miss_char
1730: , p_attribute1 => fnd_api.g_miss_char
1731: , p_attribute2 => fnd_api.g_miss_char
1732: , p_attribute3 => fnd_api.g_miss_char
1733: , p_attribute4 => fnd_api.g_miss_char

Line 1730: , p_attribute1 => fnd_api.g_miss_char

1726: , p_reason_code => fnd_api.g_miss_char
1727: , p_private_flag => fnd_api.g_miss_char
1728: , p_publish_flag => fnd_api.g_miss_char
1729: , p_restrict_closure_flag => fnd_api.g_miss_char
1730: , p_attribute1 => fnd_api.g_miss_char
1731: , p_attribute2 => fnd_api.g_miss_char
1732: , p_attribute3 => fnd_api.g_miss_char
1733: , p_attribute4 => fnd_api.g_miss_char
1734: , p_attribute5 => fnd_api.g_miss_char

Line 1731: , p_attribute2 => fnd_api.g_miss_char

1727: , p_private_flag => fnd_api.g_miss_char
1728: , p_publish_flag => fnd_api.g_miss_char
1729: , p_restrict_closure_flag => fnd_api.g_miss_char
1730: , p_attribute1 => fnd_api.g_miss_char
1731: , p_attribute2 => fnd_api.g_miss_char
1732: , p_attribute3 => fnd_api.g_miss_char
1733: , p_attribute4 => fnd_api.g_miss_char
1734: , p_attribute5 => fnd_api.g_miss_char
1735: , p_attribute6 => fnd_api.g_miss_char

Line 1732: , p_attribute3 => fnd_api.g_miss_char

1728: , p_publish_flag => fnd_api.g_miss_char
1729: , p_restrict_closure_flag => fnd_api.g_miss_char
1730: , p_attribute1 => fnd_api.g_miss_char
1731: , p_attribute2 => fnd_api.g_miss_char
1732: , p_attribute3 => fnd_api.g_miss_char
1733: , p_attribute4 => fnd_api.g_miss_char
1734: , p_attribute5 => fnd_api.g_miss_char
1735: , p_attribute6 => fnd_api.g_miss_char
1736: , p_attribute7 => fnd_api.g_miss_char

Line 1733: , p_attribute4 => fnd_api.g_miss_char

1729: , p_restrict_closure_flag => fnd_api.g_miss_char
1730: , p_attribute1 => fnd_api.g_miss_char
1731: , p_attribute2 => fnd_api.g_miss_char
1732: , p_attribute3 => fnd_api.g_miss_char
1733: , p_attribute4 => fnd_api.g_miss_char
1734: , p_attribute5 => fnd_api.g_miss_char
1735: , p_attribute6 => fnd_api.g_miss_char
1736: , p_attribute7 => fnd_api.g_miss_char
1737: , p_attribute8 => fnd_api.g_miss_char

Line 1734: , p_attribute5 => fnd_api.g_miss_char

1730: , p_attribute1 => fnd_api.g_miss_char
1731: , p_attribute2 => fnd_api.g_miss_char
1732: , p_attribute3 => fnd_api.g_miss_char
1733: , p_attribute4 => fnd_api.g_miss_char
1734: , p_attribute5 => fnd_api.g_miss_char
1735: , p_attribute6 => fnd_api.g_miss_char
1736: , p_attribute7 => fnd_api.g_miss_char
1737: , p_attribute8 => fnd_api.g_miss_char
1738: , p_attribute9 => fnd_api.g_miss_char

Line 1735: , p_attribute6 => fnd_api.g_miss_char

1731: , p_attribute2 => fnd_api.g_miss_char
1732: , p_attribute3 => fnd_api.g_miss_char
1733: , p_attribute4 => fnd_api.g_miss_char
1734: , p_attribute5 => fnd_api.g_miss_char
1735: , p_attribute6 => fnd_api.g_miss_char
1736: , p_attribute7 => fnd_api.g_miss_char
1737: , p_attribute8 => fnd_api.g_miss_char
1738: , p_attribute9 => fnd_api.g_miss_char
1739: , p_attribute10 => fnd_api.g_miss_char

Line 1736: , p_attribute7 => fnd_api.g_miss_char

1732: , p_attribute3 => fnd_api.g_miss_char
1733: , p_attribute4 => fnd_api.g_miss_char
1734: , p_attribute5 => fnd_api.g_miss_char
1735: , p_attribute6 => fnd_api.g_miss_char
1736: , p_attribute7 => fnd_api.g_miss_char
1737: , p_attribute8 => fnd_api.g_miss_char
1738: , p_attribute9 => fnd_api.g_miss_char
1739: , p_attribute10 => fnd_api.g_miss_char
1740: , p_attribute11 => fnd_api.g_miss_char

Line 1737: , p_attribute8 => fnd_api.g_miss_char

1733: , p_attribute4 => fnd_api.g_miss_char
1734: , p_attribute5 => fnd_api.g_miss_char
1735: , p_attribute6 => fnd_api.g_miss_char
1736: , p_attribute7 => fnd_api.g_miss_char
1737: , p_attribute8 => fnd_api.g_miss_char
1738: , p_attribute9 => fnd_api.g_miss_char
1739: , p_attribute10 => fnd_api.g_miss_char
1740: , p_attribute11 => fnd_api.g_miss_char
1741: , p_attribute12 => fnd_api.g_miss_char

Line 1738: , p_attribute9 => fnd_api.g_miss_char

1734: , p_attribute5 => fnd_api.g_miss_char
1735: , p_attribute6 => fnd_api.g_miss_char
1736: , p_attribute7 => fnd_api.g_miss_char
1737: , p_attribute8 => fnd_api.g_miss_char
1738: , p_attribute9 => fnd_api.g_miss_char
1739: , p_attribute10 => fnd_api.g_miss_char
1740: , p_attribute11 => fnd_api.g_miss_char
1741: , p_attribute12 => fnd_api.g_miss_char
1742: , p_attribute13 => fnd_api.g_miss_char

Line 1739: , p_attribute10 => fnd_api.g_miss_char

1735: , p_attribute6 => fnd_api.g_miss_char
1736: , p_attribute7 => fnd_api.g_miss_char
1737: , p_attribute8 => fnd_api.g_miss_char
1738: , p_attribute9 => fnd_api.g_miss_char
1739: , p_attribute10 => fnd_api.g_miss_char
1740: , p_attribute11 => fnd_api.g_miss_char
1741: , p_attribute12 => fnd_api.g_miss_char
1742: , p_attribute13 => fnd_api.g_miss_char
1743: , p_attribute14 => fnd_api.g_miss_char

Line 1740: , p_attribute11 => fnd_api.g_miss_char

1736: , p_attribute7 => fnd_api.g_miss_char
1737: , p_attribute8 => fnd_api.g_miss_char
1738: , p_attribute9 => fnd_api.g_miss_char
1739: , p_attribute10 => fnd_api.g_miss_char
1740: , p_attribute11 => fnd_api.g_miss_char
1741: , p_attribute12 => fnd_api.g_miss_char
1742: , p_attribute13 => fnd_api.g_miss_char
1743: , p_attribute14 => fnd_api.g_miss_char
1744: , p_attribute15 => fnd_api.g_miss_char

Line 1741: , p_attribute12 => fnd_api.g_miss_char

1737: , p_attribute8 => fnd_api.g_miss_char
1738: , p_attribute9 => fnd_api.g_miss_char
1739: , p_attribute10 => fnd_api.g_miss_char
1740: , p_attribute11 => fnd_api.g_miss_char
1741: , p_attribute12 => fnd_api.g_miss_char
1742: , p_attribute13 => fnd_api.g_miss_char
1743: , p_attribute14 => fnd_api.g_miss_char
1744: , p_attribute15 => fnd_api.g_miss_char
1745: , p_attribute_category => fnd_api.g_miss_char

Line 1742: , p_attribute13 => fnd_api.g_miss_char

1738: , p_attribute9 => fnd_api.g_miss_char
1739: , p_attribute10 => fnd_api.g_miss_char
1740: , p_attribute11 => fnd_api.g_miss_char
1741: , p_attribute12 => fnd_api.g_miss_char
1742: , p_attribute13 => fnd_api.g_miss_char
1743: , p_attribute14 => fnd_api.g_miss_char
1744: , p_attribute15 => fnd_api.g_miss_char
1745: , p_attribute_category => fnd_api.g_miss_char
1746: , p_date_selected => fnd_api.g_miss_char

Line 1743: , p_attribute14 => fnd_api.g_miss_char

1739: , p_attribute10 => fnd_api.g_miss_char
1740: , p_attribute11 => fnd_api.g_miss_char
1741: , p_attribute12 => fnd_api.g_miss_char
1742: , p_attribute13 => fnd_api.g_miss_char
1743: , p_attribute14 => fnd_api.g_miss_char
1744: , p_attribute15 => fnd_api.g_miss_char
1745: , p_attribute_category => fnd_api.g_miss_char
1746: , p_date_selected => fnd_api.g_miss_char
1747: , p_category_id => fnd_api.g_miss_num

Line 1744: , p_attribute15 => fnd_api.g_miss_char

1740: , p_attribute11 => fnd_api.g_miss_char
1741: , p_attribute12 => fnd_api.g_miss_char
1742: , p_attribute13 => fnd_api.g_miss_char
1743: , p_attribute14 => fnd_api.g_miss_char
1744: , p_attribute15 => fnd_api.g_miss_char
1745: , p_attribute_category => fnd_api.g_miss_char
1746: , p_date_selected => fnd_api.g_miss_char
1747: , p_category_id => fnd_api.g_miss_num
1748: , p_multi_booked_flag => fnd_api.g_miss_char

Line 1745: , p_attribute_category => fnd_api.g_miss_char

1741: , p_attribute12 => fnd_api.g_miss_char
1742: , p_attribute13 => fnd_api.g_miss_char
1743: , p_attribute14 => fnd_api.g_miss_char
1744: , p_attribute15 => fnd_api.g_miss_char
1745: , p_attribute_category => fnd_api.g_miss_char
1746: , p_date_selected => fnd_api.g_miss_char
1747: , p_category_id => fnd_api.g_miss_num
1748: , p_multi_booked_flag => fnd_api.g_miss_char
1749: , p_milestone_flag => fnd_api.g_miss_char

Line 1746: , p_date_selected => fnd_api.g_miss_char

1742: , p_attribute13 => fnd_api.g_miss_char
1743: , p_attribute14 => fnd_api.g_miss_char
1744: , p_attribute15 => fnd_api.g_miss_char
1745: , p_attribute_category => fnd_api.g_miss_char
1746: , p_date_selected => fnd_api.g_miss_char
1747: , p_category_id => fnd_api.g_miss_num
1748: , p_multi_booked_flag => fnd_api.g_miss_char
1749: , p_milestone_flag => fnd_api.g_miss_char
1750: , p_holiday_flag => fnd_api.g_miss_char

Line 1747: , p_category_id => fnd_api.g_miss_num

1743: , p_attribute14 => fnd_api.g_miss_char
1744: , p_attribute15 => fnd_api.g_miss_char
1745: , p_attribute_category => fnd_api.g_miss_char
1746: , p_date_selected => fnd_api.g_miss_char
1747: , p_category_id => fnd_api.g_miss_num
1748: , p_multi_booked_flag => fnd_api.g_miss_char
1749: , p_milestone_flag => fnd_api.g_miss_char
1750: , p_holiday_flag => fnd_api.g_miss_char
1751: , p_billable_flag => fnd_api.g_miss_char

Line 1748: , p_multi_booked_flag => fnd_api.g_miss_char

1744: , p_attribute15 => fnd_api.g_miss_char
1745: , p_attribute_category => fnd_api.g_miss_char
1746: , p_date_selected => fnd_api.g_miss_char
1747: , p_category_id => fnd_api.g_miss_num
1748: , p_multi_booked_flag => fnd_api.g_miss_char
1749: , p_milestone_flag => fnd_api.g_miss_char
1750: , p_holiday_flag => fnd_api.g_miss_char
1751: , p_billable_flag => fnd_api.g_miss_char
1752: , p_bound_mode_code => fnd_api.g_miss_char

Line 1749: , p_milestone_flag => fnd_api.g_miss_char

1745: , p_attribute_category => fnd_api.g_miss_char
1746: , p_date_selected => fnd_api.g_miss_char
1747: , p_category_id => fnd_api.g_miss_num
1748: , p_multi_booked_flag => fnd_api.g_miss_char
1749: , p_milestone_flag => fnd_api.g_miss_char
1750: , p_holiday_flag => fnd_api.g_miss_char
1751: , p_billable_flag => fnd_api.g_miss_char
1752: , p_bound_mode_code => fnd_api.g_miss_char
1753: , p_soft_bound_flag => fnd_api.g_miss_char

Line 1750: , p_holiday_flag => fnd_api.g_miss_char

1746: , p_date_selected => fnd_api.g_miss_char
1747: , p_category_id => fnd_api.g_miss_num
1748: , p_multi_booked_flag => fnd_api.g_miss_char
1749: , p_milestone_flag => fnd_api.g_miss_char
1750: , p_holiday_flag => fnd_api.g_miss_char
1751: , p_billable_flag => fnd_api.g_miss_char
1752: , p_bound_mode_code => fnd_api.g_miss_char
1753: , p_soft_bound_flag => fnd_api.g_miss_char
1754: , p_workflow_process_id => fnd_api.g_miss_num

Line 1751: , p_billable_flag => fnd_api.g_miss_char

1747: , p_category_id => fnd_api.g_miss_num
1748: , p_multi_booked_flag => fnd_api.g_miss_char
1749: , p_milestone_flag => fnd_api.g_miss_char
1750: , p_holiday_flag => fnd_api.g_miss_char
1751: , p_billable_flag => fnd_api.g_miss_char
1752: , p_bound_mode_code => fnd_api.g_miss_char
1753: , p_soft_bound_flag => fnd_api.g_miss_char
1754: , p_workflow_process_id => fnd_api.g_miss_num
1755: , p_notification_flag => fnd_api.g_miss_char

Line 1752: , p_bound_mode_code => fnd_api.g_miss_char

1748: , p_multi_booked_flag => fnd_api.g_miss_char
1749: , p_milestone_flag => fnd_api.g_miss_char
1750: , p_holiday_flag => fnd_api.g_miss_char
1751: , p_billable_flag => fnd_api.g_miss_char
1752: , p_bound_mode_code => fnd_api.g_miss_char
1753: , p_soft_bound_flag => fnd_api.g_miss_char
1754: , p_workflow_process_id => fnd_api.g_miss_num
1755: , p_notification_flag => fnd_api.g_miss_char
1756: , p_notification_period => fnd_api.g_miss_num

Line 1753: , p_soft_bound_flag => fnd_api.g_miss_char

1749: , p_milestone_flag => fnd_api.g_miss_char
1750: , p_holiday_flag => fnd_api.g_miss_char
1751: , p_billable_flag => fnd_api.g_miss_char
1752: , p_bound_mode_code => fnd_api.g_miss_char
1753: , p_soft_bound_flag => fnd_api.g_miss_char
1754: , p_workflow_process_id => fnd_api.g_miss_num
1755: , p_notification_flag => fnd_api.g_miss_char
1756: , p_notification_period => fnd_api.g_miss_num
1757: , p_notification_period_uom => fnd_api.g_miss_char

Line 1754: , p_workflow_process_id => fnd_api.g_miss_num

1750: , p_holiday_flag => fnd_api.g_miss_char
1751: , p_billable_flag => fnd_api.g_miss_char
1752: , p_bound_mode_code => fnd_api.g_miss_char
1753: , p_soft_bound_flag => fnd_api.g_miss_char
1754: , p_workflow_process_id => fnd_api.g_miss_num
1755: , p_notification_flag => fnd_api.g_miss_char
1756: , p_notification_period => fnd_api.g_miss_num
1757: , p_notification_period_uom => fnd_api.g_miss_char
1758: , p_parent_task_id => fnd_api.g_miss_num

Line 1755: , p_notification_flag => fnd_api.g_miss_char

1751: , p_billable_flag => fnd_api.g_miss_char
1752: , p_bound_mode_code => fnd_api.g_miss_char
1753: , p_soft_bound_flag => fnd_api.g_miss_char
1754: , p_workflow_process_id => fnd_api.g_miss_num
1755: , p_notification_flag => fnd_api.g_miss_char
1756: , p_notification_period => fnd_api.g_miss_num
1757: , p_notification_period_uom => fnd_api.g_miss_char
1758: , p_parent_task_id => fnd_api.g_miss_num
1759: , p_alarm_start => fnd_api.g_miss_num

Line 1756: , p_notification_period => fnd_api.g_miss_num

1752: , p_bound_mode_code => fnd_api.g_miss_char
1753: , p_soft_bound_flag => fnd_api.g_miss_char
1754: , p_workflow_process_id => fnd_api.g_miss_num
1755: , p_notification_flag => fnd_api.g_miss_char
1756: , p_notification_period => fnd_api.g_miss_num
1757: , p_notification_period_uom => fnd_api.g_miss_char
1758: , p_parent_task_id => fnd_api.g_miss_num
1759: , p_alarm_start => fnd_api.g_miss_num
1760: , p_alarm_start_uom => fnd_api.g_miss_char

Line 1757: , p_notification_period_uom => fnd_api.g_miss_char

1753: , p_soft_bound_flag => fnd_api.g_miss_char
1754: , p_workflow_process_id => fnd_api.g_miss_num
1755: , p_notification_flag => fnd_api.g_miss_char
1756: , p_notification_period => fnd_api.g_miss_num
1757: , p_notification_period_uom => fnd_api.g_miss_char
1758: , p_parent_task_id => fnd_api.g_miss_num
1759: , p_alarm_start => fnd_api.g_miss_num
1760: , p_alarm_start_uom => fnd_api.g_miss_char
1761: , p_alarm_on => fnd_api.g_miss_char

Line 1758: , p_parent_task_id => fnd_api.g_miss_num

1754: , p_workflow_process_id => fnd_api.g_miss_num
1755: , p_notification_flag => fnd_api.g_miss_char
1756: , p_notification_period => fnd_api.g_miss_num
1757: , p_notification_period_uom => fnd_api.g_miss_char
1758: , p_parent_task_id => fnd_api.g_miss_num
1759: , p_alarm_start => fnd_api.g_miss_num
1760: , p_alarm_start_uom => fnd_api.g_miss_char
1761: , p_alarm_on => fnd_api.g_miss_char
1762: , p_alarm_count => fnd_api.g_miss_num

Line 1759: , p_alarm_start => fnd_api.g_miss_num

1755: , p_notification_flag => fnd_api.g_miss_char
1756: , p_notification_period => fnd_api.g_miss_num
1757: , p_notification_period_uom => fnd_api.g_miss_char
1758: , p_parent_task_id => fnd_api.g_miss_num
1759: , p_alarm_start => fnd_api.g_miss_num
1760: , p_alarm_start_uom => fnd_api.g_miss_char
1761: , p_alarm_on => fnd_api.g_miss_char
1762: , p_alarm_count => fnd_api.g_miss_num
1763: , p_alarm_fired_count => fnd_api.g_miss_num

Line 1760: , p_alarm_start_uom => fnd_api.g_miss_char

1756: , p_notification_period => fnd_api.g_miss_num
1757: , p_notification_period_uom => fnd_api.g_miss_char
1758: , p_parent_task_id => fnd_api.g_miss_num
1759: , p_alarm_start => fnd_api.g_miss_num
1760: , p_alarm_start_uom => fnd_api.g_miss_char
1761: , p_alarm_on => fnd_api.g_miss_char
1762: , p_alarm_count => fnd_api.g_miss_num
1763: , p_alarm_fired_count => fnd_api.g_miss_num
1764: , p_alarm_interval => fnd_api.g_miss_num

Line 1761: , p_alarm_on => fnd_api.g_miss_char

1757: , p_notification_period_uom => fnd_api.g_miss_char
1758: , p_parent_task_id => fnd_api.g_miss_num
1759: , p_alarm_start => fnd_api.g_miss_num
1760: , p_alarm_start_uom => fnd_api.g_miss_char
1761: , p_alarm_on => fnd_api.g_miss_char
1762: , p_alarm_count => fnd_api.g_miss_num
1763: , p_alarm_fired_count => fnd_api.g_miss_num
1764: , p_alarm_interval => fnd_api.g_miss_num
1765: , p_alarm_interval_uom => fnd_api.g_miss_char

Line 1762: , p_alarm_count => fnd_api.g_miss_num

1758: , p_parent_task_id => fnd_api.g_miss_num
1759: , p_alarm_start => fnd_api.g_miss_num
1760: , p_alarm_start_uom => fnd_api.g_miss_char
1761: , p_alarm_on => fnd_api.g_miss_char
1762: , p_alarm_count => fnd_api.g_miss_num
1763: , p_alarm_fired_count => fnd_api.g_miss_num
1764: , p_alarm_interval => fnd_api.g_miss_num
1765: , p_alarm_interval_uom => fnd_api.g_miss_char
1766: , p_palm_flag => fnd_api.g_miss_char

Line 1763: , p_alarm_fired_count => fnd_api.g_miss_num

1759: , p_alarm_start => fnd_api.g_miss_num
1760: , p_alarm_start_uom => fnd_api.g_miss_char
1761: , p_alarm_on => fnd_api.g_miss_char
1762: , p_alarm_count => fnd_api.g_miss_num
1763: , p_alarm_fired_count => fnd_api.g_miss_num
1764: , p_alarm_interval => fnd_api.g_miss_num
1765: , p_alarm_interval_uom => fnd_api.g_miss_char
1766: , p_palm_flag => fnd_api.g_miss_char
1767: , p_wince_flag => fnd_api.g_miss_char

Line 1764: , p_alarm_interval => fnd_api.g_miss_num

1760: , p_alarm_start_uom => fnd_api.g_miss_char
1761: , p_alarm_on => fnd_api.g_miss_char
1762: , p_alarm_count => fnd_api.g_miss_num
1763: , p_alarm_fired_count => fnd_api.g_miss_num
1764: , p_alarm_interval => fnd_api.g_miss_num
1765: , p_alarm_interval_uom => fnd_api.g_miss_char
1766: , p_palm_flag => fnd_api.g_miss_char
1767: , p_wince_flag => fnd_api.g_miss_char
1768: , p_laptop_flag => fnd_api.g_miss_char

Line 1765: , p_alarm_interval_uom => fnd_api.g_miss_char

1761: , p_alarm_on => fnd_api.g_miss_char
1762: , p_alarm_count => fnd_api.g_miss_num
1763: , p_alarm_fired_count => fnd_api.g_miss_num
1764: , p_alarm_interval => fnd_api.g_miss_num
1765: , p_alarm_interval_uom => fnd_api.g_miss_char
1766: , p_palm_flag => fnd_api.g_miss_char
1767: , p_wince_flag => fnd_api.g_miss_char
1768: , p_laptop_flag => fnd_api.g_miss_char
1769: , p_device1_flag => fnd_api.g_miss_char

Line 1766: , p_palm_flag => fnd_api.g_miss_char

1762: , p_alarm_count => fnd_api.g_miss_num
1763: , p_alarm_fired_count => fnd_api.g_miss_num
1764: , p_alarm_interval => fnd_api.g_miss_num
1765: , p_alarm_interval_uom => fnd_api.g_miss_char
1766: , p_palm_flag => fnd_api.g_miss_char
1767: , p_wince_flag => fnd_api.g_miss_char
1768: , p_laptop_flag => fnd_api.g_miss_char
1769: , p_device1_flag => fnd_api.g_miss_char
1770: , p_device2_flag => fnd_api.g_miss_char

Line 1767: , p_wince_flag => fnd_api.g_miss_char

1763: , p_alarm_fired_count => fnd_api.g_miss_num
1764: , p_alarm_interval => fnd_api.g_miss_num
1765: , p_alarm_interval_uom => fnd_api.g_miss_char
1766: , p_palm_flag => fnd_api.g_miss_char
1767: , p_wince_flag => fnd_api.g_miss_char
1768: , p_laptop_flag => fnd_api.g_miss_char
1769: , p_device1_flag => fnd_api.g_miss_char
1770: , p_device2_flag => fnd_api.g_miss_char
1771: , p_device3_flag => fnd_api.g_miss_char

Line 1768: , p_laptop_flag => fnd_api.g_miss_char

1764: , p_alarm_interval => fnd_api.g_miss_num
1765: , p_alarm_interval_uom => fnd_api.g_miss_char
1766: , p_palm_flag => fnd_api.g_miss_char
1767: , p_wince_flag => fnd_api.g_miss_char
1768: , p_laptop_flag => fnd_api.g_miss_char
1769: , p_device1_flag => fnd_api.g_miss_char
1770: , p_device2_flag => fnd_api.g_miss_char
1771: , p_device3_flag => fnd_api.g_miss_char
1772: , p_costs => fnd_api.g_miss_num

Line 1769: , p_device1_flag => fnd_api.g_miss_char

1765: , p_alarm_interval_uom => fnd_api.g_miss_char
1766: , p_palm_flag => fnd_api.g_miss_char
1767: , p_wince_flag => fnd_api.g_miss_char
1768: , p_laptop_flag => fnd_api.g_miss_char
1769: , p_device1_flag => fnd_api.g_miss_char
1770: , p_device2_flag => fnd_api.g_miss_char
1771: , p_device3_flag => fnd_api.g_miss_char
1772: , p_costs => fnd_api.g_miss_num
1773: , p_currency_code => fnd_api.g_miss_char

Line 1770: , p_device2_flag => fnd_api.g_miss_char

1766: , p_palm_flag => fnd_api.g_miss_char
1767: , p_wince_flag => fnd_api.g_miss_char
1768: , p_laptop_flag => fnd_api.g_miss_char
1769: , p_device1_flag => fnd_api.g_miss_char
1770: , p_device2_flag => fnd_api.g_miss_char
1771: , p_device3_flag => fnd_api.g_miss_char
1772: , p_costs => fnd_api.g_miss_num
1773: , p_currency_code => fnd_api.g_miss_char
1774: , p_escalation_level => fnd_api.g_miss_char

Line 1771: , p_device3_flag => fnd_api.g_miss_char

1767: , p_wince_flag => fnd_api.g_miss_char
1768: , p_laptop_flag => fnd_api.g_miss_char
1769: , p_device1_flag => fnd_api.g_miss_char
1770: , p_device2_flag => fnd_api.g_miss_char
1771: , p_device3_flag => fnd_api.g_miss_char
1772: , p_costs => fnd_api.g_miss_num
1773: , p_currency_code => fnd_api.g_miss_char
1774: , p_escalation_level => fnd_api.g_miss_char
1775: , x_return_status => x_return_status

Line 1772: , p_costs => fnd_api.g_miss_num

1768: , p_laptop_flag => fnd_api.g_miss_char
1769: , p_device1_flag => fnd_api.g_miss_char
1770: , p_device2_flag => fnd_api.g_miss_char
1771: , p_device3_flag => fnd_api.g_miss_char
1772: , p_costs => fnd_api.g_miss_num
1773: , p_currency_code => fnd_api.g_miss_char
1774: , p_escalation_level => fnd_api.g_miss_char
1775: , x_return_status => x_return_status
1776: , x_msg_count => x_msg_count

Line 1773: , p_currency_code => fnd_api.g_miss_char

1769: , p_device1_flag => fnd_api.g_miss_char
1770: , p_device2_flag => fnd_api.g_miss_char
1771: , p_device3_flag => fnd_api.g_miss_char
1772: , p_costs => fnd_api.g_miss_num
1773: , p_currency_code => fnd_api.g_miss_char
1774: , p_escalation_level => fnd_api.g_miss_char
1775: , x_return_status => x_return_status
1776: , x_msg_count => x_msg_count
1777: , x_msg_data => x_error

Line 1774: , p_escalation_level => fnd_api.g_miss_char

1770: , p_device2_flag => fnd_api.g_miss_char
1771: , p_device3_flag => fnd_api.g_miss_char
1772: , p_costs => fnd_api.g_miss_num
1773: , p_currency_code => fnd_api.g_miss_char
1774: , p_escalation_level => fnd_api.g_miss_char
1775: , x_return_status => x_return_status
1776: , x_msg_count => x_msg_count
1777: , x_msg_data => x_error
1778: );

Line 1782: IF x_return_status = fnd_api.g_ret_sts_error THEN

1778: );
1779:
1780: -- Bug 8942077. Check only for the overlap message in case of x_return_status = 'S'
1781: -- Throw exception if x_return_status = 'E'/'U'
1782: IF x_return_status = fnd_api.g_ret_sts_error THEN
1783: ROLLBACK TO before_sch_date;
1784: RAISE fnd_api.g_exc_error;
1785: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1786: ROLLBACK TO before_sch_date;

Line 1784: RAISE fnd_api.g_exc_error;

1780: -- Bug 8942077. Check only for the overlap message in case of x_return_status = 'S'
1781: -- Throw exception if x_return_status = 'E'/'U'
1782: IF x_return_status = fnd_api.g_ret_sts_error THEN
1783: ROLLBACK TO before_sch_date;
1784: RAISE fnd_api.g_exc_error;
1785: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1786: ROLLBACK TO before_sch_date;
1787: RAISE fnd_api.g_exc_unexpected_error;
1788: END IF;

Line 1785: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1781: -- Throw exception if x_return_status = 'E'/'U'
1782: IF x_return_status = fnd_api.g_ret_sts_error THEN
1783: ROLLBACK TO before_sch_date;
1784: RAISE fnd_api.g_exc_error;
1785: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1786: ROLLBACK TO before_sch_date;
1787: RAISE fnd_api.g_exc_unexpected_error;
1788: END IF;
1789:

Line 1787: RAISE fnd_api.g_exc_unexpected_error;

1783: ROLLBACK TO before_sch_date;
1784: RAISE fnd_api.g_exc_error;
1785: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1786: ROLLBACK TO before_sch_date;
1787: RAISE fnd_api.g_exc_unexpected_error;
1788: END IF;
1789:
1790: -- No error status, lets check the messages for overlap message.
1791: IF x_return_status = fnd_api.g_ret_sts_success THEN

Line 1791: IF x_return_status = fnd_api.g_ret_sts_success THEN

1787: RAISE fnd_api.g_exc_unexpected_error;
1788: END IF;
1789:
1790: -- No error status, lets check the messages for overlap message.
1791: IF x_return_status = fnd_api.g_ret_sts_success THEN
1792:
1793: -- Going inside loop to check for messages...
1794: FOR l_cnt IN 1..x_msg_count
1795: LOOP

Line 1796: x_error := fnd_msg_pub.get(p_msg_index => l_cnt, p_encoded => fnd_api.g_true);

1792:
1793: -- Going inside loop to check for messages...
1794: FOR l_cnt IN 1..x_msg_count
1795: LOOP
1796: x_error := fnd_msg_pub.get(p_msg_index => l_cnt, p_encoded => fnd_api.g_true);
1797: IF INSTR(x_error, 'CSR_TASK_OVERLAP', 1, 1) > 0 THEN -- Check for the overlap message code.
1798: l_overlap_msg_index := l_cnt; --this is the index of the overlap error message.
1799: --ELSE
1800: --fnd_msg_pub.delete_msg(l_cnt);

Line 1807: fnd_msg_pub.get(p_msg_index => l_overlap_msg_index, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);

1803:
1804: -- Rollback the transaction if there is an overlap message.
1805: IF l_overlap_msg_index > 0 THEN
1806: -- Getting decoded overlap message...
1807: fnd_msg_pub.get(p_msg_index => l_overlap_msg_index, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1808: ROLLBACK TO before_sch_date;
1809: ELSE
1810: fnd_msg_pub.initialize;
1811: x_msg_count := 0;

Line 1819: WHEN fnd_api.g_exc_error THEN

1815:
1816: END IF;
1817:
1818: EXCEPTION
1819: WHEN fnd_api.g_exc_error THEN
1820: x_return_status := fnd_api.g_ret_sts_error;
1821: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1822: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1823: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1820: x_return_status := fnd_api.g_ret_sts_error;

1816: END IF;
1817:
1818: EXCEPTION
1819: WHEN fnd_api.g_exc_error THEN
1820: x_return_status := fnd_api.g_ret_sts_error;
1821: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1822: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1822: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);

1818: EXCEPTION
1819: WHEN fnd_api.g_exc_error THEN
1820: x_return_status := fnd_api.g_ret_sts_error;
1821: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1822: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;
1825: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1826: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);

Line 1823: WHEN fnd_api.g_exc_unexpected_error THEN

1819: WHEN fnd_api.g_exc_error THEN
1820: x_return_status := fnd_api.g_ret_sts_error;
1821: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1822: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;
1825: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1826: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1827: WHEN OTHERS THEN

Line 1824: x_return_status := fnd_api.g_ret_sts_unexp_error;

1820: x_return_status := fnd_api.g_ret_sts_error;
1821: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1822: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;
1825: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1826: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1827: WHEN OTHERS THEN
1828: x_error := SQLERRM;

Line 1826: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);

1822: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1823: WHEN fnd_api.g_exc_unexpected_error THEN
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;
1825: --fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_error);
1826: fnd_msg_pub.get(p_msg_index => x_msg_count, p_encoded => fnd_api.g_false, p_data => x_error, p_msg_index_out => l_msg_count);
1827: WHEN OTHERS THEN
1828: x_error := SQLERRM;
1829: END UPDATE_SCH_DATE_TASK;
1830: